pythonでpandasがデータベースを読み込む

1534 ワード

# -*- coding: utf-8 -*-     import pandas as pd import pymysql     ## , dbconn = pymysql.connect(    host = "**********" ,    database = "kimbo" ,    user = "kimbo_test" ,    password = "******" ,    port = 3306 ,    charset = 'utf8'   )     #sql sqlcmd = "select col_name,col_type,col_desc from itf_datadic_dtl_d limit 10"     # pandas mysql a = pd.read_sql(sqlcmd,dbconn) # 5 b = a.head() print (b)             # csv # pd.read_csv()     # excel #pd.read_excel()     # txt #pd.read_table()