search

Bugazelle / export-csv-to-influx

The python library to write the CSV data into Influx. Support me via Bitcoin: bc1qqgkmph9cvygzxfpupv4jr4n0nfx3qumwg39j5w
BSD 3-Clause "New" or "Revised" License
32 stars 11 forks source link

Row with one empty column drops all columns. #31

Closed 7yl4r closed 4 years ago

7yl4r commented 4 years ago

I have a csv that resembles the following:

Time,mean,climatology,anomaly
1325548800,,,
1325808000,0.00011200000000000001,,
1593475200,6.1e-05,0.000165,-0.00010400000000000001

My fields are mean,climatology,anomaly. In this example I expect row 1 to be dropped, row 2 to be partially submitted, and row 3 submitted for all fields. Rows 1 and 3 work as expected. In row 2 all fields are set to the NA value -999. The mean field for row 2 should be 0.00011200000000000001, not -999.

7yl4r commented 4 years ago

Nevermind. I was looking at the wrong db entry. Your script does work as expected. Thank you.