Welcome To Ask or Share your Answers For Others

Python dataframe中如何使y列按x列进行统计？

asked Feb 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

如图：busy=0 or 1,求出busy=1时los的平均，同样对busy=0时也求出los的平均

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

359 views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Feb 6, 2021 by 深蓝 (71.8m points)

先groupie，后用mean：

import pandas as pd
df = pd.DataFrame({'busy': [1, 0, 0],
                  'los': [0.8111, 1.1011, 0.912]})
df.groupby('busy').mean()

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...