Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- tariff = pd.read_csv('/datasets/tariffs.csv',index_col = 'tariff_name')
- def users_benefits(row, tariffs = tariffs):
- short_min = row['calls_duration_total']
- short_message = row['messages']
- short_internet = row['mb_used']
- tariff = row['tariff']
- minutes_limit = tariffs.loc[tariff, 'minutes_included']
- messages_limit = tariffs.loc[tariff, 'messages_included']
- internet_limit = tariffs.loc[tariff, 'mb_per_month_included']
- call_overlimit = max(short_min - minutes_limit, 0)
- call_overpay = call_overlimit * tariffs.loc[tariff, 'rub_per_minute']
- messages_overlimit = max(short_message - messages_limit, 0)
- messages_overpay = messages_overlimit * tariffs.loc[tariff, 'rub_per_message']
- internet_overlimit = max(short_internet - internet_limit, 0)
- internet_overpay = internet_overlimit * tariffs.loc[tariff, 'rub_per_gb']
- profit = call_overpay + messages_overpay + internet_overpay + tariffs.loc[tariff, 'rub_monthly_fee']
- return profit
- data_grouped['profit'] = data_grouped['tariff', 'calls_duration_total', 'mb_used', 'messages'].apply(users_benefits, axis = 1)
- data_grouped
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement