Python-将datetime列转换为秒

我认为您需要

total_seconds

print (df['col'].dt.total_seconds())

样品：

df = pd.Dataframe({'date1':pd.date_range('2015-01-01', periods=3),        'date2':pd.date_range('2015-01-01 02:00:00', periods=3, freq='23H')})print (df)       date1    date20 2015-01-01 2015-01-01 02:00:001 2015-01-02 2015-01-02 01:00:002 2015-01-03 2015-01-03 00:00:00df['diff'] = df['date2'] - df['date1']df['seconds'] = df['diff'].dt.total_seconds()print (df)       date1    date2     diff  seconds0 2015-01-01 2015-01-01 02:00:00 02:00:00   7200.01 2015-01-02 2015-01-02 01:00:00 01:00:00   3600.02 2015-01-03 2015-01-03 00:00:00 00:00:00      0.0

df['diff'] = df['date2'] - df['date1']df['diff'] = df['diff'].dt.total_seconds()print (df)       date1    date2    diff0 2015-01-01 2015-01-01 02:00:00  7200.01 2015-01-02 2015-01-02 01:00:00  3600.02 2015-01-03 2015-01-03 00:00:00     0.0

如果需要转换为

int

df['diff'] = df['date2'] - df['date1']df['diff'] = df['diff'].dt.total_seconds().astype(int)print (df)       date1    date2  diff0 2015-01-01 2015-01-01 02:00:00  72001 2015-01-02 2015-01-02 01:00:00  36002 2015-01-03 2015-01-03 00:00:00     0