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

24
votes
3answers
2k views

Extracting values from nested rules in JSON data

I have been using Mathematica to analyse some data from the StackExchange API. It is conveniently available in JSON form, which Mathematica interprets as replacement rules. However, some of the rules ...
6
votes
2answers
126 views

Import data from excel and store it permanently in notebook

I am trying to write the code for doing the following: by clicking a button, import specific data from an Excel file which I select through a dialog window; input a name for the imported data set ...
8
votes
1answer
570 views

Importing Excel Spreadsheet containing Array Formulas

Has anyone had any success with importing an Excel Spreadsheet holding an array formula into Mathematica? The Syntax I'm using is ...
0
votes
0answers
36 views

Why doesn't Mathematica support Import for SWF files? [closed]

Why doesn't Mathematica support Import for SWF files? I saw that Mathematica can export to .swf, but I wonder why it does not import .swf files?
12
votes
3answers
318 views

ToExpression fails with long nested string expressions

Consider the following conversion from String to Mathematica Expression: ...
1
vote
1answer
49 views

Convert spreadsheet (Excel) to *.csv during import

I have long lists of data in spreadsheets and have the problem that Mathematica crashes regularly during import of the .xlsx files. Is it possible within Mathematica to take a certain tab of a .xlsx ...
9
votes
1answer
573 views

Google Image Search in Notebook?

How can I use Google's image API to custom search for images and import them all?
1
vote
1answer
86 views

PDB Graphics Options: Opacity and Scale to superimpose on 3D point plot

I am trying to superimpose a pdb file into a 3D plot of points extracted from the pdb model, while making the pdb somewhat transparent for easy viewing of plotted points. My problems are as follows. ...
6
votes
1answer
56 views

Importing hex values from a text file

This question appeared maybe an hour ago, but was removed by OP. I'm still interested in a solution. Suppose we have a text file with hex numbers separated by tabs (or spaces): ...
15
votes
2answers
139 views

HDF5 importing large arrays

I have some computations that output a 300,000,000 element array of long unsigned ints, so about 2.4GB, in an h5 file. Mathematica handles files south of 2GB fine, albeit taking very long to import ...
1
vote
1answer
43 views

Importing a spreadsheet with infinity values from Excel

I have imported a spreadsheet from Excel that I want to use as an adjacency matrix. I want to use this matrix as the argument in WeightedAdjacencyGraph, so I have ...
7
votes
2answers
181 views

How to copy and paste $n$ lines from a text editor to $n$ cells?

If I copy from an external editor to Mathematica notebook a block of lines (with a code) line 1 line 2 ... line n then whole text is copied to a single cell. I ...
10
votes
1answer
156 views

Any solution to transfer data between Python and Mathematica

I think Mathematica handles .mat file not very well, python is pretty good at this kind of jobs. In this site, there are plenty of question related to calling Mathematica from Python, or calling ...
1
vote
2answers
75 views

Plotting data from multiple text files

I'm new to mathematica and stack exchange, so any help would be appreciated. I want to plot a bunch of data from text files that contain a lot of extraneous data. I have a hundred files with different ...
8
votes
2answers
301 views

AJAX-style HTTP calls triggered by a variable change

I'm trying to create a dynamic InputField that would autocomplete the address as I type it into the field, by calling Google Maps' GeoCoding API on every change of ...
3
votes
2answers
137 views

Why are dictionary keys reordered upon JSON import?

After importing a JSON file, Mathematica changed the order of the fields. For example, I downloaded a sample file from: http://api.openweathermap.org/data/2.5/find?lat=55.5&lon=37.5&cnt=10 I ...
0
votes
2answers
59 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
3answers
114 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 ...
2
votes
1answer
37 views

Cloud, manipulate based on a external dataset

My question is about creating a Manipulate based on a external dataset (in my private Cloud) and publish it in the Public Cloud. ...
1
vote
0answers
36 views

How to Import .ibw files in Mathematica

Can anyone tell me how to import .ibw (igor binary wave) into Mathematica?
0
votes
0answers
65 views

Does ListPlot have a bug when plotting large lists?

I was able to plot the first 13315 points of my data, but as soon as I try to plot one more data point, it no longer works. If you load the data contained in the google doc file 19857 pairs of data, ...
0
votes
0answers
39 views

How can I use mathematica to get the translated result from the webpage “google translation”? [duplicate]

I would like to use mathematica to automatically translate some input texts, from one language to the other one, then apply some manipulation of string on the text. I know how to realize the ...
0
votes
2answers
40 views

Exporting and Importing solution sets from NSolve

I have a rather large data set that I need to solve for, then save to my hard disk and import in the same format at a later time. This proves to be tricky. I use ...
4
votes
0answers
92 views

How to speed up import of large csv table?

Loading less than 2 gB of csv data took 5.29 hours: ...
0
votes
2answers
89 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 ...
21
votes
2answers
634 views

Import an RDATA, 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 ...
13
votes
1answer
578 views

Data acquisition from a Measurement Computing USB device

I would like to use Mathematica 9 for to acquire data from a Measurement Computing (MC) USB-201 analog to digital (and other) device for classroom demonstration. I do not have a budget to buy LabView ...
5
votes
1answer
74 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 ...
2
votes
1answer
80 views

Saving an XMLObject imported inside a notebook [duplicate]

In a notebook, I import an XMLObject from a html file with this code line : XMLData = Import["Z:/XXX/XXX/XXX.mw", "XML"]; In order to have all the data in the ...
0
votes
1answer
43 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 ...
1
vote
1answer
58 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
48 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
135 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
50 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
4answers
115 views
4
votes
1answer
74 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
47 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
37 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
44 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
63 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
116 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
70 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 ...
1
vote
1answer
73 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
76 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
69 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
90 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
103 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 ...