Programming84 [Python] Virtual Environment 만드는 방법 pip 설치/업그레이드 python3 -m pip install --user --upgrade pip python3 -m pip --version pip 21.1.3 from $HOME/.local/lib/python3.9/site-packages (python 3.9) 버츄얼 환경 설치 python3 -m pip install --user virtualenv 버츄얼 환경 활성화 시키기 python3 -m venv env source env/bin/activate which python 버츄얼 환경 종료 deactivate 패키지 설치 python3 -m pip install requests Collecting requests Using cached requests-2.18.4-py2.py3-none-a.. 2023. 6. 17. [python] data cleaning in pandas import pandas as pd In [40]: df= pd.read_excel(f'/Users/grace/Desktop/Alex/Customer Call List.xlsx') df #중복 제거 df.drop_duplicates() df #마지막 컬럼 제거 df= df.drop(columns = 'Not_Useful_Column') df # 1. numeric 으로 다 만들기 using replace # replace anything with empty string to nothing '[a-zA-Z0-9]' 해서 assign 한다음에 # we need to change every thing into string first # then use lambda to make it as 000-000-000.. 2023. 6. 1. [python] visualization pandas import pandas as pd import numpy as np import matplotlib.pyplot as plt In [37]: #불러오기 df = pd.read_csv(f'/Users/grace/Desktop/Alex/Ice Cream Ratings.csv') df Out[37]: DateFlavor RatingTexture RatingOverall Rating0123456 1/1/2022 0.223090 0.040220 0.600129 1/2/2022 0.635886 0.938476 0.106264 1/3/2022 0.442323 0.044154 0.598112 1/4/2022 0.389128 0.549676 0.489353 1/5/2022 0.386887 0.519439 0.98828.. 2023. 6. 1. [python] merge, join, concatenate pandas import pandas as pd In [3]: #df1 생성하기 df1 = pd.read_csv(f'/Users/grace/Desktop/Alex/LOTR.csv') df1 Out[3]: FellowshipIDFirstNameSkills0123 1001 Frodo Hiding 1002 Samwise Gardening 1003 Gandalf Spells 1004 Pippin Fireworks #df2 생성하기 df2 = pd.read_csv(r"/Users/grace/Desktop/Alex/LOTR 2.csv") df2 Out[5]: FellowshipIDFirstNameAge01234 1001 Frodo 50 1002 Samwise 39 1006 Legolas 2931 1007 Elrond 6520 .. 2023. 6. 1. 이전 1 2 3 4 ··· 21 다음
