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
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: ...
2
votes
2answers
284 views

How can I remove text headers when importing a numeric table

I have a file let's say 1.txt having numbers like: fgdgfdg fhdfdh 0.000105533 1.00E-04 0.222281 1.00E-04 0.444456 1.00E-04 0.666631 1.00E-04 asdas ddfdsfsd 0.111193 0.166733 ...
2
votes
2answers
375 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 ...
2
votes
2answers
148 views

How to read non-standard-format data into Mathematica from a file

I would like to read non-standard-format data into Mathematica from a file. How can this be achieved? For example, how can I read the following text file of data into Mathematica: ...
2
votes
2answers
115 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$. ...
2
votes
1answer
436 views

Having problems with importing data in .dat format

I have a .dat file from FORTRAN output and I am trying to plot the results. The dat file is a series of rows with the row number as the first column. Now, every other row is empty, that may be ...
2
votes
2answers
56 views

How to prevent conversion of number forms to numbers in Import [ webpage, “Data” ]?

I have tabular data on a webpage. It looks like this: Import["http://mfvonh.me/numericalTable.html", "Plaintext"] 1.0 1.1 3.53 However, I have ...
2
votes
1answer
150 views

Saving a graph of a great number of nodes

I'm developing a code where I get graphs with over 10K nodes. These graphs have a particular relationship between clustering and degree that I need to save for future analysis. The problem is when I ...
2
votes
2answers
168 views

Modifying imported 3D file

Since I am visualizing my work using Mathematica, I import some 3D models of molecules to my notebook. So, the question is, is there any way to modify somehow that imported models inside Mathematica ...
2
votes
2answers
196 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
595 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
231 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
91 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
292 views

How to export a table of complex numbers?

I'm having problems exporting a table of complex numbers. I have: ...
2
votes
2answers
778 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
440 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
119 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
1answer
54 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
2answers
116 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
110 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
152 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
2answers
149 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
1answer
729 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
508 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
151 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
114 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
140 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
183 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
451 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
453 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
2answers
73 views

Overwriting first line of large file

As mentioned, I wish to read the first line of a file, and if needed, overwrite it with a new string. The aim is to have a CSV with a list of possible elements. Example: ...
2
votes
1answer
95 views

Importing web page data

I tried importing a webpage using Import: ...
2
votes
2answers
156 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
172 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
91 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
142 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
270 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
123 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
61 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
166 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
458 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
155 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
4answers
109 views

Importing data to Mathematica

I exported the result on NMinimize with .dat format. The data looks like: Then I imported the data using: ...
1
vote
2answers
925 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
125 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 ...