Moving Average — Solution & ExplanationProblems / Moving Average / EditorialApproachA moving average smooths data by averaging over a sliding window of rows.

Window frame: ROWS BETWEEN 2 PRECEDING AND CURRENT ROW includes up to 3 rows.

Partial windows: At the partition start, fewer than 3 rows are available. AVG correctly averages only the available rows.

ROUND: Round to 2 decimal places for clean output.

This pattern is common in time-series analysis for smoothing noise in sensor data, financial prices, or metrics.Hints

Use ROWS BETWEEN 2 PRECEDING AND CURRENT ROW to define a 3-row window.

AVG over this frame automatically handles partial windows at the start.

In PySpark, use rowsBetween(-2, Window.currentRow).

Solve Moving Average yourself →