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
0answers
15 views

How can I import a table from a Wikipedia page?

I'm trying to import this table from a wikipedia page containing the list of lunar missions into a Mathematica as an Association. Here, I'm trying to use the new ...
1
vote
1answer
63 views

Importing Data Issue, Breaking Up Elements

I am trying to import a comma delimited text file as a Table and I am having two issues: First, the file imports all of the numbers that should be separate columns as a single string. This is not ...
13
votes
4answers
1k views

Importing HDF5 with compound data

I am looking to Import HDF5 data with compound data. It appears, at least from what I read, that Mathematica 8.0.4 (and previous versions) does not support reading ...
3
votes
2answers
64 views

Manipulation of .csv imported data — no blanks in either of two lists

Above is a .csv file. I am trying to construct two lists of male and female math test scores such that only districts which include info for both male and female students are included i.e. neither ...
1
vote
1answer
54 views

Importing a 3D table from excel

I have a 3D table that I'm able to plot using ListPlot3D, but when I export the table to an excel file and try to import the saved data, the format is different. The imported table seems to have ...
-1
votes
1answer
82 views

Function for importing and plotting data from excel spreadsheet

I know this must be a very basic question, but I could not find any answers. I need to create a function that: 1) imports data from an Excel Spreadsheet, 2) assign specific information from this xlsx ...
0
votes
2answers
89 views

Specific excel data needed in a list

I need to create a list from a general Excel database that requires only data from "ALL STUDENTS" rows on columns 2 and 7. The List most be of the form {DISTRICT, MATH} where the MATH score is ...
20
votes
6answers
4k 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: ...
2
votes
1answer
57 views

Import of data from ODS

With SetDirectory["~/Downloads"]; ifile = "test.xls"; TimeConstrained[idata = Import[ifile, {"Data", 1}], 5]; I can achieve the desired result of importing the ...
0
votes
1answer
46 views

How to import data from a .mat or a .txt file and manipulate dimensions

I'm new to Mathematica (I know very, very little - so I apologize if anything I say is absolutely wrong) - but I'm trying to upload a file from matlab and arrange it in matrix form. I have a .mat ...
1
vote
1answer
55 views

Read a compressed ascii data file?

I would like to write a filter for Import to handle data files that are generated by LabView in the LVM format. This should be straightforward, since the format is ...
1
vote
1answer
61 views

How to scrape image search engines?

I'd like to download highest resolution images possible from the search results like these: ...
3
votes
1answer
47 views

How to force Mathematica to interpret a file as HTML?

Some web pages do not explicitly contain the file extension "html" but is formatted that way (like this one). If I saved this page to my computer then Mathematica could parse it correctly. But if I ...
-5
votes
1answer
120 views

Exporting data from different notebooks to a common file

I am doing some calculations from different notebooks. I need to export the results from all those notebooks in columns of the same file, like a1 b1 c1 a2 b2 c2 a3 b3 c3 . . . where a, b ...
0
votes
1answer
54 views

Import mixed graph from Excel

I am new to Mathematica. I want to use the software as it allows analysis of mixed graphs (directed and undirected edges). I have my network as an Excel spreadsheet of three columns: source, target ...
1
vote
1answer
59 views

Make animation with multiple external data files

I am currently solving PDEs for a discrete vector field with C++. The output at a time t is an array where each row represents a site and there are 6 columns, the first 3 give the position of the site ...
0
votes
2answers
50 views

How to import website data which has an unknow format? [closed]

I want to import data from this website: http://hq.sinajs.cn/list=sh601006; It should look like ...
1
vote
3answers
101 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 ...
11
votes
0answers
217 views

Getting EPS imports to respect the original fill rule

One major problem in my attempt to answer to the CountryData flags question is that the way Mathematica handles filled curves differs from the way SVG and EPS style editors do. The latter two have the ...
32
votes
3answers
2k views

How to do http POST in Mathematica?

The Import command lets you do a HTTP GET from a URL, like this Import @ "http://merkosoncampus.com/wp-content/uploads/2011/05/higgs-boson.jpg" This sends an ...
22
votes
2answers
2k views

How to save all data in all variables so that loading it is fast?

I've got this CSV file I've imported that has tens of millions of lines in it. It takes around 20 minutes to import. I've been working with it for a while and have the processed data spread out in a ...
0
votes
0answers
39 views

Is it possible to import Matlab “.fig” files in Mathematica?

Is it possible to import a ".fig" file made in Matlab into Mathematica? If I try the usual Import[filename] it produces an error ...
0
votes
0answers
33 views

Copying an Imported List to another File

I have a file which begins with a large list of elements created by joining 12 different data imports, which I would now like to copy to another file so that the file can be sent by itself and not ...
0
votes
1answer
55 views

Mathematica: issues storing nested list on disk

having trouble with mathematica using nested lists. I want to save a list like this: l1={{a1,{a,b,c,d,e}},{a2,{f,g,h,i}}} So, the nested components do not have ...
1
vote
1answer
42 views

Importing files into mathematica from flashdrive

I don't know why I can't get my files to import from my flashdrive into my notebook. I have .mat files and .cvs files. I've tried this ...
0
votes
1answer
37 views

Import and export without changing number format

I have a complex file that is the output of a program. The file contains multiple columns with data in different number formats. For example: ...
0
votes
1answer
72 views

Union of large sets

I am trying to take union of thousands of set containing thousands of elements. However mathematica closes itself when I copy/paste the sets in Union[{}]. Do you ...
0
votes
0answers
48 views

Plotting stellar spectrum from FITS file

I would like to make a plot of wavelength v. relative frequency from the stellar spectrum data in a FITS file (in order to fit a curve to one of the spectral lines). I used ...
9
votes
2answers
142 views

Inconsistent behavior of undocumented Encode->Import->StringToStream->Get on password-locked stream

Let's save a definition. Encode it with password/key and Get it again. We will not use Get ...
1
vote
1answer
51 views

How to import a file for processing but not for displaying? [closed]

Here's my problem, I want to take what I have now for code ...
4
votes
0answers
42 views

Import succesful when file manually deleted

apparently Import keeps an imported file i the cache and doesn't complain for some time if a file is deleted manually from the system and then it is imported. If the file is deleted from within ...
63
votes
3answers
6k views

Recovering data points from an image

Unfortunately, some data can only be obtained in picture form (Japanese publications anyone?). Since this cannot be worked with, it has to be converted to a dataset that can; I was wondering whether ...
0
votes
1answer
35 views

Reading a .txt file with numbers

The .txt file is: tb_FeSe_22_12_2014.csv 0.00102786 (-0.000421863,1.58589e-09)(-4.04766e-05,2.67116e-07)(-8.4396e-06,-1.54976e-07) I would like to Import it to Mathematica such that I have: ...
2
votes
1answer
100 views

Mathematica doesn't read .mat file

To be honest, I don't know if the problem is with Mathematica, or with the file; it's been generated by PicoScope, a PC-based oscilloscope software, not Matlab. The error I get in Mathematica 9 when I ...
0
votes
1answer
37 views

ReadList and ToExpression

My dataset is like: id, feat_1, feat_2, feat_8, feat_9, feat_10, feat_11, feat_17, feat_18, feat_22, feat_2, target 1, 1, 0, 0, 0, 0, 1, 2, 0, 1, 0, Class_1 2, ...
0
votes
1answer
54 views

Import GEXF graphs into Mathematica?

Is there any smart way to import gephi graphs (*.gexf) into mathematica ? I mean other than converting to *.gml.
0
votes
1answer
62 views

Is there a better way to download images in parallel?

Is this the best way to batch save a list of image urls in parallel? ...
1
vote
1answer
93 views

Cannot import Excel (xls or xlsx) files which have non-ASCII characters in the name

It seems mma9 works fine, but with mma10 it fail to load a file name with Chinese characters. I use MacBook Pro(Retina) with OSX 10.10.2, and Mathematica 10.0.0.0. I need the file name with Chinese ...
0
votes
1answer
35 views

Import command gives different solution to equation than cut & paste

I would like to import values from a text file to run a notebook. The notebook works fine when I cut and paste in all the input values manually. Here is a working version. But when I import the same ...
7
votes
1answer
383 views

Mathematica 10 doesn't support path containing Chinese characters

Note: This works correctly in version 10.0.2. I tried to import file in Mathematica 10 ( windows 7 system), the path contains some chinese characters. After holding ctrl+shift, and drag the file ...
0
votes
1answer
39 views

Cannot import data into a notebook as a list of numbers

I have text file with a list of numbers separated by commas, which I would like import into a notebook to be called when the name ratevector is used. If I cut and ...
0
votes
1answer
37 views

Working on a certain column after importing data from a file

I'm trying to import a file with 2 columns, in TSV format. Something like this: ...
6
votes
2answers
237 views

Why an extra { when importing .xls?

I am trying to import data from a file. If I import a CVS file, I get: {{a,b,c},{e,f,g}}. For example, two curly brackets. If importing from a .xlsx file I get ...
1
vote
1answer
60 views

Export and Import a list of graphs?

I want to export a list of graphs that come as output to my program. However, I tried exporting all the graphs as graphs using Map and an Export statement with "graph.gml" statement, but got an error. ...
1
vote
3answers
104 views

Read data from file starting at a certain point

I have files of data that come with a whole bunch of junk in the beginning before the actual columns of data start. Is there any way to tell Mathematica to start putting the data into a table from ...
0
votes
1answer
56 views

Getting error Import::chtype when mporting 2D array of images [closed]

Suppose I have images = {{1.jpg, 2.jpg}, {3.jpg, 4.jpg}} Now I try to import all of them at level 2, ...
0
votes
0answers
34 views

Somebody imported .mdt files (3d graphics) in Mathematica?

Hello maybe someone did or import this format in math for subsequent presentation in 3D
5
votes
1answer
157 views

How to use Get on a folder

In the documentation for Get it says: If the file found by <<name is a directory, the Wolfram Language will try to ...
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. ...
18
votes
3answers
1k views

Finding a function that fits the shape of an image

How can I find a function that fits the given shape of an image? Or instead extract a point set from the shape and then find an interpolating function fits the shape. An example image is attached.