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

6
votes
1answer
195 views

Assign the contents of a “Copy” operation programmatically to a variable?

While an earlier question Cut and paste data from a spreadsheet nominally addresses the issue, a year has past since its OP asked it and I hope that others have come across simpler or more direct ...
3
votes
1answer
81 views

How to use RunProcess to import external function?

I have a functions written in an external language called GO. How can I quickly load them into the kernel for use as Mathematica functions? The two ways I've tried are with MathLink and LibraryLink ...
0
votes
2answers
44 views

File Handling. How to save the progress in a file?

Assuming I already have the file created. I have a programme that,returns an output, in our case number. I want Mathematica to save this number in a file, together with results saved from previous ...
8
votes
4answers
591 views

Import values from tab separated file, change decimal point?

I have files that look like this: ...
1
vote
0answers
37 views

Inport a web page with latex code as image png or other

To be brief; I would like to import a web page, then I write Import["http://fabricebaudoin.wordpress.com/2012/10/25/lecture-32-the-malliavin-derivative/"]; which give a notebook file without png ...
15
votes
1answer
421 views

How to programmatically extract mathematical formulas from Word with Mathematica 9?

I have a bunch of(1000+) Microsoft Word document in .Docx format. How can I programmatically extract the mathematical formulas from MS Word using Mathematica 9? This is what example looks like (or ...
0
votes
1answer
59 views

how to read an excel file using mathematica? [closed]

I have to do some data analysis and i have data in an excel file. Please tell me how to read an excel file in mathematica.
3
votes
1answer
97 views

Efficiently reading CSV with ReadList

I have a large CSV file (~1gb) with mixed data. Basically with strings and integers. It takes very long to import this whole dataset with Import[] so I would like ...
4
votes
1answer
142 views

CSV vs XLS for import

I need to import data from various database sources. At the moment I plan on importing files via a CSV file or XLS. All the data if in XLS would be on one sheet (notebook). Are there any advantages ...
4
votes
0answers
87 views

Import Excel data forcing links (ie workbooks) to be updated

We have noticed importing data from an Excel spreadsheet doesn’t update links. The problem with this is if you import a spreadsheet that comprises of linked workbooks data and those workbooks have ...
7
votes
3answers
473 views

Skip header lines on import

When importing a data file what are the comment symbols for Mathematica? That is, given a file like this blabla bulbul 1 2 6 54 7 ... .. what symbol do I have ...
1
vote
3answers
144 views

How to import files with headers?

R has excellent header supports such as read.table with header options. I don't want to mess up with text-processing or stream-processing. I am looking for a similar tool as in R because it saves a ...
6
votes
1answer
173 views

Incorrect result while using SemanticImport for CSV file import

I might use this incorrectly. I want to use a .csv file that (as list) looks like: ...
1
vote
0answers
116 views

InstallJava::fail error when importing an image with a Raspberry Pi

I'm trying to import an image in Mathematica on my Raspberry Pi. The code is simple but I get an error when importing: ...
13
votes
4answers
3k views

Cut and paste data from a spreadsheet

I have a set of data points in two columns in a spreadsheet (OpenOffice Calc): I would like to get these into Mathematica in this format: ...
3
votes
1answer
50 views

How to make Import recognize a new file extension? [duplicate]

I've written an import converter for a custom file format, and it all seems to be working as expected, except for the fallback behavior with no arguments: ...
35
votes
8answers
4k views

How do you convert a string containing a number in C scientific notation to a Mathematica number?

Suppose I have a string containing the C-representation of a floating point number, for example s = "1.23e-5" and I want to convert this to a Mathematica number. ...
1
vote
1answer
44 views

Importing file as a string causes a puzzle

I generate simple txt file and import it as follows: a = Import["binary.txt"]; b = Import["binary.txt", "String"]. It appears then that lengths of imported strings ...
1
vote
2answers
57 views

Why can't I import a file in the init.m file?

I would like to have some data read in every time the kernel starts, but it doesn't seem to work. Say I have a CSV file I want to have read in, for example I use: ...
0
votes
0answers
25 views

Importing large arrays and releasing memory

I am trying to import huge 3 dimensional arrays (in my case approximately 2GB) which I calculated before and saved in .MX format. Then I want to work with a smaller ...
4
votes
1answer
97 views

HDF5 and complex numbers

I "Export" an array with complex numbers with HDF5 format. When I "Import" it, I only get the real part. Simple example: ...
1
vote
1answer
278 views

How to work with 3D images of STL format

After importing a 3D image of STL format, my possibilities in regard to "3D Volumetric Image Processing" seems rather limited. All examples are given with TIFF files. Is there a way to convert from ...
1
vote
0answers
33 views

SemanticImport::unexpinvaliderr error when using trial version

I am trying to use SemanticImport for a personal experiment. I can correctly import a tsv file from a path, but if I change ...
3
votes
2answers
159 views

Mathematica data structures for analysis [closed]

I'm starting to learn Mathematica and one thing that has been bugging me is the apparent lack of a good structure for keeping data and metadata for analysis. Something along R's ...
5
votes
1answer
161 views

How can I read compressed .Z file automatically by Mathematica?

When I read .Z file by something like jpldatstring = Import["ftp://cddis.gsfc.nasa.gov/products/jpl/2003/jplg0040.04i.Z"] Unfortunately, it turned out that ...
10
votes
2answers
606 views

How to build a bvh player in Mathematica?

How to build a bvh player that can be used to visualize human motions in Mathematica? Any idea or sample code would be appreciated. ...
2
votes
4answers
97 views

Finding relevant parts in XML document

My qyestion is about a XML document and finding parts of strings. test = Import["C:\\Users\\filename.xml", "XMLObject"] This gives the following output: ...
0
votes
0answers
46 views

Import (of linux mathematica9) crashes after importing large nasacdf file(~50M) [on hold]

I'm importing a large file from ftp by dat = Import[ "ftp://cdaweb.gsfc.nasa.gov/pub/data/polar/timas/timas_h0/1998/po_h0_tim_19981102_v03.cdf", "Data"]; the ...
1
vote
0answers
34 views

How i can extract a single layer from a SHP file? [closed]

I just import a SHP file that have a series of layers, how can i get just one if i know the name of it?
3
votes
0answers
59 views

Monitor progress of ZIP file extraction

Importing a ZIP file containing potentially many individual files in a (custom) format using Import[filename, {{"*"}, "Gaussian"}] takes quite a while. How can I ...
0
votes
0answers
44 views

Visualization of 3D data by Raster3D and Import

I would like to visualize data stored in an external .txt file. The data is a 3D array of real numbers. I would like to visualize the data by using Raster3D function, but I am not sure what is the ...
0
votes
0answers
27 views

LinkObject::linkd error when reading PDF file

I'm attempting to import a PDF file into the Wolfram Desktop (though I have also used Mathematica 10 with identical results) on a Mac running OS X 10.9.4. The ...
0
votes
3answers
91 views

Importing multiple files with a loop

I have 101 files with data that I want to import into Mathematica. All the file names are numbered as follows datafile.20.0000.out, datafile.20.1000.out, datafile.20.2000.out and so on. I used the ...
14
votes
3answers
455 views

How to Import random elements of huge data files

I am calculating huge data files with an external program. I would like then to import the data into Mathematica for analysis. The files are 2 columns and up to many millions of rows. So for ...
2
votes
1answer
59 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): ...
7
votes
1answer
167 views

Creating time-lapse movies with Mathematica

Well, my question is this: Is that possible to make time-lapse movies with Mathematica? Here is some more explanation: Watch this YouTube video that is a wonderful example of time-lapse movies. ...
0
votes
2answers
46 views

Use modified part of file path as new file name

i want to import an image, modify it and then export the modified image. Something like this: img = Import["C:\\Images\\e4271-5.jpg"] Some modifications ...
2
votes
2answers
129 views

Convert imported PDF to an image

I've looked through the forum and have not seen an answer for this. I would like to be able to import a pdf document in which each page contains an QR code. I want to then use the Barcode reader ...
0
votes
0answers
60 views

How to open *.sif files with Mathematica

While I am processing my data collect from an Andor EM-CCD, I find it diffcult to import the file into mathematica. I think mathematica can open this kind of files since that Matlab can open it. So if ...
4
votes
2answers
111 views

Importing multiple images for machine learning classification

I want to create a ML classifier using images just like this example. I have two classes of images in two different folders. Is there an easier way to import all images from both folders rather than ...
14
votes
2answers
776 views

Dealing with large files

I have a *.dat file in which the contents are basically one giant list: {1,2,3,4} {5,6,7,8} {9,10,11,12} and so on. I'd like to read in the first 500 members { ...
2
votes
2answers
302 views

Sound data Import Export

Can't regain the data after Export. Create an array of sampled amplitude values: 2. Visualize as sound 3. Save it 4. Get it back 5. ??? ...
3
votes
1answer
99 views

Easiest way to parse semi-structured text file

I have a plain text file with some data. I need two things: Be able to extract certain values for the various field, e.g. to extract the 'Mean Dose [%]', that is to extract number ...
4
votes
0answers
194 views

Strange behavior of undocumented RawArray and ArrayObject expressions

I discovered several strange results and inconsistencies while trying to understand what undocumented RawArray and ArrayObject ...
0
votes
1answer
48 views

Importing Selected Spreadsheets [duplicate]

Consider the PISA study report, which contains dozens separate spreadsheets in each respective excel files (see http://www.oecd.org/pisa/keyfindings/pisa-2012-results-volume-iv.htm) Is there any way ...
1
vote
0answers
45 views

Import file size capacity for Mathematica

I am trying to import a large data set (.csv) into Mathematica. The data set contains more than 14 million rows, is this something Mathematica can handle? If not, what is the maximum capacity? I have ...
2
votes
2answers
127 views

How to SemanticImport Multiple Excel Sheets

I have an Excel workbook with multiple sheets that I'd like to import into a dataset each. With Import I can target individual sheets by their name into a nested ...
2
votes
1answer
58 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 ...
1
vote
0answers
49 views

Problem with importing numbers resulting from an executed file in Mathematica [closed]

I am running Mathematica 10 and I have a mathematica file, MBdebug.m, that contains the line val = Import["! ./MBpart1ep0", "Table"]; MBpart1ep0 is an ...
21
votes
2answers
1k views

How to manipulate web pages on Mathematica?

I wanted to input some data on this page through Mathematica: http://www.fundamentus.com.br/buscaavancada.php Then I would press the "buscar" button also through mathematica coding and get the ...