:::: 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..

1. install 2. uninstall pandas install $ sudo apt install python3-pandas [ Execution log ]gangserver@NT200B5C-A22R:~$ sudo apt install python3-pandas패키지 목록을 읽는 중입니다... 완료의존성 트리를 만드는 중입니다... 완료상태 정보를 읽는 중입니다... 완료 다음의 추가 패키지가 설치될 것입니다 : fonts-lyx isympy-common isympy3 libaec0 libblosc1 libblosc2-2t64 libhdf5-103-1t64 libjs-jquery-ui liblbfgsb0 libqhull-r8.0 libsz2 python-matplotlib-dat..

>>> import pandas as pd>>> df1 = pd.read_csv('sample.csv')>>> df1.mean():1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.Eng 83.1Math 73.7dtype: float64 [ Solution ]Select only valid columns or set numeric_only=True. >>> df..

import pandas as pddf = pd.read_csv('sample.csv') df.median() or df.corr() [ Error message ]---------------------------------------------------------------------------------------------------------------------------------:1: FutureWarning: The default value of numeric_only in DataFrame.median is deprecated. In a future version, it will default to False. In addition, specifying 'numeric_only=Non..

[ CSV file read ]>>> import pandas as pd >>> df1 = pd.read_csv('sample.csv')>>> df1 StdID Middle Final0 S01 90 951 S02 82 832 S03 80 783 S04 78 754 S05 93 91 [ 'StdID' set index ]>>> df1.set_index('StdID', inplace=True)>>> df1 Middle FinalStdIDS01 90 95S02 82 83S03 80 78S04 78 75S05 ..

[ Code ]---------------------------------------------------------------------------import pandas as pddf1 = pd.read_csv('sample.csv')--------------------------------------------------------------------------- [ Error message ]C:\py_test> python sample.pyTraceback (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) ..

네이버 주식 일별 시세 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: No ta..