Querying with SQL
Ask a hospital network's questions of a database, in SQL: load the extract into SQLite, join its codes without losing an encounter, count by group with NULL kept, and build each encounter's history with window functions, with answers that agree with pandas.
- You build
- queries.py, then dashboard.py
- Stages
- 3 Build, 1 Catch, 1 Ship
- Time
- About 3 hours
Loading the workspace…
Loading the workspace…