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,212
questions
-2
votes
0answers
23 views
can mathematica still not import parquet? [on hold]
What are the plans ? Any serious data scientist needs this
when speed is at stake.
https://community.wolfram.com/groups/-/m/t/1595622
Went unanswered for too long. Guys what are you doing ?
7
votes
1answer
161 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
23 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
40 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
37 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
39 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
28 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
105 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
74 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
39 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
70 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
58 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
98 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
58 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
749 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
54 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
58 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
86 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
62 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
252 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
27 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
134 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:
...
1
vote
1answer
32 views
Plotting a Histogram3D with time (a file per frame) as parameter?
I've been working for a few days trying to make a dynamic histogram on
Mathematica, but I can't seem to make it happen. You see, I'm fairly
new to working with Mathematica and thus lack some knowledge ...
2
votes
1answer
71 views
How to read in and assign values from a txt file?
I have a text file that I would like to import into Mathematica - after searching around the internet, I can't seem to find any pages that explain how to do this:
The text file containes these four ...
0
votes
2answers
39 views
Change input filename according to ticker
I want to import a series of files with similar filenames that change according to a "ticker". An example is filenames A1_data.dat, ...
2
votes
2answers
35 views
How to derive an association from a SemanticImport of a website's data?
How might I make an association out of web-derived data imported with SemanticImport?
...
