Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.20 KB | None | 0 0
  1. ID Date Item
  2. 22788928 1/1/14 12:00 Stock A
  3. 28388931 1/2/14 14:00 Stock B
  4. 23288957 1/2/14 14:00 Stock C
  5. 28788888 1/2/14 14:00 Stock A
  6. 28788946 1/2/14 14:00 Stock B
  7. 23239020 1/2/14 14:00 Stock C
  8. 28789025 1/2/14 14:00 Stock A
  9. 28783465 1/2/14 14:00 Stock B
  10. 28789089 1/2/14 14:00 Stock C
  11. 28784595 1/2/14 14:00 Stock A
  12. 28788656 1/2/14 14:00 Stock B
  13. 28790573 1/2/14 14:00 Stock C
  14. 28790574 1/2/14 14:00 Stock A
  15. 28790585 1/2/14 14:00 Stock B
  16. 28790586 1/2/14 14:00 Stock C
  17. 28790616 1/2/14 14:00 Stock A
  18. 28790617 1/2/14 14:00 Stock B
  19. 28790628 1/3/14 0:00 Stock C
  20. 28790630 1/3/14 0:00 Stock A
  21. 28790662 1/3/14 0:00 Stock B
  22. 28791947 1/3/14 0:00 Stock C
  23. 28791952 1/3/14 0:00 Stock A
  24. 28789524 1/3/14 0:00 Stock B
  25. 28789625 1/3/14 0:00 Stock C
  26. 28789842 1/3/14 0:00 Stock A
  27. 28789917 1/4/14 0:00 Stock B
  28. 28789975 1/5/14 0:00 Stock C
  29. 28789986 1/6/14 0:00 Stock A
  30. 28790058 1/7/14 0:00 Stock B
  31. 28790060 1/8/14 0:00 Stock B
  32. 28790063 1/9/14 0:00 Stock B
  33. 28790081 1/10/14 0:00 Stock B
  34. 28790085 1/11/14 0:00 Stock B
  35. 28790087 1/12/14 0:00 Stock B
  36. 28790994 1/13/14 0:00 Stock B
  37. 28791020 1/14/14 0:00 Stock A
  38. 28791082 1/15/14 0:00 Stock A
  39. 28791087 1/15/14 0:00 Stock A
  40. 28791096 1/15/14 0:00 Stock A
  41. 28791131 1/18/14 0:00 Stock A
  42. 28791086 1/19/14 0:00 Stock A
  43. 28791092 1/19/14 0:00 Stock A
  44. 28791102 1/19/14 0:00 Stock A
  45. 28791118 1/19/14 0:00 Stock A
  46. 28791140 1/19/14 0:00 Stock A
  47. 28791303 1/19/14 0:00 Stock A
  48. 28790057 1/25/14 0:00 Stock A
  49. 28790086 1/26/14 0:00 Stock A
  50. 28790098 1/27/14 0:00 Stock A
  51. 28789547 1/28/14 0:00 Stock A
  52. 28789216 1/29/14 0:00 Stock A
  53. 28788886 1/30/14 0:00 Stock A
  54. 28788556 1/31/14 0:00 Stock A
  55. 28788226 2/1/14 0:00 Stock A
  56. 28787896 2/2/14 0:00 Stock A
  57. 28787566 2/3/14 0:00 Stock C
  58. 28787236 2/4/14 0:00 Stock C
  59. 28786906 2/5/14 0:00 Stock C
  60. 28786576 2/6/14 0:00 Stock C
  61. 28786246 2/7/14 0:00 Stock C
  62. 28785915 2/8/14 0:00 Stock C
  63. 28785585 2/9/14 0:00 Stock B
  64. 28785255 2/10/14 0:00 Stock B
  65. 28784925 2/11/14 0:00 Stock B
  66. 28784595 2/12/14 0:00 Stock B
  67. 28784265 2/13/14 0:00 Stock A
  68. 28783935 2/13/14 0:00 Stock A
  69. 28783605 2/13/14 0:00 Stock A
  70.  
  71. import pandas as pd
  72. import matplotlib.pyplot as plt
  73. import matplotlib.pylab as pylab
  74. pd.set_option('display.mpl_style', 'default')
  75.  
  76. data = pd.read_csv('.../data.csv',
  77. parse_dates='Date',
  78. infer_datetime_format=True
  79. )
  80.  
  81. item_A = data[data['Item'] == 'Stock A']
  82. count_A = item_A['Date'].value_counts(sort=False)
  83. print count_A
  84. count_A.plot()
  85.  
  86. plt.show()
  87. pylab.show(block=True)
  88.  
  89. 1/28/14 0:00 1
  90. 1/26/14 0:00 1
  91. 1/27/14 0:00 1
  92. 1/14/14 0:00 1
  93. 1/3/14 0:00 3
  94. 2/13/14 0:00 3
  95. 1/25/14 0:00 1
  96. 1/2/14 14:00 5
  97. 1/6/14 0:00 1
  98. 1/15/14 0:00 3
  99. 1/1/14 12:00 1
  100. 1/19/14 0:00 6
  101. 1/30/14 0:00 1
  102. 2/2/14 0:00 1
  103. 1/29/14 0:00 1
  104. 1/18/14 0:00 1
  105. 2/1/14 0:00 1
  106. 1/31/14 0:00 1
  107. dtype: int64
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement