Count instances of strings across multiple columns in pandas

Question

I've a df with this make-up. I'm interested in counting strings in the columns that have numerical names i.e. ['1','2','3','4','5']

And would return a series something like:

string1 10
strinsag1 5
strins1 5

...

I've tried various methods of groupby, Counter, and stack but I haven't found a solution that works

Quang Hoang · Accepted Answer · 2020-10-15 19:01:41Z

3

You can stack the data and use value_counts():

df[['1','2','3','4','5']].stack().value_counts()

answered Oct 15, 2020 at 19:01

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1