Python Pandas - Get the Total seconds in the duration from the Timedelta object

To get the total seconds in the duration from a Timedelta object, use the total_seconds() method. This converts the entire duration into seconds as a float value.

Creating a Timedelta Object

First, let's create a Timedelta object with various time components ?

import pandas as pd

# Create a Timedelta object with multiple time units
timedelta = pd.Timedelta('2 days 11 hours 22 min 25 s 50 ms 45 ns')
print("Timedelta:", timedelta)

Timedelta: 2 days 11:22:25.050000045

Getting Total Seconds

Use the total_seconds() method to convert the entire duration to seconds ?

import pandas as pd

# Create a Timedelta object
timedelta = pd.Timedelta('2 days 11 hours 22 min 25 s 50 ms 45 ns')

# Get the total seconds in the duration
total_seconds = timedelta.total_seconds()
print(f"Total seconds: {total_seconds}")

Total seconds: 213745.05

Breaking Down the Calculation

Let's understand how the total seconds are calculated ?

import pandas as pd

# Create a simple Timedelta
td = pd.Timedelta(days=2, hours=11, minutes=22, seconds=25, milliseconds=50)
print(f"Timedelta: {td}")

# Manual calculation
manual_seconds = (2 * 24 * 3600) + (11 * 3600) + (22 * 60) + 25 + (50 / 1000)
print(f"Manual calculation: {manual_seconds}")

# Using total_seconds() method
method_seconds = td.total_seconds()
print(f"Using total_seconds(): {method_seconds}")

Timedelta: 2 days 11:22:25.050000
Manual calculation: 213745.05
Using total_seconds(): 213745.05

Working with Different Time Units

The method works with various Timedelta formats ?

import pandas as pd

# Different ways to create Timedeltas
td1 = pd.Timedelta('1 day')
td2 = pd.Timedelta(hours=5)
td3 = pd.Timedelta(minutes=30, seconds=45)

print(f"1 day = {td1.total_seconds()} seconds")
print(f"5 hours = {td2.total_seconds()} seconds")
print(f"30 min 45 sec = {td3.total_seconds()} seconds")

1 day = 86400.0 seconds
5 hours = 18000.0 seconds
30 min 45 sec = 1845.0 seconds

Conclusion

The total_seconds() method converts any Timedelta object to its equivalent duration in seconds as a float. This is useful for time calculations and comparisons across different time units.