yhat/pandasql
sqldf for pandas observed · 2026-08-28
Health v2 · maintenance only
10/100
- Activity 0
- Release rhythm 35
- Longevity 100
Flags: no_releases archived
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 4945
- days_rel: n/a
- days_push: 770
- n_releases_24m: 0
Adoption not part of the score
1348 stars · 184 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
pandasql is a Python library that lets you query pandas DataFrames using SQL syntax, similar to sqldf in R. It translates SQL queries (SQLite dialect) against in-memory DataFrames so users can manipulate and clean data with familiar SQL.
Use cases
- query pandas dataframes with sql
- run sql joins on dataframes
- aggregate dataframe data with group by in sql
- clean data using sql instead of pandas api
- use sqldf in python
- filter dataframes with sql select statements
When to choose
- you know SQL better than the pandas API
- you want quick ad-hoc SQL queries against DataFrames in notebooks
- you need joins or aggregations expressed in SQLite syntax
When to avoid
- you need a database other than SQLite semantics or advanced SQL features
- performance-critical pipelines where native pandas operations are faster
- you need actively developed features or long-term support
Facets
library · maturity maintenance
database data-science parser data-science databases developer-tools python cross-platform pandas sql sqldf dataframes sqlite
2 sources
- readme: https://github.com/yhat/pandasql · fetched 2026-08-28 · 34b73472935f
- registry_pypi: https://pypi.org/pypi/pandasql/json · fetched 2026-08-29 · 09cdb5f96791
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| yhat/pandasql | main | 10 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem