Guest User

Untitled

a guest
Sep 22nd, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. jan = pd.date_range(start="1-Jan-2018", end="31-Jan-2018") # could specify any year
  4.  
  5. num_repeats = 24
  6. repeated_jans = jan.repeat(num_repeats)
  7.  
  8. total_dates = num_repeats * len(jan) # 24 x 31 = 744
  9. df = pd.DataFrame(np.random.randint(0, 10, total_dates))
  10.  
  11. df['repeated_jans_lalala'] = repeated_jans
  12.  
  13. print(df.iloc[[0, 24, 48, 71, 72]]) # multiples of 24...we can see one repeated date
  14.  
  15. 0 repeated_jans_lalala
  16. 0 7 2018-01-01
  17. 24 4 2018-01-02
  18. 48 3 2018-01-03
  19. 71 6 2018-01-03
  20. 72 3 2018-01-04
  21.  
  22. df_error = pd.DataFrame(np.random.randint(0, 10, 743)) # require 744!
  23. #df_error['repeated_jans'] = repeated_jans # raises ValueError
  24.  
  25. jans_fancy = jans.strftime('%d-%B-%y')
  26. df['fancy_jans'] = jans_fancy
  27.  
  28. df.head()
  29.  
  30. 0 repeated_jans_lalal fancy_jans
  31. 0 7 2018-01-01 01-January-18
  32. 1 2 2018-01-01 01-January-18
  33. 2 8 2018-01-01 01-January-18
  34. 3 9 2018-01-01 01-January-18
  35. 4 7 2018-01-01 01-January-18
Add Comment
Please, Sign In to add comment