Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.48 KB | None | 0 0
  1. for index, row in df.iterrows():
  2. for k1, v1 in model_4_factors.items():
  3. for k2, v2 in v1.items():
  4. if isinstance(v2, dict):
  5. for k3, v3 in v2.items():
  6. if k2 == row['RATING_CLASS_CODE'] and k3 == row['unit_value_model']:
  7. df['value_factor_4'] = v3
  8. elif k2 == row['RATING_CLASS_CODE'] and k3 == row['MVEH_CC_Model']:
  9. df['cc_factor_4'] = v3
  10. elif k2 == row['term_model'] and k3 == row['advanced_purchase_days_model']:
  11. df['advanced_days_factor_4'] = v3
  12. elif k2 == row['marital_status_model'] and k3 == row['Driver_Age_model']:
  13. df['driver_age_factor_4'] = v3
  14. else:
  15. df['value_factor_4'] = None
  16.  
  17. else:
  18. if row['mveh_pkg_typ_cd'] == k2:
  19. df['mveh_pkg_typ_cd_factor_4'] = v2
  20.  
  21. elif row['CLded'] == k2:
  22. df['CLded_factor_4'] = v2
  23.  
  24. elif row['unit_drv_exp_model'] == k2:
  25. df['unit_drv_exp_model'] = v2
  26.  
  27. elif row['v_age_model'] == k2:
  28. df['v_age_model_factor_4'] = v2
  29.  
  30. elif row['years_owned_model'] == k2:
  31. df['years_owned_model_factor_4'] = v2
  32.  
  33. elif row['FIN_RESP_CD'] == k2:
  34. df['FIN_RESP_CD_factor_4'] = v2
  35.  
  36. elif row['st_ad_moto_safety_course'] == k2:
  37. df['st_ad_moto_safety_course_factor_4'] = v2
  38.  
  39. elif row['st_ai_instructor_course'] == k2:
  40. df['st_ai_instructor_course_factor_4'] = v2
  41.  
  42. elif row['st_ci_instructor_course'] == k2:
  43. df['st_ci_instructor_course_factor_4'] = v2
  44.  
  45. elif row['st_mf_moto_safety_course '] == k2:
  46. df['st_mf_moto_safety_course_factor_4'] = v2
  47.  
  48. elif row['st_mi_instructor_course'] == k2:
  49. df['st_mi_instructor_course_factor_4'] = v2
  50.  
  51. elif row['st_mc_moto_safety_course'] == k2:
  52. df['st_mc_moto_safety_course_factor_4'] = v2
  53.  
  54. elif row['st_rc_moto_safety_course'] == k2:
  55. df['st_rc_moto_safety_course_factor_4'] = v2
  56.  
  57. elif row['st_ri_instructor_course'] == k2:
  58. df['st_ri_instructor_course_factor_4'] = v2
  59.  
  60. elif row['ds_pn_prior_insurance'] == k2:
  61. df['ds_pn_prior_insurance_factor_4'] = v2
  62.  
  63. elif row['st_rc_moto_safety_course'] == k2:
  64. df['st_rc_moto_safety_course_factor_4'] = v2
  65.  
  66. elif row['Loyalty'] == k2:
  67. df['Loyalty_factor_4'] = v2
  68.  
  69. elif row['ds_mc_motorcycle_endorsement'] == k2:
  70. df['ds_mc_motorcycle_endorsement_factor_4'] = v2
  71.  
  72. elif row['multi_unit_model2'] == k2:
  73. df['multi_unit_model2_factor_4'] = v2
  74.  
  75. elif row['ds_ad_affinity'] == k2:
  76. df['ds_ad_affinity_factor_4'] = v2
  77.  
  78. elif row['ds_ak_alliance'] == k2:
  79. df['ds_ak_alliance_factor_4'] = v2
  80.  
  81. elif row['multi_policy_count_model'] == k2:
  82. df['multi_policy_count_model_factor_4'] = v2
  83.  
  84. elif row['ds_fp_paid_in_full'] == k2:
  85. df['ds_fp_paid_in_full_factor_4'] = v2
  86.  
  87. else:
  88. pass
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement