3 ms·
Similar tools for running SQL queries over CSVs in Python: - pandas.dataframe.read_csv(), dask.dataframe.read_csv(), dask_cudf.read_csv(); .read_parquet() - D
by westurner 3y ago
Similar tools for running SQL queries over CSVs in Python:
- pandas.dataframe.read_csv(), dask.dataframe.read_csv(), dask_cudf.read_csv(); .read_parquet()
- DuckDB / DuckDB-WASM: https://news.ycombinator.com/item?id=36502107 https://news.ycombinator.com/item?id=36502107 https://github.com/duckdb/duckdb https://github.com/duckdb/duckdb https://github.com/duckdb/duckdb-wasm https://github.com/duckdb/duckdb-wasm
- sqlite-utils > "Running queries directly against CSV or JSON" https://sqlite-utils.datasette.io/en/stable/cli.html#running-queries-directly-against-csv-or-json https://sqlite-utils.datasette.io/en/stable/cli.html#running... and optionally datasette / datasette-lite ?csv= for a GUI: https://github.com/simonw/datasette-lite#loading-csv-data https://github.com/simonw/datasette-lite#loading-csv-data
- PartiallyTyped 3y agoAlso polars and datafusion!
- riku_iki 3y agoand chdb