count number of rows in a dataframe code example

Example 1: get number of rows pandas

number_of_rows = len(df)

Example 2: Returns the number of rows in this DataFrame

# Returns the number of rows in this DataFrame

df.count()
# 2

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

Example 4: python - count total numeber of row in a dataframe

# Option 1
df.A.count()
# Option 2
df['A'].count()
# Option 3
number_of_rows = len(df) 
# Option 4
df.count()