Questions tagged [import]
Questions about getting data, files, images etc. from various formats into a form that can be read, tranformed and manipulated by Mathematica
1,335
questions
1
vote
0answers
86 views
Trouble reading FITS with Mathematica 12
I've been using Mathematica to process FITS for years, but it has changed in version 12. Import now yields an Association rather ...
1
vote
0answers
102 views
Importing a table of real numbers from a text file were data is represeted in Fortran form [closed]
I'm working on a project that is analyzing seismic displacement data in the above form. It's basically a text file but I could conceivably need to bring in hundreds of files each containing anywhere ...
0
votes
0answers
39 views
How to use Headers after imported them?
I read this post here, and played a bit with the Import function, so I now have my data imported from xlsx file, which say is a <...
3
votes
3answers
249 views
Trying to replace the text E with scientific notation
How to replace the E with scientific notation *^?
...
3
votes
1answer
75 views
Importing a List of Comments from Hacker News
Consider this link has a bunch of separated comments:
Is there a clever way to import this into Wolfram Mathematica such we end up getting a list of comments (for, say, sentiment analysis ...
4
votes
2answers
95 views
Importing a Google Sheet including blank cells (default is ragged array)
I'm able to import data from Google Sheets using e.g.
...
2
votes
2answers
110 views
Running a notebook which imports and exports files repeatedly
I am trying to automate the process of running a Mathematica notebook that takes as an input a .txt file and exports another .txt file. This notebook was not written by me, and I don't fully ...
1
vote
0answers
52 views
How to recover plaintext from .MX files?
I need a function to deserialize the contents of an MX source file for reading. We can’t simply use Get because I don’t want to load or run the code, but rather to ...
3
votes
1answer
55 views
Importing graphs from geng incrementally
Is it possible to import graphs generated by geng (a tool from the nauty suite) one by one, rather than all at once. If one could also specify not only the order ...
2
votes
1answer
50 views
SDF Metadata Import fails when structure information is missing
UPDATE 04 Sept 2020: This behavior been fixed in Mathematica 12.1.
Background Information: In Mathematica 12.0, SDF Import automatically triggers the generation of Molecule[] representations. SDF ...
2
votes
1answer
174 views
CSV import with delimiters not working for certain characters (curly quotation marks)
Here's an example CSV file (Example 1):
"Text","”","False","False","False","False","0","1","24","0","9","450","450"
and the code to import it (Code 1):
...
0
votes
1answer
54 views
Retrieving a list of tagged output cells and a list of variables from various Notebooks into a new Notebook
The table below provides the information needed to formulate my question: how can I gather a selected number of tagged output cells and variables in a new notebook?
I have two notebooks ...
7
votes
1answer
283 views
Importing a Wikipedia Table as a Dataset?
I am trying to import this table from Wikipedia into Mathematica as a Dataset. The fields I'm interested are Name, ...
1
vote
1answer
32 views
Converting String in “Data” Format within Mathematica [closed]
Hi I have a simple question. Given a random string in the format accepted by the Import[fileWithString, "Data"] i.e the file contents being
...
0
votes
0answers
46 views
Importing text file to plot animation in 1D
I have .txt file with data that I want import into mathematica and then create a 1D animation/simulation of 3 curves.
The format of the ...
0
votes
1answer
58 views
How to obtain integers from a txt file? [closed]
I have txt file with some comma-separated integers and i'd like to obtain a list of said integers to work with.
My best result was:
...
9
votes
1answer
158 views
Importing Packages to .wls without shadow definitions and context specification
I am trying to import a package that works correctly when I use it in a notebook in a wolframscript .wls. I get a weird shadowing problem, however.
Here is a minimal working example ...
10
votes
0answers
370 views
Is it possible to use better modern compression algorithm instead of zlib in Mathematica for efficient data saving and loading?
Some backgrouds of my problem:
Recently, I had a heavy data analysis work to do. Each day I got thousands of csv Files(colums with different datatype) with total several Gigabytes. I have to ...
1
vote
1answer
73 views
Import and Export DateObject
I'm trying to import a spreadsheet with dates and export it again. But the cell reads ### in the exported file. It's shown in the screenshots. This is my code.
...
0
votes
2answers
129 views
SmoothHistogram doesn't appear to work
I have a data set with 500,000 elements. I am trying to use SmoothHistogram to plot the distribution, but it doesn't work and the kernel quits. I used R on the same ...
2
votes
1answer
56 views
Data manipulation in Mathematica
I have a very big data set that I have generated in Matlab. I am importing into Mathematica since doing some data manipulation is much easier.
There is one caveat, which is the following: I have ...
12
votes
0answers
445 views
Why does Mathematica consume so much memory when reading binary data?
There are somewhat similar questions on here, but I didn't find a satisfying answer for this case: I import a 1.7 GB binary data file using the following command:
...
3
votes
0answers
132 views
Is there a way to make Mathematica work with Parquet?
Has anyone tried to make Mathematica work with Parquet?
If so, what are the solution possibilities? And how can
this be made possible?
https://community.wolfram.com/groups/-/m/t/1595622
7
votes
1answer
206 views
How to import a ByteArray from GenerateHTTPResponse?
Without GenerateHTTPResponse the import works as expected.
ba = ExportByteArray[Plot[x, {x, 0, 1}], "PNG"];
ImportByteArray[ba]
...
0
votes
0answers
42 views
Working with time series GDP data
I have two questions.
First, how do I get a list of points from CountryData["UnitedStates", {{"GDP"}, {1960, 2018}}] as opposed to a graph.
Second, if I have a ...
3
votes
2answers
52 views
Import expressions from a file without it getting evaluated?
How can I import a file without its expressions being evaluated ?
E.g. assume that the file "test.m" contains just the list
{a, a + b + b + c, d}
If I use
<...
0
votes
1answer
52 views
Importing data from from Mathematica file
I have a array of Mathematica files which I am running one after another using NotebookOpen/SelectionMove/SelectionEvaluate functions successfully.
In this evaluation, the o/p of each file is a ...
1
vote
1answer
101 views
Importing TIFF stack metadata
the data files I am working with are TIFF stacks, we generate them with a self-written microscope program (in matlab). Among other information, an ASCII value is saved for each image in the TIFF stack ...
1
vote
1answer
39 views
Export a multidimensional array which contains numerics and symbols?
Lets say I have an array defined as:
Array1 = ConstantArray[0, {1, 3, 3}];
Array1[[1, 1, 2]] = 5;
Array1[[1, 1, 3]] = t;
How could I export this array since it ...
0
votes
1answer
50 views
Importing a 3 dimensional list
I have a code that is generating some numerical data in the form of a list of trajectories. Each trajectory itself is a list of 2D coordinates. Each coord. is a list of 2 numbers.(see example data ...
2
votes
1answer
121 views
Importing a csv file yields weird first character
Whenever I import a CSV file, I get this weird character at the beginning of the file ,I am not sure why. How can I avoid this?
0
votes
0answers
23 views
SemanticImport adds garbage characters to key name
I want to import a csv to a dataset. This exact dataset successfully imported on a PC, but on a Mac one of the columns has garbage characters added to the key (see below example). I don't believe ...
0
votes
0answers
49 views
Mmma connectivity . parquet. python
Is there any way to exchange data in binary format with python ?
Example.
a) I have data in Mmma and want to export them to make use in python ...
b) Want to use Parquet format
7
votes
1answer
348 views
Decode Image from Base64
From a web API, I have a bunch of realllyyy long strings that look like this:
data:image/jpeg;base64,(...)
Sites like this will decode these strings no problem, ...
0
votes
1answer
48 views
importing a list of lists
I have a list of lists, a list of file paths for some number of directories.
I want to import that files as lists of lists, where instead of getting one massive 1D list, the distinct directories are ...
3
votes
3answers
124 views
Specify column data type when importing
I'm running into an annoying issue when importing a table of tab-separated-data. Several columns are numeric, while several are strings. Using Import[url,"TSV"] ...
1
vote
2answers
57 views
How can I convert a matrix of 3d experimental data into a 3d list which can be interpolated in a f(x,y) function
I have a 3d experimental *.txt data with the form:
y1 y2 y3
x1 f(x1,y1) f(x1,y2) f(x1,y3)
x2 f(x2,y1) f(x2,y2) f(x2,y3)
x3 f(x3,y1) f(x3,y2) f(x3,y3)
I need to ...
-1
votes
1answer
83 views
Exporting and then importing .dat file elsewhere, then plotting the data
I'm trying to perform a simple task: export data into a '.dat' file, then importing that file onto Mathematica on another terminal, and then plotting the list. But I keep getting the same blank plot!
...
1
vote
0answers
53 views
Webscraping when links do not change
I would like to webscrape college sports data. Specifically, I would like to get match by match data from baseball.
Manually, this is tiresome but possibly. I go to http://web1.ncaa.org/stats/...
0
votes
3answers
55 views
2
votes
1answer
115 views
How to plot .txt data, which are not comma-delimitered?
I have got a $1000\times 4$ matrix of data in .txt form. Rows are seperated with blank spaces and not with commas. I want to plot the second column against the first one (they correspond to y(x) and x ...
1
vote
0answers
170 views
How to import a mathematica notebook into another mathematica notebook?
I have a number of notebooks -295 precisely- in a folder. Each notebook contains one or more large matrices. What is the proper way of importing each one of these notebooks in a new notebook for ...
2
votes
2answers
163 views
How to use NDSolve with limited RAM?
How can I use NDSolve when running out of RAM?
The code I am implementing:
...
0
votes
1answer
146 views
How to remove brackets from a data file
I would like to know how I can transform a file (.dat) that contains
{x1,x2, x3, x4,
x5, x6, x7, x8}
{y1,y2, y3, y4,
y5, y6, y7, y8}
in another file (.dat) ...
1
vote
1answer
110 views
Problem with “MediaTools`” in Mathematica 12
I asked here for a solution how single video images can be extracted very fast from avi files.
Piotr Wendykier gave a solution for Mathematica 11.3.
Now I'm using Mathematica 12 and his solution ...
1
vote
2answers
81 views
Importing a data file with names
I have the following data file which contains four columns of data
However when I import it as
data = Import["Exo_data.txt", "Table"];
I get the following list
...
3
votes
3answers
932 views
How can I import a CSV file into Mathematica? [closed]
I have a data.csv file in the Downloads folder in my Macbook. I am trying to import the data into a Mathematica notebook using
...
5
votes
2answers
163 views
Convert String to Integer from a huge string database in a very fast way?
I have a huge string database with the form such as {{position},{1,2,3,4,5,..}}, and I want to convert such database to Interger data in a very quick way.
In the following example, I created a ...
1
vote
1answer
84 views
Import .wav and Export .csv - where is the bottleneck?
I have a number of .wav files in a folder. I want to:
Import each file as data,
cut each list into a certain number of small lists,
export each list as .csv.
The .wav files have a length of approx. ...
7
votes
1answer
805 views
web scraping images
I am trying to load player profile pictures from the following page:
https://www.transfermarkt.com/manchester-united/startseite/verein/985/saison_id/2006#
I use the following code:
...
