Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2020
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. print(df.isnull().sum())
  2.  
  3. df_sotr_avg = df[df['income_type'] == 'сотрудник']['total_income'].mean()
  4. df_comp_avg = df[df['income_type'] == 'компаньон']['total_income'].mean()
  5. df_pens_avg = df[df['income_type'] == 'пенсионер']['total_income'].mean()
  6. df_gos_avg = df[df['income_type'] == 'госслужащий']['total_income'].mean()
  7.  
  8. if (df['income_type'] == 'сотрудник'):
  9. df['total_income'] = df['total_income'].fillna(df_sotr_avg)
  10. elif (df['income_type'] == 'компаньон'):
  11. df['total_income'] = df['total_income'].fillna(df_comp_avg)
  12. elif (df['income_type'] == 'пенсионер'):
  13. df['total_income'] = df['total_income'].fillna(df_pens_avg)
  14. elif (df['income_type'] == 'госслужащий'):
  15. df['total_income'] = df['total_income'].fillna(df_gos_avg)
  16.  
  17. # ------------------------------------------------------------------------
  18.  
  19. df_sotr_avg = df[df['income_type'] == 'сотрудник']['days_employed'].mean()
  20. df_comp_avg = df[df['income_type'] == 'компаньон']['days_employed'].mean()
  21. df_pens_avg = df[df['income_type'] == 'пенсионер']['days_employed'].mean()
  22. df_gos_avg = df[df['income_type'] == 'госслужащий']['days_employed'].mean()
  23.  
  24. if (df['income_type'] == 'сотрудник'):
  25. df['days_employed'] = df['days_employed'].fillna(df_sotr_avg)
  26. elif (df['income_type'] == 'компаньон'):
  27. df['days_employed'] = df['days_employed'].fillna(df_comp_avg)
  28. elif (df['income_type'] == 'пенсионер'):
  29. df['days_employed'] = df['days_employed'].fillna(df_pens_avg)
  30. elif (df['income_type'] == 'госслужащий'):
  31. df['days_employed'] = df['days_employed'].fillna(df_gos_avg)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement