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

BUG: importing csv file when bottom right cell is empty

Open drbenvincent opened this issue 4 years ago • 0 comments

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

drbenvincent avatar Jun 12 '21 16:06 drbenvincent