KeyError列名不在索引中

Question

我又问了一个新手的问题。有以下来自Excel的数据，我得到了错误，谁能让我知道我做错了什么，谢谢：

编辑:下面是Excel中的列

+----+--------+------+----+----+---+----+-----+----+-----+----+-------+-------+----------+--------+-----------+--------+-----+--------+------------+------+----------+-------+------------+-------+---------+-----+-----+-----+-----+------+----+-----+------+-----------+----------+----------+---------+
| Rk | Player | From | To | Tm | G | GS | Yrs | PB | AP1 | AV | GS/Yr | AV/Yr | QB_score | Height | Height-in | Weight | BMI | School | BCS School | 40YD | Vertical | Bench | Broad Jump | 3cone | Shuttle | Cmp | Att | Pct | Yds | AY/A | TD | Int | Rate | Rush_Att  | Rush_Yds | Rush_Avg | Rush_TD |
+----+--------+------+----+----+---+----+-----+----+-----+----+-------+-------+----------+--------+-----------+--------+-----+--------+------------+------+----------+-------+------------+-------+---------+-----+-----+-----+-----+------+----+-----+------+-----------+----------+----------+---------+

KeyError：“Rush_Att不在索引中”

df = pd.read_excel('sportsref-qbdata-raw-v2.xlsx', header=1)

cols_to_keep = ['Player', 'QB_score', 'Height-in', 'Weight', 'BMI', 'BCS School', 'Cmp', 'Att', 'Pct', 'Yds', 'AY/A', 'TD', 'Int', 'Rate', 'Rush_Att', 'Rush_Yds', 'Rush_Avg', 'Rush_TD']

df = df[cols_to_keep] 

Answer 1

您不必使用header = 1，因为您只有1行标题、删除标头参数或使用header = 0或header = [0]