JuliaDB.jl
JuliaDB.jl copied to clipboard
nastrings ignored
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`
Related: https://github.com/JuliaComputing/TextParse.jl/pull/131
hmm, I tried ]add TextParse#master but JuliaComputing/TextParse.jl#131 doesn't fix this..?