:::: gangserver's blog ::::

[ Code ]import pandas as pddf = pd.read_excel("test.xlsx") [ Error message ]Pandas read_excel error : ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead. [ Reason ]Since xlrd 2.0 and above only supports the xls format and not the xlsx format, install the openpyxl module to process the xlsx format with read_excel in Pandas. [ Solu..

[ Code ] --------------------------------------------------------------------------- import pandas as pd df1 = pd.read_csv('sample.csv') --------------------------------------------------------------------------- [ Error message ] C:\py_test> python sample.py Traceback (most recent call last): File "C:\py_test\sample.py", line 3, in df1 = pd.read_csv('sample.csv') File "C:\Python\Python39\lib\si..

[ error message ] >>> df = pd.read_excel('data.xlsx') Traceback (most recent call last): File "C:\devel\Python\Python39\lib\site-packages\pandas\compat\_optional.py", line 138, in import_optional_dependency module = importlib.import_module(name) File "C:\devel\Python\Python39\lib\importlib\__init__.py", line 127, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "..

네이버 주식 일별 시세 pandas read_html() 오류 --------------------------------------------------------------------------------------------------- import pandas as pd # 네이버 금융 주식 일별시세(예, LG전자[066570]) url = "https://finance.naver.com/item/sise_day.nhn?code=066570" df = pd.read_html(url) --------------------------------------------------------------------------------------------------- => 오류 발생 : ValueError:..