# list all special strings and their replacements special_strings = [''', '&', 'sha '] special_string_replacements = ["'", "&", "Shaw "] # replace each special string appearing in title and transcript columns for i in range(len(special_strings)): df = df.with_columns(df['title'].str.replace(special_strings[i], special_string_replacements[i]).alias('title')) df = df.with_columns(df['transcript'].str.replace(special_strings[i], special_string_replacements[i]).alias('transcript'))