python pandas count rows code example

Example 1: pandas count rows in column

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

Example 2: Returns the number of rows in this DataFrame

# Returns the number of rows in this DataFrame

df.count()
# 2

Example 3: pandas df row count

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

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()