{"library":"qpd","type":"library","category":null,"description":"QPD (Query Pandas Dataframes) is a Python library that allows users to run SQL `SELECT` statements on pandas-like dataframes, including Pandas, Dask, and Ray (via Modin on Ray). It translates SQL directly into dataframe operations, prioritizing correctness and consistent behavior across backends, even handling SQL-specific behaviors like `GROUP BY` with null keys differently than default pandas. The current version is 0.4.4. The library has a sporadic but active release cadence, with multiple minor updates in recent history, primarily focusing on compatibility and bug fixes.","language":"python","status":"active","version":"0.4.4","tags":["pandas","sql","dataframe","dask","ray","fugue"],"install":[{"cmd":"pip install qpd","imports":["from qpd import run_sql_on_pandas"]},{"cmd":"pip install qpd[all]","imports":[]}],"homepage":null,"github":"http://github.com/goodwanghan/qpd","docs":null,"changelog":null,"pypi":"https://pypi.org/project/qpd/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":11.8,"avg_import_s":1.48,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/qpd/compatibility"},"provenance":{"verified_status":"import_fail","verified_at":"Fri Jul 03","last_verified":"Fri Jul 03","next_check":"Fri Jul 10","install_tag":null}}