我有以下代码:
grouped[['scene_average']].agg([np.mean, np.std, len])我想用np.std给ddof=5打电话
我怎样才能做到呢?
发布于 2017-05-14 13:30:14
使用lambda函数:
grouped[['scene_average']].agg([np.mean, lambda x: np.std(x, ddof=5), len])熊猫函数mean,std的另一种解决方案
grouped[['scene_average']].agg(['mean', lambda x: x.std(ddof=5), len])示例:
np.random.seed(10)
df = pd.DataFrame({'scene_average':np.random.randint(10,size=20),
'a':np.random.randint(3,size=20)})
grouped = df.groupby('a')
df1 = grouped[['scene_average']].agg([np.mean, lambda x: np.std(x, ddof=5), len])
d = {'<lambda>':'std','len':'count'}
df1 = df1.rename(columns = d)
print (df1)
scene_average
mean std count
a
0 5.500000 NaN 4
1 3.555556 5.749396 9
2 5.000000 4.898979 7如果删除列中的MultiIndex:
df1.columns = df1.columns.map('_'.join)
print (df1)
scene_average_mean scene_average_std scene_average_count
a
0 5.500000 NaN 4
1 3.555556 5.749396 9
2 5.000000 4.898979 7https://stackoverflow.com/questions/43964439
复制相似问题