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

3
votes
1answer
71 views

How to Import a password protected Excel (XLSX) file?

I have a password protected Excel (XLSX) file that I would like to Import into Mathematica. Is there a hidden option in Import ...
6
votes
1answer
66 views

Reading data from Google Docs

I am working on a personal project involving a CloudDeploy[ ] that reads data off a Google Doc and then works with it. Ideally, the Google Doc is either a text document or a spreadsheet which contains ...
30
votes
5answers
4k views

Importing a large Excel file

I'm trying to import a simple Excel file containing 94,000 rows and 52 columns of various types, mostly Reals. It's a 38-MB file. I get this super helpful error ...
2
votes
1answer
59 views

How to validate an XML file against xsd in Wolfram language?

I am planning to write a package to read data which is saved in XML format that should follow some XML schema. As part of the reading I would like to do error checking, namely schema validation. So is ...
4
votes
2answers
65 views

Excluding Specific Rows Using Import[…]

As the question states, I'm trying to import a .csv file but I would like to exclude certain rows (points which I know are bad data). This is easy when the points ...
1
vote
1answer
47 views

Non-ASCII characters in txt file can't be import correctly by Mathematica10

I'm using Mathematica v10.0.2 on Win7. I have a text file in which there are some Chinese characters and I would Import the file into Mathematica as a string by: ...
2
votes
1answer
137 views

Classifying images in mass with URLs and CSV file

I'm looking to train a image classifier with a large number of examples and categories (30,000 & 100). I would then import a file of image URLs that need to be classified, and export the results. ...
0
votes
1answer
66 views

Importing .AVI to mathematica and frame extraction

I'm trying to import frames from a video with the extension .avi, using this piece of Mathematica code: Import["video.AVI", {"Frames", {5, 6}}] But I get this ...
6
votes
1answer
162 views

Import another Notebook as if it were a Package

Is it possible to import the contents of another (existing) notebook into the current namespace in the same way that I can with a package? I know that it would be best to use a ...
24
votes
2answers
6k views

How to import all files of a folder at once?

I know how to import one textfile by calling its name filestring = Import["myfile.tex", "Text"]; Then "filestring" is a string with the myfile content. How do ...
2
votes
3answers
123 views

Importing a VCF file with quoted-printable encoding

