我正在尝试通过汇总一列从熊猫数据框中排除不必要的行。数据框如下所示:
df1=pd.DataFrame({'date':[20191121]*10,'time':[100000]*10,'last':[64131,64131,64130,64132,64130],'vol':[1]*10})
print(df1)
date time last vol
0 20191121 100000 64131 1
1 20191121 100000 64131 1
2 20191121 100000 64130 1
3 20191121 100000 64130 1
4 20191121 100000 64130 1
5 20191121 100000 64131 1
6 20191121 100000 64131 1
7 20191121 100000 64132 1
8 20191121 100000 64130 1
9 20191121 100000 64130 1
我想要这样的数据框:
df2=pd.DataFrame({'date':[20191121]*5,'time':[100000]*5,'vol':[2,3,2,1,2]})
print(df2)
date time last vol
0 20191121 100000 64131 2
1 20191121 100000 64130 3
2 20191121 100000 64131 2
3 20191121 100000 64132 1
4 20191121 100000 64130 2
您能帮我解决这个问题吗?