Breaking News: Grepper is joining You.com. Read the official announcement!

Group multiple columns in pandas

Add Answer

Elisabeth Engering answered on October 15, 2020 Popularity 9/10 Helpfulness 4/10

answer Group multiple columns in pandas

related dataframe groupby multiple columns

related group by 2 columns pandas

related pandas groupby multiple columns

related group by multiple columns

related dataframe how to groupby apply list to multiple columns

related GROUP BY With Multiple Columns

Group multiple columns in pandas

Comment

import pandas as pd

# Group multiple columns and get statistics
df = df.groupby(["store", "type"])["weekly_sales"].sum()

# Group multiple columns and multiple statistics
df = df.groupby(["store", "type"])["weekly_sales"].agg([sum, min, max])

# Display DataFrame
print(df)

Popularity 9/10 Helpfulness 4/10 Language python

Source: pandas.pydata.org

Tags: group multiple-columns pandas python

Link to this answer
Share Copy Link

Contributed on Apr 29 2022

Elisabeth Engering

0 Answers Avg Quality 2/10

Closely Related Answers

dataframe groupby multiple columns

Comment

grouped_multiple = df.groupby(['Team', 'Pos']).agg({'Age': ['mean', 'min', 'max']})
grouped_multiple.columns = ['age_mean', 'age_min', 'age_max']
grouped_multiple = grouped_multiple.reset_index()
print(grouped_multiple)

Popularity 10/10 Helpfulness 5/10 Language python

Source: jamesrledoux.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Oct 15 2020

Unsightly Unicorn

0 Answers Avg Quality 2/10

group by 2 columns pandas

Comment

In [11]: df.groupby(['col5', 'col2']).size()
Out[11]:
col5  col2
1     A       1
      D       3
2     B       2
3     A       3
      C       1
4     B       1
5     B       2
6     B       1
dtype: int64

Popularity 10/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on Dec 05 2020

Hungry Horse

0 Answers Avg Quality 2/10

pandas groupby multiple columns

Comment

df['COUNTER'] =1       #initially, set that counter to 1.
group_data = df.groupby(['Alphabet','Words'])['COUNTER'].sum() #sum function
print(group_data)

Popularity 10/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on Jan 17 2022

Novid19

0 Answers Avg Quality 2/10

pandas groupby multiple columns

Comment

#formatting
candidates_salary_by_month =  candidates_df.groupby('month').agg(num_cand_month = \
                                                                ('num_candidates', 'sum'), \
                                                                avg_sal = ('salary', 'mean')).style.format('{:.0f}')

print(candidates_salary_by_month)

Popularity 10/10 Helpfulness 2/10 Language python

Source: www.easytweaks.com

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on May 10 2022

Colorful Caterpillar

0 Answers Avg Quality 2/10

group by multiple columns

Comment

Group By X means put all those with the same value for X in the one group.

Group By X, Y means put all those with the same values for both X and Y in the one group.

Popularity 10/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on Apr 05 2022

Helping Hand

0 Answers Avg Quality 2/10

dataframe how to groupby apply list to multiple columns

Comment

df = df.groupby(['a','b']).apply(lambda x: [list(x['c']), list(x['d'])]).apply(pd.Series)
df.columns =['a','b','c','d']

Popularity 9/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: apply dataframe datafram

Link to this answer
Share Copy Link

Contributed on Aug 10 2022

Angry Alligator

0 Answers Avg Quality 2/10

GROUP BY With Multiple Columns

Comment

-2

SELECT country, state, MIN(age) as min_age
FROM Persons
GROUP BY country, state;

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: group-by group-b

Link to this answer
Share Copy Link

Contributed on May 20 2022

SAMER SAEID

0 Answers Avg Quality 2/10

Group multiple columns in pandas

Contents

More Related Answers

Group multiple columns in pandas

Closely Related Answers

dataframe groupby multiple columns

group by 2 columns pandas

pandas groupby multiple columns

pandas groupby multiple columns

group by multiple columns

dataframe how to groupby apply list to multiple columns

GROUP BY With Multiple Columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.