Analyzing Data: What pandas and SQL Taught Me About Taking an Average
summary
Code examples in pandas and SQL show the concrete mistake: taking np.mean()/AVG() over raw rows yields 6.6 apples but aggregating by day yields 11 apples, a twofold error in this example. The walkthrough builds queries and a practical pattern — collapse the data to the analysis granularity, then group — summarized as collapsing key - grouping key = observation key. Demos include the wrong query, the corrected query, and the surprising numeric impact.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 2:20The Problem
- 15:38The Pitfall
- 17:24Why are we doing it
- 18:57Defining a collapsing key
- 19:36Why does it not work
- 20:49What if it doesnt work
- 22:46The big deal
- 24:12Conclusion
