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
1answer
120 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. ...
1
vote
0answers
125 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: ...
0
votes
1answer
132 views

How do I upload a graph as an adjacency list and find the betweenness centrality?

I have an undirected simple graph in a .txt file formatted as an adjacency list like this: 100 200 200 300 300 400 500 600 700 800 900 ... Every number is a node ...
2
votes
1answer
210 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 ...
0
votes
2answers
56 views

How can I troubleshoot a PDF that fails to import?

I'm trying to import a PDF file whose text I'd like to parse, but I'm getting an error with no explanation: ...
3
votes
2answers
171 views

Import multiple files from folder in order of date added

I have a folder that contains certain files I want to import. In my case those are .png files. As all the files I want to import contain the phrase "accum" in their filenames, I can use ...
0
votes
0answers
62 views

How to save all data in all variables in context different than “global”?

I have seen questions on saving data on "global" context. Now if I set my notebook's evaluation context "unique to this notebook". the global context doesn't work quite well. Any idea what should i do ...
0
votes
0answers
27 views

relative directory paths within a mathematica package/what directory does a mathematica package see as local? [duplicate]

I have a package that gets loaded in many notebooks I use, with Import[pathToLibraryDirectory<> "toolkit.m"]; This toolkit in turn loads some Excel ...
9
votes
1answer
254 views

Wikipedia People only search

I am trying to search people from Wikipedia(For example .*John.* in REGEX). The following query is close, but it isn't generalized like ...
1
vote
2answers
93 views
8
votes
1answer
342 views

How to import a large (~50Mb) json file in mathematica

I am trying to import a 46Mb json file into mathematica (which by the way I exported using mathematica) but its failing with the following messages: ...
2
votes
1answer
123 views

Importing web page data

I tried importing a webpage using Import: ...
1
vote
1answer
56 views

ReadList error with negative very small numbers

When I try to import data with ReadList from a file containing very small numbers (~10^-318), positive data is handled well, ...
3
votes
1answer
223 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: ...
0
votes
1answer
167 views

Importing data to make a DateListPlot

I am having a hard time trying to import some text data for later use in DateListPlot. My first field in my data is a date of the format "yyyymmdd". I tried to ...
4
votes
2answers
219 views

Sorting a large file

I have some huge logs, which are text files, containing up to a million rows each, and I need them sorted. Because trying to import one obviously makes Mathematica run out of memory, we must rule out ...
9
votes
4answers
374 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 interested in exporting into a fits file ...
0
votes
1answer
61 views

Importing and manipulating data in HDF format

I have two matrices A1 and A2 in HDF format. I use the following code to import them. ...
2
votes
1answer
157 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 ...
1
vote
1answer
96 views

Extracting Imported Information

What I want to do is to compare the relationship between the consumption of say beer and wine using scatter plots where each point designates the particular country (preferably named). I have tried to ...
4
votes
1answer
119 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
1
vote
1answer
229 views

Import invocation fails with Get::noopen : Cannot open JLink error

The following function call fails when I invoke it in a fresh Mathematica session: ...
1
vote
1answer
68 views

Using imported data in further calculations

I have quite a lot of data in an Excel file, which I have to use in further calculations. The transformation should map a data point with thre coordinates into a two coordinate result. Example: ...
1
vote
2answers
138 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 ...
3
votes
2answers
103 views

Importing multiple tables within a single file

Suppose I have a file with multiple tables, each separated by a line beak, like this: ...
8
votes
2answers
204 views

Working with Java hashmaps from Mathematica

I'm using J/Link to access data from an external Java program. The data are represented as a ConcurrentHashMap (see the official specification here). ...
4
votes
1answer
612 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 ...
3
votes
1answer
118 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
2answers
167 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: ...
7
votes
1answer
208 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 ...
4
votes
3answers
196 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 ...
1
vote
1answer
294 views

How to work with 3D images of STL format

After importing a 3D image of STL format, my possibilities in regard to "3D Volumetric Image Processing" seems rather limited. All examples are given with TIFF files. Is there a way to convert from ...
10
votes
1answer
396 views

Data acquisition from a Measurement Computing USB device

I would like to use Mathematica 9 for to acquire data from a Measurement Computing (MC) USB-201 analog to digital (and other) device for classroom demonstration. I do not have a budget to buy LabView ...
-2
votes
1answer
150 views

Data is imported as string instead of numbers [closed]

newdata = Import["data.txt", "TSV"]; ListPlot[newdata] My data.txt file consists of two columns of numbers, separated by ...
2
votes
1answer
148 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 ...
0
votes
1answer
573 views

Plotting Surface Graph from Excel Data Import to Mathematica [duplicate]

I am trying to make a surface graph on Mathematica using Excel Data. My x-axis should be the "A" Column and my y-axis should be the "1" Row. The box of data in between the x-axis and the y-axis should ...
0
votes
0answers
54 views

Importing and running a notebook [duplicate]

I have a very long .nb file. I want to subdivide the different sections into separate notebooks, then call them in a common nb ...
1
vote
1answer
190 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 ...
2
votes
1answer
154 views

importing large data files with a constraint

As I have learned in this community, one way to import a hefty data files (e.g. millions of rows of {x1, y1} data) if you don't care about the individual elements (maybe just want to obtain some ...
4
votes
2answers
695 views

When importing is it possible to set the delimiter?

When importing a csv file is there a way to set the delimiter. I have a csv that uses ";" as its delimiter. I tried ...
0
votes
1answer
217 views

3D Plot of .txt File of the Surface Plotting Variety

I'm having a bit of trouble. I've seen other questions answered on here about how to 3D plot data from .txt files of the format: x y z x y z x y z Which works ...
2
votes
2answers
215 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
226 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 ...
1
vote
1answer
89 views

Problem with importing a JCAMP-DX IR spectrum file

I wrote a little function to import JCAMP-DX electron ionization or mass spectral files from the NIST webbook web site (e.g. mass spectrum of hydrogen chloride at ...
8
votes
2answers
346 views

Look up info associated with a given CAS chemical identifier from the NIST webbook & NCI CADD Chemical Identifier Resolver

I would like to retrieve information associated with a given CAS registry number (Chemical Abstracts Service nr) from the NIST webbook web site in Mathematica, using the provided API (e.g. for ...
5
votes
2answers
322 views

How to import a “.numbers” spreadsheet?

Does Mathematica support importing a ".numbers" spreadsheet file (from the "Numbers" '09 (ver. 2.3 554) spreadsheet program in Apple's OS X iWork office suite)? A ".numbers" file is actually a zip ...
3
votes
2answers
452 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 ...
8
votes
2answers
1k views

Speeding up Import and Export in CSV format

I am handling large numerical data in Mathematica. In smaller problems everything worked fine using Export and Import with the ...
0
votes
1answer
89 views

Combining an imported PDB file with a set of Graphics3D objects

Imagine we import a PDB file like so (using the example from ref/format/PDB in the help directory): ...
2
votes
2answers
116 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$. ...