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

2
votes
1answer
209 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
65 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
75 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: ...
4
votes
2answers
52 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 ...
1
vote
1answer
97 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 ...
4
votes
1answer
101 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 ...
0
votes
1answer
133 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
179 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, ...
1
vote
2answers
183 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
89 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 ...
3
votes
2answers
90 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 ...
0
votes
2answers
163 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 ...
1
vote
1answer
112 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 ...
0
votes
1answer
142 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
178 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 ...
3
votes
1answer
66 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 ...
1
vote
1answer
295 views

How to scrape image search engines?

I'd like to download highest resolution images possible from the search results like these: ...
0
votes
1answer
90 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 ...
0
votes
2answers
105 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 ...
2
votes
1answer
108 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 ...
1
vote
4answers
132 views

Mean duration between two specific data points

I have dataset such as: ...
0
votes
1answer
84 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 ...
6
votes
1answer
170 views

Is there a way to embed a data set in a notebook?

I have a data set (currently a table in a .csv file). I would like to share this notebook with colleagues either as a notebook, or (even better) as a CDF document. Is there a way to embed the data ...
1
vote
1answer
55 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
123 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: ...
4
votes
1answer
270 views

mathematica use too much memory to Import large dat file

Err... When I try to Import a .dat file by dat = Import["D:\\TIEGCM\\solar_input\\omni_m_all_years.dat", "Table"]; or ...
0
votes
1answer
86 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 ...
-1
votes
1answer
149 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
0answers
134 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 ...
1
vote
1answer
66 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
51 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 ...
0
votes
1answer
55 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: ...
9
votes
1answer
488 views

Mathematica doesn't read .mat file

Bug introduced in 6.0 and fixed in 10.2 (July 29, 2015) 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 ...
0
votes
1answer
76 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
132 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
143 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? ...
2
votes
1answer
183 views

Dynamic importing of json file is not refreshing

Running Dynamic[Refresh[Import["foo.json"], UpdateInterval->1]] or json := Import["foo.json"] then ...
1
vote
1answer
307 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
51 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 ...
0
votes
1answer
109 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
75 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: ...
7
votes
2answers
313 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
3answers
254 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
71 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, ...
9
votes
2answers
204 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 ...
25
votes
3answers
2k 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.
6
votes
1answer
96 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 ...
1
vote
1answer
165 views

How do I utilize the dynamic input field function in the manipulate function? Can I use this functionality to import a .xls from an URL dynamically?

Im trying to get my program to import a .xls for manipulation, I need to import the .xls at an url location dynamically, I did have this at the beginning of my code: ...
9
votes
1answer
274 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 ...
1
vote
0answers
48 views

Can I import (and repair) damaged GIS shape files?

Five GIS shape files are available online at http://www.utahcounty.gov/OnlineServices/maps/DataLayers.asp. Mathematica 10 imports 4 of the 5 files just fine (in the sense that, after download, ...