在Python中将CSV空白单元格转换为SQL NULL

import csv
import sqlite3

# 读取CSV文件
with open('data.csv', 'r') as file:
    reader = csv.reader(file, skipinitialspace=True)

    # 连接到SQLite数据库
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()

    # 创建表
    cursor.execute('CREATE TABLE IF NOT EXISTS data (column1 TEXT, column2 TEXT, column3 TEXT)')

    # 读取CSV文件的每一行
    for row in reader:
        # 检查每个单元格是否为空白
        converted_row = [cell if cell != '' else None for cell in row]

        # 插入数据到表中
        cursor.execute('INSERT INTO data VALUES (?, ?, ?)', converted_row)

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