/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

2 votes239 views1 answer
Python calling dynamic function on object
Python
1 vote249 views1 answer
Selenium python find all links
Python
8 votes242 views1 answer
Delete certain characters from a string python
Python
0 vote282 views1 answer
Matplotlib remove ticks and lines
Python
3 votes242 views1 answer
How to insert item last in list python
Python
1 vote199 views1 answer
Plus months onto python date
Python
0 vote235 views1 answer
Ignore nil rows value in openpyxl
Python
9 votes240 views2 answers
How to delete specific char in string python
Python
14 votes242 views1 answer
Export a dataframe to excel pandas
Python
0 vote282 views1 answer
Insertar valor python
Python