Scotland rows are showing NaN in covid-19-cases-uk.csv

tomwhite / covid-19-uk-data

Coronavirus (COVID-19) UK Historical Data

http://tom-e-white.com/covid-19-uk-data/

The Unlicense

162 stars 79 forks source link

Closed neatdot closed 4 years ago

neatdot commented 4 years ago

Scotland rows in the covid-19-cases-uk.csv file are showing NaN for 2020-03-07:

2020-03-07	Scotland	S08000015	Ayrshire and Arran	NaN

tomwhite commented 4 years ago

I've started syncing the historical case numbers by area from the official source at https://www.gov.scot/publications/trends-in-number-of-people-in-hospital-with-confirmed-or-suspected-covid-19/. Numbers less than 5 are denoted by * in that spreadsheet, and I represent them as NaN in the CSV file. You probably need to treat them specially in your processing pipeline.

neatdot commented 4 years ago

Got you. I've already adopted something similar for the "1 to 4" ranges. Thanks for the response.