在pyspark中连接两个表，多个条件，左连接？

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

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

# 读取表1的数据并创建DataFrame
df1 = spark.read.format("csv").option("header", "true").load("表1路径.csv")

# 读取表2的数据并创建DataFrame
df2 = spark.read.format("csv").option("header", "true").load("表2路径.csv")

# 定义连接条件
condition = [df1.column1 == df2.column1, df1.column2 == df2.column2]

# 进行左连接
result = df1.join(df2, condition, "left")

# 选择需要的列
selected_columns = ["表1列1", "表1列2", "表2列1", "表2列2"]
result = result.select(selected_columns)

# 展示结果
result.show()