Lesson 6.5 · Pro
Fill in missing dates
Generate every date in a range so days with no data show up as 0 instead of disappearing.
In this lesson
- Make a list of dates with generate_series
- LEFT JOIN your data onto the dates
- Dates × another list
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.