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
TCS
X
Accenture
Adobe
Google
LinkedIn
Samsung
Datadog
Wix
Dropbox
Meta
OpenAI
Hulu
Uber
DoorDash
Anthropic
Amazon
ActivisionBlizzard
Vercel
Crypto.Com
Zscaler
DeutscheBank
Apple
GoDaddy
BMW
PayPal
Snowflake
AMD
Twilio
Atlassian
JPMorgan
NVIDIA
IBM
Databricks
Coinbase
Cisco
Robinhood
Twitter
Microsoft
Palantir
Netflix
VMware
Cloudflare
Stripe
Capital One
Splunk
Intel
SAP
GitHub
JaneStreet
Bloomberg
Salesforce
Elastic
CGI
UBS
GitLab
Ubisoft
Slack
Nintendo
EY
Kayak
Lyft
Airbnb
Walmart
Revolut
Visa
Okta
HashiCorp
Instacart
Mastercard