Advertisement
Dodma

Untitled

Apr 21st, 2020
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. data_grouped = internet_grouped.merge(messages_grouped, how = 'outer', on = ['user_id', 'month']).merge(calls_grouped, how = 'outer', on = ['user_id', 'month']).merge(users[['user_id', 'tariff']], how = 'left', on = 'user_id')
  2. data_grouped.columns = ['user_id', 'month', 'mb_used', 'messages', 'calls_total', 'calls_duration_total', 'tariff']
  3.  
  4. def monthly_fee(monthly_fee):
  5. """
  6. Возвращает сумму абонентской платы по значению категории tariff, используя правила:
  7. - '550' при значении tariff = smart
  8. - '1950' при значении tariff = ultra
  9. """
  10.  
  11. if tariff == smart:
  12. return '550'
  13. return '1950'
  14.  
  15. data_grouped['monthly_fee'] = data_grouped['tariff'].apply(monthly_fee)
  16. data_grouped
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement