Aggregate Time-Series Data into Fixed Time Windows
Beginner Mode

Start your terminal to use beginner mode.

Sign in to watch the walkthrough video

Sign In

Scenario

A sensor generates temperature and humidity readings at irregular intervals. The data needs to be aggregated into fixed 15-minute time windows for analysis.

Task

Write a Python script at /home/interview/aggregate_timeseries.py that reads /home/interview/sensor_data.csv, aggregates the data into 15-minute windows calculating mean, min, and max values for both temperature and humidity, and writes the result to /home/interview/aggregated_data.csv.

Round all numeric values to 2 decimal places.

Note: pandas is already installed.

Example

Expected output format in /home/interview/aggregated_data.csv:

window_start,window_end,temp_mean,temp_min,temp_max,humidity_mean,humidity_min,humidity_max
2026-02-13 10:00:00,2026-02-13 10:15:00,22.5,21.2,23.8,45.3,43.1,47.5
2026-02-13 10:15:00,2026-02-13 10:30:00,23.1,22.0,24.2,46.8,44.2,49.1
...

Terminal requires a larger screen

Open this page on a desktop or tablet (≥ 768px) to launch the terminal and practice hands-on.

Linux Terminal Environment

Write and execute your solution in the terminal below.

Sign In

Track

Question Difficulty Company Access
Need more practice in this area? Explore more questions →