Pandas DataFrame row count in Python
David Y.
—The Problem
How can I get the number of rows of a Pandas DataFrame in Python?
The Solution
We can do this in one of two main ways:
- Using Python’s built-in
len()function:Click to Copyrow_count = len(my_dataframe) - Using the
DataFrame.shapeproperty, which contains a tuple of the row and column count:Click to Copyrow_count = my_dataframe.shape[0]
The len() function is usually the faster of the two solutions, but shape may be useful in circumstances where we also need the column count.
- Sentry BlogPython Performance Testing: A Comprehensive Guide (opens in a new tab)
- Syntax.fmListen to the Syntax Podcast (opens in a new tab)
- Sentry BlogLogging in Python: A Developer’s Guide (opens in a new tab)
- CodecovPython - Codecov (opens in a new tab)
- Listen to the Syntax Podcast (opens in a new tab)
![Syntax.fm logo]()
Tasty treats for web developers brought to you by Sentry. Get tips and tricks from Wes Bos and Scott Tolinski.
SEE EPISODES
Considered “not bad” by 4 million developers and more than 150,000 organizations worldwide, Sentry provides code-level observability to many of the world’s best-known companies like Disney, Peloton, Cloudflare, Eventbrite, Slack, Supercell, and Rockstar Games. Each month we process billions of exceptions from the most popular products on the internet.