I am reading a file with CSV.read(...) that contains many consecutive spaces between columns because the colmuns are padded. I passed the keyword argument delim=' ', but it thinks that every space counts as a new column, instead of ignoring long stretches of consecutive white spaces. How can I do …

Ignore consecutive whitespaces with CSV.read(...)

aakhmetz June 1, 2018, 1:36am 10

I think it is a normal behaviour for counting double space as the one with missing column. Otherwise, there is an ambiguity on how to define possible NAs

Topic		Replies	Views
Is there no standard way to read files with fixed width columns in the new DataFrames ecosystem? Data	6	2630	November 29, 2017
Problem with CSV.jl reading csv file with extra spaces General Usage csv	5	683	September 3, 2021
Alternatives to DataFrames.readtable? General Usage	2	727	September 24, 2018
Reading data text files delimited with both spaces & tabs General Usage csv , io	13	4537	July 19, 2021
Whitespace as missingstring in CSV.File() Data csv	5	1156	September 25, 2020

Ignore consecutive whitespaces with CSV.read(...)

Related topics