I have a dataframe. A column contains timestamps. I would like to remove dates and convert the time to seconds.
First I converted them to datetime:
In:
df_time = pd.to_datetime(df["Timestamp"])
Out:
0 2017-11-07 13:09:00
1 2017-11-07 13:11:00
2 2017-11-07 13:13:00
3 2017-11-07 13:15:00
dtype: datetime64[ns]
Then I removed dates:
In:
df_time = pd.Series([val.time() for val in df_time])
Out:
0 13:09:00
1 13:11:00
2 13:13:00
3 13:15:00
4 13:17:00
dtype: object
But they became objects and I did not managed to convert them to datetime-like objects to convert them into seconds. I know there are some similar threads I went trhough them.
I thank your help in advance.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…