Lesson 11.1 · Pro
Median and percentiles
Find the middle value and other percentiles, overall and per group, and use them as filters.
In this lesson
- percentile_cont for the median
- Per group with GROUP BY
- Use a percentile as a filter
- A percentile per group, joined back
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.