Pyspark:根据其他dataframe动态更新dataframe列位置

from pyspark.sql import SparkSession
from pyspark.sql.functions import col

spark = SparkSession.builder.appName("Column Position Update").getOrCreate()

data = [("Alice", 25, "New York"), ("Bob", 30, "London"), ("Charlie", 35, "Paris")]
df = spark.createDataFrame(data, ["Name", "Age", "City"])
df.show()

+-------+---+-------+
|   Name|Age|   City|
+-------+---+-------+
|  Alice| 25|New York|
|    Bob| 30| London|
|Charlie| 35|  Paris|
+-------+---+-------+

new_column_order = ["City", "Name", "Age"]
new_df = df.select(*new_column_order)
new_df.show()

+-------+-------+---+
|   City|   Name|Age|
+-------+-------+---+
|New York|  Alice| 25|
| London|    Bob| 30|
|  Paris|Charlie| 35|
+-------+-------+---+