将参数列表到sheet_name pandas read_execel()中

Question

我试图在sheet_name中发送一个列表，以便从.csv文件访问多个工作表，当我打印df "df = pd.read_excel( "https://www.football-data.co.uk/mmz4281/2122/all-euro-data-2021-2022.xlsx?raw=true", sheet_name=liga)";工作，他给我打印了两张表，但在下一行他说&;unhashable type: 'list'&;

这是代码:

def liga(liga):
print(liga)
df = pd.read_excel(
"https://www.football-data.co.uk/mmz4281/2122/all-euro-data-2021-2022.xlsx?raw=true", sheet_name=liga)
print(df)
df = df[['Date','HomeTeam','AwayTeam','HTHG','HTAG','HTR','FTHG','FTAG','FTR','B365H','B365D','B365A','B365>2.5']]
df.columns = ['Date', 'Home', 'Away', 'Goals_H_HT', 'Goals_A_HT', 'Result_HT',
'Goals_H_FT', 'Goals_A_FT', 'Result_FT', 'Odds_H', 'Odds_D', 'Odds_A', 'Odds_Over25_FT']
print(df)
liga(["D1","D2"])

Error:
`Traceback (most recent call last):
File "c:UsersRicarDesktopPyhonteste.py", line 20, in<module>liga(["D1","D2"])
File "c:UsersRicarDesktopPyhonteste.py", line 16, in liga 
df=df[['Date','HomeTeam','AwayTeam','HTHG','HTAG','HTR','FTHG','FTAG','FTR','B365H','B365D','B365A','B365>2.5']]
TypeError: unhashable type: 'list'`

Answer 1

pd.read_excel返回一个类似

的字典

{'D1': dataframe1, 'D2': dataframe2}

您需要获得具有字典键的数据帧，如

d = pd.read_excel(
"https://www.football-data.co.uk/mmz4281/2122/all-euro-data-2021-2022.xlsx?raw=true", sheet_name=liga)
df = d['D1'][['Date','HomeTeam','AwayTeam','HTHG','HTAG','HTR','FTHG','FTAG','FTR','B365H','B365D','B365A','B365>2.5']]