import pandas as pd import numpy as np dates = pd.date_range(start='5/28/2020', end='7/29/2020') dates = dates.date # remove h, min, s (just keep dates) data = np.random.randint(5,size=(63, 3)) df = pd.DataFrame(data, index=dates, columns=['Nr1','Nr2','Nr3']) print(df)