如何统计某一列中唯一词出现的频率？

import pandas as pd

# 假设数据存储在一个名为data.csv的文件中，且目标列名为"column_name"
data = pd.read_csv("data.csv")
column_data = data["column_name"]

# 去重得到唯一词集合
unique_words = set(column_data)

# 统计每个唯一词的频率
word_frequency = {}
for word in unique_words:
    frequency = column_data.tolist().count(word)
    word_frequency[word] = frequency

# 打印每个唯一词及其频率
for word, frequency in word_frequency.items():
    print(f"词 '{word}' 出现的频率为: {frequency}")

# 如果需要按照频率进行排序，可以使用以下代码
sorted_word_frequency = sorted(word_frequency.items(), key=lambda x: x[1], reverse=True)
for word, frequency in sorted_word_frequency:
    print(f"词 '{word}' 出现的频率为: {frequency}")