Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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')
- data_grouped.columns = ['user_id', 'month', 'mb_used', 'messages', 'calls_total', 'calls_duration_total', 'tariff']
- def monthly_fee(monthly_fee):
- """
- Возвращает сумму абонентской платы по значению категории tariff, используя правила:
- - '550' при значении tariff = smart
- - '1950' при значении tariff = ultra
- """
- if tariff == smart:
- return '550'
- return '1950'
- data_grouped['monthly_fee'] = data_grouped['tariff'].apply(monthly_fee)
- data_grouped
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement