Hacker News new | ask | show | jobs
by SQLlover2000 2069 days ago
PandaSQL allows you to do SQL on Pandas dataframes.[0]

[0] https://github.com/yhat/pandasql

1 comments

This library is badly abandoned. I've been looking for a better alternative, but ended up writing my own relatively simple and somewhat inefficient code.

There's some serious potential in combining Pandas and DuckDB[1], which has an ability to efficiently transfer query results into DataFrames.

[1] https://duckdb.org/docs/api/python