빅데이터분석기사 실기체험 1번

 

import pandas as pd

df = pd.read_csv("data/employee_performance.csv")

df['고객만족도'] = df['고객만족도'].fillna(df['고객만족도'].mean())
df = df.dropna(subset = ['근속연수'])

Q3 = df['고객만족도'].quantile(0.75)
print(f'1번 : {Q3.astype(int)}')

cond = df.groupby('부서')['연봉'].mean().sort_values(ascending = False).reset_index().iloc[1]
print(cond) #Sales