python迭代求和_在Python中迭代字典并按类别求和总数

我添加了一个额外的(假)股票，使例子更相关。在stockData = {

'AAPL': {

'beta': 1.01833975315094,

'company_name': 'Apple',

'dividend': 1.9341673320912078,

'total':300,

'sector': 'Technology'},

'GOOG': {

'beta': 1.01833975315094,

'company_name': 'Apple',

'dividend': 1.9341673320912078,

'total':300,

'sector':'Technology'},

'XXXX': {

'beta': 1.01833975315094,

'company_name': 'Apple',

'dividend': 1.9341673320912078,

'total':300,

'sector':'Food'}

}

import pandas as pd

# Create pandas dataframe wi

stockData_df = pd.DataFrame(stockData).T

stockData_df['percentage'] = stockData_df['total']/stockData_df['total'].sum()

stockData_df

Out[82]:

beta company_name dividend sector total percentage

AAPL 1.01834 Apple 1.93417 Technology 300 0.333333

GOOG 1.01834 Apple 1.93417 Technology 300 0.333333

XXXX 1.01834 Apple 1.93417 Food 300 0.333333

sector_totals = stockData_df.groupby('sector').sum()['total']/stockData_df['total'].sum()

sector_totals

Out[86]:

sector

Food 0.333333

Technology 0.666667

Name: total, dtype: float64