queryverse / queryverse/CSVFiles.jl

BUG: importing csv file when bottom right cell is empty

Open
#94 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Julia
Stars
52
Forks
12
Avg merge
18h 21m
Merged PRs (30d)
3

Description

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

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the import with the attached test.csv, focusing on the empty bottom-right cell and the query.jl path where the problem was observed. Compare it with the explicitly coded NA case; done means the empty cell imports as missing rather than #undef and no longer causes downstream failures.

Written by the indexing model from the issue text.

Assessment

Tech stack
julia
Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.