Python Pandas - Get the day of the week from the PeriodIndex object


To get the day of the week from the PeriodIndex object, use the PeriodIndex.weekday property.

At first, import the required libraries −

import pandas as pd

Create a PeriodIndex object. PeriodIndex is an immutable ndarray holding ordinal values indicating regular periods in time −

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 day of the week from the PeriodIndex object. The day of the week with Monday=0, Tuesday=1 ... Sunday=6 −

print("\nThe day of week from the PeriodIndex object...\n", periodIndex.weekday)

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 week from the PeriodIndex object
print("\nThe week from the PeriodIndex object...\n", periodIndex.week)

# Display day of the week from the PeriodIndex object
# The day of the week with Monday=0, Tuesday=1 ... Sunday=6
print("\nThe day of week from the PeriodIndex object...\n", periodIndex.weekday)

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 week from the PeriodIndex object...
Int64Index([38, 44, 28, 25], dtype='int64')

The day of week from the PeriodIndex object...
Int64Index([5, 2, 3, 5], dtype='int64')

Updated on: 21-Oct-2021

69 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements