how to find number of rows in dataframe code example
Example 1: get all count rows pandas
count_row = df.shape[0]
count_col = df.shape[1]
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
df.count()
Example 4: get number of rows pandas
number_of_rows = len(df)
Example 5: 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]