/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

7 votes206 views4 answers
Pandas apply function to column
Python
12 votes195 views3 answers
Convert pandas dataframe to dict with a column as key
Python
1 vote226 views1 answer
Get today's date pandas
Python
18 votes199 views10 answers
Stackoverflow
Python
1 vote193 views1 answer
How to draw line in markdown
Python
0 vote227 views2 answers
Empty set in python
Python
3 votes230 views1 answer
Replace multiple values in pandas column
Python
3 votes205 views3 answers
Flask migrate install
Python
0 vote200 views1 answer
Cvhaardetectobjects
Python
0 vote193 views1 answer
Highlight Active Links in Django Website
Python