数据帧合并操作的keyerror

Question

我有两个数据帧，tourney_data和season_statistics_T1。我尝试如下合并这两个数据帧，这给了我以下错误消息。我不明白原因

tourney_data = pd.merge(tourney_data, season_statistics_T1, on = ['Season', 'T1_TeamID'], how = 'left')

tourney_数据的头部数据为

{'Season': {0: 2010, 1: 2010, 2: 2010, 3: 2010, 4: 2010},
 'DayNum': {0: 138, 1: 138, 2: 138, 3: 138, 4: 138},
 'T1_TeamID': {0: 3124, 1: 3173, 2: 3181, 3: 3199, 4: 3207},
 'T1_Score': {0: 69, 1: 67, 2: 72, 3: 75, 4: 62},
 'T2_TeamID': {0: 3201, 1: 3395, 2: 3214, 3: 3256, 4: 3265},
 'T2_Score': {0: 55, 1: 66, 2: 37, 3: 61, 4: 42}}

然而，我得到了season_statistics_T1的关键错误消息，当使用season_statistics_T1.head()获取信息时，它工作得很好。但是当我使用season_statistics_T1.head().to_dict()时。我得到了KeyError: 'Season'

---

KeyError                                  Traceback (most recent call last)
<ipython-input-76-09e6432ab186> in <module>
----> 1 tourney_data = pd.merge(tourney_data, season_statistics_T1, on = ['Season', 'T1_TeamID'], how = 'left')

~\Anaconda3\envs\vscodeds\lib\site-packages\pandas\core\reshape\merge.py in merge(left, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, copy, indicator, validate)
     85         copy=copy,
     86         indicator=indicator,
---> 87         validate=validate,
     88     )
     89     return op.get_result()

~\Anaconda3\envs\vscodeds\lib\site-packages\pandas\core\reshape\merge.py in __init__(self, left, right, how, on, left_on, right_on, axis, left_index, right_index, sort, suffixes, copy, indicator, validate)
    650             self.right_join_keys,
    651             self.join_names,
--> 652         ) = self._get_merge_keys()
    653 
    654         # validate the merge keys dtypes. We may need to coerce

~\Anaconda3\envs\vscodeds\lib\site-packages\pandas\core\reshape\merge.py in _get_merge_keys(self)
   1003                     if not is_rkey(rk):
   1004                         if rk is not None:
-> 1005                             right_keys.append(right._get_label_or_level_values(rk))
   1006                         else:
   1007                             # work-around for merge_asof(right_index=True)

~\Anaconda3\envs\vscodeds\lib\site-packages\pandas\core\generic.py in _get_label_or_level_values(self, key, axis)
   1561             values = self.axes[axis].get_level_values(key)._values
   1562         else:
-> 1563             raise KeyError(key)
   1564 
   1565         # Check for duplicates

KeyError: 'Season'