我有如下元素列表:
A= ['loans','s-class','veyron','trump','rihana','drake','election']
我还有另一个熊猫数据框B,它的列类别和单词是逗号分隔的字符串,如:-
category words
audi a4, a6
bugatti veyron, chiron
mercedez s-class, e-class
dslr canon, nikon
apple iphone,macbook,ipod
finance sales,loans,sales price
politics trump, election, votes
entertainment spiderman,thor, ironmen
music beiber, rihana,drake
........ ..............
......... .........
我只想用列词映射列表A的元素并将相应的类别分配到新列表中,因此预期的输出将是.
matched_categories=['finance','mercedez','bugatti','politics','music','music','politics']