Group By Pandas Examples Code Example

Snippet 1
  # Groups the DataFrame using the specified columns

df.groupBy().avg().collect()
# [Row(avg(age)=3.5)]
sorted(df.groupBy('name').agg({'age': 'mean'}).collect())
# [Row(name='Alice', avg(age)=2.0), Row(name='Bob', avg(age)=5.0)]
sorted(df.groupBy(df.name).avg().collect())
# [Row(name='Alice', avg(age)=2.0), Row(name='Bob', avg(age)=5.0)]
sorted(df.groupBy(['name', df.age]).count().collect())
# [Row(name='Alice', age=2, count=1), Row(name='Bob', age=5, count=1)] 
Snippet 2
  >>> n_by_state = df.groupby("state")["state"].count()
>>> n_by_state.head(10)
state
AK     16
AL    206
AR    117
AS      2
AZ     48
CA    361
CO     90
CT    240
DC      2
DE     97
Name: last_name, dtype: int64
 

Similar Snippets


Pandas Iterrows Code Example - pandas

Slicing In Pandas Code Example - pandas

Pandas Count Rows With Value Code Example - pandas

Add An Index Column Pandas Code Example - pandas

Pandas Ttable With Sum Totals Code Example - pandas

Remove 1st Column Pandas Code Example - pandas

Pandas Dataframe Froms String Code Example - pandas

Combine Two Dataframe In Pandas Code Example - pandas

Str_Count On Pandas Series Code Example - pandas

Convert Pandas Data Frame To Latex File Code Example - pandas

Append New Data On Pandas Dataframe Code Example - pandas

Getting Dummies And Input Them To Pandas Dataframe Code Example - pandas

How To Drop Columns In Pandas Code Example - pandas

Pandas Select All Columns Except One Code Example - pandas

How To Change Column Name In Pandas Code Example - pandas

Index Max Pandas Code Example - pandas

Rename Row Pandas Code Example - pandas

Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas

Pandas Cumulative Sum Column Code Example - pandas

Creating A Pandas Df Code Example - pandas

Pandas Read From Website Code Example - pandas

Pandas Show Top 10 Rows Code Example - pandas

How To Merge Two Column Pandas Code Example - pandas

How To Set Pandas Dataframe As Global Code Example - pandas

Pandas Merge Two Columns From Different Dataframes Code Example - pandas

Pandas Read Excel With Two Headers Code Example - pandas

Pandas Frame Convert String Code Example - pandas

Onehot Encode List Of Columns Pandas Code Example - pandas

Reshape Wide To Long In Pandas Code Example - pandas