The pdsql package contains convenience functions for adding, manipulating, and changing data in SQL servers with a emphasis on Pandas DataFrames for the handling of data in Python.

At the moment, the only supported SQL system is MSSQL, but other SQL systems can/will be added in the future through the better implementation of Sqlalchemy. Priority will be given to PostgreSQL and SQLite/Spatialite.

installation

pdsql can be installed via pip or conda:

pip install pdsql

or:

conda install -c mullenkamp pdsql

The core dependency is Pandas and pyodbc.

Recommended articles: