如何在pyspark dataframe中将一列的字典列表拆分成两列？

from pyspark.sql import SparkSession
from pyspark.sql.functions import col, explode, expr

spark = SparkSession.builder.getOrCreate()

data = [
    (1, [{"key1": "value1", "key2": "value2"}, {"key1": "value3", "key2": "value4"}]),
    (2, [{"key1": "value5", "key2": "value6"}, {"key1": "value7", "key2": "value8"}])
]
df = spark.createDataFrame(data, ["id", "dict_list"])

df_exploded = df.select("id", explode("dict_list").alias("dict"))

df_final = df_exploded.select("id", expr("dict.key1").alias("key1"), expr("dict.key2").alias("key2"))