Jupyter NoteBook

Jupyter

Here are sample code of my Jupyter Notebook exploration

- Query from CSV file

Right, you can do a query to csv file, just use jupysql and duckdb engine

# Query using csv file
%pip install jupysql duckdb duckdb-engine
%load_ext sql
%sql duckdb://

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