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

Filter by
Sorted by
Tagged with
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
65 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
350 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
260 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
58 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
36 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
32 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
144 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
73 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
36 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
72 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
37 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
21 views

Strange Import behaviour from wls script

I have a data file that is composed as follows ...
7
votes
2answers
372 views

How to import .txt file with missing data?

I have a .txt file that looks like this (direct copy from the file): ...
5
votes
3answers
152 views

How do I import data formatted in C or Fortran into Wolfram Language?

I want to import some data that has been formatted using C language. I am not sure if there is a way to read in data by specifying column widths in WL. The data has been formatted using ...
0
votes
0answers
45 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
119 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
74 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
35 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
54 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
174 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
35 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
34 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
128 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
75 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
72 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: ...
7
votes
2answers
463 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
62 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
81 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
112 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
106 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
113 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
90 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
73 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
55 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
108 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
126 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
101 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
50 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
129 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
146 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
212 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
56 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 ...