Jupyter NoteBook

Source: Dev.to

Jupyter

Here are sample code snippets from my Jupyter Notebook exploration.

Query from CSV file

You can query a CSV file directly using jupysql with the DuckDB engine.

# Install required packages
%pip install jupysql duckdb duckdb-engine

# Load the SQL extension
%load_ext sql

# Connect to DuckDB (in‑memory)
%sql duckdb://

# Execute the query
%%sql
SELECT GolonganRuang,
       AVG(Usia) AS rata_rata_usia,
       COUNT(*) AS jumlah
FROM 'datapeg.csv'
GROUP BY GolonganRuang
ORDER BY rata_rata_usia;