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()