Guest User

Untitled

a guest
Apr 26th, 2018
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. +--------+-----+------+-------------+
  2. | Date | ID | Flag | Action Type |
  3. +--------+-----+------+-------------+
  4. | 201712 | 123 | - | Delete |
  5. | 201712 | 456 | + | Add |
  6. | 201712 | 123 | + | Add |
  7. | 201801 | 123 | + | Change |
  8. +--------+-----+------+-------------+
  9.  
  10. +--------+-----+------+--------------+
  11. | Date | ID | Flag | Action Type |
  12. +--------+-----+------+--------------+
  13. | 201712 | 123 | * | Add & Delete |
  14. | 201712 | 456 | + | Add |
  15. | 201801 | 123 | + | Added Chg |
  16. +--------+-----+------+--------------+
  17.  
  18. s=df.groupby(['Date','ID'],as_index=False).agg('&'.join)
  19. s.Flag.str.len().gt(1)
  20. Out[285]:
  21. 0 True
  22. 1 False
  23. 2 False
  24. Name: Flag, dtype: bool
  25. s.loc[s.Flag.str.len().gt(1),'Flag']='*'
  26. s
  27. Out[287]:
  28. Date ID Flag Actiontype
  29. 0 201712 123 * Delete&Add
  30. 1 201712 456 + Add
  31. 2 201801 123 + Change
Add Comment
Please, Sign In to add comment