如何在python中扁平化数据以加载到sql db中。

import sqlite3

def flatten_data(data, parent_key='', sep='_'):
    flattened_data = {}
    for key, value in data.items():
        new_key = parent_key + sep + key if parent_key else key
        if isinstance(value, dict):
            flattened_data.update(flatten_data(value, new_key, sep=sep))
        else:
            flattened_data[new_key] = value
    return flattened_data

# 原始数据
data = {
    'name': 'John',
    'age': 30,
    'address': {
        'street': '123 Main St',
        'city': 'New York',
        'state': 'NY'
    }
}

# 扁平化数据
flattened_data = flatten_data(data)

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

# 创建表
cursor.execute('''CREATE TABLE IF NOT EXISTS flattened_data
                  (key TEXT, value TEXT)''')

# 插入数据
for key, value in flattened_data.items():
    cursor.execute("INSERT INTO flattened_data VALUES (?, ?)", (key, value))

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