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

can mathematica still not import parquet? [on hold]

What are the plans ? Any serious data scientist needs this when speed is at stake. https://community.wolfram.com/groups/-/m/t/1595622 Went unanswered for too long. Guys what are you doing ?
7
votes
1answer
161 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
23 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 ...
0
votes
1answer
48 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
40 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
28 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
37 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
39 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
18 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
28 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
4
votes
1answer
105 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
27 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 ...
0
votes
2answers
45 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
48 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
24 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
48 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
53 views

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

I have a file like this: ...
2
votes
1answer
74 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 ...
0
votes
0answers
39 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
150 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
70 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
84 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
58 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
98 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
139 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
58 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
749 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: ...
0
votes
1answer
34 views

Unable to operate on the table imported from .mx file

I saved a table by exporting it to .mx file. Now, when I import it back, it gives me the desired output. So, to work with elements of the table, I first define the imported table as (res2 = Import["...
1
vote
1answer
54 views

Interpolating data from Excel

Sorry for the probably mainstream question, but I have not found the answer I was looking for yet. I have this Excel file: https://drive.google.com/file/d/1UhkYdoaqXQIsf6opOx-EBgG7xPxxHga3/view and I ...
5
votes
1answer
58 views

How do I reliably read from stdin using wolframscript?

I am trying to direct a stream of data to a wls script in a command line environment. Wolframscript provides the ...
0
votes
1answer
86 views

Using Semantic Import to do an Excel-like VLookUp using Mathematica

I'm following an example provided in the following Stack Exchange Link but, using a different approach. My data is contained in an Excel workbook called "Input Workbook.xlsx" as shown here: I ...
0
votes
0answers
22 views

Why is the number of sample points of an audio changed after being export?

I have an audio audio001 and I need to export/import it so that I can do auto-correlation. Below I used ...
1
vote
1answer
58 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: ...
2
votes
0answers
57 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
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
62 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
349 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
252 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
57 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
34 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
31 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
27 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
134 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
71 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
35 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? ...