Jupyter Notebook

Source: Dev.to

Jupyter

以下是我在 Jupyter Notebook 中探索时的示例代码片段。

从 CSV 文件查询

您可以使用 jupysql 搭配 DuckDB 引擎直接查询 CSV 文件。

# 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;