Guest User

Untitled

a guest
Mar 13th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. mdf = pd.DataFrame([[1,2,50],[1,2,30],[1,5,10],[2,8,80]], columns=['src','dst','n']); mdf
  2.  
  3. src dst n
  4. 0 1 2 50
  5. 1 1 2 30
  6. 2 1 5 10
  7. 3 2 8 80
  8.  
  9. test = mdf.groupby(['src','dst'])['n'].agg(['sum','count']); test
  10.  
  11.  
  12. sum count
  13. src dst
  14. 1 2 80 2
  15. 5 10 1
  16. 2 8 80 1
Add Comment
Please, Sign In to add comment