AaronWard / covidify

Covidify - corona virus report and dataset generator for python 📈 [no longer being updated]
MIT License
446 stars 113 forks source link

ValueError: 'Last Update' is not in list #27

Closed rdorsch closed 4 years ago

rdorsch commented 4 years ago

I get since today (w/o updating covid-19-analysis)

... importing data: 95%|████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████▌ | 59/62 [00:01<00:00, 25.02it/s] Traceback (most recent call last): File "./build/lib/covidify/data_prep.py", line 42, in df = github.get() File "/home/rd/tmp.nobackup/git/covid-19-analysis/build/lib/covidify/sources/github.py", line 140, in get df = get_data(cleaned_sheets) File "/home/rd/tmp.nobackup/git/covid-19-analysis/build/lib/covidify/sources/github.py", line 62, in get_data header=0, parse_dates=['Last Update']) File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 678, in parser_f return _read(filepath_or_buffer, kwds) File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 440, in _read parser = TextFileReader(filepath_or_buffer, kwds) File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 787, in init self._make_engine(self.engine) File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 1014, in _make_engine self._engine = CParserWrapper(self.f, self.options) File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 1758, in init self._set_noconvert_columns() File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 1826, in _set_noconvert_columns _set(val) File "/usr/lib/python3/dist-packages/pandas/io/parsers.py", line 1816, in _set x = names.index(x) ValueError: 'Last Update' is not in list

AaronWard commented 4 years ago

@rdorsch Hey, i just seen this too.

This is because JHU unexpectedly just changed there column names for no reason.

I will work on a fix today

AaronWard commented 4 years ago

Fixed