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
28 views

Problem with ReadList, record separator is not working

I have entries in a file with the following form: 3579038 2cc567cda3afd5e1d5406152e8ba77024c46ecda 2742564 4202599 093e88c26bd1637d12253115bd5a8a81531ba68f 2742821 3579039 ...
14
votes
0answers
450 views
+50

Import an SPSS, SAS, or STATA file into Mathematica

I would like to import the World Value Survey data file into Mathematica, but it's only given in spss, sas or stata formats, which are statistical analysis softwares format I think. I can't get to ...
1
vote
1answer
52 views

Import a jpeg file and a mov file and display them side by side

I am planning to use Mathematica for a presentation. In one of the slides I need to place a jpeg file side by side to a mov file. ...
0
votes
0answers
42 views

Pulling the boundaries from a Solidworks Profile in Mathematica

I'm currently trying to take a 2d profile generated in SolidWorks and use mathematica to analyze it. I need to pull lines that represent the boundaries of the shape from an image of the shape. . My ...
2
votes
1answer
118 views

Binary file gymnastics

I have an unformatted binary file generated by fortran 77 and i want to import it in Mathematica. The file is formed by 5 data arrays with double precission float numbers. The problem is that seems ...
2
votes
1answer
47 views

Problem with plotting data (.csv)

I have a problem with plotting the data of a recent experiment. I'm quite new to Mathematica, but searched the documentation and forums without solving my issue. My data is stored in a .csv document, ...
1
vote
3answers
105 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 ...
0
votes
1answer
32 views

how to read a list from a file which has mixed types of data?

I need to read in a file with the first several lines reading as ...
1
vote
4answers
111 views
4
votes
1answer
63 views

How can I import html fragments as formatted cells?

I see that there is limited support for "HTMLFragment" in Export, but I figured with all the work that went into porting Mathematica into the Wolfram Cloud there should be a way to Import ...
4
votes
2answers
43 views

NaNs in tabular data and import performance

I'm working with some data files that are just too large for Import. I tried using ReadList, specifying either ...
-2
votes
1answer
34 views

Doing calculation on an imported data file [closed]

I have a data file which has been calculated from mathematica code and saved in test.txt, I need to import the data and do new calculation on it, here is the simple ...
1
vote
1answer
39 views

TSV import issue

I am having an issue importing a tab-seperated file properly. Most lines get split into elements based on the tabs but some don't: ...
1
vote
1answer
56 views

Retrieve XML Tree with only specific XMLElements

I would like to retrieve the XML Tree of a XMLObject with only specific XMLElements. In the help of Mathematica ...
0
votes
1answer
104 views

Importing large data without using Import [closed]

I have around 240 files with lots of data, I have been using Import[] to import these data for further processing. But as my simulations are growing bigger, I am ...
1
vote
1answer
53 views

Import csv file which contains columns of different lengths --> How can I delete empty fields?

I have the following problem: I want to import a csv file into Mathematica. I file as a lot of rows and columns, but the column lengths differ for certain rows. 2 columns always belong together, ...
20
votes
4answers
2k views

Is it possible to use Mathematica to record sound and/or vision?

I think the title says it all. I know about ImageCapture which seems to capture stills. Can ImageCapture be made to capture a ...
0
votes
2answers
75 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
67 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
73 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
59 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
84 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
95 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 ...
21
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
59 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
54 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
57 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
70 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
48 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
56 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 ...
2
votes
1answer
66 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
55 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 ...
11
votes
0answers
230 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
48 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
42 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
73 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
53 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
146 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
52 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
43 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 ...
64
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
36 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: ...