Advertisement
Guest User

Untitled

a guest
Nov 11th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.84 KB | None | 0 0
  1. import numpy as np
  2. import pandas as pd
  3.  
  4.  
  5. def get_profit_report(input_data):
  6.     data = pd.DataFrame.copy(input_data)
  7.     report = {
  8.         'full_data': None,
  9.         'risky_months': 0,
  10.         'finding': ''
  11.     }
  12.     profitable_months = []
  13.     unprofitable_months = []
  14.  
  15.     data['balance'] = np.nan
  16.     data['comment'] = np.nan
  17.     data['balance'] = data['sales'] * data['car_price'] - data['costs']
  18.     data.loc[data['balance'] > 50000, 'comment'] = 'Outstanding'
  19.     data.loc[data['balance'] < -100000, 'comment'] = 'Risk'
  20.     report['full_data'] = data
  21.  
  22.    
  23.    
  24.     if len(data[data['balance']>0]) < len(data[~(data['balance']>0)]):
  25.  
  26.         report['risky_months'] = len(data[data['comment'] == 'Risk'])
  27.  
  28.         if report['risky_months'] > len(data) / 2:
  29.             report['finding'] = 'Car price needs adjustment'
  30.  
  31.     return report
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement