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

0
votes
0answers
73 views

How to render a 3d image of the galaxy? [on hold]

I recently came across the Uniview software package, there has even been a TED talk about it. Here is another example of some interactive views of star maps. In Mathematica 10 AstronomicalData has ...
2
votes
2answers
66 views

How to rearrange structure and type of an imported dataset?

I have a bigger dataset imported from Excel. Its elements have a form of {time, data}. Day is irrelevant and I would like to have the time in decimal form e.g. 10:30 is 10.5 ...
0
votes
2answers
34 views

Import table from txt file with specific rows

I have a .txt file written as 1 2 3 4 5 6 7 8 9 10 11 12 I would like to import it as three matrices according to the rows. I used b = Import["d:\am.txt", {"Table", Range[1, 2]}] Seems it ...
2
votes
1answer
92 views

How can I download images from Instagram and Twitter?

The new function ServiceExecute seems to suggest the ability to download images containing a specific hashtags. Can anyone get this to work?
0
votes
0answers
40 views

Set first line in CSV as header in mathematica list

New to stackexchange. Need some help with mathematica - also new to this!. I have a CSV file with 80 something columns and 6000 something rows = 500,000ish elements in total. I am trying to import ...
0
votes
1answer
55 views

reading data, one number at a time, from file to be used in a formula

