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
0answers
86 views

Trouble reading FITS with Mathematica 12

I've been using Mathematica to process FITS for years, but it has changed in version 12. Import now yields an Association rather ...
1
vote
0answers
102 views

Importing a table of real numbers from a text file were data is represeted in Fortran form [closed]

I'm working on a project that is analyzing seismic displacement data in the above form. It's basically a text file but I could conceivably need to bring in hundreds of files each containing anywhere ...
0
votes
0answers
39 views

How to use Headers after imported them?

I read this post here, and played a bit with the Import function, so I now have my data imported from xlsx file, which say is a <...
3
votes
3answers
249 views

Trying to replace the text E with scientific notation

How to replace the E with scientific notation *^? ...
3
votes
1answer
75 views

Importing a List of Comments from Hacker News

Consider this link has a bunch of separated comments: Is there a clever way to import this into Wolfram Mathematica such we end up getting a list of comments (for, say, sentiment analysis ...
4
votes
2answers
95 views

Importing a Google Sheet including blank cells (default is ragged array)

I'm able to import data from Google Sheets using e.g. ...
2
votes
2answers
110 views

Running a notebook which imports and exports files repeatedly

I am trying to automate the process of running a Mathematica notebook that takes as an input a .txt file and exports another .txt file. This notebook was not written by me, and I don't fully ...
1
vote
0answers
52 views

How to recover plaintext from .MX files?

I need a function to deserialize the contents of an MX source file for reading. We can’t simply use Get because I don’t want to load or run the code, but rather to ...
3
votes
1answer
55 views

Importing graphs from geng incrementally

Is it possible to import graphs generated by geng (a tool from the nauty suite) one by one, rather than all at once. If one could also specify not only the order ...
2
votes
1answer
50 views

SDF Metadata Import fails when structure information is missing

UPDATE 04 Sept 2020: This behavior been fixed in Mathematica 12.1. Background Information: In Mathematica 12.0, SDF Import automatically triggers the generation of Molecule[] representations. SDF ...
2
votes
1answer
174 views

CSV import with delimiters not working for certain characters (curly quotation marks)

Here's an example CSV file (Example 1): "Text","”","False","False","False","False","0","1","24","0","9","450","450" and the code to import it (Code 1): ...
0
votes
1answer
54 views

Retrieving a list of tagged output cells and a list of variables from various Notebooks into a new Notebook

The table below provides the information needed to formulate my question: how can I gather a selected number of tagged output cells and variables in a new notebook? I have two notebooks ...
7
votes
1answer
283 views

Importing a Wikipedia Table as a Dataset?

I am trying to import this table from Wikipedia into Mathematica as a Dataset. The fields I'm interested are Name, ...
1
vote
1answer
32 views

Converting String in “Data” Format within Mathematica [closed]

Hi I have a simple question. Given a random string in the format accepted by the Import[fileWithString, "Data"] i.e the file contents being ...
0
votes
0answers
46 views

Importing text file to plot animation in 1D

I have .txt file with data that I want import into mathematica and then create a 1D animation/simulation of 3 curves. The format of the ...
0
votes
1answer
58 views

How to obtain integers from a txt file? [closed]

I have txt file with some comma-separated integers and i'd like to obtain a list of said integers to work with. My best result was: ...
9
votes
1answer
158 views

Importing Packages to .wls without shadow definitions and context specification

I am trying to import a package that works correctly when I use it in a notebook in a wolframscript .wls. I get a weird shadowing problem, however. Here is a minimal working example ...
10
votes
0answers
370 views

Is it possible to use better modern compression algorithm instead of zlib in Mathematica for efficient data saving and loading?

Some backgrouds of my problem: Recently, I had a heavy data analysis work to do. Each day I got thousands of csv Files(colums with different datatype) with total several Gigabytes. I have to ...
1
vote
1answer
73 views

Import and Export DateObject

I'm trying to import a spreadsheet with dates and export it again. But the cell reads ### in the exported file. It's shown in the screenshots. This is my code. ...
0
votes
2answers
129 views

SmoothHistogram doesn't appear to work

I have a data set with 500,000 elements. I am trying to use SmoothHistogram to plot the distribution, but it doesn't work and the kernel quits. I used R on the same ...
2
votes
1answer
56 views

Data manipulation in Mathematica

I have a very big data set that I have generated in Matlab. I am importing into Mathematica since doing some data manipulation is much easier. There is one caveat, which is the following: I have ...
12
votes
0answers
445 views

Why does Mathematica consume so much memory when reading binary data?

There are somewhat similar questions on here, but I didn't find a satisfying answer for this case: I import a 1.7 GB binary data file using the following command: ...
3
votes
0answers
132 views

Is there a way to make Mathematica work with Parquet?

Has anyone tried to make Mathematica work with Parquet? If so, what are the solution possibilities? And how can this be made possible? https://community.wolfram.com/groups/-/m/t/1595622
7
votes
1answer
206 views

How to import a ByteArray from GenerateHTTPResponse?

Without GenerateHTTPResponse the import works as expected. ba = ExportByteArray[Plot[x, {x, 0, 1}], "PNG"]; ImportByteArray[ba] ...
0
votes
0answers
42 views

Working with time series GDP data

I have two questions. First, how do I get a list of points from CountryData["UnitedStates", {{"GDP"}, {1960, 2018}}] as opposed to a graph. Second, if I have a ...
3
votes
2answers
52 views

Import expressions from a file without it getting evaluated?

How can I import a file without its expressions being evaluated ? E.g. assume that the file "test.m" contains just the list {a, a + b + b + c, d} If I use <...
0
votes
1answer
52 views

Importing data from from Mathematica file

I have a array of Mathematica files which I am running one after another using NotebookOpen/SelectionMove/SelectionEvaluate functions successfully. In this evaluation, the o/p of each file is a ...
1
vote
1answer
101 views

Importing TIFF stack metadata

the data files I am working with are TIFF stacks, we generate them with a self-written microscope program (in matlab). Among other information, an ASCII value is saved for each image in the TIFF stack ...
1
vote
1answer
39 views

Export a multidimensional array which contains numerics and symbols?

Lets say I have an array defined as: Array1 = ConstantArray[0, {1, 3, 3}]; Array1[[1, 1, 2]] = 5; Array1[[1, 1, 3]] = t; How could I export this array since it ...
0
votes
1answer
50 views

Importing a 3 dimensional list

I have a code that is generating some numerical data in the form of a list of trajectories. Each trajectory itself is a list of 2D coordinates. Each coord. is a list of 2 numbers.(see example data ...
2
votes
1answer
121 views

Importing a csv file yields weird first character

Whenever I import a CSV file, I get this weird character at the beginning of the file ,I am not sure why. How can I avoid this?
0
votes
0answers
23 views

SemanticImport adds garbage characters to key name

I want to import a csv to a dataset. This exact dataset successfully imported on a PC, but on a Mac one of the columns has garbage characters added to the key (see below example). I don't believe ...
0
votes
0answers
49 views

Mmma connectivity . parquet. python

Is there any way to exchange data in binary format with python ? Example. a) I have data in Mmma and want to export them to make use in python ... b) Want to use Parquet format
7
votes
1answer
348 views

