GP
Size: a a a
GP
GP
v
v
ЕГ
ЕГ
ЕГ
ЕГ
GP
GP
ЕГ
ЕГ
GP
ЕГ
v
window = Window.partitionBy([col(MEETING_SUBJECT), col(START_DATE)]) \
.orderBy(
col(COMPANY_SUBJECT_COMMON).desc(),
col(PARTICIPANTS_AND_EMPLOYEES_IN_SUBJ).desc(),
col(PARTICIPANTS_IN_EMPLOYEES).desc(),
col(BOOKING_DATE),
)
# Takes only the best match
df = df.withColumn('rank', row_number().over(window)).filter(col('rank') == 1).drop('rank')
ЕГ
ЕГ
ЕГ
ЕГ