3 ms·
Cool tool! Panda SQL is great for doing SQL on pandas dataframes. https://pypi.org/project/pandasql/ https://pypi.org/project/pandasql/
by beckingz 5y ago
Cool tool!
Panda SQL is great for doing SQL on pandas dataframes.
https://pypi.org/project/pandasql/ https://pypi.org/project/pandasql/
- RobinL 5y agoDuckDB is a newer but much faster alternative that lets you run SQL on csv files (and also directories of parquet files etc.) It's so fast/good that I've actually been using it for a lot of data cleaning and transformation that previously I'd have done in Pandas. https://github.com/duckdb/duckdb https://github.com/duckdb/duckdb