在 pandas 中的列元素旁边添加数值

这是我问的问题的进一步部分here https://stackoverflow.com/questions/51574485/match-keywords-in-pandas-column-with-another-list-of-elements?noredirect=1#comment90132834_51574485。所以我决定把它作为另一个问题。

有什么方法可以让我在列中每个匹配列表名称旁边添加相关值matched_list_names。所以相关性值的公式是(number of matched words from list/total number of words in that list)*100为了获得哪个列表名称最相关。因此，对于政治相关性的第一行将是(1/3)*100=30%即政治列表中总共 3 个单词中的 1 个单词与体育相同，这将是(1/3)*100=0.3对于杂项值是100-(sum of total value) i.e (100-(30+30)。所以，输出会是这样的：-

    word_list                                          matched_list_names
['nuclear','election','usa','baseball']            politics 30,sports 30,miscellaneous 40
['football','united','thriller']                   sports 30,movies 30,miscellaneous 40               
['marvels','spiderman','hockey']                   movies 60,sports 30

....................                               .....................
....................                               .....................
....................                               ....................

Use:

movies=['spiderman','marvels','thriller']
sports=['baseball','hockey','football']
politics=['election','china','usa']
d = {'movies':movies, 'sports':sports, 'politics':politics}
d1 = {k: oldk for oldk, oldv in d.items() for k in oldv}

def f(x):
    a = Counter([d1.get(y, 'miscellaneous') for y in x])
    return ', '.join(['{} {}'.format(k, v / sum(a.values())* 100 ) for k, v in a.items()])

df['matched_list_names'] = df['word_list'].apply(f)
print (df)
                            word_list  \
0  [nuclear, election, usa, baseball]   
1        [football, united, thriller]   
2     [marvels, hollywood, spiderman]   

                                  matched_list_names  
0     miscellaneous 25.0, politics 50.0, sports 25.0  
1  sports 33.33333333333333, miscellaneous 33.333...  
2  movies 66.66666666666666, miscellaneous 33.333...