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
2
votes
1answer
84 views

Generic XML to Dataset

I am having trouble to transform XML data into a Mathematica Dataset of Associations. I want a dataset that follows the structure of the XML file with all its sublevels. Here is the example xml: ...
1
vote
1answer
41 views

Extracting data from binary file without reading the whole file - is this possible? [duplicate]

Suppose I have a binary data file that holds 1 million lists each composed of five integers. i.e. $\{ x1,x2,x3,x4,x5 \}$ Perhaps I am missing something obvious (quite likely) - but if I know I want to ...
5
votes
1answer
38 views

Importing textual data removes some letters

I have the following file TSV file p.txt containing a single line of 3 values: "22p" "22o" "22u"...
3
votes
1answer
53 views

Importing text generates whitespaces between every character

I have a TSV file with string data in it that I want to import. While the TSV format is correctly parsed into a Mathematica table format using ...
4
votes
1answer
59 views

How to persist in a notebook the result of an imported spreadsheet? [duplicate]

I create data table in my notebook by importing a excel spreadsheet using: ...
1
vote
0answers
49 views

Import Infinite Scrolling Data

I'm trying to use Import to scrape historical data from Yahoo! finance (update: or any other website that uses infinite scrolling). The issue is that the webpage initially only shows 3 months of data ...
0
votes
1answer
67 views

Is there a difference between generating and loading data?

EDIT-1 This is a minimal example where an error occurs after 44538 samples generated in d1 upon importing as d2. Note that if <...
1
vote
0answers
57 views

How to find the spatial coordinate in a Geotiff that is not recognized by Mathematica as Geotiff [closed]

I am trying to read a geotiff file that is not recognized by Mathematica as a geotiff file. ...
0
votes
2answers
69 views

How to remove quotation marks in Table List

I have Import a .txt Data = Import["files.txt", "Table"]; But the Data ...
1
vote
1answer
37 views

Get every line of a .txt file generated with PutAppend as an element of a list

I have filled a .txt file with expressions, separated by new lines, through PutAppend. I want to define a list whose elements are those expressions. The first thing I tried was ...
0
votes
0answers
79 views

Import website "Source" slows down after a few iterations

I am using Import[link, "Source"] to import the source of several hundreds of thousands of webpages in a while loop to process them. Each iteration has ...
3
votes
1answer
91 views

How to export/import the following data in a proper way?

Consider numeric data that has the form {{{a,{b,c,d},e,f,g,h,k,{l,m,n},o}, ...},...}, where the first ... mean other similar rows, while the second ... mean ...
3
votes
1answer
185 views

Import strategies for large .txt files ~600MB

I'm quite new to large data processing in Mathematica and got the task to Import and Plot some .txt measurement data. The files are very very large ~600 MB and have about 3*E7 lines, I can plot and ...
3
votes
2answers
284 views

How to extract email addresses from a text file using Mathematica

I have a text file which I have uploaded here. I want to find all email addresses in this text file. I just know that some of them are after "Subscription Date" expression (I don't know if ...
5
votes
1answer
201 views

How to import equations from a pdf

Here is a pdf I am trying to import: https://i.stack.imgur.com/J2e0z.png Its a photo so that I can upload it here easily. I am trying to extract the formulas from this pdf but to no avail. Plaintext ...
3
votes
1answer
70 views

How to Import multiple sheets (aka tabs) from Google Sheets?

One can Import multiple sheets from an Excel file, say sheet "n" with Import["file.xls"][[n]], but how to do ...
0
votes
1answer
37 views

Cannot retrieve a function definition from file after save with ParallelDo

This is an example of a problem I have retrieving functions from a file I save using ParalleDo. ...
0
votes
1answer
58 views

Creating a ListPlot From Imported Excel file with errors

I'm learning mathematica, and right now trying to plot a graph with error bars. What I would like to do is to import 3 lists with x values(1/viscosity), y values(permeance), and error values, and plot ...
0
votes
1answer
51 views

Importing a .csv containing list of complex numbers

I exported a list (with two columns) to a .csv file with Mathematica, and the first few lines are, ...
1
vote
0answers
73 views

Ignoring or deleting empty cells from an Excel import

I have tried all the possibilities with DeleteCases and everything at the answer in the closed question on the same subject how to exclude empty cells when Importing from excel? and checked my input ...
1
vote
0answers
34 views

HPC doesn't read .mx file

I am trying to work in an HPC cluster. Mathematica works fine and I can export tables that I need. However, I had one interpolated data saved in as a mx file. I ...
0
votes
0answers
39 views

Import imaginary numbers

I'm trying to import a matrix data which contains complex numbers, and uses "i" as the imaginary number. Because Mathematica uses "I" for the imaginary number, it doesn't read my ...
2
votes
3answers
415 views

Read sympy expression in .txt file as Mathematica input

I have a Python file that has a variable defined using sympy. For instance, let us take the following (crazy) example that I could have eventually since I am automatizing a routine: ...
3
votes
3answers
96 views

Importing complex numpy arrays

Related question: Formatting Imported Complex Arrays from Python (csv. files) I am trying to import a large numpy array to Mathematica but the strategy in the question above is far too slow. For a 100-...
1
vote
0answers
116 views

How to stream NSE option chain data into mathematica

I'm trying to stream option chain data into mathematica from the url: https://www.nseindia.com/api/option-chain-indices?symbol=BANKNIFTY ...
0
votes
0answers
45 views

Error trying to import multiples excel files

I have a set of Excel files produced daily, in a folder, with names like: "GH tl data - 2021-08-01_2021-08-01.xlsx". Each file has just one worksheet. The files have many columns of data (...
3
votes
0answers
45 views

Importing all parts of a multipart email

Here is an email with two parts, a plaintext part and an HTML part: ...
1
vote
2answers
50 views

Reading File of Complex Numbers

I have a text file "IQ256.txt" with the following format (one complex pair per line): -23636.100 13359.055I -25478.040 9342.004I -26637.370 5257.033I -27184.020 1087.021I -27069.778 -2976....
0
votes
0answers
27 views

Correcting Import Errors presumably caused by unwanted whitespace characters

In scrapping data from a website that has a list of references searchable by the first letter of the author. I have attempted to Import this as a single html file for each letter. Oddly, this works ...
0
votes
0answers
57 views

Importing n different pdf files and sending them to n different emails

How with MMA could I do to load from a folder called "jobs" "n" different pdf files and send them to "n" different "gmail" emails stored in a mails.txt file in ...
0
votes
0answers
20 views

How to rewrite Import[filename, {"XLSX", "Dataset", 1} in Mathematica 11?

The example of usage that you can find documented on the [Wolfram site][1] seems not to work in Mathematica 11. Is there another way to parse the Header of the excel file? ...
3
votes
2answers
132 views

Import PDF as `Graphics`

How can I import a PDF file as a Graphics object. When calling Import["filename.pdf","PDF"], Mathematica ...
0
votes
0answers
23 views

Importing multi sequence Midi Files into Mathematica

Can I import a multi sequence Midifile into Mathematica? Can I import multiple short Midifiles into Mathematica in one go? Thanks, peter
1
vote
1answer
34 views

How to get correct note timings when importing multi-track Midi files?

I have observed when importing midi files with more than one track, the times for every track except for the first one are sped up. for example, ...
1
vote
2answers
82 views

How to wait for new input from file InputStream

I'm trying to open a file to read and do some processing indefinitely until I decide to abort: ...
0
votes
1answer
79 views

Import structure from Matlab into Mathematica 12 and nested lookup

I use Matlab and generate data that I save in a structure in a MAT file. I want the results to be loaded into Mathematica, as several analysis and plots are best when done in the latter than in the ...
4
votes
1answer
173 views

Copy clipboard content to mathematica notebook - line break symbol changes

There are 3 kinds of line breaks \r \n \r\n For windows, \r\n is standard. Suppose that there is a file called document.txt, using \r or \r\n as line breaks. Suppose that I open document.txt with a ...
2
votes
1answer
58 views

Read files from TLS server using Mathematica

Good morning, I would like to know if anyone knows if it is possible to read files from servers with TLS using Mathematica. In particular, my interest is to read files from the CDDDIS server (NASA's ...
1
vote
0answers
74 views

Is there already a program that analyzes THz-TDS data in Mathematica?

I plan to write a code that reads the time domain data(sample+reference), performs Fourier transforms, calculates transmissivity, solves the transfer function numerically, and gets complex refractive ...
21
votes
2answers
1k views

How to make Mathematica read in CSV as fast as Python's Pandas

I have many big CSV files for processing in Mathematica. And each time loading them into Mathematica takes a long time. Meanwhile, it takes much less time using Pandas under Python. For example, ...
1
vote
1answer
77 views

Editing complex arrays for export to Python

Quick question, can anyone advise on an efficient way to convert complex arrays with complex part denoted '${I}$' in Mathematica to '$j$' (as used in Python) and curly brackets '{}' replaced with '[]' ...
0
votes
4answers
73 views

Formatting an imported data into Mathematica in a matrix form

I have a file whose data read as {{0,:,1,2,3;},{1,:,0,164,165;},{2,:,0,3,167;},{3,:,0,2,166;},.., {"$$"}} I have to format this data into a matrix. There ...
1
vote
0answers
85 views

Lists of rules vs. Associations

It seems that generally, Mathematica users (or at least the Q&A I've read here) prefer associations to represent data in ways that many other languages would use structures. However, when ...
0
votes
2answers
46 views

How to copy a specific parameter from imported text file

I am working with the imported text files in Mathematica. Each text file has experimental data, measured at a several input parameter like "Field (V/cm):" How to ask Mathematica to copy the ...
2
votes
1answer
140 views

How do I get the data from this binary file? [duplicate]

I have a file which contains the following binary data: ...
6
votes
2answers
162 views

Is there a CryptocurrencyData alternative to FinancialData?

What's the easiest way to ingest time series data on cryptocurrencies into Mathematica? I'm looking for up-to-date price, volume, and other properties for both major coins and altcoins.
1
vote
0answers
32 views

Automatic import of the lexicon for the Game of Life

I am trying to import the lexicon for the Game of Life, preserving the structured information as far as possible automatically (so if the data changes a future import will update it). The text form of ...
0
votes
0answers
18 views

Can FormPage be used to upload a file (a CSV to be specific)?

I want to use FormPage to give the user an option to upload a CSV file and once it is uploaded, the data from the file should be plotted. How can this be done? Thanks!
0
votes
2answers
129 views

Importing selected data from text files

I have a large number of text files in a folder with different names. These are the output data files from an experiment. Each text file has first 50 lines of text, followed by four columns of ...
0
votes
1answer
37 views

How to import a table of numbers from a .txt file without losing dimensions?

I have a long txt file (which attached here). I want to import this file and then use a special line (in this case line 112) to plot a graph. I tried this ...

1
2 3 4 5
29