- plan = plans['plan_name']
- internet_usage = internet['gb_used']
- monthly_minutes = calls['duration']
- messages = mssges['mssges_date_month']
- def total_revenue(plan,internet_usage,monthly_minutes,messages):
- if plan == 'surf':
- if monthly_minutes >= 500:
- revenue_calls = (0.03)*(monthly_minutes - 500)
- else:
- revenue_calls = 0
- if messages >= 50:
- revenue_messages = 0.03*(messages - 50)
- else :
- revenue_messages = 0
- if internet_usage >= 15:
- revenue_internet_usage = 10*(internet_usage - 15)
- else :
- revenue_internet_usage = 0
- cost = 20 + revenue_messages + revenue_internet_usage + revenue_calls
- elif plan == 'ultimate':
- if monthly_minutes >= 3000:
- revenue_calls = (0.01)*(monthly_minutes - 3000)
- else:
- revenue_calls = 0
- if messages >= 50:
- revenue_messages = 0.01*(messages - 1000)
- else :
- revenue_messages = 0
- if internet_usage >= 15:
- revenue_internet_usage = 7*(internet_usage - 30)
- else :
- revenue_internet_usage = 0
- cost = 70 + revenue_messages + revenue_internet_usage + revenue_calls
- return cost
- telecom['total_cost'] = telecom['total_cost'].apply(total_revenue)
- telecom.head()
[text] Code
Viewer
Editor
You can edit this paste and save as new:
File Description
- Code
- Paste Code
- 26 Feb-2021
- 1.38 Kb
You can Share it: