python MySQL

import pyodbc

import pandas as pd

cn = pyodbc.connect('DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=localhost;DATABASE=my_db;USER=root;PASSWORD=xxxx;OPTION=3;')

SQL = "select * from expense"

df = pd.read_sql(SQL, cn)

cn.close()