Python Pandas - Convert given Timestamp to Period with quarterly frequency


To convert given Timestamp to Period, use the timestamp.to_period() method. Within that, set the frequency using the freq parameter. For quarterly frequency, set freq as Q.

At first, import the required libraries −

import pandas as pd

Create the timestamp object in Pandas

timestamp = pd.Timestamp(2021, 9, 18, 11, 50, 20, 33)

Convert timestamp to Period. We have set the frequency as quarterly using the "freq" parameter with value 'Q'

timestamp.to_period(freq='Q')

Example

Following is the code

import pandas as pd

# set the timestamp object in Pandas
timestamp = pd.Timestamp(2021, 9, 18, 11, 50, 20, 33)

# display the Timestamp
print("Timestamp...\n", timestamp)

# convert timestamp to Period
# we have set the frequency as quarterly using the "freq" parameter with value 'Q'
print("\nTimestamp to Period with quarterly frequency...\n", timestamp.to_period(freq='Q'))

Output

This will produce the following code

Timestamp...
 2021-09-18 11:50:20.000033
Timestamp to Period with quarterly frequency...
 2021Q3

Updated on: 13-Oct-2021

479 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements