I am trying to merge a dataframe with list values. dates dataframe is created like this:
df['date'] = df['Date_time'].dt.strftime('%m/%d/%Y')
idx = pd.date_range(df.Date_time.min(),df.Date_time.max())
dates = pd.DataFrame(idx)
dates.columns = ['date']
dates['date'] = dates['date'].dt.strftime('%m/%d/%Y')
dates
The dates dataframe looks like this:
date
0 09/17/2020
1 09/18/2020
2 09/19/2020
I would like to add a new column for the list: test = ['ST-1', 'ST-2', 'ST-3']. So that it creates a new row date for each unique value in the list. Like so:
date test
0 09/17/2020 ST-1
1 09/17/2020 ST-2
2 09/17/2020 ST-3
0 09/18/2020 ST-1
1 09/18/2020 ST-2
2 09/18/2020 ST-3
0 09/19/2020 ST-1
1 09/19/2020 ST-2
2 09/19/2020 ST-3
Anyone have an idea how to merge the two and create the dataframe shown above?
