如何使用默认值从PySpark数据帧访问JSON值？

from pyspark.sql import SparkSession

spark = SparkSession.builder \
    .appName("Access JSON values with default") \
    .getOrCreate()

df = spark.read.json("path/to/json/file.json")

{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "New York"
  }
}

from pyspark.sql.functions import col

name = df.select(col("name")).first()[0]
age = df.select(col("age")).first()[0]
street = df.select(col("address").getItem("street")).first()[0]
city = df.select(col("address").getItem("city")).first()[0]
country = df.select(col("address").getItem("country", "USA")).first()[0]

print("Name:", name)
print("Age:", age)
print("Street:", street)
print("City:", city)
print("Country:", country)