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

PythonServer Side ProgrammingProgramming

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("
PeriodIndex frequency object...
", periodIndex.freq)

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

print("
The month number from the PeriodIndex object...
", 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...
", periodIndex) # Display PeriodIndex frequency print("
PeriodIndex frequency object...
", periodIndex.freq) # Display PeriodIndex frequency as string print("
PeriodIndex frequency object as a string...
", periodIndex.freqstr) # Display month number from the PeriodIndex object # The month id displayed as January=1, February=2 ... December=12. print("
The month number from the PeriodIndex object...
", 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')
raja
Updated on 21-Oct-2021 06:07:45

Advertisements