Python Pandas - Get the seconds of the period from the PeriodIndex object

To get the seconds of the period from the PeriodIndex object, use the PeriodIndex.second 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="S")

Display PeriodIndex object −

print("PeriodIndex...\n", periodIndex)

Display seconds from the PeriodIndex object −

print("\nThe seconds from the PeriodIndex object...\n", periodIndex.second)

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="S")

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

Output

This will produce the following code −

PeriodIndex...
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'],
dtype='period[S]')

PeriodIndex frequency object...
<Second>

PeriodIndex frequency object as a string...
S

The seconds from the PeriodIndex object...
Int64Index([35, 45, 15, 55], dtype='int64')

AmitDiwan

Updated on: 21-Oct-2021

63 Views

Kickstart Your Career

Get certified by completing the course

Get Started