Guest User

Untitled

a guest
Jul 19th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. df.groupby([df.Time.str[0:13], 'Type']).Name.value_counts()
  2. # or
  3. df.groupby([df.Time.str[0:13], 'Type', 'Name']).size()
  4.  
  5. Time Type Name
  6. 2018-04-07 15 COMMUNICATIONS ALARM Device Management IP is Unreachable 141
  7. 2018-04-07 16 COMMUNICATIONS ALARM Device Management IP is Unreachable 64
  8. 2018-04-07 17 COMMUNICATIONS ALARM Device Management IP is Unreachable 6
  9. ...
  10. 2018-04-09 14 COMMUNICATIONS ALARM Device Management IP is Unreachable 8
  11. 2018-04-09 15 COMMUNICATIONS ALARM Device Management IP is Unreachable 11
  12. 2018-04-09 16 COMMUNICATIONS ALARM Device Management IP is Unreachable 5
  13. 2018-04-09 17 QUALITY_OF_SERVICE_ALARM Temperature Absolute High 64
  14. Memory Absolute High 1
Add Comment
Please, Sign In to add comment