Start your terminal to use beginner mode.
Scenario
A company's monthly sales data shows recurring seasonal patterns that need to be removed to analyze the underlying trend and make better forecasts.
Task
Write a Python script at /home/interview/remove_seasonality.py that reads /home/interview/sales_data.csv containing monthly sales data with 12-month seasonality, removes the seasonal effects using seasonal decomposition with an additive model, and saves the deseasonalized values (rounded to 2 decimal places) to /home/interview/deseasonalized_sales.csv.
The deseasonalized values should be calculated as the original sales with the seasonal component removed (trend + residual). Ensure all rows from the input are preserved in the output by handling edge effects appropriately.
Note: pandas and statsmodels are already installed.
Example
Input (sales_data.csv):
date,sales
2023-01-01,45000.00
2023-02-01,48000.00
2023-03-01,52000.00
...
Expected output (deseasonalized_sales.csv):
date,deseasonalized_sales
2023-01-01,50123.45
2023-02-01,50234.67
2023-03-01,50345.89
...
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.
Cloudflare
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
Stripe
Capital One
Splunk
Intel
SAP
Tesla
GitHub
JaneStreet
Bloomberg
Salesforce
Elastic
CGI
UBS
GitLab
Ubisoft
Slack
Nintendo
EY
Kayak
Lyft
Airbnb
Walmart
Revolut
Visa
Okta
HashiCorp
Instacart
Mastercard