pandas print out all rows

Pandas DataFrame: Print All Rows at Once

By Laura JonesFebruary 5, 2026

When working with pandas, a powerful data manipulation library in Python, you often need to view or analyze your entire dataset. For this, you'd want to print out all rows from your DataFrame. Let's explore how to achieve this with pandas.

Pandas, by default, only shows a subset of rows (5 by default) when you print a DataFrame to avoid overwhelming you with a large dataset. To print all rows, you need to tell pandas to do so.

Printing All Rows from a DataFrame

Pandas provides several ways to print all rows from a DataFrame. The most common method is to use the option 'display.max_rows' from the 'option_context' method. Let's discuss this further.

many pandas are sitting on the bamboo trees

panda face stickers with different expressions on the same sheet, each one in black and white

Another method is to use the 'select_data' method with the condition 'ისიTrue()', which instructs pandas to select all rows. We'll delve into this method as well.

Using 'option_context' and 'display.max_rows'

The 'option_context' method temporarily changes the display options, allowing you to print all rows. Here's how you can do it:

a panda bear pattern on a white background

the panda bear is sitting down and posing for different poses, including one with his paws on

Example: ```python import pandas as pd with pd.option_context('display.max_rows', None, 'display.max_columns', None): print(df) ```

In this example, 'display.max_rows' is set to None, which tells pandas to print all rows.

Using 'select_data' with True Condition

Another way to print all rows is to use the 'select_data' method with a condition that's always True, like True or 'somedataframe().isin([True])'. Here's how:

Cute Panda Coloring Pages for Kids & Adults | Easy Woodland Animal Printable Art

Paper Wrap with Theme Game Console Graphic by Arsa Adjie · Creative Fabrica

Feed The Hungry Pandas - A Panda Counting Game - Nurtured Neurons

Example: ```python print(df.select_data(somedataframe().isin([True]))) ```

This tells pandas to select all rows, as the condition 'ისination True' is met for every row.

Viewing All Rows in a DataFrame interactively

If you're using a Jupyter notebook or an IPython shell, you can use 'display()' function from 'IPython.display' to view all rows. This is particularly useful when you want to view a large DataFrame interactively.

the pandas are playing with each other in the bamboo frame, which is decorated with black and white flowers

50 Free Printable Cute Panda Coloring Pages!

Remember, 'display()' doesn't print the output to the console. Instead, it opens an interactive display window where you can scroll and navigate through all rows and columns.

Using 'IPython.display.display()'

Here's how you can use 'display()' function to view all rows:

Example: ```python from IPython.display import display display(df) ```

This will open an interactive display allowing you to view all rows and columns of your DataFrame.

Remember, the choice of method often depends on your specific use case, the size of your DataFrame, and the environment you're working in. Now you can explore your data with ease!