The documentation has an example importing a VCF address book file which works fine: Import[ "ExampleData/wolfram.vcf" ] {{FormattedName->Wolfram Research, ...
9
votes
2answers
492 views

Convert quoted printable aka PrintableASCII characters to UTF-8

I have several .eml email files to import. Some of them were saved as quoted-printable 7-bit encoded. I skipped through the Mathematica documentation and found ...
0
votes
0answers
34 views

What does copying Output cell using Copy As > Plain Text actually does? [duplicate]

So, an input cell after evaluation gives an In[X] := str1 = ... Out[X]:= .... If I right click on the right edge of the Out[X]'s cell, and select Copy As > Plain ...
0
votes
0answers
37 views

load NOAA ENC s-57 chart?

Is it possible to load a NOAA ENC s-57 formatted nautical chart into MMA 9.x? Particularly in MMA9.x within the MAC OS? -There does not appear to be any discussion of importing nautical charts ...
1
vote
2answers
131 views

How to cut imported audio?

How to cut an audio clip imported by the Import function? E.g. I'm interested in the content starting from the 100th sample up to the 200th. I'd like to avoid ...
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". ...
4
votes
2answers
69 views

importing a 150 MB .wav crashes Mathematica

rawdata = Import["rawdata_10min.wav"] crashes Mathematica when the file is 150 MB, but does not crash Mathematica when the file is 20 MB.
2
votes
2answers
576 views

How to Flatten and stack Efficiently 50000 Images

I have 50000 grayscale images with 56*56 pixels each one. I need to flatten images and stakck it in the same array with dimensions 50000*3136 after that export the file as .CSV. I am doing this code ...
0
votes
1answer
80 views

Importing $\LaTeX$

I have a LaTex file, and import it this way: tex=Import["texfile.tex"]; Now according to Help, this returns a notebook expression: ...
3
votes
1answer
32 views

Skipping commented in a stream from OpenRead

Is there a solution to skip comments in text files that are imported with OpenRead? I know there are solutions for Importand <...
1
vote
1answer
66 views

How to interpret and extract the information from the JSON (JavaScript Object Notation)? [closed]

How to interpret and extract the information from the JSON (JavaScript Object Notation)? I would extract the information and plot the information graphically. Please advise and comment. Thank you. <...
0
votes
1answer
43 views

How to analyze a large wav file?

I have a large wav file (100 Mb). Any operation on it is time consuming. For example, to Import it takes about 1-2 minutes. The next step seems to be to figure out how it is encoded, since WAV files ...
0
votes
2answers
83 views

How to make a graph form imported spreadsheet data [closed]

I've three csv files: v.csv for vertex data, like this: 1 2 3 ... e.csv for edges: 1,2 2,4 2,24 3,1 ... and vcoor.csv for vertex coordinates: 23.4, 35.2 23.4, 40.3 ... I know how to construct a ...
2
votes
1answer
83 views

Change bond cutoff distance when plotting .xyz files

When plotting a molecule from a xyz data file, Mathematica automatically adds the bonds between the atoms. But in my case it adds too many bonds, not only between nearest neighbours but also between ...
7
votes
2answers
231 views

Extracting and displaying data from GW150914 hdf5 files

Has anyone looked at the LIGO data using Mathematica or know how to do this? I'm not familiar with the hdf5 format but I've been able to import the data, consisting primarily of 131,072 floating ...
1
vote
1answer
79 views

Cannot import PDF with JPXDecode or JBIG2Decode Filters?

I am trying to what I think should be a very basic thing, which is to import a large PDF from my files into Mathematica. The long term goal is to extract images from the PDF. The original command was ...
1
vote
2answers
534 views

Importing base-64 encoded Canvas element into Mathematica

The aim of this code is to transfer a web image into webMathematica for image manipulation. Since the question here failed to resolve direct URL loading, I tried a different method of extraction ...
5
votes
0answers
74 views

why does ReadString[“fname”,term] open a persistent stream, and how to close it?

Bug introduced in 10.0 and fixed in 10.3.0 Create a file temp.txt with the following content: test1 ;;; test2 ;;; test3 ;;; ...
25
votes
1answer
331 views

Getting Mathematica.SE reputation data

I'm asking the following on behalf of Mr.Wizard. On StackOverflow I used the old v1.0 SO API and Mathematica to obtain user reputation data. Now we are no longer a tag on StackOverflow and the v2.1 ...
0
votes
1answer
55 views

Combining first 5 columns from CSV file into AbsoluteTime date

Thanks in advance for all your help. I need to import data from a CSV file that looks like : (easier to read in excel) I would like to convert the data into timestamps by creating a Table with 2 ...
0
votes
1answer
51 views

Improving performance Importing Table

I am currently working on mathematica script on a Raspberry Pi, which will periodically (10 secs) be launched by a bash script. However the runtime of my script really isn't the best. It's actually ...
4
votes
1answer
88 views

How to get sub property from json result?

I'm brand new to Mathematica and I imported a json: data = ImportString["{\"x\":1,\"y\":1}", "json"] and result: ...
2
votes
0answers
83 views

Using SHP files to draw a density map [closed]

My SHP file of census block groups has polygons and associated employment data for each block group. Is there a simple way to draw an employment density map? I've played around with ...
11
votes
3answers
1k views

Is it possible to import dates and times directly as AbsoluteTime and by pass DateLists?

Date and time calculations are quite slow so I am exploring ways to minimize the number of calculations performed. As an example: ...
11
votes
2answers
1k views

Stream CSV or TSV files

RAM limitations make import impractical for large CSV files. Is it possible to Stream CSV correctly? str = OpenRead["EU.csv"]; Read[str, "CSV"] Read::readn: ...
3
votes
2answers
105 views

How do I run 1-855 data points( imported from excel sheet) into a formula to obtain value for each data point?

I am very new to Mathematica and I just couldn't figure out the solution for the following problem. I have two columns in an Excel file. I have imported the 1st column as ...
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: ...
1
vote
1answer
78 views

How to get missing lines from a file? [closed]

Let's say I have this file dat.csv which basically is a number of strings like that: animal horse duck dog plant tree grass sunflower sky oxygen nytrogen air ...
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-...
0
votes
2answers
55 views

Assigning columns of data from a file to variables extracted from headers

I'm very new to Mathematica. I want import a file in which the first colum is a function f1, the second another function f2. So the file looks like this: ...
3
votes
3answers
325 views

URLFetch functionality for a Persian website

I want to fetch the content of a Persian website. I tried URLFetch["http://www.tsetmc.com/"] Why is Mathematica unable to recode the characters in the results ...
1
vote
1answer
92 views

Export the coordinates of STL object

Hi I currently have a STL file of a 3D object Is it possible for me to obtain the coordinates of the object so that I can just input that into Autodesk Inventor
0
votes
1answer
74 views

How to convert this .txt data into a list of points [closed]

Question How to import data from a .txt file into Mathematica and convert it to an expression? Download the .txt file here (click download): http://pastebin.com/2NW2DfiE
0
votes
1answer
75 views

Why vertices number increased when importing .STL file

I import a .STL Import[*.st,"VertexData"] file on mathematica and I remark that the number of vertices is increased comparing to the number given by Blender. ...
9
votes
3answers
450 views

Why doesn't DumpSave work for elements created within a local notebook context?

I recently noticed that when dealing with notebooks with local context, I cannot successfully DumpSave variables, or, rather, when I call ...
3
votes
2answers
932 views

video image recognition [closed]

Has anybody experience with video and image recognition? I've made a video of two teams playing soccer. Now I would like to translate each soccer-player to a (x,y) coordinate and follow them during ...
3
votes
1answer
69 views

Reading an exported List

I have exported a list of 2d coordinates as a List: Export["F:\\coordinates.dat", coordinates, "List"]; You can access the ...
1
vote
0answers
42 views

What is a good way to import interpolating functions of large size? [duplicate]

I was generating a set of eigenfunctions from a differential equation using NDEigensystem. Because of the computer time cost is too high, I thought it'd be better ...
0
votes
1answer
76 views

Applying a formula to the data in several files [duplicate]

I am calculating with the depth data recorded in a number of files with extension .log. The depth data is like this and I loaded it by means of Mathematica: ...