pymysql数据库表格转为二维数组

首先看有哪些数据，从数据库中的表格查看：

def shuju():
    con=pymysql.connect(host='localhost',user='root',passwd='123456',charset='utf8',database='shuju')
    cur=con.cursor()
    cur.execute('select * from test')
    a=cur.fetchall()
    return a
if __name__=="__main__":
    a=shuju()

接着看数据类型，字符，数字或者时间。

def leixing():
    con=pymysql.connect(host='localhost',user='root',passwd='123456',charset='utf8',database='shuju')
    cur=con.cursor()
    cur.execute('desc test')
    b=cur.fetchall()
    jiegou=[]
    for i in range(len(b)):
        i=b[i][0]
        jiegou.append(i)
    return jiegou
if __name__=="__main__":
    b=leixing()

 

 数据库表格转为二维数组

import pymysql
import pandas as pd
def shuju():
    con=pymysql.connect(host='localhost',user='root',passwd='123456',charset='utf8',database='shuju')
    cur=con.cursor()
    cur.execute('select * from test')
    a=cur.fetchall()
    return a
def leixing():
    con=pymysql.connect(host='localhost',user='root',passwd='123456',charset='utf8',database='shuju')
    cur=con.cursor()
    cur.execute('desc test')
    b=cur.fetchall()
    jiegou=[]
    for i in range(len(b)):
        i=b[i][0]
        jiegou.append(i)
    return jiegou
def shuzu():
    a=shuju()
    b=leixing()
    c=pd.DataFrame(a,columns=b)
    return c
if __name__=="__main__":
    df=shuzu()