python实现读取excel文件写入MySQL

import os

import numpy as np
import pandas as pd
import pymysql


cnx = pymysql.connect(
    host='localhost',
    user='root',
    password='',
    database='')
i = 1
output_folder = 'D:\\yunwei\\pdm_insert\\distinct_columns\\part\\'
cursor = cnx.cursor()
for file_name in os.listdir(output_folder):
    print(file_name+f" {i} ")
    i = i+1
    columns_to_insert = ['sys_id', 'table_hive_name', 'column_name', 'column_name_cn', 'is_keyword', 'is_null']
    df = pd.read_excel(output_folder+file_name, names=columns_to_insert, skipfooter=0)
    df = df.replace({np.nan: None})

    for row in df.itertuples(index=False):
        insert_query = """ INSERT INTO t_svn_columns (sys_id, table_hive_name, column_name, column_name_cn,is_keyword,is_null) VALUES
        (%s, %s, %s, %s, %s, %s) """
        cursor.execute(insert_query, row)

cnx.commit()
cursor.close()
cnx.close()