Lesson 10.3 · Pro
Window frames: moving averages
Choose exactly which rows a window adds up, like "the last 7 days" or "the 6 days before today".
In this lesson
- ROWS BETWEEN n PRECEDING AND CURRENT ROW
- Leave out the current row
- The default frame and ties
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.