Skip to content
This repository has been archived by the owner on Oct 11, 2024. It is now read-only.

Skip empty cells, do not skip whole row #52

Open
johnjohndoe opened this issue Jul 31, 2015 · 0 comments
Open

Skip empty cells, do not skip whole row #52

johnjohndoe opened this issue Jul 31, 2015 · 0 comments

Comments

@johnjohndoe
Copy link

I am working with a data set which has multiple phenomena per station. Some station do not provide any data (empty cells, red in the screenshot) for certain phenomenas. Other stations do but lack data for other phenomena. This can be seen from the screenshot of the tabular data.

Sensor data with missing data for certain phenomena

It also happens that a station misses data for a phenomena for a certain day while data is available for the same phenomena on all the other days. This can been seen in the following screenshot:

Sensor data with missing data for certain days

Status quo

At the current state the importer skips the whole row if it lacks data for at least one of the columns.

Skip CSV line (2) #2751; Reason: Line is empty.; Raw data: '[32, 2015-06-19, , , , , 13.0, 18.0, , , , , , , 2.0, 6.0]'

Workaround

I could enter 0 for these cells but that would actually be an incorrect statement.

Change request

Please allow to import all available values from a row. Skip empty cells, continue processing the next cell.


Related

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants