在dataframe列值/字符串中搜索和统计单词出现次数

import pandas as pd

# 假设dataframe为df，列名为'column_name'
df['column_name'] = df['column_name'].astype(str)

# 定义目标单词
target_word = 'word'

# 初始化单词计数字典
word_count = {}

# 遍历每个字符串
for string in df['column_name']:
    # 将字符串拆分为单词列表
    words = string.split(' ')
    
    # 遍历每个单词
    for word in words:
        # 判断单词是否包含目标单词
        if target_word in word:
            # 统计单词出现次数
            if word in word_count:
                word_count[word] += 1
            else:
                word_count[word] = 1

# 打印单词计数结果
for word, count in word_count.items():
    print(f"单词 '{word}' 出现次数: {count}")