Decode Image from Base64

From a web API, I have a bunch of realllyyy long strings that look like this: data:image/jpeg;base64,(...) Sites like this will decode these strings no problem, ...
0
votes
1answer
48 views

importing a list of lists

I have a list of lists, a list of file paths for some number of directories. I want to import that files as lists of lists, where instead of getting one massive 1D list, the distinct directories are ...
3
votes
3answers
124 views

Specify column data type when importing

I'm running into an annoying issue when importing a table of tab-separated-data. Several columns are numeric, while several are strings. Using Import[url,"TSV"] ...
1
vote
2answers
57 views

How can I convert a matrix of 3d experimental data into a 3d list which can be interpolated in a f(x,y) function

I have a 3d experimental *.txt data with the form: y1 y2 y3 x1 f(x1,y1) f(x1,y2) f(x1,y3) x2 f(x2,y1) f(x2,y2) f(x2,y3) x3 f(x3,y1) f(x3,y2) f(x3,y3) I need to ...
-1
votes
1answer
83 views

Exporting and then importing .dat file elsewhere, then plotting the data

I'm trying to perform a simple task: export data into a '.dat' file, then importing that file onto Mathematica on another terminal, and then plotting the list. But I keep getting the same blank plot! ...
1
vote
0answers
53 views

Webscraping when links do not change

I would like to webscrape college sports data. Specifically, I would like to get match by match data from baseball. Manually, this is tiresome but possibly. I go to http://web1.ncaa.org/stats/...
0
votes
3answers
55 views

How do I import only the number and separate between 'n' and 'p'?

I have a file like this: ...
2
votes
1answer
115 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 ...
1
vote
0answers
170 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
163 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
146 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) ...
1
vote
1answer
110 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
81 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
932 views

How can I import a CSV file into Mathematica? [closed]

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
163 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
84 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
805 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: ...

1 2
3
4 5
27