Personnel Work_Date
Aleksey 2020-05-25 519
2020-05-26 223
2020-05-27 203
2020-05-29 265
2020-05-30 262
2020-05-31 510
2020-06-02 329
2020-06-03 486
2020-06-04 766
2020-06-07 343
2020-06-08 372
df1.groupby(['Personnel','Month'])['Boxes_Picked_Picking'].mean().unstack('Month')
Month Июль Июнь Май
Personnel
Aleksey 517.900000 521.444444 330.333333
Andrey 79.000000 276.500000 189.166667
Tatyana 0.000000 0.000000 26.250000
Aleksandr 990.181818 1097.347826 1383.714286
Andrey 418.600000 626.714286 583.600000
import requests
url = "http://ovga.mos.ru:8080/_ajax/pass/list?search={%22grz%22:%22К239ММ159%22}&sort=validitydate&order=desc"
payload = {}
headers = {
'X-Requested-With': 'XMLHttpRequest'
}
response = requests.request("GET", url, headers=headers, data = payload)
print(response)
https://somesite.ru/delivery/?export_excel=Y
https://somesite/delivery/?export_excel=Y&FILTER%5BUF_SHIPPING_DATE%5D%5Bstart%5D%5B0%5D=16.04.2020&FILTER%5BUF_SHIPPING_DATE%5D%5Bfinish%5D%5B0%5D=16.04.2020