How to change days format to total second in pandas data frame?

Question

[

This day format 17 days 00:00:00 To Format in seconds : 1641600.0 please tell the syntax for this pandas dataframe

Answer 1

You can use pd.Timedelta and .view methods:

import numpy as np
import pandas as pd

# Create a sample dataframe
df = pd.DataFrame([{'delta_days':'17 days 00:00:00'}, {'delta_days':'19 days 00:00:00'}])

# Convert to the format of seconds
df['converted_delta_days'] = pd.to_timedelta(df['delta_days']).view(np.int64) / 1e9

	delta_days	converted_delta_days
0	17 days 00:00:00	1468800.0
1	19 days 00:00:00	1641600.0