single positional indexer is out-of-bounds 오류 질문드립니다

Question

안녕하십니까 선배님들 질문하나 드리겠습니다. 해당 코드는 QFileDialog.getOpenFileNames 를 통해 받은 엑셀 데이터 전처리 작업 중 코드 일부입니다. def create_table(self): #받은 엑셀파일 전처리 작업 AE_cor &#61; pd.DataFrame() global fnames for i in fnames: AE_team &#61; pd.read_excel(f'{i}') #연도 추출 date &#61; AE_team.iloc[0,5] # 필요없는 행 삭제 AE_team.drop([AE_team.index[0], AE_team.index[1],AE_team.index[3],AE_team.index[4]], inplace &#61; True) AE_team &#61; AE_team.rename(columns&#61;AE_team.iloc[0]) AE_team.drop([AE_team.index[0]], inplace &#61; True) AE_team &#61; AE_team.reset_index(drop &#61; True, inplace &#61; False) team &#61; AE_team.iloc[0,0] 오류내용은 다음과 같습니다. File &#34;c:\Users\Desktop\python workspace\.vscode\expenses\expense.py&#34;, line 111, in create_table team &#61; AE_team.iloc[0,0] return self._getitem_tuple(key) File &#34;C:\Python39\lib\site-packages\pandas\core\indexing.py&#34;, line 1450, in _getitem_tuple self._has_valid_tuple(tup) File &#34;C:\Python39\lib\site-packages\pandas\core\indexing.py&#34;, line 723, in _has_valid_tuple self._validate_key(k, i) File &#34;C:\Python39\lib\site-packages\pandas\core\indexing.py&#34;, line 1358, in _validate_key self._validate_integer(key, axis) File &#34;C:\Python39\lib\site-packages\pandas\core\indexing.py&#34;, line 1444, in _validate_integer raise IndexError(&#34;single positional indexer is out-of-bounds&#34;)IndexError: single positional indexer is out-of-bounds 문제는 주티터 노트북에선 잘 작동이 되는데 vscode에서는 이런 오류가 발생합니다. 원인이 무엇인가요? 답변 해주시면 감사하겠습니다!

single positional indexer is out-of-bounds 오류 질문드립니다

0개의 답변

Q&A 목록