Course contentsShow
← Machine Learning and Deep Learning
Lesson 175 of 3,5382. Machine Learning Mindset and Core ConceptsFree lesson

Time Series Data in Pandas

Work with datetime indices, resampling, and rolling windows for temporal ML features.

Time Series Data in Pandas

You'll learn: How to handle temporal data in Pandas using datetime indices, resampling, and rolling windows to create powerful time-based ML features.

Why Time Matters in ML

Time series data—measurements recorded at different points in time—is everywhere in machine learning: stock prices, sensor readings, user activity logs, weather forecasts. Pandas provides specialized tools to handle temporal patterns that regular tabular operations can't capture.

Datetime Indices: Labeling Time

Think of a datetime index like timestamps on a video timeline. Instead of generic row numbers (0, 1, 2...), each row is labeled with its exact moment in time. This lets Pandas understand temporal relationships between observations.

When your DataFrame has a datetime index, you can slice by date ranges, align data from different sources by timestamp, and apply time-aware operations that would be tedious with plain integers.

Resampling: Changing Time Granularity

Resampling adjusts your data's time resolution—like zooming in or out on that video timeline. You might have hourly sensor readings but need daily averages for your ML model, or daily sales figures that you want to aggregate monthly. Resampling groups data by time periods and applies aggregation functions (mean, sum, max, etc.).

Rolling Windows: Capturing Local Trends

A rolling window slides across your time series like a moving spotlight, calculating statistics over a fixed number of recent observations. For example, a 7-day rolling average smooths out daily noise to reveal underlying trends. These become valuable ML features that capture momentum, volatility, or seasonal patterns.

Rolling operations turn raw temporal data into features that help models learn "What happened recently matters for what happens next."

Key Takeaway: Datetime indices, resampling, and rolling windows transform raw time-stamped data into structured features that ML models can use to learn temporal patterns and make time-aware predictions.