Data analysis with SQLite and Python for PyCon 2023

I'm at PyCon 2023 in Salt Lake City this week.

Yesterday afternoon I presented a three hour tutorial on Data Analysis with SQLite and Python. I think it went well!

I covered basics of using SQLite in Python through the sqlite3 module in the standard library, and then expanded that to demonstrate sqlite-utils, Datasette and even spent a bit of time on Datasette Lite.

One of the things I learned from the Carpentries teacher training a while ago …

analysis basics city data data analysis datasette datasettelite hour lake library pycon python speaking sqlite sqliteutils standard think through training tutorial workshop