queryverse / CSVFiles.jl

FileIO.jl integration for CSV files
Other
51 stars 13 forks source link

BUG: importing csv file when bottom right cell is empty #94

Open drbenvincent opened 3 years ago

drbenvincent commented 3 years ago

I have tracked down an error I initially found in trying to use query.jl, but the root cause seems to be an apparent bug when importing csv files where the bottom right most cell is empty.

For example with the simple test csf file (attached test.csv) which looks like this

Screenshot 2021-06-12 at 17 12 48

when you import the empty bottom right most cell is coming up as #undef rather than missing

Screenshot 2021-06-12 at 17 14 03

This then causes all kinds of downstream havoc when doing anything with this cell. For example

Screenshot 2021-06-12 at 17 14 47

EDIT: To clarify this error happens when the bottom right code cell in the csv file is empty. When it is explicitly coded as NA the import works fine