search

RandomFractals / chicago-crimes

Exploring Chicago crimes dataset with Jupyter notebooks, DuckDB, Malloy and new Panel/PyScript data and dashboard tools.
GNU Affero General Public License v3.0
38 stars 4 forks source link

Add Chicago Crimes DuckDB SQL Magic Jupyter notebook example #16

Closed RandomFractals closed 1 year ago

RandomFractals commented 1 year ago

Inspired by this post on using DuckDB with sql magics in Jupyter notebooks, written by @rmoff:

https://rmoff.net/2022/10/14/current-22-session-analysis-with-duckdb-and-jupyter-notebook/

Gist: https://gist.github.com/rmoff/e5cd6e04fc54e592fc4c232863252607

More info about this Jupyter notebook setup from the official duckDB docs:

https://duckdb.org/docs/guides/python/jupyter

RandomFractals commented 1 year ago

Prelim. setup and notebook run results:

chicago-crimes-sqlmagic

RandomFractals commented 1 year ago

see new section in docs: https://github.com/RandomFractals/chicago-crimes#with-duckdb-sqlmagic