需要按天和名称对列进行分组,并获得其开始和结束的最小值
dataframe
day name value start end duration
Wednesday AAA 1 10/23/2019 2:46 10/23/2019 3:09 00:23
Wednesday AAA 1 10/23/2019 5:20 10/23/2019 5:44 00:24
Wednesday AAA 1 10/23/2019 6:51 10/23/2019 8:14 01:23
Wednesday AAA 17602 10/23/2019 12:35 10/23/2019 12:38 00:03
Wednesday AAA 1155 10/23/2019 15:50 10/23/2019 15:54 00:04
逻辑
df.groupby(['day','name']).agg({'duration':[np.min,np.max],'start':[np.min,'end':[np.min,'value':[np.min,np.max]})
我会得到什么
day name duration_min duration_max duration_max_start duration_max_end duration_min_start duration_min_end value_min value_max
Wednesday AAA 00:03 01:23 10/23/2019 6:51 10/23/2019 3:09 10/23/2019 12:35 10/23/2019 15:54 1 17602
但是我应该得到什么
day name duration_min duration_max duration_max_start duration_max_end value_max duration_min_start duration_min_end value_min
Wednesday AAA 00:03 01:23 10/23/2019 6:51 10/23/2019 8:14 1 10/23/2019 12:35 10/23/2019 12:38 17602
我需要通过将其开始值和结束值分组来获得最小值和最大值