Guest User

Untitled

a guest
Apr 20th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. comp1 = pd.date_range('1/31/2016', periods=8, freq='3M')
  2. comp2 = pd.date_range('1/31/2016', periods=8, freq='Q')
  3. quarters = pd.DataFrame([1] * 8 + [2] * 8, index=comp1.append(comp2), columns=['company'])
  4.  
  5. values = np.transpose([np.arange(1, 25), np.arange(1, 25) * 11])
  6. dates = ['2016-01-14', '2016-02-03', '2016-03-15', '2016-04-04',
  7. '2016-05-30', '2016-06-11', '2016-07-18', '2016-08-08',
  8. '2016-09-09', '2016-10-10', '2016-11-01', '2016-12-24',
  9. '2017-01-30', '2017-02-19', '2017-03-13', '2017-04-24',
  10. '2017-05-31', '2017-06-02', '2017-07-28', '2017-08-23',
  11. '2017-09-04', '2017-10-30', '2017-11-11', '2017-12-06']
  12. df = pd.DataFrame(values, index=pd.DatetimeIndex(dates), columns=['A', 'B'])
  13.  
  14. A B
  15. 2016-01-14 1 11
  16. 2016-02-03 2 22
  17. 2016-03-15 3 33
  18. 2016-04-04 4 44
  19. 2016-05-30 5 55
  20. 2016-06-11 6 66
  21. 2016-07-18 7 77
  22. 2016-08-08 8 88
  23. 2016-09-09 9 99
  24. 2016-10-10 10 110
  25. 2016-11-01 11 121
  26. 2016-12-24 12 132
  27. 2017-01-30 13 143
  28. 2017-02-19 14 154
  29. 2017-03-13 15 165
  30. 2017-04-24 16 176
  31. 2017-05-31 17 187
  32. 2017-06-02 18 198
  33. 2017-07-28 19 209
  34. 2017-08-23 20 220
  35. 2017-09-04 21 231
  36. 2017-10-30 22 242
  37. 2017-11-11 23 253
  38. 2017-12-06 24 264
  39.  
  40. company A B
  41. 2016-01-31 1 1 11
  42. 2016-04-30 1 3 33
  43. 2016-07-31 1 6 66
  44. 2016-10-31 1 9 99
  45. 2017-01-31 1 12 132
  46. 2017-04-30 1 15 165
  47. 2017-07-31 1 18 198
  48. 2017-10-31 1 21 231
  49. 2016-03-31 2 2 22
  50. 2016-06-30 2 5 55
  51. 2016-09-30 2 8 88
  52. 2016-12-31 2 11 121
  53. 2017-03-31 2 14 154
  54. 2017-06-30 2 17 187
  55. 2017-09-30 2 20 220
  56. 2017-12-31 2 23 253
Add Comment
Please, Sign In to add comment