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)