SigmaAnalytics & Tech
C11PythonIntermediateAbout 110 min to complete

Date & Time Handling

Time series operations that turn 'monthly totals' or 'rolling 30-day average' into a single line.

Notebook

About 110 minutes to complete

Enrol to read the notebook and download it to run.

What this module covers

Time series operations that turn 'monthly totals' or 'rolling 30-day average' into a single line.

By the end of it

  • Parse dates reliably, including ambiguous and mixed formats
  • Use the .dt accessor to extract every component
  • Build and exploit a DatetimeIndex for slicing and alignment
  • Resample to any frequency with the right aggregation
  • Handle time zones and daylight saving correctly
  • Compute with Timedelta, business days, and custom offsets
  • Use Period for fiscal and calendar-quarter reporting
  • Build a time series analysis with correct period comparisons