Day 14 of 14 45 minCleanAnalysePresent
Put the whole course together. Take a raw export from a chain of coffee shops, inspect and clean it, answer real business questions about revenue, products, busy times and customers, chart the results, and write up what you found.
By the end of today you can
- Inspect a raw dataset and list its problems before changing anything
- Write a repeatable cleaning step and check the result
- Answer business questions with groupby, pivot_table, resample and pct_change
- Summarise findings in a small dashboard of charts
- Write up results clearly, including what you assumed and what you couldn't answer
What's inside
- 4 sections
- 2 diagrams and mind maps
- 8 code examples you can run
- 5-question quiz
- 11. Inspect the raw data
- 22. Clean, then check
- 33. Analyse
- 44. Present
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free