数据库-Mysql

import pymysql
# 必须先安装pymysql
# pip install pymysql

conn=pymysql.connect(
    host="127.0.0.1",
    user="root",
    passwd="root",
    db="test",
    charset="utf8"
)
conn.db

cursor=conn.cursor()
sql='select id,extra_org_name,extra_plate_info,original_type,org_code from nm_query_intell_data limit 10;'
cursor.execute(sql)
conn.commit()

data=cursor.fetchall()
data[:5]

# 拆分数据
position=[];company=[];place=[];salary=[]

for row in data:
    position.append(row[1])
    company.append(row[2])
    place.append(row[3])
    salary.append(row[4])

# 组合数据为矩阵
from pandas import DataFrame

df=DataFrame([position,company,place,salary]).T
df.head()


conn.close() # 关闭数据库连接

image.png
image.png