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
2answers
445 views

Importing data into an array, column by column

I'm building a large matrix having different sized rows consisting of a few columns. The different columns are imported .txt files. Why can't I build the matrix column by column? For example, I ...
0
votes
0answers
69 views

Importing specific columns of a .txt file [duplicate]

I have text delimited file, with data in four columns. How to use ReadList to extract only the first and the fourth column.
3
votes
2answers
216 views

Speeding up TIF import

After trying to import a $\approx 2$ GB TIF file with the Import command, I noticed that the process takes $\approx 15$ minutes or so, which seems excessive, especially when compared to other software ...
1
vote
1answer
234 views

Reading FITS file [closed]

I am trying to read in the FITS file into Mathematica. My FITS file is very simple, it should be 2 columns of numbers. What should be the correct Mathematica command to convert this fits file into ...
3
votes
0answers
158 views

Strange behavior of undocumented RawArray and ArrayObject expressions

I discovered several strange results and inconsistencies while trying to understand what undocumented RawArray and ArrayObject ...
7
votes
1answer
473 views

How to read data from IBM 32-bit floating point binary file ? (not the common IEEE !!!)

I am trying to read a binary file. This file records seismic data. Basically its first 3600 bytes are for the general file information, following are for seismic traces, each begins with 240 bytes for ...
0
votes
1answer
486 views

Importing a named range of cells from Excel

I have a macro (is that what you call it?) set up in Mathematica and it runs fine. What I want to do now is set up my notebook to look through an Excel document (.xlsx) and pick out a certain set of ...
2
votes
1answer
480 views

How to import a Microsoft Word document into Mathematica?

