grouby to find the most redundant value for each column

I would like to generate an additional row in my table that contains the most abundant value in each column.
For example, if I have in the first column: 5,2,2,3,3,2,7,3,1,2 then the new row will contain 2 in its first column.
I have the feeling it is something doable with GroupBy but not sure how.

If I’m understanding you correctly, this should be Mode aggregation using GroupBy.


Perfect answer.
Thanks @ScottF

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.