这看起来不漂亮,但它会得到每个“根”的和,即。
d1 = []; d2 = []
for i in l1:
v1 = i[1].split('_')[0]
v2 = i[0]
d1.append(v1)
d2.append(v2)
d1
#['count', 'count', 'count', 'country', 'country', 'SACC', 'leading', 'SACC']
d2
#[0.14409883378622257, 0.1274820635854658, 0.10362930186446877, 0.017066033814948037, 0.014104260612047153, 0.011414953372550486, 0.010291762087645236, 0.009979426898654558]
df1 = pd.DataFrame({'root':d1, 'value':d2})
df1
# root value
#0 count 0.144099
#1 count 0.127482
#2 count 0.103629
#3 country 0.017066
#4 country 0.014104
#5 SACC 0.011415
#6 leading 0.010292
#7 SACC 0.009979
df1.groupby('root')['value'].sum()
给予,
root
SACC 0.021394
count 0.375210
country 0.031170
leading 0.010292
Name: value, dtype: float64
