如何在代码工作簿中将JSON对象列表转换为Spark dataframe？

from pyspark.sql import SparkSession
from pyspark.sql.types import StructType, StructField, StringType

spark = SparkSession.builder.appName("JSON to DataFrame").getOrCreate()

json_data = [
    {"name": "John", "age": 25, "city": "New York"},
    {"name": "Alice", "age": 30, "city": "San Francisco"},
    {"name": "Bob", "age": 35, "city": "Seattle"}
]

json_schema = StructType([
    StructField("name", StringType(), True),
    StructField("age", StringType(), True),
    StructField("city", StringType(), True)
])

df = spark.createDataFrame(json_data, schema=json_schema)

df.show()