Pandas DataFrame is one of the most commonly used class in data programming with Python. This article shows you how to get row and column count of a pandas DataFrame.
Get row count
There are multiple ways to get row count.
Via index
Use len(df.index) to get the row count.
>>> import pandas as pd
>>> mydict = [{'a': 1, 'b': 2, 'c': 3, 'd': 4},
... {'a': 100, 'b': 200, 'c': 300, 'd': 400},
... {'a': 1000, 'b': 2000, 'c': 3000, 'd': 4000 }]
>>> df = pd.DataFrame(mydict)
>>> df
a b c d
0 1 2 3 4
1 100 200 300 400
2 1000 2000 3000 4000
>>> row_count = len(df.index)
>>> row_count
3
Via shape
We can also use df.shape`` attribute to get the row count.
>>> df.shape[0]
3
Via columns
We could also use any column to get the row count however it only returns the count of non-NaN values.
>>> df[df.columns[0]].count()
3
Get column count
For shape attribute of DataFrame, it also returns the column count.
>>> df.shape[1]
4