Size: a a a
Ⴗ
ᅠ
Ⴗ
A
L
L
A
A
A
L
A
L
A
K
К
import pandas as pd
from datetime import datetime as dt
severstal_df = pd.read_csv('C:/Тестовое задание Северсталь.csv', sep = ';', encoding = 'windows-1251')
severstal_df = severstal_df.rename(columns = {'Операция': 'operation',
'Дата': 'date',
'Время': 'time',
'Пользов': 'user'})
severstal_df['duration'] = pd.to_datetime(severstal_df['time'], format = '%H:%M:%S')
severstal_df = severstal_df.groupby(['operation', 'date', 'user'])\
.duration.apply(lambda x: x.max() - x.min()).reset_index(name = 'duration')
severstal_df = (pd.Timestamp('today').normalize() + severstal_df['duration']).dt.time
severstal_df = pd.DataFrame(severstal_df)
severstal_dfᅠ
VA
IL