Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2020
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. print(df.isnull().sum())
  2. df_sotr_avg = df[df['income_type'] == 'сотрудник']['total_income'].mean()
  3. df_comp_avg = df[df['income_type'] == 'компаньон']['total_income'].mean()
  4. df_pens_avg = df[df['income_type'] == 'пенсионер']['total_income'].mean()
  5. df_gos_avg = df[df['income_type'] == 'госслужащий']['total_income'].mean()
  6. total_income_avg = (11119 / 19351)*df_sotr_avg + (5085 / 19351)*df_comp_avg + (3856 / 19351)*df_pens_avg + (1459 / 19351)*df_gos_avg
  7. df['total_income'] = df['total_income'].fillna(total_income_avg)
  8. df_sotr_avg = df[df['income_type'] == 'сотрудник']['days_employed'].mean()
  9. df_comp_avg = df[df['income_type'] == 'компаньон']['days_employed'].mean()
  10. df_pens_avg = df[df['income_type'] == 'пенсионер']['days_employed'].mean()
  11. df_gos_avg = df[df['income_type'] == 'госслужащий']['days_employed'].mean()
  12. days_employed_avg = (11119 / 19351)*df_sotr_avg + (5085 / 19351)*df_comp_avg + (3856 / 19351)*df_pens_avg + (1459 / 19351)*df_gos_avg
  13. df['days_employed'] = df['days_employed'].fillna(days_employed_avg)
  14. print(df['dob_years'].value_counts())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement