커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
2-3 엑셀가져오기
undefined주차
북마크
한*호
댓글
2
추천
0
조회수
22
조회수
22
답변 완료
import pandas as pd
import numpy as np

df = pd.read_excel('종목데이터.xlsx')
df
---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-47-2acd221d8ac6> in <module>
----> 1 df = pd.read_excel('종목데이터.xlsx')
      2 df


4 frames
/usr/local/lib/python3.7/dist-packages/pandas/util/_decorators.py in wrapper(*args, **kwargs)
    309                     stacklevel=stacklevel,
    310                 )
--> 311             return func(*args, **kwargs)
    312 
    313         return wrapper

/usr/local/lib/python3.7/dist-packages/pandas/io/excel/_base.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, parse_dates, date_parser, thousands, comment, skipfooter, convert_float, mangle_dupe_cols, storage_options)
    362     if not isinstance(io, ExcelFile):
    363         should_close = True
--> 364         io = ExcelFile(io, storage_options=storage_options, engine=engine)
    365     elif engine and engine != io.engine:
    366         raise ValueError(

/usr/local/lib/python3.7/dist-packages/pandas/io/excel/_base.py in __init__(self, path_or_buffer, engine, storage_options)
   1190             else:
   1191                 ext = inspect_excel_format(
-> 1192                     content_or_path=path_or_buffer, storage_options=storage_options
   1193                 )
   1194                 if ext is None:

/usr/local/lib/python3.7/dist-packages/pandas/io/excel/_base.py in inspect_excel_format(content_or_path, storage_options)
   1069 
   1070     with get_handle(
-> 1071         content_or_path, "rb", storage_options=storage_options, is_text=False
   1072     ) as handle:
   1073         stream = handle.handle

/usr/local/lib/python3.7/dist-packages/pandas/io/common.py in get_handle(path_or_buf, mode, encoding, compression, memory_map, is_text, errors, storage_options)
    709         else:
    710             # Binary mode
--> 711             handle = open(handle, ioargs.mode)
    712         handles.append(handle)
    713 

FileNotFoundError: [Errno 2] No such file or directory: '종목데이터.xlsx'


엑셀파일 '종목데이터' 받은거 안 읽혀오네요;;

취소
 공유
취소
댓글 0
댓글 알림
나의얼굴