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
2answers
109 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: ...
0
votes
1answer
73 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
80 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
128 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
51 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
123 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
70 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
75 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
64 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
265 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 ...
34
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
3k 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
78 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
34 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
64 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
48 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
58 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
80 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
86 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
167 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
61 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
46 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 ...
68
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
42 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: ...
6
votes
1answer
231 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
45 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
80 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
89 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
162 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
44 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
48 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
49 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
262 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
70 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
144 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
66 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
42 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
177 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
75 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 ...
1
vote
1answer
92 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: ...
1
vote
0answers
41 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, ...
3
votes
1answer
188 views

How to correctly import data zipped with the “deflate” algorithm?

I'm writing an importer for the GIFTI file format. The details of the format are not particularly important, but the basic idea is that it is a relatively simple XML file which includes binary arrays ...
1
vote
0answers
43 views

import file from directory using sftp

I want to import a file from a directory on a ftp using sftp. I'm not sure how the command looks, but here is what I have tried (based on this older post): ...
0
votes
0answers
37 views

What are the limits to file size for Import[ file.wav,“WAV”]

What is the maximum size *.WAV file that can be imported into Mathematica with Import[]?? What is the code used to read the header of a *.WAV file?
1
vote
1answer
112 views

A bug won't let me import JSON files

I have been working on a project and I have been using JSON to build some networks, the code I use is: ...
0
votes
0answers
60 views

How can I run my API on an image?

I've built an API that takes a url of an image as an argument. Using Import[] I can easily call my API on any url and get the results... but I need to run it on an ...
3
votes
2answers
88 views

Most efficient way of splitting a file into length-prefixed blocks

Let's say I have a really big file (>100MB) that consists of length-prefixed blocks, i.e. the first byte of each byte block indicates the length of the rest of the block. This is a simplified example ...
1
vote
1answer
95 views

Importing, sorting and exporting lists

I have several TSV lists (.txt) of something like 2000*2000 numerics (e.g. 1.8645) to import ...
0
votes
0answers
15 views

import part of data [duplicate]

I am using the following code for importing multiple files. ...