xuebadb is a python package that allows users to conveniently connect to and query from various database systems using a unified API. Currently, it supports connecting to MySQL and SQL Server database systems. The queries return Pandas dataframes which can then be cleaned up and analysed using one of the modules in the package.
Project description
xuebadb
Travis CI Status:
xuebadb is a python package that allows users to conveniently connect to and query from various database systems using a unified API. Currently, it supports connecting to MySQL and SQL Server database systems. The queries return Pandas dataframes which can then be cleaned up and analysed using one of the modules in the package.
Requirements:
In order to be able to use the package, you would have to install the following:
Python packages:
- pyodbc
- mysql-connector
- pandas
- numpy
- missingno
- matplotlib
Package structure:
xuebadb --> package
-- dbgeneric --> sub-package
-- db_interface --> module
-- mysql_interface -->module
-- odbc_interface --> module
-- dfanalysis --> sub-package
-- cleanup --> module
-- stats --> module
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.