pandas count number of rows with value code example

Example 1: pandas count rows with value

len(df[df['score'] == 1.0])

Example 2: pandas count rows in column

>>> df.count(axis='columns')
0    3
1    2
2    3
3    3
4    3
dtype: int64

Example 3: Returns the number of rows in this DataFrame

# Returns the number of rows in this DataFrame

df.count()
# 2

Example 4: pandas count number of rows with value

In [37]:
df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()

Out[37]:

   a
a   
a  2
b  3
s  2

[3 rows x 1 columns]