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
881 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 ...
4
votes
3answers
332 views

Plotting data with exponentials

I have some data with 19000 sublists such as : {" 7.9080000e+01 1.9283193e+04"} Where the first number is the value for variable ...
4
votes
3answers
232 views

Reading binary strings from file as strings

I have a file that contains binary strings like 01011 00101 01011 I want to import the file to Mathematica as a list of strings, but ...
4
votes
2answers
131 views

Reading from a file: complex number with small imaginary part

I'm trying to read a matrix from the next file: 1+1e-18i 24 42 23.43e-23i using u=Import["file.dat","Table"]; and then find, ...
4
votes
2answers
175 views

Workaround for Import not supporting the \leqslant TeX macro

$\{A\leqslant x\leqslant B\}$ Copy the code into Notebook, and you'll lose the less sign, this can be rendered well in ...
4
votes
3answers
3k 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': ...
4
votes
2answers
1k views

How to process .vtk file

I want to extract the cluster of points inside 3D box, is there any way one can do this in Mathematica?
4
votes
2answers
93 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: ...
4
votes
2answers
414 views

Image Rotation, Line Symmetry

I'd like to import an image, superimpose it, reduce the opacity of the overlaid image, and then use a manipulate to rotate the top image to illustrate rotational symmetry. The image below is using ...
4
votes
1answer
78 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: ...
4
votes
2answers
693 views

Importing array with complex numbers

This is probably an easy question: I am exporting the results from a longer calculation into a dat-File, then I set the cell to non-evaluatable and put an Import in front, so I can later work with the ...
4
votes
2answers
118 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 ...
4
votes
1answer
363 views

How to clean up messy data

The start of my question is about one specific situation - I have some erroneous lat/long values in a dataset which I need to clean up. But I'd like it to cover the overall topic of cleaning up messy ...
4
votes
1answer
2k views

Importing CSV financial data in Mathematica

I am trying to import a CSV file in Mathematica 8 with the aim of charting it with the TradingChart command. This is what I have done : ...
4
votes
2answers
59 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.
4
votes
1answer
391 views

CSV vs XLS for import

I need to import data from various database sources. At the moment I plan on importing files via a CSV file or XLS. All the data if in XLS would be on one sheet (notebook). Are there any advantages ...
4
votes
1answer
162 views

Order imported files by their alteration date

Probably a very easy question, but I could not find the answer, so it would be very nice if you can help me: Let us say I have 10 files, all with the extension ...
4
votes
2answers
146 views

Equivalent of __FILE__?

