def read_excel(
io,
sheet_name: "str | int | list[IntStrT] | None" = 0,
header: "int | Sequence[int] | None" = 0,
names=None,
index_col: "int | Sequence[int] | None" = None,
usecols=None,
squeeze: "bool | None" = None,
dtype: "DtypeArg | None" = None,
engine: "Literal[('xlrd', 'openpyxl', 'odf', 'pyxlsb')] | None" = None,
converters=None,
true_values: "Iterable[Hashable] | None" = None,
false_values: "Iterable[Hashable] | None" = None,
skiprows: "Sequence[int] | int | Callable[[int], object] | None" = None,
nrows: "int | None" = None,
na_values=None,
keep_default_na: "bool" = True,
na_filter: "bool" = True,
verbose: "bool" = False,
parse_dates=False,
date_parser=None,
thousands: "str | None" = None,
decimal: "str" = ".",
comment: "str | None" = None,
skipfooter: "int" = 0,
convert_float: "bool | None" = None,
mangle_dupe_cols: "bool" = True,
storage_options: "StorageOptions" = None,
) -> "DataFrame | dict[IntStrT, DataFrame]": # noqa: PR01, RT01, D200
"""
Read an Excel file into a DataFrame.
"""
_, _, _, kwargs = inspect.getargvalues(inspect.currentframe())
Engine.subscribe(_update_engine)
from modin.core.execution.dispatching.factories.dispatcher import FactoryDispatcher
intermediate = FactoryDispatcher.read_excel(**kwargs)
if isinstance(intermediate, (OrderedDict, dict)):
parsed = type(intermediate)()
for key in intermediate.keys():
parsed[key] = DataFrame(query_compiler=intermediate.get(key))
return parsed
else:
return DataFrame(query_compiler=intermediate)
def read_excel(
io,
sheet_name=0,
header=0,
names=None,
index_col=None,
usecols=None,
squeeze=False,
dtype=None,
engine=None,
converters=None,
true_values=None,
false_values=None,
skiprows=None,
nrows=None,
na_values=None,
keep_default_na=True,
na_filter=True,
verbose=False,
parse_dates=False,
date_parser=None,
thousands=None,
comment=None,
skipfooter=0,
convert_float=None,
mangle_dupe_cols=True,
storage_options: StorageOptions = None,
):
_, _, _, kwargs = inspect.getargvalues(inspect.currentframe())
Engine.subscribe(_update_engine)
from modin.core.execution.dispatching.factories.dispatcher import FactoryDispatcher
intermediate = FactoryDispatcher.read_excel(**kwargs)
if isinstance(intermediate, (OrderedDict, dict)):
parsed = type(intermediate)()
for key in intermediate.keys():
parsed[key] = DataFrame(query_compiler=intermediate.get(key))
return parsed
else:
return DataFrame(query_compiler=intermediate)
