Skip to content
Related Articles

Related Articles

Improve Article

Get Seconds from timestamp in Python-Pandas

  • Last Updated : 28 Jul, 2021

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: 
 

 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. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course

seconds
1
4
5
6
7

Example 1 : 
 



Python3




# 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'))
 
# converting 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)

Output : 
 

Example 2 : 
 

Python3




# 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'))
 
# converting 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)

Output : 
 

 




My Personal Notes arrow_drop_up
Recommended Articles
Page :