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

4
votes
2answers
141 views

Extract part of a matrix

I have imported a matrix from a .txt file (it could be better from an Excel file): ...
4
votes
1answer
207 views

how can i associate the headings of columns/rows with content of itself and then recall what i want after i've imported the excel file in mathematica

Hello, i make another try... I have to import a file like this below (it is an excel file, i show you just the beginnig. it should have thousend of rows and columns). After i've imported the file i ...
3
votes
2answers
130 views

Take a specific part of a matrix imported from a .xls

i would like to know if there are any ways to link headings of a table i had imported with the data in the table itself. I imported a matrix from an excel file and i want to take a specific part of it....
0
votes
1answer
87 views

What´s wrong with my FindFit

I updated the data which is a table I deleted the first coordinate as it was the quote from the document. ...
2
votes
2answers
76 views

How to separate the double columns while reading file

I have a file which has contents of the form 10533 "MENDOZAT " 115.0000 : 1 1.00000 Now I want to separate the words and get it as a list. like ...
1
vote
1answer
113 views

Import graphml file in mathematica

I am trying import a graphml file I created with NodeXL in mathematica in order to create a network. However when i try to import it I get the error message: "Cannot import data as GraphML format". ...
1
vote
1answer
72 views

Edit header information of a DICOM file and export it again

I have some DICOM files and want to edit a part of the Header and export the DICOM files with this edited header. I know how to Import a DICOM files and extract the Header Information, but how to ...
6
votes
0answers
73 views

Can't get Mathematica to Import PDF files with diacritics on the file name

Tested with versions 9.0.0, 10.0.2 and 10.3.0, all under OS X 10.10.5. and Linux The drag-...
1
vote
1answer
44 views

Medium-sized graph won't build

Why can't Mathematica import a 40-KB file (mediumEWD.txt) and build the underlying graph in some decent time? I waited a minute, nothing. ...
3
votes
1answer
96 views

Mathematica can't Import data of NetCDF file with Datasets name including “.”

I have downloaded NetCDF data file EVE_L3_merged_1nm_2015323_005.ncdf from http://lasp.colorado.edu/eve/data_access/evewebdata/products/merged/ and read it by Mathematica 10.0.2 on my windows 7. <...
1
vote
1answer
80 views

Downloading a number of images from a web site as a list

For a MachineLearning project I need to form a training set using images taken from the web page containing lots of them. Like, for example this one. It would be very convenient, if all the images ...
1
vote
1answer
95 views

HDF5 file managing for dummies

I am new to HDF5 format and I am also not hundred percent confident with Mathematica. I have googled to find out examples to deal with HDF5 files in Mathematica but couldn't find one that work out for ...
4
votes
0answers
77 views

File Formats for Scientific Data

I have a simulation written in another language which currently just dumps all its data (doubles, lists of doubles, lists of lists of doubles) in lines in ASCII, and then I read it into Mathematica by ...
0
votes
1answer
59 views

file import from website failed (Http status code 403 returned) [closed]

I failed import an xls file from website in Mathematica but got no problem to download it directly using chrome. Can anyone help me solve the problem? Thanks. The detailed situation is listed as the ...
4
votes
1answer
95 views

Importing large datasets using streams

I work with large data sets with 22 columns and up to a million rows. Each row contains one observation with several variables. All variables are numbers. Simplyfied example: 1, 1, 2, 3, 4, 5, 6,...
3
votes
1answer
182 views

Run Command Not Executing Node

How do I make the following command work in Mathematia? Import["!\"C:\\Program Files\\nodejs\\node.exe\" -p console.log('test')", "Text"] I don't get any output ...
10
votes
1answer
120 views

Converting text from unsupported encodings like 866 into known by Mathematica?

The list of character encodings currently supported by Mathematica is still extremely limited. For example, it supports only three standard IBM PC (OEM) code pages: ...
10
votes
1answer
153 views

Is there an efficient way to load a large list to Mathematica from R within Rlink?

I'm working on something that involves using both R and Mathematica. For this something, I first generate a large R list (1000 matrices, each 200x1000, mixed integer and real values) and then need to ...
2
votes
0answers
126 views

Animate FromQuarternionTo3DRotation nb file with 4 quarternion values

I have a csv file. Inside the csv file, there are few rows of 4 quartenion values. I would like to animate the quarternion nb in http://demonstrations.wolfram.com/FromQuaternionTo3DRotation/ I ...
1
vote
0answers
68 views

Import using POST method and web-page drill down

A response to a previous question about invoking the POST method via Mathematica was most informative in trying to further understand the intricacies of using the POST Method to obtain tabular data ...
1
vote
0answers
36 views

How to test if Import was successful? [duplicate]

I am importing and processing a bunch of files. Sometimes, for whatever reason, some of these files are not successfully imported so I'm looking for a way to Abort ...
0
votes
1answer
119 views

how to import a matlab 3 dimensional array into mathematica

I have created a three dimensional array "data" in matlab by using the following commands : ...
2
votes
1answer
80 views

Extract arguments from MeshRegion created by STL import

I've been trying to extract points and polygons from a MeshRegion expression created by importing an STL file. At first I thought I could use a simple ReplaceAll as shown below: ...
8
votes
1answer
198 views

CloudDeploy - Import[x] issue

My question is about why Import executed in Wolfram Cloud with a fixed value (see A) works and with a variable (see B) doesn't when you use the form and submit the value 5565471199 (same as the fixed ...
1
vote
1answer
95 views

Multiple Import and Export of Images

I wrote a program that imports an image and creates three new images, for example "black and white" or "grey scaled". My problem is that i work with around 200 images and it takes a long time to ...
10
votes
3answers
132 views

Unwanted extra spaces at HTML tag boundaries when using ImportString

What causes the following unexpected behavior? ...
0
votes
1answer
63 views

Exported picture has less MB than imported

I have to duplicate a picture several times – and each time the duplicate shall have another name. I do this with mathematica 10 with the following easy code: ...
0
votes
1answer
83 views

SocialMediaData[“Twitter”] - strange output

I am getting error messages when I use SocialMediaData["Twitter"]: ...
0
votes
1answer
88 views

How to import columns of data (.mat file)

I have a two 100x2 .mat file and I would like to get the elements stored as pairwise entries i.e. something like data = [{a1,b1},{a2,b2}..{a100,b100}]. Can someone help me do this efficiently?
1
vote
0answers
70 views

How to import and export msgpack?

MessagePack is an efficient binary serialization format, I find it much better than JSON. There is currently (as of v10.3) no support for this in Mathematica. Does anyone know of third party ...
1
vote
1answer
99 views

Using ReadList to import specific arrays of a multi-dimensional variable

Consider a large numerical variable (almost 1GB) which was constructed like below: output={scalar1,{Matrix1,Matrix2,Matrix3,scalar2}}; I used ...
1
vote
0answers
46 views

Error when importing XML - XMLGetString::pserr: MalformedURLException

I am getting the following error when trying to import XML: ...
4
votes
2answers
106 views

Reading an ASCII file mixing text and numerics in Mathematica

We have a sequence of large data files (LAMMPS dump files) which begin like this: ...
2
votes
0answers
93 views

Confocal Microscopy

Is it possible to direcly import Nikon ND2 files (e.g Confocal microscope 2D or 3D stacks files)? Otherwise how can we import TIFFs of 3D stack and process it as a single "entity" so to speak? ...
2
votes
1answer
99 views

How to download tables from a url?

I'm trying to import all the tables on a website, this one in particular: https://aws.amazon.com/ec2/pricing/ For local files that are already tabular, ...
4
votes
2answers
124 views

Import Data different column length

Lets assume, i have this data.txt file. s1/km t1/h s2/km t2/h 20 1 40 1 40 2 80 2 60 3 I define myself a function ...
0
votes
0answers
69 views

How to prevent space trimming when importing HTML with ImportString?

I am importing a HTML-formatted string with ImportString[string, "HTML"] to properly parse all HTML-escaped characters like ...
2
votes
3answers
110 views

Importing and saving .csv files as variables with the original filebasenames

I have a modest number of .csv files that I want to import into mathematica. I would like to save their contents as their filebasename for use throughout my notebook, but I am running into errors as ...
3
votes
1answer
268 views

Import a table from a text file or string

XYScan produces results in the following form (as *.txt): ...
0
votes
0answers
29 views

Save lists to re-open with Mathematica [duplicate]

I want to save a result of a computation in a file to re-open then in Mathematica in a new session. What is the most efficient and simple way to do this? To be specific, I am using ...
2
votes
1answer
120 views

Fourier of List

I have such a problem. I try to evaluate and plot the spectrum of large list, and this is what I get: ...
3
votes
2answers
116 views

Troubles importing date and time from CSV file

I'm trying to import CSV file with the following format: 20150803 00:00:01.649,1.09675,1.09678 using this code: ...
29
votes
4answers
2k views

How can I import a huge CSV file quickly?

I have two CSV files, each one is around 1 GB of data. When I use Import["file.csv"], it takes a very, very, long time to import the data. So how can I accelerate ...
0
votes
1answer
192 views

Network/Graph Visualization read edgelist

I have what it seems to be a very trivial question, but after searching for hours I was not able to find an answer, so I am asking here. I have an edgelist for a graph, a 2 column csv file with id1,...
2
votes
1answer
43 views

Import variable assignments from external files into different contexts

(I use Mathematica 9.0.1 on OS X 10.10.5.) I have two text files. One is named file1.txt with the contents a = 4 b = 15 c = 23 ...
1
vote
1answer
225 views

Import camera parameters and data from *.sif image files? [closed]

By default, Andor's line of scientific cameras saves data in an apparently undocumented *.sif format. Are there any Mathematica packages or code that can help import these data? I've inherited an ...
1
vote
2answers
68 views

How do I import a non-directed graph in graphml format?

I have created a graph with undirected edges, and I'm trying to import it into Mathematica. However, when I import it, I get directed edges. ...
1
vote
0answers
86 views

Import a column of data, make a sum on them [closed]

I import a data file, then do calculation on it and after that I want to sum on my output data. Here is my sample code: ...
0
votes
1answer
37 views

Import n'th data from a file and do calculation on it [closed]

I want to import a n'th data from a data file and then do some calculation on it. Here is may sample code: ss = Import["myfile.data", {"Words", 3}] gg = ss + 1 ...
0
votes
0answers
60 views

Using Import during initialization, i.e., in an init.m file

I am trying to import a list of directories from a file during initialization. I wrote a package that defines a function to import the file. When I test the function in a notebook or execute the <...