Many languages define a special identifier whose value is the path to the source file currently being processed. (For example, in C, this is done through the ...
4
votes
1answer
313 views

Attaching WolframAlpha data

I have used WolframAlpha since it was launched (now a pro member) but am new to Mathematica 8. Is there a way to automatically add data from WA to a Mathematica dataset? For example, what if I ...
4
votes
2answers
215 views

How can I encrypt/decrypt a directory?

I'd like to use Mathematica 10's new Encrypt and Decrypt functions to secure files and folders on my mac. Here's what I have so far but something goes wrong along the way, since by the end of this ...
4
votes
1answer
341 views

Using the variable in the MATLAB workspace using MATLink or any other packages

I have a program in MATLAB and after I run the program, I get some results in MATLAB's workspace. Now, I need to use these results in Mathematica. What I currently do is that I save the workspace as a ...
4
votes
1answer
77 views

Export and Import with special unicode characters

I exported a list of characters say: ClearAll[t, r, \[Theta], \[Phi]]; Export["hello.txt", {t, r, \[Theta], \[Phi]}, "List"]; the file has the correct symbols ...
4
votes
2answers
5k views

Importing from Excel

I'm trying to import a matrix from Excel to Mathematica. My code is: Import["desktop/stproj.xls", "xls", data, 1] The output is some weird stuff about population ...
4
votes
1answer
900 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: ...
4
votes
1answer
724 views

Mathematica PDF import and fonts

I am trying to put nice LaTeX labels on my Mathematica plots. I can do this manually, or by introducing an extra GNUPlot step into my workflow, but it would streamline the process considerably if ...
4
votes
2answers
56 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 ...
4
votes
2answers
138 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
187 views

Problem exporting and re-importing STL file

I wrote all code and there're no errors in code. Result of code is like first picture(left). But I can't Import that structure. The result of import stl file is second one(right one). How can I import ...
4
votes
1answer
201 views

Importing malformed XML: Import[… “XMLObject”] vs ImportString[…, “XML”]

It appears that Import[ url , "XMLObject" ] is more forgiving of improperly formatted XML than ImportString[ string, "XML"]. For ...
4
votes
1answer
220 views

How to prevent output truncation when importing large Graphics?

The Evaluation Preferences in Mathematica specify a maximum output size of 1048576 Bytes before truncation occurs. That makes a ...
4
votes
2answers
2k views

Reading in scientific notation from C++ to Mathematica

With a text file with entries formatted as (output from C++): f[38.67] = -2.5387862698183892298317350539374412777263289550697e-05; ⋮ Is there a way to read this ...
4
votes
1answer
100 views

How can I import html fragments as formatted cells?

I see that there is limited support for "HTMLFragment" in Export, but I figured with all the work that went into porting Mathematica into the Wolfram Cloud there should be a way to Import ...
4
votes
1answer
261 views

mathematica use too much memory to Import large dat file

Err... When I try to Import a .dat file by dat = Import["D:\\TIEGCM\\solar_input\\omni_m_all_years.dat", "Table"]; or ...
4
votes
2answers
482 views

Importing High Precision (22 digits) data from a file

I want to import list from a file and I am using ReadList but my data is in format like this 8.2457409790900004e+08 but it i being imported like $8.24574*10^8$. Is ...
4
votes
1answer
308 views

Importing FITS file from HEALPix

I am trying to read FITS file created by HEALPix software. The file contains a spherical map of a scalar field. There is the online support on how to use the file in IDL, but not for Mathematica. I ...
4
votes
1answer
192 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 ...
4
votes
1answer
89 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, ...
4
votes
1answer
327 views

How can I colorize an imported model?

How can I colorize an imported model from for example 3ds max? I'm trying to find the way to colorize a 3D plot from an imported model with something like this: ...
4
votes
2answers
51 views

NaNs in tabular data and import performance

I'm working with some data files that are just too large for Import. I tried using ReadList, specifying either ...
4
votes
1answer
179 views

Import audio in uLaw format?

How do I import a uLaw-format audio file into Mathematica? Here's an example: hello-world.ulaw For reference, here's the same file in wav format: hello-world.wav As I understand it, the uLaw ...
4
votes
0answers
29 views

Is there a way to use iframes in a notebook?

For me, mathematica online is totally unusable, but the EmbeddedServices would be great to use. I wish that these functions worked in Mathematica, is there any hack anyone can think of to get these ...
4
votes
0answers
73 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 ...
4
votes
0answers
148 views

How to speed up import of large csv table?

Loading less than 2 gB of csv data took 5.29 hours: ...
4
votes
0answers
49 views

Import succesful when file manually deleted

apparently Import keeps an imported file i the cache and doesn't complain for some time if a file is deleted manually from the system and then it is imported. If the file is deleted from within ...
4
votes
0answers
107 views

Monitor progress of ZIP file extraction

Importing a ZIP file containing potentially many individual files in a (custom) format using Import[filename, {{"*"}, "Gaussian"}] takes quite a while. How can I ...
4
votes
0answers
157 views

Problem with FTP import in V10

Mathematica V10 returns an error when download directory. URLFetch :: invhttp: "FTP: could not retrieve (RETR failed) the specified file." V9 successfully retrieves the same reference. This ...
4
votes
0answers
111 views

Import Excel data forcing links (ie workbooks) to be updated

We have noticed importing data from an Excel spreadsheet doesn’t update links. The problem with this is if you import a spreadsheet that comprises of linked workbooks data and those workbooks have ...
4
votes
0answers
197 views

Single image import from stack via FTP connection

Background I would like to create a CDF document that is embedded on a webpage. The CDF will contain some image display ...
4
votes
0answers
264 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 ...
3
votes
3answers
4k 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 ...