Generating a random series

generate_random_series.py

from random import randint
import pandas as pd

num_observations = 500
dates = pd.to_datetime([f"{randint(2018, 2020)}-{randint(1, 12)}-{randint(1, 27)}" 
                        for _ in range(num_observations)]).unique()
df = pd.DataFrame({"date": dates, 
                   "balance": [randint(0, 10000) 
                               for _ in range(len(dates))]
                  })

df = df.set_index("date").resample("H").ffill().reset_index()
print(f"Resampling has expanded our df from {len(dates)} rows to {len(df)}!")