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

Microsoft ODBC Driver 17

Package structure:

xuebadb --> package
  -- dbgeneric --> sub-package
    -- db_interface --> module
    -- mysql_interface -->module
    -- odbc_interface --> module
  -- dfanalysis --> sub-package
    -- cleanup --> module
    -- stats --> module