Traceback (most recent call last):


 "/usr/local/lib/python3.7/asyncio/runners.py", line 43, in run

return loop.run_until_complete(main)


 "/usr/local/lib/python3.7/asyncio/base_events.py", line 583, in run_until_complete

return future.result()


 "/usr/src/homeassistant/homeassistant/__main__.py", line 249, in setup_and_run_hass

safe_mode=args.safe_mode,


 "/usr/src/homeassistant/homeassistant/bootstrap.py", line 89, in async_setup_hass

await async_from_config_dict(config_dict, hass)


 "/usr/src/homeassistant/homeassistant/bootstrap.py", line 132, in async_from_config_dict

await _async_set_up_integrations(hass, config)


 "/usr/src/homeassistant/homeassistant/bootstrap.py", line 377, in _async_set_up_integrations

*(async_setup_component(hass, domain, config) for domain in domains_to_load)


 "/usr/src/homeassistant/homeassistant/setup.py", line 49, in async_setup_component

return await task
# type: ignore


 "/usr/src/homeassistant/homeassistant/setup.py", line 145, in _async_setup_component

hass, config, integration


 "/usr/src/homeassistant/homeassistant/config.py", line 704, in async_process_component_config

return component.CONFIG_SCHEMA(config)
# type: ignore


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 272, in __call__

return self._compiled([], data)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 594, in validate_dict

return base_validate(path, iteritems(data), out)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 386, in validate_mapping

cval = cvalue(key_path, value)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 817, in validate_callable

return schema(data)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 272, in __call__

return self._compiled([], data)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 594, in validate_dict

return base_validate(path, iteritems(data), out)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 373, in validate_mapping

new_key = ckey(key_path, key)


 "/usr/local/lib/python3.7/site-packages/voluptuous/schema_builder.py", line 817, in validate_callable

return schema(data)


 "/usr/src/homeassistant/homeassistant/helpers/config_validation.py", line 659, in validator

value = config[key]
TypeError: string indices must be integers

Traceback (most recent call last):


 "F:\testReadexcel.py", line 8, in <module>

dc = pd.read_excel(ex_file, sheet_name=name)


 "D:\pandas\util\_decorators.py", line 118, in wrapper

return func(*args, **kwargs)


 "D:\pandas\io\excel.py", line 238, in read_excel

false_values=false_values, squeeze=squeeze, **kwds)


 "D:\pandas\io\excel.py", line 543, in _parse_excel

output[asheetname] = parser.read()


 "D:\pandas\io\parsers.py", line 1069, in read

ret = self._engine.read(nrows)


 "D:\pandas\io\parsers.py", line 2273, in read

index, columns = self._make_index(data, alldata, columns, indexnamerow)


 "D:\pandas\io\parsers.py", line 1412, in _make_index

index = self._agg_index(index)


 "D:\pandas\io\parsers.py", line 1512, in _agg_index

index = _ensure_index_from_sequences(arrays, names)


 "D:\pandas\core\indexes\base.py", line 4152, in _ensure_index_from_sequences

return MultiIndex.from_arrays(sequences, names=names)


 "D:\pandas\core\indexes\multi.py", line 1150, in from_arrays

labels, levels = _factorize_from_iterables(arrays)


 "D:\pandas\core\categorical.py", line 2352, in _factorize_from_iterables

return map(list, lzip(*[_factorize_from_iterable(it) for it in iterables]))


 "D:\pandas\core\categorical.py", line 2352, in <listcomp>

return map(list, lzip(*[_factorize_from_iterable(it) for it in iterables]))


 "D:\pandas\core\categorical.py", line 2324, in _factorize_from_iterable

cat = Categorical(values, ordered=True)


 "D:\pandas\core\categorical.py", line 336, in __init__

raise TypeError("'values' is not ordered, please "
TypeError: 'values' is not ordered, please explicitly specify the categories order by passing in a categories argument.
