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

0
votes
1answer
67 views

reading data, one number at a time, from file to be used in a formula

First off let me say that I am a total nube. I saw some examples of answers "close" to my question but I did not understand them :-( I want to read individual numbers in from a text file and have ...
0
votes
2answers
95 views

Import a given column from an excel file? [closed]

It seems that I can get the first column of excle data, say "test.xls", if I know the total length... ...
0
votes
1answer
48 views

How to get an elements of given class that generated by javascripts

I want to get the number of total pages of a given search resluts of this site: http://srh.bankofchina.com/search/whpj/searchen.jsp, e.g., from 2015-1-12 to 2015-1-13 the currency of USD by the ...
2
votes
1answer
75 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 ...
0
votes
0answers
55 views

ViewPoint: Saving coordinates in a text file

How should I save (Export?), all coordinates of the ViewPoint, in a text file when I rotate the ...
3
votes
1answer
100 views

Using the variable in the MATLAB workspace using MATLink or any other packages

I have a program in MATLAB and after I run the program, I get some results in MATLAB's workspace. Now, I need to use these results in Mathematica. What I currently do is that I save the workspace as a ...
1
vote
1answer
78 views

Importing a text file

I have a *.txt file with values like so: 0 2 4 3 4 2 the position in this huge *.txt ...
0
votes
0answers
21 views

Importing sobj sage objects?

I have a sage-math object . It used to be sage could send data to Mathematica directly but the function appears to have broken with Mathematica 9 (http://trac.sagemath.org/ticket/13892). How can I get ...
1
vote
3answers
97 views

Import Data using selection criteria

I imported a file (text and numbers) and made constructed this. e[[1,All,{1,2,3,4,6}]] Column 1 is the name of the state. How can I get a subset of this where, say Column 1 is not equal to "New ...
1
vote
0answers
85 views

Import/Export a FIT file, Fitness file created by Garmin GPS's and others

A FIT file is a binary replacement for GPX and TCX text files containing GPS and fitness data (heart monitors, etc.). Mathematica reads GPX and TCX files and represents them as XML. I would like to ...
2
votes
1answer
91 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 ...
7
votes
1answer
84 views

Is it possible to move .mx file from one server to other?

I have mathematica file in one server along with .mx file. Is there any way to move the .mx file from one server to other such ...
3
votes
3answers
310 views

Import data from first/last 100 rows of a file

If one wants import data from the first three rows of a file "myfile.data", one can use the command Import["myfile.data",{"Data",{1,2,3},All}]; However, if I ...
1
vote
2answers
62 views

Table operation after export and import of data does not give me the same result

If I create a table of this kind: (m1 = Table[{RandomInteger[], RandomInteger[{1, 5}, {3}]}, {i, 1, 5}]) // MatrixForm which looks like I know how to pick ...
1
vote
1answer
57 views

List Manipulation and Removing Cases

I've imported a large data set, manually removing headers in the .rtf file where it originates. However, when I import this data, I receive this output: ...
5
votes
0answers
126 views

ImportString JSON possible bug

My problem is when I catch up some json output of whatever method and process it with ImportString[%, "JSON"], The first time ...
0
votes
1answer
45 views

Elegant ways of solving this file batching task

There are a batch of data files in a folder (dir = "D:\\Documents\\datadir"), each of which consists of a list of data items, one per line. Each data item is a pair ...
1
vote
2answers
81 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 ...
0
votes
2answers
69 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 ...
7
votes
1answer
156 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 ...
1
vote
0answers
66 views

Import a web page with $\LaTeX$ code including images (png or other)

To be brief; I would like to import a web page, so I use Import["http://fabricebaudoin.wordpress.com/2012/10/25/lecture-32-the-malliavin-derivative/"]; which ...
0
votes
1answer
103 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
161 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
189 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 ...
16
votes
1answer
975 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 ...
1
vote
3answers
201 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 ...
3
votes
1answer
85 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: ...
1
vote
1answer
54 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
74 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
32 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
131 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
0answers
52 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
213 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 ...
2
votes
4answers
142 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: ...
1
vote
0answers
38 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?
0
votes
0answers
68 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 ...
3
votes
0answers
76 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
3answers
121 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 ...
7
votes
1answer
256 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. ...
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): ...
0
votes
2answers
56 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
207 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
149 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 ...
5
votes
1answer
206 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 ...
17
votes
2answers
1k views

How to build a bvh (a motion capture file format) 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. ...
3
votes
1answer
179 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 ...
0
votes
1answer
65 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
62 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 ...
3
votes
2answers
233 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
135 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 ...