我有一个这样的数据框:
df = pd.DataFrame({'A' : list('ababababba'),
'B' : [1, 1, 1, 2, 2, 1,1,2,1,1],
'C' : [2.0, 5., 8., 1., 2., 9.,2.0,4.0,5.0,3.0],
'D' : [10,20,30,10,20,30,20,40,50,10]})
必须:
A B C D
0 a 1 2.0 10 # a1 min keep
1 b 1 5.0 20 # b1 min
2 a 1 8.0 30 # a1 max keep
3 b 2 1.0 10
4 a 2 2.0 20
# b1 removed
# a1 remove
7 b 2 4.0 40
8 b 1 5.0 50 # b1 max keep
9 a 1 3.0 10 # a1 min keep
相关链接: 如何在pandas groupby中获取最小值和最大值行
from tabulate import tabulate print(tabulate(df, headers=df.columns, tablefmt='psql'))
- BhishanPoudel