I have a Microsoft Word document in DOCX format. I need to import it into Mathematica as a String preserving all formatting (font, size, bold/italic style, colors, ...
1
vote
0answers
107 views

Errors importing UTF8 file to mathematica

I'm trying to import this file: Import["https://dl.dropboxusercontent.com/u/35192406/jarlaxxe_tweets.\ csv", CharacterEncoding -> "UTF8"] But I am getting ...
0
votes
1answer
132 views

Import variables from excel

I have an excel file I am trying to import into Mathematica. It is in the format of variables names in the first row of each column and then the data underneath. One of the columns specifies ...
5
votes
1answer
131 views

Importing Data with Line feeds

I am trying to import data from a CSV file into Mathematica that contains line feeds in certain elements that I wish to be properly rendered in Mathematica. I suppose this has something to do with the ...
13
votes
2answers
357 views

Problem importing URL with Greek characters

I'm considering buying a car. So I thought why not make a web-crawler in Mathematica to pile-up car data? Brilliant idea. Then I found this Greek website, gocar.gr, which just so happens to have all ...
3
votes
3answers
1k views

Import specific data from Excel to make a plot

I need some help with this: I have imported data from an Excel file and I need to make a contour plot of it. The data are in table-like form. Here is a sample of the first few 'rows': ...
5
votes
1answer
379 views

Reading in Huge Text Files

I would like to read in really large text files (about 2GB) into Mathematica. The structure of the file is such that the first row and the first column are text i.e strings. Rest is all numbers. Is it ...
1
vote
1answer
315 views

Making a ListVectorPlot3D from data in an external file

I have a .dat file with six columns: {x y z vx vy vz}, where x, y, z are space coordinates and vx, vy, vz are the vector components. How can I use this file to get ...
2
votes
2answers
568 views

How can I import images from a Microsoft SQLServer database?

I have a table with binary data (images) in Microsoft SQlServer. I want to import that data and convert it into Image format. I wrote the following code, but it's ...
0
votes
1answer
140 views

Problem with importing format of data from Excel?

I am trying to import data from Excel. It is located in a single column of the Excel file but each cell contains a comma separated pair of two values as a,b. When I am importing them I have this ...
3
votes
2answers
123 views

how to convert string output into executable commands

temp = (layer = #; layerS = ToString[#]; StringForm["Import[\"drainCdg_gdat0``\",\"Table\"]", layerS]) & /@ {1, 2, 3} how to get the output of ...
5
votes
1answer
209 views

How to import non-text data from std input in a Mathematica script?

Or maybe a better question is - how can I get a stdin stream? I need to run on Linux. I did look at Reading from STDIN, or: how to pipe data into Mathematica, but ...
0
votes
0answers
139 views

Behavior of copy and paste with different image formats

Ok, let's say I create a 1x1 pixel image. i = Image[{{0}}, "Byte"]; Now I Export["image.png", i] the image and import it into ...
0
votes
0answers
54 views

Import and file symbolic links

Can Import be forced to follow a file symbolic link (a.k.a. alias (Mac) or shortcut (Windows)) to the true file?
6
votes
3answers
176 views

Is it possible to Import urls not type “”

These days I often copy urls from Internet Explorer's address bar. When I paste the url into a Mathematica cell it is neither a string nor a expression. ...
2
votes
0answers
163 views

Exporting Specific Cells of Many Workbooks into One using Mathematica

I currently have a large number of detailed files from which I would like to extract certain cells' information to make an Archive spreadsheet. There are approximately 9 parameters of each ...
2
votes
2answers
188 views

Importing LTSpice data into mathematica

I am working with LTSpice (Discret electrical circuit ( Spice) simulator). I would like to import LTSpice ouput data into mathematica for processing and plots. An example of a file can be found here ...
11
votes
3answers
4k views

Plot data from txt file?

I have data in file.txt which can be expressed by 20000x11 matrix. I do not want to import all of these data. How can I plot graph of the column 1 & column 4?
6
votes
2answers
298 views

How to show wireframes on imported Object / Mesh (.obj file)

I've managed to import a Wavefront (.obj) file and store it in a variable like so: ...
6
votes
1answer
162 views

Importing images from the web using ImportString & URLFetch

I can bring images from the web using the Import command like this: Import["http://blog.wolfram.com/wp-content/uploads/2008/06/se-30.jpg"] Sometimes the web ...
3
votes
4answers
451 views

Importing or reading data in binary format 212

I have a binary data file in format 212, and I want to import the file into Mathematica. How do I read or import binary format 212? I almost have no direct experience of working with any binary ...
0
votes
2answers
135 views

Import matrices side-by-side separated by TAB

The problem is 0(TAB)0 interpreted falsely as a dark red square although it should be a dark red square surrounded by zeroes/ones. Import has different data-formats ...
2
votes
1answer
138 views

ReadList importing negative times

This is probably an easy question to answer, but I need a fresh eye... I'm struggling with processing the following file (extract shown here) It's a list of dates, and positive/negative time durations ...
0
votes
0answers
53 views

How to monitor the progress of Importing files? [duplicate]

I want now,how much of percentage was imported,while importing any file. How can I solve this? Can anyone help me? Thank you.
0
votes
2answers
201 views

Import large amount of data with time stamps

I have a large data file (150 000 lines) which I want to import in Mathematica. The first few lines look like this ...
2
votes
0answers
96 views

Significant platform-dependent efficiency when importing data?

I'm curious, as I understand that answer this way: If you are using a Linux derivative or something like cygwin on Windows, then this is an efficient solution for reading only the third field ...
2
votes
2answers
724 views

Importing several huge files with headers & footers

having here several files in ASCII format http://ge.tt/91rv0Jf/v/0 I want to import, while removing headers and footers and then join the several lists. ...
0
votes
1answer
558 views

Error messages in importing data file

I want to copy the data in a public file (link in code below) and put each row of the data as a sub-list, i.e., in the format ...
0
votes
2answers
132 views

Convert *.txt file

I would like to Import and Convert a *.txt file which looks like: https://docs.google.com/file/d/0Bw-308nJcF01Yl92RURCLUg4VzQ/edit?usp=sharing and turn it into a Matrix which I can use to make ...
2
votes
1answer
165 views

Using NetLink to Import Excel File

I can import an Excel file into Mathematica easily: But when I try from .Net it fails: These are the commands and errors I am getting: ...
0
votes
1answer
108 views

How to import sound file from computer? [duplicate]

I know you can import sounds/images from the Mathematica library, but I was wondering if I could import sounds I have on my computer (i.e. .wav files)? I've tried using the Import functon and properly ...
3
votes
2answers
470 views

Check Google PageRank for a given URL

Does anyone know how to write a Mathematica function that returns the Google PageRank of a given URL? I found a tutorial for achieving this in a bash script here, but I have no idea how to port this ...
0
votes
0answers
213 views

Determining if a point is inside or outside a 3DS (.3ds) or 3DS MAX (.max) object?

Imagine I import some 3DS (i.e. 3D studio) file (http://reference.wolfram.com/mathematica/ref/format/3DS.html) or a 3DS MAX file. How could I place this model (say, the 747.3ds file in the ...
0
votes
0answers
31 views

Exporting large expression [duplicate]

I generated a huge mathematical expression (~200k terms, impossible to simplify yet) and want to save it for later analysis. Last time I did Export to *.nb file and ...
2
votes
5answers
248 views

Creating ordered triplets from an Excel sheet

I have an Excel sheet of the form: " " a b c 1 R S T 2 U V W 3 X Y Z Where every entry is a number (except the blank quotes, ...
1
vote
3answers
124 views

problem with Importing multiple files

I need to import about 100000 "dat" files to my progrom. I want to do this using the last answer to this question: Importing multiple files using a for-loop I know that I should define a list of all ...
7
votes
3answers
267 views

Unencoding encoded URLs in a function

Is there a built-in function for decoding encoded URLs in Mathematica? I would like to convert an encoded URL, for example ...
7
votes
1answer
214 views

Exporting German Umlauts to PDF and importing them doesn't work - character encoding problem

I am using Mathematica 9.0.0.0 under German Windows 32bit. I am on trying to export and import German text to PDF and re-import it. It seems that there is a confusion about the character encoding. It ...
11
votes
1answer
386 views

Get both output and return code of external program

Run["program"] will run an external program and return the return code. Import["!program", "String"] will run the program and ...
1
vote
3answers
1k views

Importing multiple files using a for-loop

once again I am stuck solving a seemingly easy problem :( I would like to make a List of tables by importing data from several txt-Files. Importing the data into a table works so far and I am able to ...
2
votes
4answers
1k views

Plotting a large number of data points

I would like to know how to plot when I have a large number of points (arround 600) in a specific format: ...
3
votes
1answer
97 views

Reading RData files without RLink

I am using Mathematica 8. I would like to read some RData files which I have received. I do not currently have an installation of R on the machine with Mathematica.
1
vote
1answer
168 views

Automating sequential import of data from web

I am trying to import data from multiple web pages hosted by a single online source. The data is posted by the source as one data set per web page for each week of the year. I would like to import the ...