单个位置索引器越界错误编码大师，请帮帮我

user16820944 发表于 Dev

用户16820944

我正在收集和预处理 2021 年编写的 Excel 数据。

我的代码如下：

AE_cor = pd.DataFrame()
    global fnames
    for i in fnames: 
        # AE_team = pd.read_excel(f'{i}', header = 3)
        AE_team = pd.read_excel(f'{i}')
        team = AE_team.iloc[5,0]
        date = AE_team.iloc[0,5]

“fname”包含从 QFileDialog.getOpenFileNames 接收到的多个 Excel 文件路径。

当前输出：

Traceback (most recent call last):
File "c:\Users\My\Desktop\python workspace\.vscode\business_expenses\Agency_expense.py", line 71, in create_table
    team = AE_team.iloc[5,0]
  File "C:\Python39\lib\site-packages\pandas\core\indexing.py", line 889, in __getitem__
    return self._getitem_tuple(key)
  File "C:\Python39\lib\site-packages\pandas\core\indexing.py", line 1450, in _getitem_tuple
    self._has_valid_tuple(tup)
  File "C:\Python39\lib\site-packages\pandas\core\indexing.py", line 723, in _has_valid_tuple
    self._validate_key(k, i)
  File "C:\Python39\lib\site-packages\pandas\core\indexing.py", line 1358, in _validate_key
    self._validate_integer(key, axis)
  File "C:\Python39\lib\site-packages\pandas\core\indexing.py", line 1444, in _validate_integer
    raise IndexError("single positional indexer is out-of-bounds")
IndexError: single positional indexer is out-of-bounds

奇怪的是，2020年写的Excel文件运行良好。为什么会出现这样的错误？有没有人可以帮助您理解错误？

Chaos_Is_Harmony

该错误IndexError: single positional indexer is out-of-bounds告诉您其中一个 DataFrame 没有您期望的行数或列数。

运行print(AE_team.head(10))之前team = AE_team.iloc[5,0]可能会帮助您找出哪一个（触发错误的那个）。

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。