自动将csv文件传输到MySQL

pip install pandas mysql-connector-python

import pandas as pd
import mysql.connector

# 读取csv文件
csv_file = 'your_csv_file.csv'
data = pd.read_csv(csv_file)

# 连接到MySQL数据库
db_config = {
    'host': 'your_host',
    'user': 'your_user',
    'password': 'your_password',
    'database': 'your_database'
}

conn = mysql.connector.connect(**db_config)
cursor = conn.cursor()

# 将数据插入到MySQL数据库
for index, row in data.iterrows():
    columns = ', '.join(row.index)
    values = ', '.join(['%s'] * len(row))
    sql = f"INSERT INTO your_table ({columns}) VALUES ({values})"
    cursor.execute(sql, list(row))

# 提交更改并关闭连接
conn.commit()
cursor.close()
conn.close()