Skip to content

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

@drbenvincent

Description

@drbenvincent

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions