How to add date column in python pandas dataframe
You can use the built-in date_range function from pandas library to generate dates and then add them to your dataframe. You can use it in the following way:
In [9]: import pandas as pd

In [10]: df = pd.DataFrame({'column1':[34,54,32,23,26]})

In [11]: df
Out[11]: 
   column1
0       34
1       54
2       32
3       23
4       26

In [12]: df['date'] = pd.date_range(start='1/1/1979', periods=len(df), freq='D')

In [13]: df
Out[13]: 
   column1       date
0       34 1979-01-01
1       54 1979-01-02
2       32 1979-01-03
3       23 1979-01-04
4       26 1979-01-05

Here I have incremented the dates day-wise per row. If you want to generate dates in some other way, check out the official documentation here.