count the number of rows in dataframe code example
Example 1: Returns the number of rows in this DataFrame
# Returns the number of rows in this DataFrame
df.count()
# 2
Example 2: 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 3: 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()