Advertisement
Guest User

Untitled

a guest
May 27th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. locations = df['Подразделение'].unique()
  2. df_locations = []
  3. for loc in locations:
  4. df_per_location = df[df['Подразделение'] == loc]
  5. df_tmp = df_per_location[df_per_location['Возврат'] == 'Нет']
  6. upt = df_tmp[['Номер', 'Количество']].groupby(['Номер']).sum()['Количество'].mean()
  7. average_check = df_tmp[['Номер', 'Сумма']].groupby(['Номер']).sum()['Сумма'].mean()
  8.  
  9. # start = pd.Timestamp('2017-09-01 00:00:00'.format(y = y, m = m, d = d))
  10. # end = pd.Timestamp('2017-09-30 23:59:59'.format(y = y, m = m, d = d))
  11. # df_monthly = df_tmp[(df_tmp['Дата'] >= start) & (df_tmp['Дата'] <= end)]
  12. monthly_revenue = df_tmp[['ГодМесяц', 'Сумма']].groupby(['ГодМесяц']).sum()['Сумма'].mean()
  13.  
  14. df_locations.append([loc, upt, average_check, monthly_revenue])
  15. # print(df_locations)
  16.  
  17. df_locations = pd.DataFrame(df_locations)
  18. print(df_locations)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement