DataFrame.to_timedelta() to add or subtract date and time parameters in Pandas

Pandas date & time Pandas

This converts arguments to timedelta format ( timedelta64[ns] is a dtype in Pandas ). We will use this for addition of different date and time components.

Options

arg: the data to be converted.
unit: default is ns, possible values are 'Y','M','W','D',days, day,hours, hour, minute, sec, milliseconds,millis, micro, microseconds, ns, nanoseconds,nano,nanoseconds
errors:Default value is 'raise'. We can set it to errors='ignore'. If we set to coerce errors='coerce' then invalid parsing will be set as NaT.

We will use present date and time and to it we will add different components. We used to_datetime() to get present date time.

Adding 10 days to today

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(10,unit='days')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:35:44.877832
Future Date and time :  2020-04-23 13:35:44.877832

Adding 4 months to today

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(4,unit='M')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:48:30.168673
Future Date and time :  2020-08-13 07:44:54.168673

Adding 4 years to today

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(4,unit='Y')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:50:29.531906
Future Date and time :  2024-04-13 13:07:17.531906

Adding 2 weeks to today

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(2,unit='W')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:50:55.697808
Future Date and time :  2020-04-27 13:50:55.697808

Adding 2 hours to current time

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(2,unit='H')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:51:58.302150
Future Date and time :  2020-04-13 15:51:58.302150

Adding 10 minutes to present time

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(10,unit='minutes')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:52:47.943290
Future Date and time :  2020-04-13 14:02:47.943290

Adding 10 seconds to present time

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(10,unit='seconds')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:53:34.288719
Future Date and time :  2020-04-13 13:53:44.288719

adding 100 milli seconds to present time

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(100,unit='millis')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:54:26.743903
Future Date and time :  2020-04-13 13:54:26.843903

adding 100 micro seconds to present time

import pandas as pd 
present_day=pd.to_datetime('now') # current day 
future_day=present_day + pd.to_timedelta(100,unit='micros')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-04-13 13:55:07.402857
Future Date and time :  2020-04-13 13:55:07.402957

With any datetime

In above code we have used current date and time and applied timedelta to it. We can also use any date and time to in our future date time calculation. We are using to_datetime() to create datetime

import pandas as pd
present_day=pd.to_datetime('12252020:233445',format='%m%d%Y:%H%M%S')
future_day=present_day + pd.to_timedelta(5,unit='Y')
print("Present Date and time :", present_day)
print("Future Date and time : ",future_day)

Output

Present Date and time : 2020-12-25 23:34:45
Future Date and time :  2025-12-26 04:40:45

Adding day hour minute and secondary

import pandas as pd 
dt_delta=pd.to_timedelta('1 days 5 hours 22 minute 34.006 second')
print(dt_delta)
dt_bd=pd.to_datetime('2001-11-27 16:20:05')
print(dt_bd + dt_delta)

Output

1 days 05:22:34.006000
2001-11-28 21:42:39.006000

td = pd.Series([pd.Timedelta(days=i) for i in range(6)]) 
print(td)
print(td.dtypes)

Output

0   0 days
1   1 days
2   2 days
3   3 days
4   4 days
5   5 days
dtype: timedelta64[ns]
timedelta64[ns]

Pandas date & time date_range() period_range() to_excel()

Pandas Python & MySQL Python- Tutorials

Subscribe to our YouTube Channel here