Get Minutes from timestamp in Pandas-Python



Get Minutes from timestamp in Pandas-Python

Pandas is an open-source library built for Python language. It offers various data structures and operations for manipulating numerical data and time series.

Here, let’s use some methods provided by pandas to extract the minute’s value from a timestamp.

Method 1: Use of pandas.Timestamp.minute attribute.

This attribute of pandas can be used to extract the minutes from a given timestamp object.

Example1: 
Let’s first create a timestamp object below:

# import pandas library
import pandas as pd 
   
# create a Timestamp object 
time_stamp = pd.Timestamp(2020, 7, 20,
                          12, 41, 32, 15
   
# view the created time_stamp
print(time_stamp)

Output: 

time stamp object

In the above-created timestamp object, the minute’s value is “41”. Let’s extract this value using the Timestamp.minute attribute.

# display the value of minute from
# the created timestamp object
print(time_stamp.minute)

Output: 

minute

Example 2: 

 

Create a timestamp object:

# import pandas library
import pandas as pd 
   
# create a Timestamp object 
time_stamp = pd.Timestamp(2020, 7, 20
   
# view the created time_stamp
print(time_stamp)

Output: 

time stamp object

In the above-created timestamp object, the minute’s value is “0”. Let’s extract this value using the Timestamp.minute attribute.

# display the value of minute from
# the created timestamp object
print(time_stamp.minute)

Output: 

minute

Method 2: Use of Series.dt.minute attribute.

Now, consider the example of a pandas dataframe with one of the columns containing timestamps. In this case, we would first use the Series.dt method to access the values of the series as a DateTime object and then use the minute attribute to extract the minutes from the datetimes object.

 

Example 1: 
First, create a pandas dataframe:

# import pandas library
import pandas as pd 
 
# create a series
sr = pd.Series(['2020-7-20 12:41'
                '2020-7-20 12:42'
               '2020-7-20 12:43',
                '2020-7-20 12:44'])
 
# convert the series to datetime
sr = pd.to_datetime(sr)
 
# create a pandas dataframe with a
# column having timestamps
df = pd.DataFrame(dict(time_stamps = sr))
   
# view the created dataframe
print(df)

Output: 

time stamp object

Extracting the minute from each of the timestamp in the dataframe:

# extract minutes from time stamps and
# add them as a separate column
df['minutes_from_timestamps'] = df['time_stamps'].dt.minute
 
# view the updated dataframe
print(df)

Output: 

minute

Example 2: 

Create a pandas dataframe:

 

# import pandas library
import pandas as pd 
 
# create a series
sr = pd.Series(pd.date_range('2020-7-20 12:41'
                             periods = 5,
                             freq = 'min'))
 
# create a pandas dataframe with a
# column having timestamps
df = pd.DataFrame(dict(time_stamps=sr))
   
# view the created dataframe
print(df)

Output: 

time stamp object

Extracting the minute from each of the timestamp in the dataframe:

# extract minutes from time stamps and
# add them as a separate column
df['minutes_from_timestamps'] = df['time_stamps'].dt.minute
 
# view the updated dataframe
print(df)

Output: 

minute

 

Last Updated on October 21, 2021 by admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Recommended Blogs