Python/Python For Analytics

[Python] dataframe of pandas returns mysql / Maria DB result

Pydole 2019. 8. 8. 10:20

mysql / maria DB 쿼리의 결과를 pandas의 dataframe으로 만들기

import pymysql 
import pandas as pd 


db = pymysql.connect( 
    host=' ', 
    port= , 
    user=' ', 
    password=' ', 
    db=' ', 
    charset='utf8' 
) 

SQL = "select * from table" 
df = pd.read_sql(SQL,db) 
print(df)