logo

Pandas | How to create date index in Pandas

Python Numpy arange 

import pandas as pd
import numpy as np

dates = pd.date_range("20200110", periods=10)
print(dates)

""" Output
DatetimeIndex(['2020-01-10', '2020-01-11', '2020-01-12', '2020-01-13',
               '2020-01-14', '2020-01-15', '2020-01-16', '2020-01-17',
               '2020-01-18', '2020-01-19'],
              dtype='datetime64[ns]', freq='D')
"""

df = pd.DataFrame(np.arange(10), index=dates,columns=["A"])
print(df)
"""Output
            A
2020-01-10  0
2020-01-11  1
2020-01-12  2
2020-01-13  3
2020-01-14  4
2020-01-15  5
2020-01-16  6
2020-01-17  7
2020-01-18  8
2020-01-19  9
"""
Follow US on Twitter: