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,180
questions
1
vote
1answer
39 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:
...
1
vote
0answers
34 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
54 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
54 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
342 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
49 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
222 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
28 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
116 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
31 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
68 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
34 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
51 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
33 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
18 views
7
votes
2answers
341 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
36 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 ...
2
votes
1answer
92 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
59 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
51 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
33 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
29 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
124 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
69 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
63 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:
...
6
votes
2answers
274 views
How to read .npy file in Mathematica?
I have a .npy file which is created by numpy of Python as below:-
...
1
vote
1answer
59 views
Simple approach to importing data and reading headers
Admittedly, this will be a very naive question, but I'm really curious to learn how one can achieve the following in a simple manner:
Suppose we have a text file formatted like so:
...
1
vote
0answers
65 views
How to uncompress zip file fast with Mathematica?
What is the fastest possibilty to uncompress zip files with the following content?
It containes numbered ".png" files, corresponding ".header" files (theses are text files) and a file called "...
5
votes
4answers
98 views
Import every 50th record from a data file [closed]
I want to import a really big data file which seems like it is too big for Mathematica. That's why I want to import the data in parts. For example, if I have 15,000 rows of data then I would read in ...
1
vote
2answers
86 views
How can I import a .txt file containing a matrix of numbers and work with its columns? [closed]
I want to import a text file which has two columns. Then I want to assign one column to an array alpha[i].
Using the following command assigns the whole file to t[i].
...
1
vote
1answer
99 views
How do I create multiple plots from an Excel spreadsheet?
I have imported an Excel spreadsheet with dimensions {row, col}= {92, 28} into Mathematica, I want to plot 27 datasets from the spreadsheet: column 1 with column 2, column 1 with column 3, ..., column ...
1
vote
1answer
84 views
Converting .STL from Shell to Solid for stress analysis of wing
I'm new to Mathematica as this is the first class I've had to used it in my undergrad time as an aerospace engineer. Anyway, I have run into a problem that I can't figure out. I have created .STL's of ...
3
votes
1answer
69 views
Retrieve File Dates for Files Inside an Archive (ZIP)
Suppose I have a zip archive file with many files in it.
I can get a list of the files in the archive with:
Import["zipfile.zip"]
I can get data out of one of ...
4
votes
1answer
78 views
FITS files are importing with different values depending on version
Bug introduced in 11.3
I recently updated to 11.3 and found that my FITS files don't import the same way anymore. I've read a posts about the changes made to FITS imports and can deal with that fine ...
1
vote
0answers
44 views
Conversion of STL files to 3D Images
I am trying to convert some stl files to 3d images in MMA 11.3. I came across this post that contained some code making use of parallelization to speed up the process, as follows:
...
1
vote
1answer
76 views
How can I suppress the warning $\mathrm{\it precision\ may\ be\ lost}$?
When I import data from a .dat file, V11.3 emits the message: is too small to represent as a normalized machine number; precision may be lost.
How can I close the ...
5
votes
0answers
83 views
Hyperspectral files in the ENVI format?
Have any of you had the pleasure of reading geospatial / hyperspectral files in the ENVI format? Headers that describe the data here,
https://www.harrisgeospatial.com/docs/enviheaderfiles.html
which ...
1
vote
1answer
99 views
How can I make a frequency plot of successful trials? [closed]
I have got different files with the result of an experiment varying 2 variables. The files are in this link. Each file has 3 columns of data: the first column is the same for all the rows of the file ...
0
votes
0answers
46 views
How to ImportString “JSON” with Unicode characters? [duplicate]
Update
The short answer is that when getting results back from an API into an HTTPResponse object the "Body" property is a post-...
2
votes
1answer
76 views
How can empty fields in a csv file be set to Missing when importing as a Dataset?
When importing a csv file with empty fields as a Dataset, the empty fields are set to zero-length strings (""). There is an option, ...
2
votes
1answer
116 views
Deleting missing values from a dataset
I wanted to create a dataset of all UFO sightings in April of 2018. The
AssociationThread doesn't want to work, because some of the entries are missing value, what ...
