Skip to content
Related Articles

Related Articles

Get Seconds from timestamp in Python-Pandas
  • Last Updated : 18 Aug, 2020

In this program our task is to create a program in python which will extract seconds from a given timestamp. We will use the s attribute of the DataTime object to extract the second.

Example : If we have a data frame that contains 5 different time stamps such as:

Timestamp
2012-12-11 04:12:01
2013-10-13 04:12:04
2014-12-14 04:12:05
2015-11-15 04:12:06
2016-10-15 04:12:07

And our task is to extract that seconds from given timestamps. So the output here will be:

seconds
1
4
5
6
7

Example 1 :

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# generating 10 timestamp starting from '2016-10-10 09:21:12'
date1 = pd.Series(pd.date_range('2016-10-10 09:21:12'
                                periods = 10, freq = 's'))
  
# coverting pandas series into data frame
df = pd.DataFrame(dict(GENERATEDTIMESTAMP = date1))
  
# extracting seconds from time stamp
df['extracted_seconds_timestamp'] = df['GENERATEDTIMESTAMP'].dt.second
  
# displaying  DataFrame
display(df)

chevron_right


Output :



Example 2 :

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# generating 5 timestamp starting from '2020-01-01 00:00:00'
date1 = pd.Series(pd.date_range('2020-01-01 00:00:00'
                                periods = 5, freq = 's'))
  
# coverting pandas series into data frame
df = pd.DataFrame(dict(GENERATEDTIMESTAMP = date1))
  
# extracting seconds from time stamp
df['extracted_seconds_timestamp'] = df['GENERATEDTIMESTAMP'].dt.second
  
# displaying  DataFrame
display(df)

chevron_right


Output :

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :