I had some adventures in reading a CSV file created on a windows computer in Julia, and it as left me with some confusion on what counts as a line. In particular, it sees like CSV.jl and readlines have different opinions, which is a pain. Lets demonstrate with a MWE. julia> # We create test-file …

\r = CR = carriage return is not a new line, but just move cursor to the beginning of the line. \n = LF = linefeed which is move the paper a line above (or the cursor into the next line down). (Exact details depend on OS and editors) In your data these are mixed clearly to show your problem. I d…

Editing the data to simplify parsing seems like a good general approach. I will try to remember that in the future. I shy away from it because often multiple people use the sama data-files, so it could be messy to if everyone made different versions of the data. But I suppose making a dummy-file, o…

Inconsistencies in the number of lines in a CSV file

General Usage

rafael.guerra November 22, 2023, 7:06pm 3

Linking a related posted on counting the lines in a CSV file.

Topic		Replies	Views
CSV.jl number of lines General Usage csv , io	13	1234	November 3, 2021
.csv number of rows Data csv	6	3428	September 13, 2022
Handle large csv file using `enumerate(CSV.File())` or `CSV.read()`? New to Julia	3	576	April 21, 2019
Preserving File Structure when Reading and Writing New to Julia	12	1459	August 29, 2018
Countlines() bug? Internals & Design	8	2428	February 2, 2018

Inconsistencies in the number of lines in a CSV file

Related topics