Pyspark :如何根据另一列中的匹配值从数组中的第一个匹配值开始挑选值，直到最后一个值

from pyspark.sql import SparkSession
from pyspark.sql.functions import expr

# 创建SparkSession
spark = SparkSession.builder.getOrCreate()

# 创建示例数据
data = [("A", ["apple", "banana", "cherry"]),
        ("B", ["orange", "banana", "apple"]),
        ("C", ["cherry", "apple", "banana"])]

df = spark.createDataFrame(data, ["column1", "column2"])

# 使用expr函数和数组索引来选择值
df = df.withColumn("selected_value", expr("column1[column2[0]:column2[size(column2)-1]]"))

# 显示结果
df.show(truncate=False)