spice valley
Hitting a very bizzare issue where if I try to CSV.write this dataframe(even If I just successfully read it with CSV.read) it errors out
Minimum example
df_translations = CSV.read("folder1\\translations.txt", DataFrame)
CSV.write("folder2\\translations.txt", df_translations)
Error in comments because discord
Added file in comments
Error
Dataframe columns
97995×3 DataFrame
Row trans_id lang translation
String String3 String
the file in question
vivid bobcat
Does folder2 exist? If not you might have to mkpath that first
I think mkpath will make it if it doesn't exist, and skip if it does exist
vivid bobcat
There seems to be a problem with row 64698
translation is undefined
I'm not very sure what's wrong with it
spice valley
Seems like csv parsing gets tripped up if there is "<space> in a column
spice valley
Any ideas on how I could handle this?
spice valley
passing quoted=false to CSV.read fixed this issue. seems to be known-ish in https://github.com/JuliaData/CSV.jl/issues/1002
vivid bobcat
Ah ok, I forget what the row of data contained but I think it was assuming that the strings are quoted