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

>>> 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.1 Math 73.7 dtype: float64 [ Solve ] Select only valid columns or set numeric_only=True. >>> df1.me..

import pandas as pd df = 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=N..

[ CSV file read ] >>> import pandas as pd >>> df1 = pd.read_csv('sample.csv') >>> df1 StdID Middle Final 0 S01 90 95 1 S02 82 83 2 S03 80 78 3 S04 78 75 4 S05 93 91 [ 'StdID' set index ] >>> df1.set_index('StdID', inplace=True) >>> df1 Middle Final StdID S01 90 95 S02 82 83 S03 80 78 S04 78 75 S05 93 91 * inplace=True option df1.set_index('StdID', inplace=True) => df1 = df1.set_index('StdID') [ ..

import pandas as pd df = pd.read_csv('sample.csv') --------------------------------------------------------------------------- UnicodeDecodeError Traceback (most recent call last) in () ----> 1 df = pd.read_csv('sample.csv') 10 frames /usr/local/lib/python3.10/dist-packages/pandas/_libs/parsers.pyx in pandas._libs.parsers.raise_parser_error() UnicodeDecodeError: 'utf-8' codec can't decode byte 0..

로또 번호 생성기, 로또 6/45 첨부 파일(lotto_645.html) 다운로드 후 다운로드된 파일 클릭하면 기본 브라우저(예, 크롬(Chrome)가 실행되면서 로또 번호 생성됩니다. (다운로드된 파일이 HTML 파일이어서 클릭 시 기본 브라우저가 실행되면서 번호가 생생됩니다.)

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

1. 천 단위 숫자를 컴마(',')로 구분하기 1.1 format() 함수 사용 >>> format(1234567890, ',') '1,234,567,890' 1.2 f-string으로 문자열 포멧팅하기 >>> f'{1234567890:,}' '1,234,567,890' 2. 천 단위 숫자를 컴마(',') 제거 2.1 split(), join() 함수 이용 >>> ''.join('1,234,567,890'.split(',')) '1234567890' 2.2 replace() 함수 이용 >>> '1,234,567,890'.replace(',', '')

- Error message : ImportError: libf77blas.so.3: cannot open shared object file: No such file or directory - Solutions : $ sudo apt install libatlas-base-dev gangserver@raspberrypi:~/devel/pydev $ python BreamAndSmelt.py Traceback (most recent call last): File "/home/gangserver/devel/pydev/BreamAndSmelt.py", line 35, in from sklearn.neighbors import KNeighborsClassifier File "/usr/local/lib/pytho..

1. Download attached file(lotto645.html)2. Double click the downloaded file (or Downloaded file open in browser) 1. 첨부파일 다운로드(lotto645.html)2. 다운로드 파일 더블클릭 (또는 다운로드 파일 브라우저에서 열기) html source :DOCTYPE html>html>  head>    link rel="stylesheet" href="https://pyscript.net/latest/pyscript.css" />    script defer src="https://pyscript.net/latest/pyscript.js">script>  head>  body>..

PIP package list $ pip freeze beautifulsoup4==4.12.2 Django==4.2 html5lib==1.1 httplib2==0.20.2 matplotlib==3.7.1 numpy==1.24.2 pandas==2.0.0 Pillow==9.0.1 requests==2.28.2 scikit-learn==1.2.1 scipy==1.10.1 six==1.16.0 PIP package backup (file : requirements.txt) $ pip freeze > requirements.txt => Copy other pc file(requirements.txt) PIP package restore $ pip install --upgrade -r requirements.tx..