pandas 报错 KeyError Traceback

没看懂这个报错，是要改数据库还是改哪里啊
真的很迷，请uu指导

取值的问题，没有叫counts的数据列

• 这篇博客: Python pandas模块中的 10.4 如果出现非Key的字段重名怎么办 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:
  

• 实例 ：

  import pandas as pd
  left=pd.DataFrame({"key":["K1","K2","K3","K4"],
                     "爱好":["篮球 ","篮球","排球","台球"],
                     "B":["B1","B2","B3","B4"]})
  right=pd.DataFrame({"key":["K3","K4","K5","K6"],
                     "爱好":["篮球1 ","篮球2","排球3","台球4"],
                     "A":["A1","A2","A3","A4"]})
  

  Pandas默认处理方法：会在 相同key后加上"_x"和"_y"

  print(pd.merge(left,right,on="key"))
  

  可以指定后缀：

  print(pd.merge(left,right,on="key",suffixes=("_left","_right")))