[FIXED] Add a column with the hourly difference of the Datetime Index

Issue

I have a Dataframe with a datetimeindex and I need to create a column that contains the difference in time between the rows of the datetimeindex expressed in hours. This is what I have:

Datetime            Numbers
2020-11-27 08:30:00    1
2020-11-27 13:00:00    2
2020-11-27 15:15:00    3
2020-11-27 20:45:00    4
2020-11-28 08:45:00    5
2020-11-28 10:45:00    6
2020-12-01 04:00:00    7
2020-12-01 08:15:00    8
2020-12-01 12:45:00    9
2020-12-01 14:45:00   10
2020-12-01 17:15:00   11
         ...

This is what I need:

Datetime             Numbers   Delta
2020-11-27 08:30:00    1        Nan
2020-11-27 13:00:00    2       4.5
2020-11-27 15:15:00    3       2.25
2020-11-27 20:45:00    4       5.5
2020-11-28 08:45:00    5       12
2020-11-28 10:45:00    6       2
2020-12-01 04:00:00    7       65.25
2020-12-01 08:15:00    8       4.25
2020-12-01 12:45:00    9       4.5
2020-12-01 14:45:00   10       2
2020-12-01 17:15:00   11       2.5
                  ...

The Dataframe has thousands of rows so I can't use a "for" loop. Thanks in advance!

EDIT: I found a solution:

df = df.reset_index()
df['Time'] = df['Datetime'].astype(np.int64) // 10**9
df['Delta'] = df['Time'].diff()/3600
df.drop(columns=['Time'],inplace =True)
df.set_index('Datetime', inplace=True)

Solution

I assume that Datetime is set as index:

df.reset_index(inplace=True)
df['Delta'] = df['Datetime'].diff().dt.total_seconds()/3600
df.set_index('Datetime', inplace=True)

OUTPUT:

                     Numbers  Delta
Datetime                           
2020-11-27 08:30:00        1    NaN
2020-11-27 13:00:00        2   4.50
2020-11-27 15:15:00        3   2.25
2020-11-27 20:45:00        4   5.50
2020-11-28 08:45:00        5  12.00
2020-11-28 10:45:00        6   2.00
2020-12-01 04:00:00        7  65.25
2020-12-01 08:15:00        8   4.25
2020-12-01 12:45:00        9   4.50
2020-12-01 14:45:00       10   2.00
2020-12-01 17:15:00       11   2.50

Answered By - Muhammad Hassan