使用
str.extract+
insert：
pat = "|".join(df_search.SEARCH)df_all.insert(0, 'SEARCH', df_all['FILE'].str.extract("(" + pat + ')', expand=False))print (df_all) SEARCHFILE EXTENSION PATH0 part1 part1_1 .prt //server/folder1/part1_11 part1 part1_2 .prt //server/folder2/part1_22 part1 part1_2 .pdf //server/folder3/part1_23 part1 part1_3 .prt //server/folder2/part1_34 anotherpart anotherpart_1 .prt //server/folder1/anotherpart_15 anotherpart anotherpart_2 .prt //server/folder3/anotherpart_26 anotherpart anotherpart_3 .prt //server/folder2/anotherpart_37 anotherpart anotherpart_3 .cgm //server/folder1/anotherpart_38 anotherpart anotherpart_4 .prt //server/folder3/anotherpart_49 onemorepart onemorepart_1 .prt //server/folder2/onemorepart_110 onemorepart onemorepart_2 .prt //server/folder1/onemorepart_211 onemorepart onemorepart_2 .dwg //server/folder2/onemorepart_212 onemorepart onemorepart_3 .prt //server/folder1/onemorepart_313 onemorepart onemorepart_4 .prt //server/folder1/onemorepart_4
