python-pandasHow to create dataframe from Mysql table

Usage example

from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://test:test@localhost/test?charset=utf8mb4")

import pandas as pd
df = pd.read_sql('SELECT * FROM phones', engine, 'index')

print(df)

output

      Phone  Price  Color
index                    
0       ip5    204    red
1       ip6    304    red
2       ip8    404   gray
3       sms    405  black
4        xi    305    red