/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

4 votes234 views2 answers
Python press any key to continue
Python
0 vote247 views1 answer
Http404 django
Python Django
0 vote233 views1 answer
Pandas change frequency of datetimeindex
Python
0 vote190 views1 answer
Algorithme pour afficher table de multiplication python
Python
1 vote285 views2 answers
Turn off colorbar seaborn heatmap
Python
0 vote258 views1 answer
Django blog new post
Python Django
0 vote222 views1 answer
OneHotEncoder(categorical_features=
Python
0 vote229 views1 answer
Generating datafraoms using specific row values
Python
1 vote232 views2 answers
Isprime function in python
Python
0 vote231 views1 answer
Train chatterbot using yml
Python