pandas read_excel 入库mysql

最新推荐文章于 2022-07-11 15:55:32 发布

miaowu~

最新推荐文章于 2022-07-11 15:55:32 发布

阅读量88

点赞数

本文链接：https://blog.csdn.net/weixin_45143622/article/details/112246663

版权

pandas read_excel

案例

def save_data():
    conn = pymysql.connect(host='localhost', user='root', password='123456', port=3306,db='test')
    cur = conn.cursor()
    insert_sql = f"insert into table (tgt,src) values "
    df = pd.read_excel('冬.xlsx')
    print(df)
    for index, data in df.iterrows():
        # print(data['原文'])
        # print(data['译文'])
        tgt = str(data['译文']).replace("\r\n", "")
        src = str(data['原文']).replace("\r\n", "")

        insert_sql += f"('{tgt}','{src}'),"
    insert_sql = insert_sql[0:-1] + ";"
    try:
        cur.execute(insert_sql)
        conn.commit()
        conn.close()
        print('ok............................')
    except Exception as e:
        print(e, "insert--------------")