Start your terminal to use beginner mode.
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.
Tesla
Revolut
Accenture
Adobe
Google
LinkedIn
Samsung
Datadog
Wix
Dropbox
Meta
OpenAI
Hulu
Uber
X
DoorDash
Anthropic
Amazon
ActivisionBlizzard
Vercel
Crypto.Com
Zscaler
DeutscheBank
Apple
GoDaddy
GitLab
BMW
PayPal
Snowflake
AMD
Twilio
Atlassian
JPMorgan
NVIDIA
IBM
Databricks
Coinbase
Cisco
Robinhood
Twitter
Microsoft
Palantir
Netflix
VMware
Cloudflare
Stripe
Lyft
Salesforce
GitHub
Bloomberg
Airbnb
Walmart
SAP
HashiCorp
Instacart
Mastercard
Intel
Visa