pandas number of occurrences in column code example
Example 1: pandas count occurrences in column
df['column'].value_counts()
df['column'].value_counts(normalize=True)
import pandas as pd
df = pd.DataFrame(np.array([[1, 2, 3], [4, 5, 6], [7, 5, 9]]),
columns=['a', 'b', 'c'])
print(df)
a b c
0 1 2 3
1 4 5 6
2 7 5 9
df['b'].value_counts()
5 2
2 1
df['b'].value_counts(normalize=True)
5 0.666667
2 0.333333
Example 2: python - count number of occurence in a column
print df
col1 education
0 a 9th
1 b 9th
2 c 8th
len(df[df['education'] == '9th'])