用excel工作表中的信息填充Mysql表，包括图像的相对路径

import pandas as pd

df = pd.read_excel('path/to/excel_file.xlsx', sheet_name='Sheet1', header=0)

import pymysql

# 建立与MySQL数据库的连接
connection = pymysql.connect(host='localhost',
                             user='username',
                             password='password',
                             database='database_name',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # 创建表的SQL语句
        create_table_sql = "CREATE TABLE IF NOT EXISTS table_name (column1 datatype, column2 datatype, ...)"
        # 执行创建表的SQL语句
        cursor.execute(create_table_sql)
    # 提交事务
    connection.commit()
finally:
    connection.close()

try:
    with connection.cursor() as cursor:
        for index, row in df.iterrows():
            # 插入数据的SQL语句
            insert_sql = "INSERT INTO table_name (column1, column2, ...) VALUES (%s, %s, ...)"
            # 执行插入数据的SQL语句
            cursor.execute(insert_sql, (row['column1'], row['column2'], ...))
    # 提交事务
    connection.commit()
finally:
    connection.close()

import os

excel_path = 'path/to/excel_file.xlsx'
image_folder = 'path/to/image_folder/'

for index, row in df.iterrows():
    relative_path = row['image_path']
    absolute_path = os.path.join(os.path.dirname(excel_path), relative_path)
    # 在插入数据之前，可以将绝对路径存储到DataFrame中，然后再插入MySQL表
    df.loc[index, 'image_path'] = absolute_path