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

1
vote
1answer
306 views

Cannot import Excel (xls or xlsx) files which have non-ASCII characters in the name

It seems mma9 works fine, but with mma10 it fail to load a file name with Chinese characters. I use MacBook Pro(Retina) with OSX 10.10.2, and Mathematica 10.0.0.0. I need the file name with Chinese ...
0
votes
1answer
51 views

Import command gives different solution to equation than cut & paste

I would like to import values from a text file to run a notebook. The notebook works fine when I cut and paste in all the input values manually. Here is a working version. But when I import the same ...
0
votes
1answer
108 views

Cannot import data into a notebook as a list of numbers

I have text file with a list of numbers separated by commas, which I would like import into a notebook to be called when the name ratevector is used. If I cut and ...
0
votes
1answer
75 views

Working on a certain column after importing data from a file

I'm trying to import a file with 2 columns, in TSV format. Something like this: ...
7
votes
2answers
312 views

Why an extra { when importing .xls?

I am trying to import data from a file. If I import a CVS file, I get: {{a,b,c},{e,f,g}}. For example, two curly brackets. If importing from a .xlsx file I get ...
2
votes
1answer
87 views

Export and Import a list of graphs?

I want to export a list of graphs that come as output to my program. However, I tried exporting all the graphs as graphs using Map and an Export statement with "graph.gml" statement, but got an error. ...
1
vote
3answers
254 views

Read data from file starting at a certain point

I have files of data that come with a whole bunch of junk in the beginning before the actual columns of data start. Is there any way to tell Mathematica to start putting the data into a table from ...
0
votes
1answer
71 views

Getting error Import::chtype when mporting 2D array of images [closed]

Suppose I have images = {{1.jpg, 2.jpg}, {3.jpg, 4.jpg}} Now I try to import all of them at level 2, ...
1
vote
0answers
82 views

Import a web page with $\LaTeX$ code including images (png or other)

To be brief; I would like to import a web page, so I use Import["http://fabricebaudoin.wordpress.com/2012/10/25/lecture-32-the-malliavin-derivative/"]; which ...
1
vote
1answer
165 views

How do I utilize the dynamic input field function in the manipulate function? Can I use this functionality to import a .xls from an URL dynamically?

Im trying to get my program to import a .xls for manipulation, I need to import the .xls at an url location dynamically, I did have this at the beginning of my code: ...
1
vote
0answers
48 views

Can I import (and repair) damaged GIS shape files?

Five GIS shape files are available online at http://www.utahcounty.gov/OnlineServices/maps/DataLayers.asp. Mathematica 10 imports 4 of the 5 files just fine (in the sense that, after download, ...
1
vote
0answers
79 views

import file from directory using sftp

I want to import a file from a directory on a ftp using sftp. I'm not sure how the command looks, but here is what I have tried (based on this older post): ...
1
vote
1answer
154 views

A bug won't let me import JSON files

I have been working on a project and I have been using JSON to build some networks, the code I use is: ...
3
votes
2answers
102 views

Most efficient way of splitting a file into length-prefixed blocks

Let's say I have a really big file (>100MB) that consists of length-prefixed blocks, i.e. the first byte of each byte block indicates the length of the rest of the block. This is a simplified example ...
1
vote
1answer
115 views

Importing, sorting and exporting lists

I have several TSV lists (.txt) of something like 2000*2000 numerics (e.g. 1.8645) to import ...
0
votes
1answer
92 views

Having trouble displaying imported Excel regression data [closed]

The plot points and residual lines are not showing, hard-coded data works, and imported data does do something, just not what its supposed to Is the table or the plot range the wrong size? I can't ...
0
votes
0answers
56 views

How to import (from a table file) only rows with a specific element in a given position using Import?

I have a large file containing a table. To be specific, the table columns are aligned by spaces, and the rows are terminated by newlines. I want to import only specific rows from this table. For ...
10
votes
4answers
609 views

Exporting data extensions in fits file

Context In Astronomy the de facto standard for images and data is FITS. I would like to export heterogenous data sets into a single fits file. Attempt I am ...
1
vote
1answer
51 views

Dynamic check box with import!

Here what i am trying to do: I have a list of the names of excel files, for example s={"red carpet.csv","red box.csv","black carpet.csv","black box.csv"}; i am ...
3
votes
2answers
306 views

Equivalent of Matlab's uigetfile in Mathematica

I was wondering if there an equivalent of the "uigetfile" Matlab function to use it in Mathematica. To be more precise, I want to read many Excel files and I don't want to type a static path; ...
8
votes
2answers
1k views

How do I display imported images at actual size?

I know that this is an extremely basic question, but I am having a lot of trouble finding the answer in the documentation. When I import an image (for example, ...
2
votes
2answers
131 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
297 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
326 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
158 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
88 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
1answer
71 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
1k 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... ...
3
votes
1answer
112 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 ...
0
votes
0answers
85 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 ...
4
votes
1answer
349 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 ...
2
votes
1answer
439 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 : ...
1
vote
1answer
103 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 ...
15
votes
2answers
819 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 ...
5
votes
0answers
1k 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 ...
8
votes
1answer
126 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
182 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 ...
7
votes
1answer
275 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
4k 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
3answers
977 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
150 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
83 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: ...
5
votes
0answers
259 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
159 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
69 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 ...
44
votes
5answers
6k 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 ...
9
votes
1answer
282 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
109 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
1k views