Get count of values across columns-Pandas DataFrame

Question

I have a Pandas DataFrame like following:

 A B C 0 192.168.2.85 192.168.2.85 124.43.113.22 1 192.248.8.183 192.248.8.183 192.168.2.85 2 192.168.2.161 NaN 192.248.8.183 3 66.249.74.52 NaN 192.168.2.161 4 NaN NaN 66.249.74.52

I want to get the count of a certain values across columns. So my expected output is something like:

IP Count 192.168.2.85 3 #Since this value is there in all coulmns 192.248.8.183 3 192.168.2.161 2 66.249.74.52 2 124.43.113.22 1

I know how to this across rows, but doing this for columns is bit strange?Help me to solve this? Thanks.

@OP, would you consider accepting a more performant answer if it was given? — cs95
– cs95, Commented Jan 23, 2019 at 10:39

waitingkuo · Accepted Answer · 2013-07-17 05:58:05Z

36

stack it first and then use value_counts:

In [14]: df.stack().value_counts() Out[14]: 192.248.8.183 3 192.168.2.85 3 66.249.74.52 2 192.168.2.161 2 124.43.113.22 1 dtype: int64

answered Jul 17, 2013 at 5:58

waitingkuo

94.5k28 gold badges119 silver badges122 bronze badges

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

1 Comment

user3155053 Over a year ago

Only pandas Series can use value_counts(). By using df.stack(), you transformed his DataFrame into a Series. Your solution is correct, but knowing why it worked helped me out a lot.

o11c · Accepted Answer · 2015-07-06 19:40:00Z

2

df['Counts'] = df[['col1','col2','col3']].groupby(['col1','col2','col3']).transform('count')

edited Jul 6, 2015 at 19:40

o11c

16.5k5 gold badges57 silver badges80 bronze badges

answered Jul 6, 2015 at 18:29

Vamshi G

4374 silver badges5 bronze badges

Collectives™ on Stack Overflow

Get count of values across columns-Pandas DataFrame

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related