covid-19-open-data icon indicating copy to clipboard operation
covid-19-open-data copied to clipboard

Scotland Hospitalizations datasource fails to run (changed excel schema again)

Open themonk911 opened this issue 4 years ago • 0 comments

"Traceback (most recent call last):
  File "/env/lib/python3.7/site-packages/xlrd/book.py", line 474, in sheet_by_name
    sheetx = self._sheet_names.index(sheet_name)
ValueError: 'Table 3a - Hospital Confirmed' is not in list

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/vmagent/app/lib/pipeline.py", line 163, in _run_wrapper
    return data_source.run(output_folder, cache, aux)
  File "/home/vmagent/app/lib/data_source.py", line 227, in run
    data = self.parse(data, {name: df.copy() for name, df in aux.items()}, **parse_opts)
  File "/home/vmagent/app/pipelines/hospitalizations/gb_authority.py", line 52, in parse
    sources[0], sheet_name="Table 3a - Hospital Confirmed", value_name="new_hospitalized"
  File "/home/vmagent/app/pipelines/hospitalizations/gb_authority.py", line 26, in _parse
    data = read_file(file_path, sheet_name=sheet_name)
  File "/home/vmagent/app/lib/io.py", line 99, in read_file
    return pandas.read_excel(path, **{**default_read_opts, **read_opts})
  File "/env/lib/python3.7/site-packages/pandas/util/_decorators.py", line 296, in wrapper
    return func(*args, **kwargs)
  File "/env/lib/python3.7/site-packages/pandas/io/excel/_base.py", line 334, in read_excel
    mangle_dupe_cols=mangle_dupe_cols,
  File "/env/lib/python3.7/site-packages/pandas/io/excel/_base.py", line 926, in parse
    **kwds,
  File "/env/lib/python3.7/site-packages/pandas/io/excel/_base.py", line 439, in parse
    sheet = self.get_sheet_by_name(asheetname)
  File "/env/lib/python3.7/site-packages/pandas/io/excel/_xlrd.py", line 44, in get_sheet_by_name
    return self.book.sheet_by_name(name)
  File "/env/lib/python3.7/site-packages/xlrd/book.py", line 476, in sheet_by_name
    raise XLRDError('No sheet named <%r>' % sheet_name)
xlrd.biffh.XLRDError: No sheet named <'Table 3a - Hospital Confirmed'>

themonk911 avatar Sep 16 '20 08:09 themonk911