Pandas Count Specific Values in Column code example

Example 1: pandas count specific value in column

(df[education]=='9th').sum()

Example 2: how to count special values in data in python

df['sex'].value_counts()

Example 3: 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

Example 4: how to count special values in data in python

df['fare'].value_counts(bins=7)

Example 5: hiw ti count the number of a certain value in python

#using the .count() function where the occurence of an element you 
#want to find is the thing in the paranthesis
lista = [1,1,2,3,4,5]
print(lista.count(1))
# will return 2