统计pandas df列中子字符串列表的出现次数

import pandas as pd

# 创建示例数据
data = {'col1': ['apple', 'banana', 'orange', 'apple,banana', 'banana,orange']}
df = pd.DataFrame(data)

# 子字符串列表
substrings = ['apple', 'banana']

# 统计子字符串列表在列中的出现次数
counts = {}
for substring in substrings:
    df_subset = df[df['col1'].str.contains(substring)]
    count = df_subset['col1'].str.count(substring).sum()
    counts[substring] = count

# 打印结果
for substring, count in counts.items():
    print(f"子字符串 '{substring}' 出现的次数为: {count}")

子字符串 'apple' 出现的次数为: 2
子字符串 'banana' 出现的次数为: 3