Connect to MySQL with Python 3.x and get Pandas Dataframe

virtualenv -p python3 venv

source venv/bin/activate

pip install mysql-connector-python

from mysql.connector import pooling
import mysql.connector


class MySqlDs(object):

    def __init__(self):
        self.connection_pool = None
        self.db_config = db_credentials //(1)
        self.create_pool()

    def create_pool(self):
        self.connection_pool = mysql.connector.pooling.MySQLConnectionPool(pool_name="pynative_pool",
                                                                        pool_size=4,
                                                                        pool_reset_session=False,
                                                                        **self.db_config)

    def get_connection(self):
        return self.connection_pool.get_connection()

db_credentials = {
    'user': "root",
    'password': 'password',
    'host': 'localhost',
    'database': 'mydatabase',
    'charset': 'utf8'
}

from config.config import db_credentials

import pandas as pd

class mySQlDao(object):

    def __init__(self, sqlDb):
        self.sqlDb = sqlDb
        self.connection = sqlDb.get_connection()

    def __del__(self):
        print("Closing db connection")
        self.connection.close()

    def read_table(self,query):
        if self.connection.is_connected():
            dataframe = pd.read_sql_query(query, self.connection)
            return dataframe

dataSource = MySqlDs()
dbclass = mySQlDao(dataSource)

query = """
            select * from table
            """
data = dbclass.read_table(query)