Is there any aggregate list function for categorical data in python

Question

I have a dataset with a lot of categorical data. I'm trying to reshape my dataframe by using groupby and pivot_table.I have find a list of aggregated function for numerical values such as:

'count','mean','max', 'sum'

I wanted to know if there is any equivalent for categorical values (Top, frequency etc). expect using the function .describe()

`df.groupby(['col1','col2']).agg(lambda x:x.value_counts().index[0])` — mad_, Jan 23 '19 at 21:38
https://stackoverflow.com/questions/16330831/most-efficient-way-to-find-mode-in-numpy-array — mad_, Jan 23 '19 at 21:42

score 0 · Answer 1 · answered Jan 23 '19 at 21:30

0

import pandas as pd

df = pd.DataFrame(data=yours_dataset)
df.describe() # top, frequency etc, max, min etc

answered Jan 23 '19 at 21:30

fuwiak

721
1
8
25

Is there any aggregate list function for categorical data in python

1 Answers1