πŸ“šνŒŒμ΄μ¬ λ¨Έμ‹ λŸ¬λ‹ νŒλ‹€μŠ€ 데이터뢄석 part4. 데이터 μ‹œκ°ν™”

πŸ“„part4 matplotlib.ipynb

🐿️ import

import pandas as pd
import matplotlib.pyplot as plt

🌡 κΈ°λ³Έ μ‚¬μš©λ²•

πŸ’ 데이터 뢈러였기

df=pd.read_excel('data/μ‹œλ„λ³„ μ „μΆœμž… 인ꡬ수.xlsx', header=0)
df.head()

Untitled

df.fillna(method='ffill',inplace=True)

df=df.fillna(method='ffill')

method='ffill' λ©”μ„œλ“œλ₯Ό μ‚¬μš©ν•˜λ©΄, λˆ„λ½κ°’ (NaN)을 μ•ž λ°μ΄ν„°λ‘œ μ±„μšΈ 수 있음

mask=(df['μ „μΆœμ§€λ³„']=='μ„œμšΈνŠΉλ³„μ‹œ')&(df['μ „μž…μ§€λ³„']!='μ„œμšΈνŠΉλ³„μ‹œ')
df_seoul=df[mask]

μ„œμšΈμ—μ„œ λ‹€λ₯Έ μ§€μ—­μœΌλ‘œ μ΄λ™ν•œ λ°μ΄ν„°λ§Œ μΆ”μΆœν•˜μ—¬ 정리