Python:拆分列后计算列的和

import pandas as pd

data = {'A': ['a,b,c', 'd,e,f', 'g,h,i'],
        'B': [1, 2, 3]}
df = pd.DataFrame(data)

df['A'] = df['A'].str.split(',')

df = df.explode('A')

result = df.groupby('A')['B'].sum()

print(result)

import pandas as pd

data = {'A': ['a,b,c', 'd,e,f', 'g,h,i'],
        'B': [1, 2, 3]}
df = pd.DataFrame(data)

df['A'] = df['A'].str.split(',')
df = df.explode('A')
result = df.groupby('A')['B'].sum()

print(result)