Pandas group by

Pandas groupby

data.groupby('month', as_index=False).agg({"duration": "sum"})

Source: shanelynn.ie

Df groupby loop

grouped = df.groupby('A')

for name, group in grouped:
    ...

Source: stackoverflow.com

Pandas groupby

>>> emp.groupby(['dept', 'gender']).agg({'salary':'mean'}).round(-3)

Source: medium.com

Pandas groupby

# usage example
gb = df.groupby(["col1", "col2"])
counts = gb.size().to_frame(name="counts")
count
(
    counts.join(gb.agg({"col3": "mean"}).rename(columns={"col3": "col3_mean"}))
    .join(gb.agg({"col4": "median"}).rename(columns={"col4": "col4_median"}))
    .join(gb.agg({"col4": "min"}).rename(columns={"col4": "col4_min"}))
    .reset_index()
)

# to create dataframe
keys = np.array(
    [
        ["A", "B"],
        ["A", "B"],
        ["A", "B"],
        ["A", "B"],
        ["C", "D"],
        ["C", "D"],
        ["C", "D"],
        ["E", "F"],
        ["E", "F"],
        ["G", "H"],
    ]
)



df = pd.DataFrame(
    np.hstack([keys, np.random.randn(10, 4).round(2)]), columns=["col1", "col2", "col3", "col4", "col5", "col6"]
)
df[["col3", "col4", "col5", "col6"]] = df[["col3", "col4", "col5", "col6"]].astype(float)

Source: stackoverflow.com

Pandas group by

data.groupby('amount', as_index=False).agg({"duration": "sum"})

Groupby

df['frequency'] = df['county'].map(df['county'].value_counts())

    county  frequency
1   N       5
2   N       5
3   C       1
4   N       5
5   S       1
6   N       5
7   N       5

-1

Source: stackoverflow.com

Similar codes

0 vote108 views2 answers
How to download excel file with password from online python
Python
0 vote128 views1 answer
Python - Cara Mengurutkan String Secara alfabet
Python
0 vote111 views1 answer
Selenium python chrome path
Python
10 votes107 views2 answers
Check if key exists in sesison python
Python
0 vote116 views1 answer
List generation for python
Python
0 vote102 views1 answer
Debug console shows blank
Python
0 vote126 views1 answer
Python3 list directories
Python
19 votes154 views5 answers
Autoclicker in python
Python
0 vote102 views1 answer
'numpy.ndarray' object has no attribute 'count'
Python
0 vote134 views1 answer
Df = df.apply(lambda x: np.square(x) if x.name in [ 'a', 'e', 'g'] else x, axis=1)
Python