Questions tagged [csv-format]
Questions about the Text based file format CSV (Comma Seperated Values). Questions include, but are not restricted to, importing from and exporting to this file format.
93
questions
2
votes
1answer
86 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):
...
1
vote
1answer
53 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 ...
0
votes
1answer
30 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 ...
2
votes
1answer
59 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?
3
votes
3answers
153 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
...
0
votes
1answer
74 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 ...
0
votes
0answers
61 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
0answers
47 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 ...
2
votes
1answer
156 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, ...
1
vote
0answers
46 views
How can I export the values of both the dependent variable and the independent variable? [closed]
This is the first time I am using Mathematica.
I am trying to calculate the bandgap of a solid using the following script.
...
2
votes
1answer
111 views
How do I tell Mathematica to write numbers on a file without using scientific notation?
I need to write numbers out to a file without using the scientific notation. How do I tell Mathematica to do that?
This is the code I am using:
...
5
votes
1answer
352 views
Huge CSV file with numeric and text data
I try to load a huge CSV file (~ 4 Gbyte), the data is both numeric and textual.
So, I can't load the data as a string.
...
7
votes
1answer
849 views
Working with a CSV data file with 100 millions rows (and 30 columns)
I am new to working with large datasets.. Currently I am struggling to upload a "big data" file into Mathematica. The file is in the CSV format and has 14GB. There are 100 millions of rows and 30 ...
1
vote
1answer
213 views
How to separate rows with commas in imported CSV
I imported a CSV file that uses commas as its delimiter, but some fields also contain commas. When I import the file into Mathematica as follows
...
4
votes
1answer
465 views
Import specific columns from a large amount of CSV files
I'm looking to import the 4th column of data from a few hundred CSV files that I have stored in various folders. I have been able to import all CSV files from a given directory through use of:
...
2
votes
2answers
81 views
Convert CSV data for use with CandleStickChart
can anyone show me an example of how to import a CSV file and produce and CandlestickcChart using the imported data.
I have tried
...
6
votes
2answers
125 views
Importing a string such as “3d456” from a CSV file causes trouble
I have a CSV file I'm importing with Import and it consistently crashes Mathematica. It turns out the culprit is one particular value of an ID field that was ...
3
votes
1answer
688 views
Appending to a .csv file [duplicate]
I have a selection of Lists of data which are in the same format, and if I Export them all to CSV at the same time I get a nice ...
0
votes
1answer
88 views
Import floating numbers from Google spreadsheets in CSV
For some reason when importing some floating numbers, Mathematica does not interpret them correctly. For example this spreadsheet:
https://docs.google.com/spreadsheets/d/...
1
vote
1answer
91 views
separating a `ReadList` of a CSV file into columns using `Case`
I have a really large file and would like to determine the pattern required for separating the columns by the different headers.
I attempted to use Cases but it's ...
0
votes
0answers
74 views
Problems importing data file
I'm having trouble importing a CSV file.
The CSV file doesn't have simple dimensions, some rows may have many more columns than others.
From my imported file I cannot access the ...
2
votes
1answer
544 views
Empty field “\”\“” In CSV Import Problem
I have a huge CSV data, with the format like this:
"5";"8";"2803";
"";"6";"2793";
I import the data with this code:
...
5
votes
0answers
128 views
How to change Export default in 11.2?
To achieve the same CSV output as from previous versions Export requires the option "TextDelimiters" -> "". Presumably the ...
0
votes
0answers
106 views
Text-analysis: Import CSV without stringquotes
I have a large amount of text-files. I want to compare these text-files based on common 'words'. I export the output of my analysis as a CSV file. When I import the same file I get all seperate words ...
1
vote
1answer
68 views
read data from file having different format numbers
I'm trying to process my bank's data, which is always formed by lines with 5 fields separated by semicolons.
Until recently, it used to write the numbers in the "1234,56" format, and I processed them ...
9
votes
3answers
1k views
Mathematica 11.2 Import Statement Produces Errors & Truncates CSV Data Created in 11.1
Bug introduced in 11.2.0
TL;DR
Issue 1 (bug): Import of CSV files with column specification fails when "HeaderLines" or ...
0
votes
0answers
95 views
How to explicitly set horizontal coordinates when plotting multidimensial Table using DateListPlot?
I'm trying to plot a multidimensial data table which is stored in csv file.
Like so:
...
1
vote
3answers
246 views
Import of CSV with OpenRead
I have tried to use OpenRead for my application as it appears to be less of a burden on the memory.
I OpenRead a .csv file to extract coordinates in the form {x,y} in the following way
...
1
vote
1answer
305 views
Exporting weather data as CSV or XLS file
I am relatively new to mathematica, and sorry if this question is too simple.
I am trying to export weatherdata to a csv or xls file.
...
6
votes
2answers
226 views
SemanticImport fails with CSV when last column is ALL empty
(MMA v11.1.1)
I have many empty fields in my CSV files and I couldn't understand why sometimes SemanticImport just failed to recognize the headers. I just find out ...
1
vote
2answers
888 views
Plotting data imported from CSV file
So I have some data in a csv file that I want to plot. The csv file has several columns. I want to plot one of the columns as the x axis and all the other columns on the y axis. I have used the Import ...
2
votes
0answers
50 views
Import fails silently [closed]
In brief, an Import of a largish (11G) tsv file fails silently. I'm looking for ways to troubleshoot the problem further, and/or work around the failure.
Details
...
0
votes
0answers
251 views
1
vote
0answers
172 views
Export number as formatted numeric value, not string
Some related questions include here.
Is there a way to format numbers for export in CSV or JSON as numbers - not strings - with a specified number of decimal places and no exponentials?
Is output ...
1
vote
1answer
442 views
Import image saved as CSV file [closed]
I have saved my image file from ccd camera as a CSV file. How can I plot this file to get my image back? My file is here.
4
votes
1answer
749 views
How to make Import[…, “Table”] not convert strings to numbers and not convert numbers to strings?
Bug introduced in 8 or earlier and persisting through 11.2.0
I have to to use r = Import["foo.txt", "Table", "FieldSeparators" -> {","}] since my data is Table ...
2
votes
1answer
121 views
Importing integer codes with leading zeros as strings from CSV [closed]
Importing CSV seems to automatically cast to integer what are supposed to be integer codes.
This causes problems when some codes have a prefix of a variable number of "0" and have to be matched ...
3
votes
2answers
540 views
I have a bigdata CSV file as a single table of five columns and almost 10 million rows
I need to examine the bigdata file with a database/DBMS and have used MS Office 365/Access successfully so to do, import and query. I have also tried, many times, to open a MMA 10.4 database link ...
4
votes
1answer
695 views
Importing data from a CSV file — a string is being converted to a number
I'm very much a newbie, so please forgive any errors or stupidity.
I have a csv file named csvfile. Its, contents confirmed by me, by looking at the contents in a ...
3
votes
0answers
108 views
SemanticImport extremely slow with “Number” format
With the following definition:
col = "num\n" <> StringRiffle[Table[i, {i, 1000}], "\n"];
I do not understand why the ...
3
votes
1answer
1k views
Removing quotes from fields after import of table [closed]
I would like to remove quotes around fields when importing a csv table. It should be simple, but I cannot find any answer.
My data is in the format ...
0
votes
1answer
204 views
Import hangs on a 15 MB CSV file [closed]
Trying to import a small (15 MB) CSV file and the Import command is either not responding or responding very slowly. Watching the memory usage of the Mathematica kernel when initializing the command ...
0
votes
1answer
774 views
How to export CSV with fixed delimiter and specific format specifier
I would like to export an array to a csv file with a specific type of delimiter and a specific notation of the numbers (in this case scientific notation 1.234E-02).
How can I achieve this in a ...
3
votes
1answer
944 views
StringSplit on comma but ignore commas in quotes [closed]
I'm importing CSV files and some of the fields include quoted text with commas as part of the field, rather than as a field separator. What is the syntax (or alternative method entirely) to import ...
1
vote
2answers
194 views
Reading simple data csv file containing “e” and “i”
I can't find a way to properly read a csv file containing complex numbers in the following form:
...
0
votes
2answers
238 views
make a surface plot that changes with time from csv data
How can I plot 4d data from a csv, using a slider for the 4th variable? I would like to use var1 and var2 as x-y corrdinates, var3 as surface height, and var4 as the time slider.
If I have a csv <...
-1
votes
2answers
446 views
4
votes
2answers
783 views
Excluding Specific Rows Using Import[…]
As the question states, I'm trying to import a .csv file but I would like to exclude certain rows (points which I know are bad data).
This is easy when the points ...
0
votes
1answer
186 views
Combining first 5 columns from CSV file into AbsoluteTime date
Thanks in advance for all your help.
I need to import data from a CSV file that looks like :
(easier to read in excel)
I would like to convert the data into timestamps by creating a Table with 2 ...
1
vote
2answers
1k views
Problem fitting a exponential function to data points [closed]
finale edit: i found someone who solved my problem via matlab. therefore i wont try out the proposed solutions now, but wont delete my question in case someone might have use for the proposed ...
