python将csv写入mysql数据库

pip install pandas
pip install mysqlclient

import pandas as pd
import MySQLdb

data = pd.read_csv('data.csv')
df = pd.DataFrame(data)

conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')

cursor = conn.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS table_name (column1 datatype1, column2 datatype2, ...)")

for index, row in df.iterrows():
    cursor.execute("INSERT INTO table_name (column1, column2, ...) VALUES (%s, %s, ...)", tuple(row))
    conn.commit()

cursor.close()
conn.close()