TypeError with pandas.read_excel

Question

我无法加载xlsx文件

import pandas
y=pandas.read_excel("as.xlsx",sheetname=0)
y

这是错误消息

TypeError                                 Traceback (most recent call last)
<ipython-input-5-54208838b8e5> in <module>
      1 import pandas
----> 2 y=pandas.read_excel("as.xlsx",sheetname=0)
      3 y
c:userslenovo-pcappdatalocalprogramspythonpython37libsite-packagespandasutil_decorators.py in wrapper(*args, **kwargs)
    206                 else:
    207                     kwargs[new_arg_name] = new_arg_value
--> 208             return func(*args, **kwargs)
    209 
    210         return wrapper
c:userslenovo-pcappdatalocalprogramspythonpython37libsite-packagespandasioexcel_base.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, verbose, parse_dates, date_parser, thousands, comment, skip_footer, skipfooter, convert_float, mangle_dupe_cols, **kwds)
    304         if arg in kwds:
    305             raise TypeError(
--> 306                 "read_excel() got an unexpected keyword argument " "`{}`".format(arg)
    307             )
    308 
TypeError: read_excel() got an unexpected keyword argument `sheetname`

Answer 1

您有语法错误

尝试

y=pandas.read_excel("as.xlsx",sheet_name=0)

Answer 2

看来这个" sheet_name"可能是依赖语言的。该论点也是位置的，因此您可以删除" sheet_name"。并写：

y=pandas.read_excel("as.xlsx",0)

我尝试了pandas 1.0.5和xlrd 1.2.0

Answer 3

语法错误。应该是：

sheet_name = 'xxx'

Answer 4

从命令提示符中安装 xlrd，使用以下：

1. conda install xlrd
2. pip install xlrd

它称为Sheetname