Group by on a mapped dataframe index

PHOTO EMBED

Sun Mar 27 2022 22:34:06 GMT+0000 (Coordinated Universal Time)

Saved by @ianh #python #groupby

sales.groupby('Platform').get_group('X360')

platform_names = {
    'PS3':'Playstation',
    'PS4':'Playstation',
    'X360':'Xbox',
    'XOne':'Xbox'
}

sales.set_index('Platform').groupby(platform_names).sum()
content_copyCOPY

perform groupby on a dataframe index that is mapped to a category Note: Only works on an index column

https://www.udemy.com/course/the-ultimate-pandas-bootcamp-advanced-python-data-analysis/learn/lecture/19268906#overview