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 :

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

Output :

Example 2 :

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

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

Related Articles