1. 1st> py,pd - Review1
* 코드
import pandas as pd
import numpy as np
df = pd.DataFrame({
"메뉴":['아메리카노', '카페라떼', '에스프레소', '카페모카', '바닐라라떼'],
"가격":[4500, 5000, 4000, 5000, 5300],
"칼로리":[10, 110, np.nan, 210, np.nan],
"원두":['과테말라', '브라질', '과테말라', np.nan, np.nan]
})
df
# Q1.
#cond = df['칼로리'].isnull()
df['칼로리'] = df['칼로리'].fillna(df['칼로리'].min())
df
# Q2.
df['원두'] = df['원두'].fillna(df['원두'].mode()[0])
df
# Q3.
cond = df['가격'] >= 5000
len(df[cond])
# Q4.
df['이벤트가'] = df['가격']*0.5
df
# Q5.
df = df.drop(axis=1, columns='칼로리')
df
# Q6, Q7
df
df.loc[:2]
df.iloc[:3]
# Q8.
df
df.loc[1:2, :'가격']
# Q9.
df
df.iloc[1:3, :2]
# Q10.
df
df.sort_values('가격', ascending=False)[:3]
* 공유 링크
https://colab.research.google.com/drive/1XYvg2nRDJSdV2ou-2XH4yTn2ZtGCi_rW?usp=sharing
Google Colab Notebook
Run, share, and edit Python notebooks
colab.research.google.com