将集合与中的excel单元格进行比较时出错

Question

您好，在下面的代码中，我正在尝试将集合与excel单元格进行比较

s = [a]
d=b
loc_file=r"C:\\Users\\Public\Downloads\\media_bias.xlsx"
data=p.read_excel(loc_file, index_col=0)

print("\n ")
print(data)
print("\n")

for i in range(0,43):
    for j in range (0,43):
        if data[i][j]==s:
            print("found")

我遇到的错误是：-

  File "d:\python script & program\Media Bais Detector.py", line 31, in detec
    if data[i][j]==s:
  File "C:\Users\SAYYED VIQUAR AHED\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\frame.py", line 3024, in __getitem__
    indexer = self.columns.get_loc(key)
  File "C:\Users\SAYYED VIQUAR AHED\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\indexes\base.py", line 3082, in get_loc
    raise KeyError(key) from err
KeyError: 0

感谢您阅读代码

Answer 1

KeyError: 0

您的data框架由Excel列A索引。要使用整数索引，请使用^{}：

        if data.iloc[i][j]==s:

请注意，Excel单元格至少不太可能包含列表[a]；也许你的意思是

        if data.iloc[i][j] in s:

当然，您必须发布文件内容