如何使用pyspark找到每年的汽车车票总数？

from pyspark.sql import SparkSession
from pyspark.sql.functions import year, sum

spark = SparkSession.builder.appName("CarTicketAnalysis").getOrCreate()

car_tickets = spark.read.csv("path/to/car_tickets.csv", header=True, inferSchema=True)

car_tickets = car_tickets.withColumn("Year", year(car_tickets["Date"]))

yearly_ticket_counts = car_tickets.groupBy("Year").agg(sum("TicketCount").alias("TotalTickets"))

yearly_ticket_counts.show()