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
2answers
190 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 ...
2
votes
2answers
575 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 ...
2
votes
1answer
229 views

How to solve issue with exporting / importing data to and from Excel

Background ( simplified ): When I export data to Excel like ...
2
votes
2answers
87 views

Importing Data and Devoting Their Names to Them

There are some files in a directory. I have used of SetDiroctory to access all of them. SetDirectory["C:\\Users\\SE7EN\\Desktop\\mathematica\\test"]; I can visit ...
2
votes
2answers
267 views

How to export a table of complex numbers?

I'm having problems exporting a table of complex numbers. I have: ...
2
votes
2answers
730 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. ...
2
votes
1answer
420 views

Read and filter a text file without importing

I have a large text file of a million sections. Each section contains A lines of header and B lines of numeric data. I want to read the first and last line of B from each section (to have a list of 2 ...
2
votes
1answer
117 views

Import a file only if it contains a certain pattern

Let's say I have three files containing: File 1: x y z 1 4 6 File 2: x y z 2 5 9 File 3: x y z 5 4 8 My goal is to import the data from a file only if in ...
2
votes
2answers
112 views

Animation of moving rectangles in 2D from data file

I am not very familiar with mathematica but I know the basics so I thought I give it a try. For a project I have to animate rectangles moving around in 2D (later also 3D). The data come from a C ...
2
votes
1answer
103 views

Text analysis and loops

I need a loop for a text analysis involving about 1000 papers (identical structure of all papers) I have these two commands to read all the papers into memory. ...
2
votes
1answer
140 views

Importing data from excel and assigning a variable to each of its columns

How should I assign variables to the data imported from excel containing 3 columns which are time, mean and standard deviation. I want to perform operations on the three variables to get new ...
2
votes
1answer
663 views

Having Problem with Importing Excel file to Mathematica Notebook?

I have solved some equations and exported the final results, which they are several Matrices, as a EXCEL file ( .Xls ). Now, I want to use these EXCEL files as my inputs to solve some other equations. ...
2
votes
1answer
484 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, ...
2
votes
1answer
146 views

diff-able text-only notebooks?

I would like to save my Mathematica notebooks as plain-text documents, so that I can keep them under git version control. I thought that ...
2
votes
1answer
50 views

How to read from /dev/random?

I am looking to read a few bytes from /dev/random on OS X and Linux. The simplest approach fails on both operating systems (see below). Why? What is a ...
2
votes
1answer
99 views

ReadList with header and foot lines

I want to do some large data analysis, and i want to be able to import files in a fast way. I tried Import, but it is quite slow; ReadList takes half the time. This is the code I was using: ...
2
votes
1answer
94 views

Reading many single files and creating numbered (? or indexed) variable

I tried many different approaches, but I could not solve the following problems, I appreciate your help: What is the best way to read many data files? I mean we have ...
2
votes
1answer
134 views

Is it possible to take data from external database for the CDF embedded in webpage?

I have embedded my CDF in facebook.The data for the CDF should be taken from facebook server or my server dynamically.I tried out but its not working in dynamic code iam not able to access the data at ...
2
votes
2answers
137 views

ReadList and Import cannot read data separated by “,” [closed]

I have a data file contains several lines of numbers that separated by "," and I cannot load it correctly with ReadList and Import. Here is a example: with data contains "," and "\n", simple ...
2
votes
2answers
170 views

import a list of replacement rules

I have a text file with a set of replacement rules, of the form x^3y^2 -> 4, xy^2 -> 2, ... for example. I'm having some issues trying to figure out ...
2
votes
1answer
414 views

How to export/import function values [duplicate]

I have a function with two variables: f[x_,y_]:=f[x,y] = ... I calculated some values (they are fractions like 435345345/3424242424) and would like to store the ...
2
votes
1answer
435 views

Importing data sets from plain-text files and performing operations on them

I am working with a lot of daily weather files in the txt format. I need to calculate a daily quantity from each of them, e.g., daily light intensity, which ...
2
votes
1answer
85 views

Importing web page data

I tried importing a webpage using Import: ...
2
votes
2answers
146 views

How to delete all rows in datafile that contain a string

I'm importing some data from a file. However, the file was created by an unreliable instrument, such that the data looks like this: ...
2
votes
1answer
166 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: ...
2
votes
1answer
57 views

Avoiding re-evaluation of RegionPlot3D on a second computer

After running a RegionPlot3D named "testplot" on my desktop, I followed an earlier suggestion from the forum and saved it using: ...
2
votes
2answers
180 views

Import[] bug (video)?

I have the following code: frames = Import["myvideo.avi",{"Frames",{50,60,70}}]; This imports frames 1,2, and 3 of the video, not 50,60 and 70. It imports the ...
2
votes
1answer
84 views

Import YAML file into Mathematica

Has anyone implemented the import of YAML data files into Mathematica? I suppose some sort of transformation into a nested list of rules would be the way to do it. Thanks
2
votes
1answer
140 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 ...
2
votes
5answers
253 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, ...
2
votes
1answer
122 views

Implementing a For (?) or series or loop (?) for individual results for every x to n

I'm working on improving a modeling formula and have spreadsheets worth of data to use, but my work so far has been quite tedious. I'm essentially pulling 20 rows of data from each separate sheet of a ...
2
votes
0answers
59 views

Antialiased text in manipulate constantly re-evaluated, ignores TrackedSymbols

I am trying to display antialiased text (using the ImportString[ExportString[]] method shown here) but inside a manipulate so that the text can be changed interactively. I have found a way to do this, ...
2
votes
0answers
57 views

The “right” way to define a custom Encoding format?

I have implemented an Import|Export format for xz that behaves like gzip and other encoding formats: ...
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
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
0answers
438 views

Can not Import PDF

I try to import PDF and extract text from it Import["D:\\Vegetarian MS.pdf", {"PDF", "Plaintext"}] but with some files I have a problem like this ...
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 ...
1
vote
2answers
139 views

Importing numerical data from RTF file

This might be a very simple question but I have been struggling with it for a couple of hours, so thought maybe someone here can show me a quick way of solving it. I have a file in rtf format ...
1
vote
2answers
112 views

How to extract data depending on Position of First zero?

I have a file (attached as an image) which I imported to Mathematica and only extracted the first and second column. My problem is that I want to extract the data beginning from the row where $A=0$. ...
1
vote
2answers
914 views

Can I improve the importing speed of Excel data?

I have data in an Excel spreadsheet that has 4 rows and 1,000 columns. I am using Import as follows: ...
1
vote
2answers
117 views

Problems with importing a .txt file

I have some problems with importing a .txt file as a table. This is the file. I tried importing it with data = Import["data.txt", "Data"] I want to access ...
1
vote
2answers
195 views

Import image using InputField and Button

I've got a pretty basic problem, which is probably easily solved, but for all my efforts I haven't found a solution yet: I want to make an Image importer of the following form: An ...
1
vote
1answer
400 views

Interpolate specific columns of data

I have a txt file with 3 columns of data: x y1 y2 How do I import the file then create 2 functions, one interpolated with {x,y1} values and the other interpolated with {x,y2} values? This ...
1
vote
1answer
410 views

How can I speed up image importing? [closed]

The following examples show how slow it is to load a simple GIF. Can anything be done to make it faster? System #1: Mathematica 8.0.1.0, HP notebook, Win7 64Bit, 2 x 2.4Ghz Intel Core i5, 2GB RAM, w/ ...
1
vote
1answer
580 views

Importing a matrix from a text file

I have a $4 \times N$ matrix in a .txt file of the form: -17.071 137.567 16.554 0.65 -16.873 136.138 16.934 0.7 -15.397 135.738 16.894 0.7 -14.7 135.982 15.9 0.6 ...
1
vote
1answer
57 views

Importing adjacency matrix from file of 0/1 arrays

Is it possible to import adjacency matrix for graph representation, from simple text file with NxN (rows x columns) of 0s/1s: 0 1 0 0 1 0 1 1 0 1 0 0 0 1 0 0
1
vote
1answer
148 views

Alternating Axis Labeling between Left and Right Axis

I'm using the following to label a MatrixPlot: FrameTicks -> {{yticks, None}, {None, xticks}}, I'm labeling these ticks with text. It is impossible to get the ...
1
vote
1answer
319 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 ...
1
vote
3answers
125 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 ...
1
vote
1answer
169 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 ...