Pandas: Create a DataFrame with date and time as index

31 July 2020

Code

# Import library
import pandas as pd

# Create DatetimeIndex
index = pd.date_range(start='2020-07-31 11:22:33', end='2020-08-03 09:10:33', freq='D',
                      name='raindate' )

# Create DataFrame
df = pd.DataFrame({
    'temperature': [40, 20, 30], # celcius
    'humidity': [40, 30, 70] # percent
    }, 
    index = index
)
print(df)
print(df.index)

Output

                     temperature  humidity
raindate                                  
2020-07-31 11:22:33           40        40
2020-08-01 11:22:33           20        30
2020-08-02 11:22:33           30        70

DatetimeIndex(['2020-07-31 11:22:33', '2020-08-01 11:22:33',
               '2020-08-02 11:22:33'],
              dtype='datetime64[ns]', name='raindate', freq='D')






Any errors in code above?
Please send a message.