Questions about getting data, files, images etc. from various formats into a form that can be read, tranformed and manipulated by Mathematica

learn more… | top users | synonyms

2
votes
1answer
245 views

How to solve issue with exporting / importing data to and from Excel

Background ( simplified ): When I export data to Excel like ...
2
votes
2answers
99 views

Importing Data and Devoting Their Names to Them

There are some files in a directory. I have used of SetDiroctory to access all of them. SetDirectory["C:\\Users\\SE7EN\\Desktop\\mathematica\\test"]; I can visit ...
2
votes
2answers
291 views

ReadList and Import cannot read data separated by “,” [closed]

I have a data file contains several lines of numbers that separated by "," and I cannot load it correctly with ReadList and Import. Here is a example: with data contains "," and "\n", simple ...
2
votes
2answers
423 views

How to export a table of complex numbers?

I'm having problems exporting a table of complex numbers. I have: ...
2
votes
1answer
1k views

Having Problem with Importing Excel file to Mathematica Notebook?

I have solved some equations and exported the final results, which they are several Matrices, as a EXCEL file ( .Xls ). Now, I want to use these EXCEL files as my inputs to solve some other equations. ...
2
votes
2answers
999 views

Importing several huge files with headers & footers

having here several files in ASCII format http://ge.tt/91rv0Jf/v/0 I want to import, while removing headers and footers and then join the several lists. ...
2
votes
1answer
125 views

Import a file only if it contains a certain pattern

Let's say I have three files containing: File 1: x y z 1 4 6 File 2: x y z 2 5 9 File 3: x y z 5 4 8 My goal is to import the data from a file only if in ...
2
votes
2answers
91 views

How to rearrange structure and type of an imported dataset?

I have a bigger dataset imported from Excel. Its elements have a form of {time, data}. Day is irrelevant and I would like to have the time in decimal form e.g. 10:30 is 10.5 ...
2
votes
1answer
71 views

How to read from /dev/random?

I am looking to read a few bytes from /dev/random on OS X and Linux. The simplest approach fails on both operating systems (see below). Why? What is a ...
2
votes
2answers
145 views

Animation of moving rectangles in 2D from data file

I am not very familiar with mathematica but I know the basics so I thought I give it a try. For a project I have to animate rectangles moving around in 2D (later also 3D). The data come from a C ...
2
votes
1answer
133 views

Text analysis and loops

I need a loop for a text analysis involving about 1000 papers (identical structure of all papers) I have these two commands to read all the papers into memory. ...
2
votes
1answer
258 views

Importing data from excel and assigning a variable to each of its columns

How should I assign variables to the data imported from excel containing 3 columns which are time, mean and standard deviation. I want to perform operations on the three variables to get new ...
2
votes
1answer
177 views

importing large data files with a constraint

As I have learned in this community, one way to import a hefty data files (e.g. millions of rows of {x1, y1} data) if you don't care about the individual elements (maybe just want to obtain some ...
2
votes
1answer
770 views

How to import a Microsoft Word document into Mathematica?

I have a Microsoft Word document in DOCX format. I need to import it into Mathematica as a String preserving all formatting (font, size, bold/italic style, colors, ...
2
votes
1answer
173 views

diff-able text-only notebooks?

I would like to save my Mathematica notebooks as plain-text documents, so that I can keep them under git version control. I thought that ...
2
votes
1answer
756 views

How to export/import function values [duplicate]

I have a function with two variables: f[x_,y_]:=f[x,y] = ... I calculated some values (they are fractions like 435345345/3424242424) and would like to store the ...
2
votes
1answer
72 views

How to correctly import data zipped with the “deflate” algorithm?

I'm writing an importer for the GIFTI file format. The details of the format are not particularly important, but the basic idea is that it is a relatively simple XML file which includes binary arrays ...
2
votes
1answer
131 views

How can I download images from Instagram and Twitter?

The new function ServiceExecute seems to suggest the ability to download images containing a specific hashtags. Can anyone get this to work?
2
votes
1answer
156 views

Is it possible to take data from external database for the CDF embedded in webpage?

I have embedded my CDF in facebook.The data for the CDF should be taken from facebook server or my server dynamically.I tried out but its not working in dynamic code iam not able to access the data at ...
2
votes
2answers
249 views

import a list of replacement rules

I have a text file with a set of replacement rules, of the form x^3y^2 -> 4, xy^2 -> 2, ... for example. I'm having some issues trying to figure out ...
2
votes
1answer
556 views

Importing data sets from plain-text files and performing operations on them

I am working with a lot of daily weather files in the txt format. I need to calculate a daily quantity from each of them, e.g., daily light intensity, which ...
2
votes
1answer
86 views

How to get a audio file's duration time in Mathematica?

I have a *.avi file and if I want to know the file's duration time: I can use this code to get the result: Import["test.avi", "Duration"] or the code to get the ...
2
votes
1answer
134 views

Import selective elements from mixed (text and numbers) data file

How can I import only the 2nd and 5th elements (numbers, located in the 2nd and 5th columns) from all n raws of a data file (.xlxx) that contains both numbers and text. Imported data be inserted into ...
2
votes
2answers
153 views

Overwriting first line of large file

As mentioned, I wish to read the first line of a file, and if needed, overwrite it with a new string. The aim is to have a CSV with a list of possible elements. Example: ...
2
votes
1answer
165 views

Importing web page data

I tried importing a webpage using Import: ...
2
votes
1answer
202 views

Using NetLink to Import Excel File

I can import an Excel file into Mathematica easily: But when I try from .Net it fails: These are the commands and errors I am getting: ...
2
votes
1answer
58 views

Avoiding re-evaluation of RegionPlot3D on a second computer

After running a RegionPlot3D named "testplot" on my desktop, I followed an earlier suggestion from the forum and saved it using: ...
2
votes
2answers
190 views

Import[] bug (video)?

I have the following code: frames = Import["myvideo.avi",{"Frames",{50,60,70}}]; This imports frames 1,2, and 3 of the video, not 50,60 and 70. It imports the ...
2
votes
1answer
70 views

Local evaluation works, CloudDeploy did not work

I a playing around with my programming cloud account. What I have found, interactive functions often are not working because there are several details that are not implemented into the cloud. So I ...
2
votes
1answer
63 views

Customized directory import

I have defined a function in a package to import some data files under a directory which is produced by a scanning device (LS55): ...
2
votes
1answer
73 views

Registering/detecting an importer by file name extension

I've developed an importer and exporter for FreeSurfer's MGH/MGZ file format; the specific format isn't important, but I was ...
2
votes
1answer
154 views

ReadList importing negative times

This is probably an easy question to answer, but I need a fresh eye... I'm struggling with processing the following file (extract shown here) It's a list of dates, and positive/negative time durations ...
2
votes
5answers
347 views

Creating ordered triplets from an Excel sheet

I have an Excel sheet of the form: " " a b c 1 R S T 2 U V W 3 X Y Z Where every entry is a number (except the blank quotes, ...
2
votes
1answer
132 views

Implementing a For (?) or series or loop (?) for individual results for every x to n

I'm working on improving a modeling formula and have spreadsheets worth of data to use, but my work so far has been quite tedious. I'm essentially pulling 20 rows of data from each separate sheet of a ...
2
votes
0answers
62 views

The “right” way to define a custom Encoding format?

I have implemented an Import|Export format for xz that behaves like gzip and other encoding formats: ...
2
votes
0answers
152 views

Errors importing UTF8 file to mathematica

I'm trying to import this file: Import["https://dl.dropboxusercontent.com/u/35192406/jarlaxxe_tweets.\ csv", CharacterEncoding -> "UTF8"] But I am getting ...
2
votes
0answers
102 views

Significant platform-dependent efficiency when importing data?

I'm curious, as I understand that answer this way: If you are using a Linux derivative or something like cygwin on Windows, then this is an efficient solution for reading only the third field ...
2
votes
0answers
585 views

Can not Import PDF

I try to import PDF and extract text from it Import["D:\\Vegetarian MS.pdf", {"PDF", "Plaintext"}] but with some files I have a problem like this ...
1
vote
3answers
2k views

Importing multiple files using a for-loop

once again I am stuck solving a seemingly easy problem :( I would like to make a List of tables by importing data from several txt-Files. Importing the data into a table works so far and I am able to ...
1
vote
2answers
203 views

Importing numerical data from RTF file

This might be a very simple question but I have been struggling with it for a couple of hours, so thought maybe someone here can show me a quick way of solving it. I have a file in rtf format ...
1
vote
2answers
322 views

Import large amount of data with time stamps

I have a large data file (150 000 lines) which I want to import in Mathematica. The first few lines look like this ...
1
vote
4answers
149 views

Importing data to Mathematica

I exported the result on NMinimize with .dat format. The data looks like: Then I imported the data using: ...
1
vote
2answers
1k views

Can I improve the importing speed of Excel data?

I have data in an Excel spreadsheet that has 4 rows and 1,000 columns. I am using Import as follows: ...
1
vote
2answers
144 views

Problems with importing a .txt file

I have some problems with importing a .txt file as a table. This is the file. I tried importing it with data = Import["data.txt", "Data"] I want to access ...
1
vote
2answers
262 views

Import image using InputField and Button

I've got a pretty basic problem, which is probably easily solved, but for all my efforts I haven't found a solution yet: I want to make an Image importer of the following form: An ...
1
vote
1answer
475 views

Interpolate specific columns of data

I have a txt file with 3 columns of data: x y1 y2 How do I import the file then create 2 functions, one interpolated with {x,y1} values and the other interpolated with {x,y2} values? This ...
1
vote
1answer
442 views

How can I speed up image importing? [closed]

The following examples show how slow it is to load a simple GIF. Can anything be done to make it faster? System #1: Mathematica 8.0.1.0, HP notebook, Win7 64Bit, 2 x 2.4Ghz Intel Core i5, 2GB RAM, w/ ...
1
vote
1answer
1k views

Importing a matrix from a text file

I have a $4 \times N$ matrix in a .txt file of the form: -17.071 137.567 16.554 0.65 -16.873 136.138 16.934 0.7 -15.397 135.738 16.894 0.7 -14.7 135.982 15.9 0.6 ...
1
vote
2answers
70 views

Save file from URL using mathematica

Is there an easy way to download and save a .zip file from a URL to my computer through Mathematica? I am trying to develop an auto-update function for a mathematica package that is distributed via ...
1
vote
1answer
91 views

Importing adjacency matrix from file of 0/1 arrays

Is it possible to import adjacency matrix for graph representation, from simple text file with NxN (rows x columns) of 0s/1s: 0 1 0 0 1 0 1 1 0 1 0 0 0 1 0 0