Python Pandas - Get the month number of the period from the PeriodIndex object


To get the month number of the period from the PeriodIndex object, use the PeriodIndex.month property.

At first, import the required libraries −

import pandas as pd

Create a PeriodIndex object −

periodIndex = pd.PeriodIndex(['2021-09-25 07:30:35', '2019-10-30 04:15:45',
'2021-07-15 02:55:15', '2022-06-25 09:40:55'], freq="T")

Display PeriodIndex frequency −

print("\nPeriodIndex frequency object...\n", periodIndex.freq)

Display month number from the PeriodIndex object. The month id displayed as January=1, February=2 ... December=12 −

print("\nThe month number from the PeriodIndex object...\n", periodIndex.month)

Example

Following is the code −

import pandas as pd

# Create a PeriodIndex object
# PeriodIndex is an immutable ndarray holding ordinal values indicating regular periods in time
# We have set the frequency using the "freq" parameter
periodIndex = pd.PeriodIndex(['2021-09-25 07:30:35', '2019-10-30 04:15:45',
'2021-07-15 02:55:15', '2022-06-25 09:40:55'], freq="T")

# Display PeriodIndex object
print("PeriodIndex...\n", periodIndex)

# Display PeriodIndex frequency
print("\nPeriodIndex frequency object...\n", periodIndex.freq)

# Display PeriodIndex frequency as string
print("\nPeriodIndex frequency object as a string...\n", periodIndex.freqstr)

# Display month number from the PeriodIndex object
# The month id displayed as January=1, February=2 ... December=12.
print("\nThe month number from the PeriodIndex object...\n", periodIndex.month)

Output

This will produce the following code −

PeriodIndex...
PeriodIndex(['2021-09-25 07:30', '2019-10-30 04:15', '2021-07-15 02:55', '2022-06-25 09:40'],
dtype='period[T]')

PeriodIndex frequency object...
<Minute>

PeriodIndex frequency object as a string...
T

The month number from the PeriodIndex object...
Int64Index([9, 10, 7, 6], dtype='int64')

Updated on: 21-Oct-2021

305 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements