pandas mariadb
-
[Python] dataframe of pandas returns mysql / Maria DB resultPython/Python For Analytics 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)