/Python/Pandas count occurrences of certain value in row

Pandas count occurrences of certain value in row

Pd count how many item occurs in another column

df['Counts'] = df.groupby(['Color'])['Value'].transform('count')

Source: stackoverflow.com

How to count special values in data in python

df['sex'].value_counts()

Source: dfrieds.com

Pandas count occurrences of certain value in row

print df
  col1 education
0    a       9th
1    b       9th
2    c       8th

print df.education == '9th'
0     True
1     True
2    False
Name: education, dtype: bool

print df[df.education == '9th']
  col1 education
0    a       9th
1    b       9th

print df[df.education == '9th'].shape[0]
2
print len(df[df['education'] == '9th'])
2

Source: stackoverflow.com

Similar codes

9 votes165 views2 answers
Read live video from usb opencv python
Python
1 vote175 views1 answer
Get last year of today python
Python
0 vote200 views1 answer
A int and float python
Python
0 vote182 views1 answer
How to loop through pages of pdf using python
Python
0 vote217 views1 answer
Max value indices
Python
0 vote185 views2 answers
Phow to install python modules in no internet in sercer
Python
66 votes181 views6 answers
Python delete folder and contents
Python
0 vote174 views2 answers
Python read file from same directory
Python
3 votes295 views1 answer
Python delete saved image
Python
7 votes156 views1 answer
Float to percentage python
Python