DataFrame.join(right, on=None, how='left', lsuffix='', rsuffix='')[source]

codes = ["80751681", "80850454", "80756979"]
codes_list = "|".join(codes) 
df_final = df_final.filter(F.col("marc.matnr").rlike(codes_list))