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.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…