Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- locations = df['Подразделение'].unique()
- df_locations = []
- for loc in locations:
- df_per_location = df[df['Подразделение'] == loc]
- df_tmp = df_per_location[df_per_location['Возврат'] == 'Нет']
- upt = df_tmp[['Номер', 'Количество']].groupby(['Номер']).sum()['Количество'].mean()
- average_check = df_tmp[['Номер', 'Сумма']].groupby(['Номер']).sum()['Сумма'].mean()
- # start = pd.Timestamp('2017-09-01 00:00:00'.format(y = y, m = m, d = d))
- # end = pd.Timestamp('2017-09-30 23:59:59'.format(y = y, m = m, d = d))
- # df_monthly = df_tmp[(df_tmp['Дата'] >= start) & (df_tmp['Дата'] <= end)]
- monthly_revenue = df_tmp[['ГодМесяц', 'Сумма']].groupby(['ГодМесяц']).sum()['Сумма'].mean()
- df_locations.append([loc, upt, average_check, monthly_revenue])
- # print(df_locations)
- df_locations = pd.DataFrame(df_locations)
- print(df_locations)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement