Data analysis with SQLite and Python, PyCon 2023

On YouTube: Data analysis with SQLite and Python - 2hr45m

• What you’ll need
  • python3 and pip
  • Optional: GitHub Codespaces
• Introduction to SQLite
  • Why SQLite?
  • First steps with Python
  • Creating a table
  • Inserting some data
  • UPDATE and DELETE
  • SQLite column types
  • Transactions
• Exploring data with Datasette
  • Installing Datasette locally
  • Try a database: legislators.db
  • Install some plugins
  • Learning SQL with Datasette
• sqlite-utils
  • Using the command-line tools to clean data
  • Using sqlite-utils as a Python library, to import all the PEPs
  • Enabling full-text search
• Publishing a database to Vercel
  • Other publishing options
• Datasette Lite
  • Loading SQLite, CSV and JSON data
  • Installing plugins
  • Further reading
• Advanced SQL
  • Aggregations
  • Subqueries
  • CTEs
  • JSON
  • Window functions
• Baked Data
  • Niche Museums and TILs
  • Generating a newsletter with an Observable notebook
• More demos and further reading
  • Fun demos
  • SpatiaLite