Peak Hour Analysis — Solution & ExplanationProblems / Peak Hour Analysis / EditorialApproach

Extract hour: Use EXTRACT(HOUR FROM request_time) in SQL or F.hour() in PySpark.

Count per hour: Group by hour and count requests.

Rank: Use RANK() OVER (ORDER BY request_count DESC) to rank hours by traffic volume.

Filter: Keep only rows where rank <= 5.

Key ConceptCombining time extraction with ranking window functions lets you identify peak periods. RANK() assigns the same rank to tied values, which is more appropriate than ROW_NUMBER() when multiple hours could share the same traffic level.Hints

EXTRACT(HOUR FROM timestamp) or F.hour() gives the hour component (0–23).

Use RANK() instead of ROW_NUMBER() to handle tied counts correctly.

Filter for rank <= 5 after computing the ranking.

Solve Peak Hour Analysis yourself →