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.