How do I display all columns and rows in a Pandas Dataframe?

Pandas is one of the most popular Python libraries for data analysis. It provides high-performance, easy-to-use data structures and data analysis tools.

The DataFrame is one of these structures. It is a two-dimensional tabular data structure with labeled axes (rows and columns). Arithmetic operations align on both row and column labels. It can be created from a dict of arrays, lists, or tuples.

A DataFrame has an index (row labels) and a columns attribute (column labels). The basic method to get all the column names of a DataFrame is:

We will use the following dataframe:

Codeblock E.1. IPL sample dataset can be downloaded from Kaggle Datasets.

You can download the dataset from here

Link : https://www.kaggle.com/datasets/hiimanshuagarwal/ipl-dataset-2008-2020

or

Download. Click here to previe and download 'IPL Dataset (2008 - 2020)'.

Pandas truncates information when it is too long which can be a problem when trying to analyze data, as important information may be lost.

Figure E.1. To avoid displaying too much information, they are concealed..

One way to avoid this is to set the display.max_colwidth option in pandas so that longer strings are not truncated:

This will ensure that strings are not truncated when displayed.

Columns

Codeblock E.2. Displaying the number of columns of the dataset.

With the max colwidth parameter, you can modify the column's width something like:

 pandas.set_option('max_colwidth', 100)

Codeblock E.3. Setting the column width of the dataset.

You can change the number of rows and columns displayed in the console with the option display.max_columns and display.max_rows.

You can reset all the options to their default values with the option reset_option.

You can change the default values for all the options with the option set_option.

 
You can check the values of all the options with the option get_option.

Rows

You must modify the max rows parameter in order to change the amount of rows.

Codeblock E.4. Modifying the rows of the dataset.

What does pd.set_option('display.max_rows', None) do ?

The function pd.set_option('display.max_rows', None) is used to display all the rows of a dataframe in jupyter notebook.