获取pandas列字符串中与预定义列表匹配的单词计数

import pandas as pd
import re

data = {'column_name': ['This is a sample string.', 'Another example string.', 'Yet another sample string.']}
df = pd.DataFrame(data)

predefined_list = ['sample', 'string']

def count_matching_words(row):
    words = re.findall(r'\w+', row['column_name'])
    matching_words = [word for word in words if word.lower() in predefined_list]
    return len(matching_words)

df['word_count'] = df.apply(count_matching_words, axis=1)

print(df)

                 column_name  word_count
0    This is a sample string           2
1    Another example string           1
2  Yet another sample string           2