option_context() to set DataFrame display option values for the code block and restore after executing

Pandas | All display functions

Execute part of the code by different value of display options and restore the same after executing.

option_context() Execute the code block with set options ( reset after execution )

We can get a list of available options by using describe_option().

By using option_context() we can set the values of a set of display options temporarily and restore the values after execution of the set of code block. We will use with to define our set of code.

max_rows & max_columns

Let us set the option value max_rows to display 6 rows and max_columns to 3 columns of the DataFrame. Note that our excel file is having 35 rows of data and 5 columns.

import pandas as pd 
my_data = pd.read_excel('D:\student.xlsx',index_col='id')
with pd.option_context('display.max_rows',6,'display.max_columns',3):
    print(my_data)
print(pd.get_option("display.max_rows")) # 60

Output

          name  ...     sex
id              ...        
1     John Deo  ...  female
2     Max Ruin  ...    male
3       Arnold  ...    male
..         ...  ...     ...
33   Kenn Rein  ...  female
34    Gain Toe  ...    male
35  Rows Noump  ...  female

[35 rows x 4 columns]
60

More on student excel file ( you can download and use ) having 35 rows of data

In above code we have set the value of max_rows to 6 and max_columns to 3. The print() command will display records based on this setting. After executing the print() command we will display the value of max_rows by using get_option(). The value ( output ) is restored to default value of 60.

Like this there are several options available and we can update the values of these function. A list of such options with detail description is available by using describe_option()
All display option functions of DataFrame

Pandas read_csv() read_excel() to_excel()

Numpy arrays Python & MySQL Python- Tutorials

Subscribe to our YouTube Channel here