Answers for "pandas create dataframe with date range index"

pandas dataframe set datetime index

df['Datetime'] = pd.to_datetime(df['date'] + ' ' + df['time'])
df = df.set_index('Datetime')

panda get rows with date range

#greater than the start date and smaller than the end date
mask = (df['date'] > start_date) & (df['date'] <= end_date)
df = df.loc[mask]