dataframe number of rows code example

Example 1: pandas dataframe get number of columns

import pandas as pd
df = pd.DataFrame({"pear": [1,2,3], "apple": [2,3,4], "orange": [3,4,5]})

len(df.columns)
3

Example 2: 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 3: pandas count rows with value

len(df[df['score'] == 1.0])

Example 4: pandas count rows in column

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

Example 5: get number of rows pandas

number_of_rows = len(df)

Example 6: Returns the number of rows in this DataFrame

# Returns the number of rows in this DataFrame

df.count()
# 2