</>
pythonintermediate

Pandas PeriodIndex for Fiscal Calendars

Use PeriodIndex for fiscal period arithmetic, aggregations, and comparisons beyond datetime.

python
import pandas as pd
import numpy as np

idx = pd.period_range('2024Q1', periods=8, freq='Q')
df = pd.DataFrame({'revenue': np.random.randint(50000, 150000, 8)}, index=idx)

df['yoy_growth'] = df['revenue'].pct_change(4)  # compare same quarter prior year
df['is_h2'] = df.index.month > 6

print(df)
print('Annual total:', df.resample('A')['revenue'].sum())

Use Cases

  • fiscal reporting
  • quarterly analytics
  • period comparisons

Tags

#pandas#period#fiscal#time-series

Related Snippets

Similar patterns you can reuse in the same workflow.

pythonintermediate

Pandas Time Series Analysis

Time series operations with resampling, rolling windows, date offsets, and period conversions.

Best for: Sales trend analysis with moving averages

#pandas#time-series
pythonintermediate

Pandas Rolling & Expanding Windows

Compute moving averages, rolling sums, and cumulative stats on time-series data with pandas.

Best for: sales forecasting

#pandas#time-series
pythonbeginner

Pandas Time-Series Resampling

Resample time-series data from daily to weekly/monthly frequencies with aggregation functions.

Best for: time-series analytics

#pandas#time-series
pythonintermediate

Pandas merge_asof for Time-Based Joins

Perform an as-of join to match events to the most recent reference record within a time window.

Best for: tick data joins

#pandas#merge-asof