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
2
votes
1answer
61 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
26 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
27 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
41 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
32 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
16 views
7
votes
2answers
322 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
35 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 ...
1
vote
0answers
52 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
51 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
41 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
50 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
157 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
32 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
28 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
118 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
63 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
60 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
188 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
53 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
58 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
95 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
78 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
92 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
77 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
67 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
73 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
43 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
68 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
70 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
97 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
41 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
55 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
107 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 ...
8
votes
1answer
181 views
Scrape AJAX Website with Webdriver
I hope the new Webdriver functionality can help as the normal Import and HTTPRequest don't work.
The sites I have found are a ...
1
vote
1answer
39 views
How to import XLSX data as integers?
I am importing simple 0s and 1s array from Excel
myDep = Import[
FileNameJoin[{NotebookDirectory[], "dependencies.xlsx"}], {"Sheets",
"Data"}]
All good
...
2
votes
1answer
52 views
Web Scraping - Why are these numbers interpreted as strings?
I started with:
data = Import["https://www.destatis.de/DE/ZahlenFakten/GesellschaftStaat/Gesundheit/Todesursachen/Tabellen/Sterbefaelle_Unfaelle.html", "Data"]
...
1
vote
0answers
38 views
Export system of inequalities in MPS format
I am interested in the .MPS format, usually used in Linear Programming problems (see here).
When importing a file in the .MPS ...
0
votes
1answer
49 views
Export and import sound give different data
If I export a sound object
and then I import the same sound
I have a different data array. The errors seem to have a certain regularity. They are all multiples of the same value:
Why does it ...
1
vote
1answer
103 views
How to get URL request response in Mathematica?
I am considering the following link:
https://myimmitracker.com/en/ca/trackers/consolidated-e-apr-tracker-express-entry-permanent-residency-application
It produces the following page with a table in ...
3
votes
0answers
120 views
How to import a binary data generated by Fortran? [closed]
I have a unformatted binary data file generated by gfortran. However, when the binary data is imported by Mathematica, a correct result is not obtained.
This is my fortran code:
...
1
vote
2answers
75 views
What info is exchanged when using Import[url]?
When using Import with a url what information is broadcasted/sent to the receiving end of the request and is it possible to monitor/modify that information?
1
vote
2answers
39 views
Import date and number Matrix Formatted as text
Hi I am new to Mathematica. I have a large text file that looks like: {"i":"2008-02-22","v":"9.102"},{"i":"2008-02-23","v":"11.14"},{"i":"2008-02-24","v":"12.21"}.....
3
votes
0answers
52 views
How to import unsupported language dictionaries?
Mathematica seems to only know about these 27 languages:
However, I need access to dictionaries for other languages, namely Romanian and Japanese. Now, WordList ...
1
vote
2answers
72 views
How can I extract blocks of 8 bits data from a plain text file?
I have a plain textfile consisting of 4M numbers (0 and 1's) from the number Pi.
I would like to split this textfile into blocks of 8 bits (ie 8 characters).
I know this can be done with StringTake ...
2
votes
1answer
84 views
Importing Data multiple times from the same File
I have a large data file (.txt) with bivariate data in the following form
x1,y1
x2,y2
x3,y3
.
.
.
xn,yn
---------F 0
x1, y1
x2, y2
.
.
.
xn, yn
--------F 1
.
.
.
...
3
votes
2answers
118 views
Import columns from a long .txt file
I have to import columns 1,2,3, and 6 from a long (2 * 10^5 rows) file with this structure:
...
1
vote
2answers
106 views
Importing Excel File as Dataset
This might be a basic question but I couldn't get it to work.
I have a dataset in Excel that I import to mathematica using
...
3
votes
1answer
61 views
What's the best way to import such dataset?
https://www.ocr.org.uk/Images/400305-large-data-set-lds_1-h630-2018-h640-2018-2019-pre-release-data-mei.xlsx
What's the best way to import such dataset?
I have tried to use
...
