Tutorials - Simon Willison: Data analysis with SQLite and Python
SQLite is the world's most widely used database and has been a part of the Python standard library since 2006. It continues to evolve and offer more capabilities every year.
This tutorial will transform you into a SQLite power-user. You'll learn to use SQLite with Python, level up your SQL skills and take advantage of libraries such as sqlite-utils and tools such as Datasette to explore and analyze data in all kinds of shapes and sizes.
This hands-on tutorial will cover:
The sqlite3 module in the Python standard library
A review of SQL basics, plus advanced SQL features available in SQLite
Using sqlite-utils for advanced manipulation of SQLite databases
Datasette as a tool for exploring, analyzing and publishing data
Applying the Baked Data architectural pattern to build a data application using Datasette and deploy it to the cloud
This tutorial is aimed at beginner-to-intermediate Python users with some previous exposure to basic SQL.
Attendees will leave this workshop with a powerful new set of tools for productively exploring, analyzing and publishing data.
Auf dieser Seite können Sie das Online-Video Tutorials - Simon Willison: Data analysis with SQLite and Python mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer PyCon US 02 Juni 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 9,527 Mal angesehen und es wurde von 177 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
