How to groupby in pandas

Pandas groupby

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

Source: shanelynn.ie

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 to dataframe

In [21]: g1.add_suffix('_Count').reset_index()
Out[21]: 
      Name      City  City_Count  Name_Count
0    Alice   Seattle           1           1
1      Bob   Seattle           2           2
2  Mallory  Portland           2           2
3  Mallory   Seattle           1           1

Source: stackoverflow.com

How to groupby in pandas

# importing pandas as pd
import pandas as pd
  
# Creating the dataframe 
df = pd.read_csv("nba.csv")
  
# Print the dataframe
df

Source: geeksforgeeks.org

Similar codes

0 vote283 views1 answer
Python soma números
Python
0 vote323 views1 answer
Decorator patter
Python
10 votes286 views3 answers
Pacman 30th anniversary
Python
-1 vote280 views2 answers
Traceback (most recent call last): File "/usr/bin/pip", line 9, in <module> from pip import main
Python
0 vote279 views1 answer
Setting spacing between ticks in matplotlib
Python
14 votes283 views3 answers
Pyautogui send keys
Python
11 votes298 views4 answers
Get count of values in column pandas
Python
0 vote334 views1 answer
Mechanize python #12
Python
0 vote271 views1 answer
Python dataframe appendisnt showing
Python
4 votes249 views2 answers
How to drop a column in pandas
Python