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.

Filter by
Sorted by
Tagged with
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

How to build file to be used in Gephi 0.9.1?

I have an adjacency matrix obtained by: ...
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

Export to excel or CSV file with column and rows. List manipulation required

...
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 ...