Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- jan = pd.date_range(start="1-Jan-2018", end="31-Jan-2018") # could specify any year
- num_repeats = 24
- repeated_jans = jan.repeat(num_repeats)
- total_dates = num_repeats * len(jan) # 24 x 31 = 744
- df = pd.DataFrame(np.random.randint(0, 10, total_dates))
- df['repeated_jans_lalala'] = repeated_jans
- print(df.iloc[[0, 24, 48, 71, 72]]) # multiples of 24...we can see one repeated date
- 0 repeated_jans_lalala
- 0 7 2018-01-01
- 24 4 2018-01-02
- 48 3 2018-01-03
- 71 6 2018-01-03
- 72 3 2018-01-04
- df_error = pd.DataFrame(np.random.randint(0, 10, 743)) # require 744!
- #df_error['repeated_jans'] = repeated_jans # raises ValueError
- jans_fancy = jans.strftime('%d-%B-%y')
- df['fancy_jans'] = jans_fancy
- df.head()
- 0 repeated_jans_lalal fancy_jans
- 0 7 2018-01-01 01-January-18
- 1 2 2018-01-01 01-January-18
- 2 8 2018-01-01 01-January-18
- 3 9 2018-01-01 01-January-18
- 4 7 2018-01-01 01-January-18
Add Comment
Please, Sign In to add comment