Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling Average Over Time Window

Medium
MediumSQL & Data ManipulationWindow FunctionsTime Series

Problem

Given a dataset, write an algorithm to find the rolling average of a specific column over a sliding window of time.

Practicing as: Data Scientist interview at Rhombus Power

Hi, I'll play your Rhombus Power interviewer for the Data Scientist role. Candidates describe these interviews as often stressful and moderately difficult, so expect me to be direct and to the point. Take your time with the question above and answer like we're in the room.

Take this as a live interview session →

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Next questions
Rolling Average in Time WindowMediumImpact Recruitment GroupRolling Average with Window FunctionsMediumIndeedRolling Average QueryMedium