Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import numpy as np
- import pandas as pd
- def get_profit_report(input_data):
- data = pd.DataFrame.copy(input_data)
- report = {
- 'full_data': None,
- 'risky_months': 0,
- 'finding': ''
- }
- profitable_months = []
- unprofitable_months = []
- data['balance'] = np.nan
- data['comment'] = np.nan
- data['balance'] = data['sales'] * data['car_price'] - data['costs']
- data.loc[data['balance'] > 50000, 'comment'] = 'Outstanding'
- data.loc[data['balance'] < -100000, 'comment'] = 'Risk'
- report['full_data'] = data
- if len(data[data['balance']>0]) < len(data[~(data['balance']>0)]):
- report['risky_months'] = len(data[data['comment'] == 'Risk'])
- if report['risky_months'] > len(data) / 2:
- report['finding'] = 'Car price needs adjustment'
- return report
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement