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,196
questions
1
vote
1answer
61 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
37 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
103 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
57 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) ...
0
votes
0answers
45 views
Problem with importing data and interpolating it [on hold]
Here is the code
data = Import["D:\\Third Semester\\q1.patxt", "Table"]
And here is the imported data file with properly arranged data
1
vote
1answer
69 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
51 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
78 views
How can I import a CSV file into Mathematica?
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
123 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
51 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
736 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
26 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
43 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
42 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
66 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
21 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
50 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
56 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
56 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
57 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
345 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
51 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
234 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
56 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
30 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
30 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
56 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
23 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
119 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
69 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
37 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?
...
2
votes
1answer
55 views
How to import a part of an Excel file?
I'm trying to import a part of an excel, the column 20 and the row between 6-59 in this column.
I tried :
tab = Import[
"file.xlsx"];
time = tab[[20, 6 ;; 59]]
...
1
vote
1answer
35 views
Comma separated images for .gif creation
I recently created a key frame animation using Mandelbulber 2.18-1. Each .png image was placed in a folder with known location. I then dragged all the images and dropped them into a Mathematica ...
0
votes
0answers
19 views
7
votes
2answers
347 views
How to import .txt file with missing data?
I have a .txt file that looks like this (direct copy from the file):
...
0
votes
0answers
38 views
How to export a multidimensional array in which each element is also an array?
I have a {15,5,2} dimensional array and each element is itself a {14,16} dimensional array. When I export/import my file as an excel file I get a {15,,5,2} dimensional array but with {} dimension for ...
3
votes
1answer
110 views
Read NumericArray from a file
Suppose I have a binary file which consists of a list of integer or real numbers. Let's say signed 8-bit integers; so each byte of the file is a single such integer. How can I read it and turn it into ...
1
vote
0answers
60 views
Import JPG picture missing XMP / EXIF metadata tags
I used Google Picasa to tag a face in a JPG photo, which is stored as an XMP metadata tag within the photo itself:
Here is a link to the photo. If that URL has expired, you can download the pic as a ...
0
votes
0answers
32 views
Verify that a document matches a URL
Writing:
Quiet[Length[Import["http://www.africau.edu/images/default/sample.pdf"]]]
I get:
2
while writing:
...
2
votes
1answer
45 views
How to import a matrix of integers from MATLAB?
I am importing a matrix from MATLAB. However, there are some redundant items added in the imported matrix.
For example, the imported matrix is a binary matrix. After import, it looks like this
...
0
votes
1answer
53 views
Parallel XML import
I need to import some xml information from many pages. I have list of this pages. Doing it in single thread is too long. But I can't access multiple pages from the same IP at the same time. So I need ...
8
votes
1answer
168 views
Most efficient method for export/import of non-traditional tensor-style dimensions of matrices/tables/lists-of-lists-of-lists(-of lists)?
Hello World!
(I did it for my first answer, so it only feels proper...I'm not nostalgic, you are!)
OKAY, here we go!
Let's start off with the good-stuff, here's my code, made relatively arbitrary, ...
1
vote
0answers
34 views
Importing Data from csv fills my notebook with large list [closed]
Sorry for bother you with such a trivial problem, but I can't stand it!
I use Import[file] to read a CSV and I get my notebook fill up with hundred of lines of ...
0
votes
1answer
31 views
How to plot for imported data while performing some operations on different columns?
I have imported an Excel file, then I did multiplied different numbers with different columns;
...
1
vote
1answer
127 views
New entity type “ Company” in MMA 12 [closed]
New entity type namely Company and Financial have been added to MA 12 to import a company specific financial information. For example:
...
2
votes
1answer
72 views
How to import only a small part from a large data file?
Let's assume that the data:
are arranged in a table of $n$ rows by $m$ columns,
are stored in a *.dat file or other textual format,
number of rows is very large, say $n=10^7$.
Suppose we need to ...
2
votes
1answer
64 views
Issues with NifTI images under Mathematica (Neurotica package)
I have some troubles when I want to import NifTI files with Mathematica. When I do:
...
