Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- print(df.isnull().sum())
- df_sotr_avg = df[df['income_type'] == 'сотрудник']['total_income'].mean()
- df_comp_avg = df[df['income_type'] == 'компаньон']['total_income'].mean()
- df_pens_avg = df[df['income_type'] == 'пенсионер']['total_income'].mean()
- df_gos_avg = df[df['income_type'] == 'госслужащий']['total_income'].mean()
- total_income_avg = (11119 / 19351)*df_sotr_avg + (5085 / 19351)*df_comp_avg + (3856 / 19351)*df_pens_avg + (1459 / 19351)*df_gos_avg
- df['total_income'] = df['total_income'].fillna(total_income_avg)
- df_sotr_avg = df[df['income_type'] == 'сотрудник']['days_employed'].mean()
- df_comp_avg = df[df['income_type'] == 'компаньон']['days_employed'].mean()
- df_pens_avg = df[df['income_type'] == 'пенсионер']['days_employed'].mean()
- df_gos_avg = df[df['income_type'] == 'госслужащий']['days_employed'].mean()
- days_employed_avg = (11119 / 19351)*df_sotr_avg + (5085 / 19351)*df_comp_avg + (3856 / 19351)*df_pens_avg + (1459 / 19351)*df_gos_avg
- df['days_employed'] = df['days_employed'].fillna(days_employed_avg)
- print(df['dob_years'].value_counts())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement