2.1.4.5.GroupBy

GroupBy的概念

• 讓table中有相同ID的row可以成組

操作

1. 產生groupby物件

    import numpy as np
    import pandas as pd
    data = {'Company': ['GooG', 'GooG', 'Att', 'Att'],
       'Person': ['Sam', 'Mike', 'Ray', 'Neil'],
       'Sales': [200, 100, 130, 500]}
    df = pd.DataFrame(data)
    byComp = df.GroupBy('Company')

2. 對groupby物件使用aggregate function

    byComp.mean()
    byComp.sum()
    byComp.std()
    byComp.count()
    byComp.min()
    byComp.describe()
    byComp.describe().transpose()