Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. import pandas
  2.  
  3. binwidth = 10
  4. data = pandas.read_csv('sample.csv', sep=' ', names=['time', 'value'], header=None, comment='#')
  5.  
  6. mylist = []
  7.  
  8. for item in data.iterrows():
  9. index = item[1]['time']/binwidth
  10. if len(mylist) <= index:
  11. mylist.append(1)
  12. else:
  13. mylist[index] += 1
  14.  
  15. print mylist # [8, 4, 4]
  16.  
  17. # time value
  18. 1 a
  19. 2 b
  20. 3 c
  21. 4 d
  22. 6 e
  23. 7 f
  24. 8 g
  25. 9 h
  26. 10 i
  27. 12 j
  28. 15 k
  29. 17 l
  30. 21 m
  31. 22 n
  32. 26 o
  33. 29 p
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement