行数据
Ticker date price
a 11/11/2017 11.1
a 11/12/2017 12.1
a 11/13/2017 13.1
b 11/11/2017 3
b 11/12/2017 4
b 11/13/2017 2
c 11/11/2017 100
c 11/12/2017 87
c 11/13/2017 104
我希望结果像：
Ticker max max_date min min_date
a 13.1 11/13/2017 11.1 11/11/2017
b 4 11/12/2017 2 11/13/2017
c 104 11/13/2017 87 11/12/2017
关于如何做的任何建议？
使用聚合
df_new = df.groupby('Ticker').agg(['min', 'max'])
df_new.columns = df_new.columns.map('_'.join)
date_min date_max price_min price_max
Ticker
a 11/11/2017 11/13/2017 11.1 13.1
b 11/11/2017 11/13/2017 2.0 4.0
c 11/11/2017 11/13/2017 87.0 104.0