df rows count code example

Example 1: get all count rows pandas

count_row = df.shape[0]  # gives number of row count
count_col = df.shape[1]  # gives number of col count

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: get number of rows pandas

number_of_rows = len(df)

Example 4: pandas df row count

df = pd.DataFrame({"Letters": ["a", "b", "c"], "Numbers": [1, 2, 3]})
index = df.index
number_of_rows = len(index)