{"library":"pandasql","type":"library","category":null,"description":"Pandasql is a Python library that allows users to query pandas DataFrames using SQL syntax. It functions similarly to `sqldf` in R, leveraging SQLite under the hood to provide a familiar interface for data manipulation and analysis for those comfortable with SQL. It is currently at version 0.7.3 and receives limited updates, with alternatives like DuckDB or Polars SQL often recommended for more active development or performance needs.","language":"python","status":"maintenance","version":"0.7.3","tags":["pandas","sql","dataframe","sqlite","data analysis","query"],"install":[{"cmd":"pip install pandasql","imports":["from pandasql import sqldf"]}],"homepage":null,"github":"https://github.com/yhat/pandasql","docs":null,"changelog":null,"pypi":"https://pypi.org/project/pandasql/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":10.1,"avg_import_s":1.56,"wheel_type":"sdist"},"url":"https://checklist.day/v1/registry/pandasql/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":null}}