如何使用NaN向MariaDB插入Python值

import pymysql
import numpy as np

# 连接到MariaDB数据库
conn = pymysql.connect(host='localhost', user='user', password='password', db='database_name')
cursor = conn.cursor()

# 创建一个包含NaN值的DataFrame（假设使用pandas）
import pandas as pd
data = {'column1': [1, 2, np.nan], 'column2': [4, np.nan, 6]}
df = pd.DataFrame(data)

# 插入数据到MariaDB
for index, row in df.iterrows():
    # 将NaN转换为NULL
    query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
    values = (row['column1'] if not pd.isna(row['column1']) else None,
              row['column2'] if not pd.isna(row['column2']) else None)
    cursor.execute(query, values)

# 提交事务
conn.commit()

# 关闭连接
cursor.close()
conn.close()