Answers for "pandas groupby"

20

group by pandas examples

>>> 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
Posted by: Guest on May-21-2020
-1

groupby

df.groupby(sepal_len_groups)['sepal length (cm)'].agg(count='count')

sum_sep = sep.groupby('Year').agg({'TotalProjects':'sum',
                                   'TotalFunds':'sum',
                                   'TotalFunds':'count',
                                   'SubDistrict':'count'})
                                   
sum_sep.stb.subtotal(grand_label='Total').applymap('{:,.0f}'.format)
Posted by: Guest on September-19-2021

Python Answers by Framework

Browse Popular Code Answers by Language