Questions tagged [csv-format]
Questions about the text based file format CSV (Comma Separated Values). Questions include, but are not restricted to, importing from and exporting to this file format.
134
questions
1
vote
1
answer
79
views
Trying to plot a CSV file and getting a blank graph
I am trying to plot two NMR line graphs superimposed to show a before and after. I was able to successfully do it with excel files but the CSV files have been giving me trouble. This is my code. I ...
- 11
2
votes
2
answers
192
views
Import complex numbers from a CSV file created in MATLAB
I export a simple CSV file created in MATLAB with complex numbers, such as:
0.1+2.1i,0.9+0.13i,0.02+0.3i
I would like to import it into Mathematica with the "i" recognized as the imaginary ...
- 115
0
votes
1
answer
59
views
Having issues creating rules from a CSV import
I'm importing a CSV file with two columns. I've done this with other files, but this one is causing issues when trying to create rules to associate IDs with the titles. Here's a sample of the ...
- 159
2
votes
2
answers
153
views
How to import, read and convert a .bib to .csv format?
I have a document in .bib format, namelad by savedrecs1.bib, obtained from Web of Science.
The document have a set of reference, of the type:
...
- 1,335
1
vote
2
answers
98
views
Importing an unusually formatted text file and converting to CSV
I have some data that looks like:
...
- 2,027
0
votes
0
answers
36
views
Data Export not working when running module using Wolframscript compared to executing in notebook
I have a Mathematica module im_solver.m that I wish to iterate through Python or a bash script. The module runs a bunch o' other modules. At the end im_solver.m executes a diagnostic.m that collects ...
0
votes
0
answers
70
views
1
vote
0
answers
52
views
Why is Import[file, "CSV"] faster than Import[file, "TSV"]
I have a lot of data which use tabs as field separators. There are no tab characters in their fields. The data are all alphanumerical, strings are not enclosed in quotes.
Theoretically ...
- 2,808
0
votes
1
answer
94
views
Graph blockchain transaction data
I am new to Mathematica, and i am trying to Graph some blockchain transaction data. I would like the Addresses "From" & "To" to be the Nodes/Vertices, and the edges to be a ...
- 1
2
votes
1
answer
99
views
How to convert a CSV entry from a String to an Expression?
I have a list that looks like this:
{{"74.28300000000003,90.32258064516131"},{"75.06400000000004,92.90322580645163"}}
To be able to use these ...
- 21
0
votes
0
answers
155
views
ListLinePlot: Options expected (instead of ImportCSVToDataset
I have the following code
...
3
votes
1
answer
127
views
How to import CSV file with mixed data, including string Mathematica expressions and numbers
I am importing a CSV file that looks like this (Extract of data as viewed in Notepad):
...
- 93
0
votes
1
answer
81
views
It's about manipulating .csv file
Actually I load .csv file about movies to Mathematica and store it in "dt", and there is one column records the production countries which is the first column df[[All,{1}]]. And the format ...
- 3
3
votes
3
answers
160
views
Exporting CSVs of UTM coordinates. How to stop northing exporting in scientific notation?
I need to batch convert a folder of CSVs containing UTM coordinates from GDA94 to GDA2020.
Sample data below:
Copyable form:
...
- 31
0
votes
1
answer
47
views
How can I save the eigenvalues of a 1000x1000 COE matrix and 500x500 COE matrix in the same file?
I have generated eigenvalues of '1' 1000x1000 matrix of CircularOrthogonalEnsemble and saved it in a csv file using Export. Now ...
0
votes
1
answer
473
views
Converting JSON to CSV but the formatting is not correct
I have a folder of about a million JSON files and I wrote this to convert them quickly to CSV, but the formatting is not correct for the software I'm feeding them into.
Here's the code I'm using:
<...
- 4,478
2
votes
2
answers
127
views
Exporting a Large List to a CSV File Kills Kernel in 12.3?
I noticed that Mathematica 12.3 (also 12.1) kills the kernel when I try to Export a large list to a CSV file. No error messages, no warning, just a hard stop. Here is the code I wrote to replicate the ...
- 81
0
votes
2
answers
60
views
Data wrangling to create a matrix from lists
I have a super simple data wrangling question that I can't seem to figure out (I am new to Mathematica). Basically I'm not sure what function to use. I have two parameters, ...
- 1
0
votes
1
answer
153
views
Exporting complex exponential float arrays to Python
A question related to a previous question. The answer in the previous question works well for simple complex arrays but not when considering arrays with exponential float coefficients as in the ...
- 295
22
votes
2
answers
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, ...
- 4,337
1
vote
1
answer
263
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 '[]' ...
- 295
1
vote
2
answers
165
views
Import all elements in a specific column from a CSV file given the name of the column
I have a large CSV file with many columns (300 MB). I know their names. I don't know the column numbers. How can I efficiently import a column for inspection by name?
Here is a tiny example file:
<...
- 7,349
0
votes
2
answers
397
views
Import from CSV formatting issue
I have two lists of data here: dm and dmHalo (see attached image). Theses are the same lists, the only difference is that dm was exported to a csv file and then reimported, while dmHalo was generated ...
- 117
4
votes
2
answers
175
views
Organising and examining a complicated CSV file
I am being sent data in CSV files. The sender is providing helpful comments and lots of headings so that it is fine to look at in a spreadsheet environment. However, when I import it into Mathematica ...
- 16.1k
1
vote
1
answer
95
views
Import of csv-data don't read columns
I couldn't catch the point:
when I try to read an easy csv-dataset with ";" as delimiter, I get only "strings" instead of a set of columns.
Here are two lines of the csv-File:
k_id;...
- 33
3
votes
1
answer
1k
views
Formatting Imported Complex Arrays from Python (csv. files)
Just a short question, I am trying to import a complex array (matrix) from Python to Mathematica by first writing to a csv. file. When I Import the csv. array to Mathematica it is in a form (matrix ...
- 295
2
votes
2
answers
136
views
Plot the complete dataset as listplots
I have imported as a csv file and converted to a Dataset. The data is in the following csv format
...
- 601
2
votes
2
answers
327
views
How to Listplot data from huge DataSet?
I have this data set in .csv and I imported them to mathematica to analyze them using Import function. Now here I have only shown a part of the dataset just to give an example of how it looks in Excel....
- 601
1
vote
1
answer
73
views
Incomplete data transfer: large CSV data Import, computation outputs exported as MX, then import the MX data [closed]
I have a very large CSV data file, which I imported it to my active Notebook:
...
- 5,470
0
votes
1
answer
135
views
Import CSV data from internet to mathematica [closed]
This Link has data in CSV format for 2015 and other years. I would like to get the data for 2015 (by clicking on 2015) but the CSV data format has more rows than Excel can handle and therefore the ...
- 5,470
1
vote
1
answer
207
views
Correcting delimiter definitions in .csv files
I have a number of .csv files that have a semicolon (;) delimiter rather than comma, and I'm wondering if there is a simple way to change the text in them all.
Lets say I have a test file "a.csv&...
- 1,033
1
vote
2
answers
214
views
How to import a (large) .CSV file maintaining its shape (defined by curly brackets)
I'm working on large tables generated with Mathematica, evaluated on different computers. I plan on join the tables on my computer and proceed with the interpolation of the data there contained.
The ...
- 113
0
votes
2
answers
499
views
Import and extract certain column and row
I have a problem with importing and extracting 2nd column in my CSV file. I need to have 3 list, the first one first column except for first row, the second will be second column except for 1st row ...
- 185
8
votes
0
answers
73
views
Export Strings without quotes to a CSV file [duplicate]
Would like to export a List of Lists to a CSV file.
Would like the strings in the exported file to not have quotes around them,
which doesn't appear to be the default behavior. Is there an option ...
- 1,027
1
vote
1
answer
119
views
How to use column header as the x-axis in ListPlot?
I imported a csv file, and the header of the columns are specific dates. How would I plot these points using ListPlot, but the x-axis instead of 1,2,3, etc, is the dates from the column headers?
For ...
- 31
0
votes
0
answers
43
views
Reading CSV data as numbers rather than symbols
I am attempting to read some data from a CSV file I have using
edgeDistribution = Import["edge_distribution_2.csv", "CSV"]
Mathematica will ...
- 33
1
vote
1
answer
64
views
Formating of cells with Dates on Exporting [closed]
I am trying to export a matrix into a .CSV file which has dates with format: Year/Month/Day.
When I try to export it into a CV those cells are converted into Day/Month/Year
When I try to export it ...
- 31
0
votes
1
answer
82
views
Importing a CSV file hangs up [duplicate]
Ver.12.1.0.0 hangs up when I do "Import" a csv file
that contain an entry ""000000000000000000000000000000000000000053253943D755066515000057",
while this csv file can be read ...
- 51
0
votes
1
answer
332
views
How to export list of lists to a CSV without "Row[{}]" text?
When I export a CSV file using the code above, I get something like this:
I'd like to export the answers / text on the right column without "Row[{}]" but just the raw text. Is this possible?...
- 33
1
vote
0
answers
70
views
How can I import a txt file with both tsv and csv characteristics and plot it?
I have a problem with importing and plotting a txt data.
I used this code:
data=Import["C:/Users/user/Desktop/Mohammad Simulation/2nm.txt","TSV"]
header=Take[data, {10, 1889}];
But, I am not able ...
-3
votes
1
answer
86
views
2
votes
1
answer
512
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):
...
user55405
1
vote
1
answer
359
views
Plotting a 2D grid "spectrogram" from a large .csv file [closed]
I'm aware of this question here that uses MatrixPlot to plot the spectrogram of a sound file, but it's too complicated for me to understand, unfortunately.
My file ...
- 141
0
votes
1
answer
138
views
Export to CSV gives unformatted output and unexpected characters
I want to export data I collected in a Table to a CSV (or XLSX)-File.
However, the output is not very handy, it is not in a column-shape but surrounded by {} and in ...
- 67
2
votes
1
answer
540
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?
- 601
3
votes
3
answers
6k
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
...
- 131
0
votes
1
answer
160
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 ...
- 185
0
votes
0
answers
75
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:
...
0
votes
0
answers
55
views
Plotting data imported from Excel and overlaying it on a disk
I'm new to Mathematica and I'm trying to get the hang of plotting data from an external CSV file. The data is just x, y, z values from an experiment I ran. I would ...
3
votes
1
answer
745
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, ...
- 971