This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Analyst at Bank of America. The fraud detection team wants to monitor unusual spending patterns by tracking a 7-day moving average of daily transaction amounts for each account. By comparing each day's total spending to its recent average, analysts can flag days where spending deviates significantly from the norm. Your task is to aggregate transaction amounts by account and date, then compute the rolling 7-day average.
You are a Data Analyst at Bank of America. The fraud detection team wants to monitor unusual spending patterns by tracking a 7-day moving average of daily transaction amounts for each account. By comparing each day's total spending to its recent average, analysts can flag days where spending deviates significantly from the norm. Your task is to aggregate transaction amounts by account and date, then compute the rolling 7-day average.