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,217
questions
1
vote
1answer
36 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
93 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
49 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
149 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:
...
2
votes
0answers
93 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
163 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
24 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 ...
0
votes
1answer
48 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
43 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
28 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
39 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
41 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
18 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
29 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
4
votes
1answer
108 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
27 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 ...
0
votes
2answers
45 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
48 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
24 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
48 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
53 views
2
votes
1answer
75 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 ...
0
votes
0answers
40 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
150 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
73 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
84 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
60 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
102 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
139 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
60 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
750 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:
...
0
votes
1answer
34 views
Unable to operate on the table imported from .mx file
I saved a table by exporting it to .mx file. Now, when I import it back, it gives me the desired output. So, to work with elements of the table, I first define the imported table as (res2 = Import["...
1
vote
1answer
55 views
Interpolating data from Excel
Sorry for the probably mainstream question, but I have not found the answer I was looking for yet.
I have this Excel file: https://drive.google.com/file/d/1UhkYdoaqXQIsf6opOx-EBgG7xPxxHga3/view and I ...
5
votes
1answer
60 views
How do I reliably read from stdin using wolframscript?
I am trying to direct a stream of data to a wls script in a command line environment. Wolframscript provides the ...
0
votes
1answer
87 views
Using Semantic Import to do an Excel-like VLookUp using Mathematica
I'm following an example provided in the following
Stack Exchange Link
but, using a different approach. My data is contained in an Excel workbook called "Input Workbook.xlsx"
as shown here:
I ...
0
votes
0answers
22 views
Why is the number of sample points of an audio changed after being export?
I have an audio audio001 and I need to export/import it so that I can do auto-correlation. Below I used ...
1
vote
1answer
58 views
Unable to use the Import[] function to get the clickable hyperlinks of a page
I can get the hyperlinks of the Google search result of "Wolfram" by using the following code:
Import["https://www.google.nl/search?q=Wolfram", "Hyperlinks"]
Now ...
2
votes
1answer
35 views
Do not skip empty table entries while importing data from HTML string?
Consider importing the following table from an HTML string:
...
2
votes
0answers
57 views
Mathematica (v12.0) fails to Import NASACDF (Common Data Format)
I was doing research about Mars using data from MAVEN spacecraft. The data used could be downloaded from https://lasp.colorado.edu/maven/sdc/public/data/sci/swe/l2/2017/06/.
When run
...
1
vote
1answer
58 views
How to change the allowed formats in Import[…]? [closed]
I want to read data from files with an unusual extension with the Import function. However, the following message appears:
The data is well organized, when I rename the extension to ".dat" ...
0
votes
1answer
63 views
Import many csvs from folder and change date format from american to european
I have many csv files in one folder and I have to import all of them into Mathematica. I need actually just two columns and all the rows except for the first one so I got rid of another 6 columns and ...
6
votes
1answer
349 views
Why is my read in of data taking so long?
I'm just trying to read in some data before I do some calculations. The data set is over 200,000 values that look like this:
Here is the code I am using:
...
0
votes
1answer
52 views
How to evaluate a function on Imported data (.xlsx file)
I have imported an excel file, and I want to evaluate an expression on each point:
Data = Import["data.xlsx"]
which gives output like this:
...
5
votes
3answers
254 views
Import data from a current web session?
Consider opening a web session such as (Mathematica 11.3)
session = StartExternalSession["WebDriver-Chrome"];
ffoxdo[cmd_] := ExternalEvaluate[session, cmd];
...
1
vote
1answer
57 views
How to fit 2nd order polynomial to multiple graphs and show them together?
I want to fit 2nd order polynomial to multiple graphs and show them together;
I imported file by using following command:
Mode1 = Import["1-CF.txt", "Table"];
...
2
votes
0answers
34 views
Import data from a webpage with dynamically generated content
Following the example of this very detailed thread 190177 and others related to the subject, that introduced me to snooping around in the developer's tools, I tried to apply to my case, which is ...
0
votes
0answers
31 views
How do I import changing/dynamic data on a webpage?
A remote device (sensor) is sending measurements (that I get in JSON format) to a given URL and is sending new measurements (data points) every couple of minutes. I cannot share the URL but the ...
0
votes
0answers
60 views
Finding area between curves formed by csv data
I have a bunch of Differential Pulse Voltammetry data I am trying to import into Mathematica, and find the area between each curve and the blank. So far I have used the following commands:
...
1
vote
0answers
28 views
SemanticImport changes “string” type to “quantity” type--how to change during import or after import?
This question may overlap with other questions about the quirks of SemanticImport, but I don't see this specific wrinkle on StackExchange and I hope it will be a simple answer to help me and others ...
4
votes
2answers
136 views
How to import latex matrices into Mathematica?
I have a lot of $\LaTeX$ matrices, and I want to find their eigenvalues and eigenvectors.
I tried to import them to Mathematica with:
...
