将df表格写入mysql数据库

import pandas as pd
import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(
    host='localhost',
    user='your_username',
    password='your_password',
    database='your_database'
)

# 创建数据表（如果还没有）
create_table_query = '''
    CREATE TABLE IF NOT EXISTS your_table (
        column1 VARCHAR(255),
        column2 INT,
        ...
    )
'''
cursor = cnx.cursor()
cursor.execute(create_table_query)
cnx.commit()

# 转换df表格数据（假设df表格有两列，列名分别为column1和column2）
df['column1'] = df['column1'].astype(str)
df['column2'] = df['column2'].astype(int)

# 写入数据
insert_query = '''
    INSERT INTO your_table (column1, column2)
    VALUES (%s, %s)
'''
for index, row in df.iterrows():
    data = (row['column1'], row['column2'])
    cursor.execute(insert_query, data)
cnx.commit()

# 关闭数据库连接
cursor.close()
cnx.close()