Hey guys, ich want to read in the following text file. [Bildschirmfoto 2022-05-15 um 10.51.40] So the first two rows are irrelevant, but the problem is that the file has space and ; as a delimiter. If I try to read in the file I get the following result: [Bildschirmfoto 2022-05-15 um 10.58.46] …

If you don’t need to use CSV package in particular, with readdlm from DelimitedFiles you could do readdlm(filename, Int, skipstart=2, comments=true, comment_char=';') It will read anything after a ; character (included) as a comment and skip it. I don’t know much about CSV but it seems it to have…

[image] mastrof: readdlm(filename, Int, skipstart=2, comments=true, comment_char=‘;’) Thank you! That works for me. Yes I’ve seen the optional arguments for CSV.File but none of these options worked in my case. At least I haven’t found the right one I guess.

Related: https://github.com/JuliaData/CSV.jl/issues/956

You could try (this is likely only useful to you, faster, if your file is huge): CSV.File(filname; delim=' ', decimal = ';') It’s a bit of a hack, with decimal, used as a comments hack, and then make sure your values are actually always integer going in (and what you get). If you tried with the co…

See also this related post and its solution . Adapted here for reference: using DelimitedFiles, DataFrames input2=""" 6 0 0 0 1; 4 0 0 2; 5 0 0 3; 6 """ io = IOBuffer(input2) data = readdlm(IOBuffer(replace(read(io, String), ";" => " ")), skipstart=2) # trick by @GunnarFarneback df = DataFrame(da…

Reading a txt. file with two different delimiters

General Usage

nilshg May 15, 2022, 2:47pm 4

https://github.com/JuliaData/CSV.jl/issues/956

Topic		Replies	Views
Reading text data: `readdlm` is deprecated, so how CSV package is used? General Usage question , csv , io , delimitedfiles , text-data	9	1101	July 17, 2024
Reading '¤' separated value file with readdlm General Usage csv	5	655	January 31, 2019
DelimitedFiles reading everything in one column New to Julia	1	361	January 15, 2021
Reading data text files delimited with both spaces & tabs General Usage csv , io	13	4651	July 19, 2021
Question about DelimitedFiles Data question , package	1	346	July 30, 2020

Reading a txt. file with two different delimiters

Related topics