First off let me say that I am a total nube. I saw some examples of answers "close" to my question but I did not understand them :-( I want to read individual numbers in from a text file and have ...
0
votes
0answers
39 views

Transform Excel .xlsx file into a matrix [closed]

i have a table in excel which represents a 45x45 matrix. I have a WolframAlpha Pro Account and wanted to do some calculations on the matrix. Is there any way that wolframAlpha interprets the xlsx file ...
1
vote
3answers
68 views

Import Data using selection criteria

I imported a file (text and numbers) and made constructed this. e[[1,All,{1,2,3,4,6}]] Column 1 is the name of the state. How can I get a subset of this where, say Column 1 is not equal to "New ...
0
votes
1answer
43 views

How to get an elements of given class that generated by javascripts

I want to get the number of total pages of a given search resluts of this site: http://srh.bankofchina.com/search/whpj/searchen.jsp, e.g., from 2015-1-12 to 2015-1-13 the currency of USD by the ...
0
votes
2answers
48 views

Import a given column from an excel file? [closed]

It seems that I can get the first column of excle data, say "test.xls", if I know the total length... ...
2
votes
1answer
60 views

Local evaluation works, CloudDeploy did not work

I a playing around with my programming cloud account. What I have found, interactive functions often are not working because there are several details that are not implemented into the cloud. So I ...
25
votes
1answer
1k views

Web Browsing Automation with Mathematica

I want to build a bot to automate web browsing, this mean something like: filling forms press "submit" buttons find certain text inside pages and so on... How can I do this with Mathematica? The ...
0
votes
0answers
47 views

ViewPoint: Saving coordinates in a text file

How should I save (Export?), all coordinates of the ViewPoint, in a text file when I rotate the ...
3
votes
1answer
65 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 ...
1
vote
1answer
276 views

Import symbolic variables from Matlab with MATLink

I'm trying to manipulate with Mathematica symbolic expression created in Matlab. I'm using the MATLink package, and I've succedeed in importing numerical variables, but not symbolic ones : ...
-2
votes
0answers
48 views

Statical Analyze a PDF (document file) for

I would like to import a set of PDF files to Mathematica and analyze it. And find out which words used most and find meaningful information about them. Finally, I would like to find out are they use a ...
1
vote
1answer
73 views

Importing a text file

I have a *.txt file with values like so: 0 2 4 3 4 2 the position in this huge *.txt ...
13
votes
2answers
550 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 ...
20
votes
4answers
3k 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 ...
5
votes
0answers
693 views

Import Large Excel File

Currently, I am working on a large time series dataset, which contains 928,586 rows and 35 time intervals in columns, in excel format (.xlsx) and using Import to ...
0
votes
0answers
17 views

Importing sobj sage objects?

I have a sage-math object . It used to be sage could send data to Mathematica directly but the function appears to have broken with Mathematica 9 (http://trac.sagemath.org/ticket/13892). How can I get ...
11
votes
3answers
249 views

ToExpression fails with long nested string expressions

Consider the following conversion from String to Mathematica Expression: ...
1
vote
0answers
38 views

Import/Export a FIT file, Fitness file created by Garmin GPS's and others

A FIT file is a binary replacement for GPX and TCX text files containing GPS and fitness data (heart monitors, etc.). Mathematica reads GPX and TCX files and represents them as XML. I would like to ...
4
votes
1answer
72 views

Is it possible to move .mx file from one server to other?

I have mathematica file in one server along with .mx file. Is there any way to move the .mx file from one server to other such ...
2
votes
1answer
76 views

How to get a audio file's duration time in Mathematica?

I have a *.avi file and if I want to know the file's duration time: I can use this code to get the result: Import["test.avi", "Duration"] or the code to get the ...
16
votes
4answers
3k views

Cut and paste data from a spreadsheet

I have a set of data points in two columns in a spreadsheet (OpenOffice Calc): I would like to get these into Mathematica in this format: ...
7
votes
1answer
212 views

Assign the contents of a “Copy” operation programmatically to a variable?

While an earlier question Cut and paste data from a spreadsheet nominally addresses the issue, a year has past since its OP asked it and I hope that others have come across simpler or more direct ...
2
votes
4answers
2k 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
3answers
236 views

Import data from first/last 100 rows of a file

If one wants import data from the first three rows of a file "myfile.data", one can use the command Import["myfile.data",{"Data",{1,2,3},All}]; However, if I ...
1
vote
2answers
56 views

Table operation after export and import of data does not give me the same result

If I create a table of this kind: (m1 = Table[{RandomInteger[], RandomInteger[{1, 5}, {3}]}, {i, 1, 5}]) // MatrixForm which looks like I know how to pick ...
1
vote
1answer
52 views

List Manipulation and Removing Cases

I've imported a large data set, manually removing headers in the .rtf file where it originates. However, when I import this data, I receive this output: ...
4
votes
0answers
92 views

ImportString JSON possible bug

My problem is when I catch up some json output of whatever method and process it with ImportString[%, "JSON"], The first time ...
1
vote
2answers
61 views

Save file from URL using mathematica

Is there an easy way to download and save a .zip file from a URL to my computer through Mathematica? I am trying to develop an auto-update function for a mathematica package that is distributed via ...
0
votes
1answer
41 views

Elegant ways of solving this file batching task

There are a batch of data files in a folder (dir = "D:\\Documents\\datadir"), each of which consists of a list of data items, one per line. Each data item is a pair ...
60
votes
3answers
5k views

Recovering data points from an image

Unfortunately, some data can only be obtained in picture form (Japanese publications anyone?). Since this cannot be worked with, it has to be converted to a dataset that can; I was wondering whether ...
35
votes
5answers
4k views

How can I extract data points from a black and white image?

Consider the following graph (source): Is there any way to extract the data points from this image in a semi-automatic way? I have seen, and tried the methods suggested in this question, but they ...
5
votes
1answer
120 views

How to use RunProcess to import external function?

I have a functions written in an external language called GO. How can I quickly load them into the kernel for use as Mathematica functions? The two ways I've tried are with MathLink and LibraryLink ...
0
votes
2answers
60 views

File Handling. How to save the progress in a file?

Assuming I already have the file created. I have a programme that,returns an output, in our case number. I want Mathematica to save this number in a file, together with results saved from previous ...
8
votes
4answers
649 views
1
vote
0answers
44 views

Inport a web page with latex code as image png or other

To be brief; I would like to import a web page, then I write Import["http://fabricebaudoin.wordpress.com/2012/10/25/lecture-32-the-malliavin-derivative/"]; which give a notebook file without png ...
16
votes
1answer
663 views

How to programmatically extract mathematical formulas from Word with Mathematica 9?

I have a bunch of(1000+) Microsoft Word document in .Docx format. How can I programmatically extract the mathematical formulas from MS Word using Mathematica 9? This is what example looks like (or ...
0
votes
1answer
81 views

how to read an excel file using mathematica? [closed]

I have to do some data analysis and i have data in an excel file. Please tell me how to read an excel file in mathematica.
3
votes
1answer
126 views

Efficiently reading CSV with ReadList

I have a large CSV file (~1gb) with mixed data. Basically with strings and integers. It takes very long to import this whole dataset with Import[] so I would like ...
4
votes
1answer
160 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
0answers
93 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 ...
7
votes
3answers
673 views

Skip header lines on import

When importing a data file what are the comment symbols for Mathematica? That is, given a file like this blabla bulbul 1 2 6 54 7 ... .. what symbol do I have ...
1
vote
3answers
163 views

How to import files with headers?

R has excellent header supports such as read.table with header options. I don't want to mess up with text-processing or stream-processing. I am looking for a similar tool as in R because it saves a ...
7
votes
1answer
179 views

Incorrect result while using SemanticImport for CSV file import

I might use this incorrectly. I want to use a .csv file that (as list) looks like: ...
1
vote
0answers
134 views

InstallJava::fail error when importing an image with a Raspberry Pi

I'm trying to import an image in Mathematica on my Raspberry Pi. The code is simple but I get an error when importing: ...
3
votes
1answer
55 views

How to make Import recognize a new file extension? [duplicate]

I've written an import converter for a custom file format, and it all seems to be working as expected, except for the fallback behavior with no arguments: ...