- import pandas as pd
- data=[[9,1 ],
- [9,2 ],
- [6,1565 ],
- [6,1570 ],
- [3,1 ],
- [3,2 ],
- [7,7 ],
- [7,356 ],
- [7,381 ],
- [8,1734 ]]
- df1 = pd.DataFrame(data)
- df3=df1.join(df1.groupby(0).max(),0,'inner','l','r')
- df3.columns=[0,1,2,3]
- df3[4]=(df3[3]-df3[2])
- print df3.iloc[:,[0,2,4]].values.tolist()
复制代码 |