JuliaDB.jl icon indicating copy to clipboard operation
JuliaDB.jl copied to clipboard

nastrings ignored

Open yakir12 opened this issue 6 years ago • 2 comments
trafficstars

It's pretty common that an empty string (e.g. x,,z) would signify a missing value. I tried that with no success. But then I discovered that specifying a specific string doesn't work either. See the following MWE:

data = ["col1" "col2"; "a" 1; "b" 2; "" 3]
using DelimitedFiles
writedlm("tmp.csv", data, ',')
using JuliaDB
t = loadtable("tmp.csv", nastrings = [""]) # thought first column third row would be `missing`
t = loadtable("tmp.csv", nastrings = ["b"]) # thought first column second row would be `missing`

yakir12 avatar Apr 26 '19 12:04 yakir12

Related: https://github.com/JuliaComputing/TextParse.jl/pull/131

joshday avatar Apr 26 '19 18:04 joshday

hmm, I tried ]add TextParse#master but JuliaComputing/TextParse.jl#131 doesn't fix this..?

yakir12 avatar Apr 29 '19 11:04 yakir12