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;