Advertisement
Guest User

Untitled

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