1

I am stuck in a requirement to pick the top 5 rows sorted in desc in the data frame based on column var_count and for each unique col_name in the dataFrame.

I would like to have the output to be sorted in desc based on var_count in the attached screenshot Could someone please help?

I have attached the screenshot

My code:

df_ans
#df_ans.groupby('col_name')['var_name'].nlargest(5)
#top_col_values = pd.DataFrame(df_ans.groupby('col_name')['var_count'].nlargest(5))
top_col_values = df_ans.groupby('col_name').head(5)
top_col_values

enter image description here

Improve this question
0
Related questions
512
Get the row(s) which have the max value in groups using groupby
648
Create new column based on values from other columns / apply a function of multiple columns, row-wise in Pandas
414
Detect and exclude outliers in a pandas DataFrame
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.