Pandas have an options system that lets you customize some aspects of its behavior, display-related options being those the user is most likely to adjust. Let us see how to see the value of a specified option.
get_option()
Syntax : pandas.get_option(pat)
Parameters :
- pat : Regexp which should match a single option.
Returns : Value of the option
Raises : OptionError if no such option exists
Example 1 : Fetching the value of maximum and minimum number of columns and rows that can be displayed.
Python3
# importing the moduleimport pandas as pd# fetching maximum number of # columns that can be displayedprint("The value of max_columns : " + str(pd.get_option("display.max_columns")))# fetching maximum number of # rows that can be displayedprint("The value of max_rows : " + str(pd.get_option("display.max_rows")))# fetching minimum number of # rows that can be displayedprint("The value of min_rows : " + str(pd.get_option("display.min_rows"))) |
Output :
Output may vary.
Example 2 : Fetching the attributes related to Excel files.
Python3
# importing the moduleimport pandas as pd# default Excel reader engine for ‘ods’ filesprint("The default Excel reader engine for ‘ods’ files : " + str(pd.get_option("io.excel.ods.reader")))# default Excel reader engine for ‘xls’ filesprint("The default Excel reader engine for ‘xls’ files : " + str(pd.get_option("io.excel.xls.reader")))# default Excel writer engine for ‘xls’ filesprint("The default Excel writer engine for ‘xls’ files : " + str(pd.get_option("io.excel.xls.writer")))# default Excel reader engine for ‘xlsb’ filesprint("The default Excel reader engine for ‘xlsb’ files : " + str(pd.get_option("io.excel.xlsb.reader")))# default Excel reader engine for ‘xlsm’ filesprint("The default Excel reader engine for ‘xlsm’ files : " + str(pd.get_option("io.excel.xlsm.reader")))# default Excel writer engine for ‘xlsm’ filesprint("The default Excel writer engine for ‘xlsm’ files : " + str(pd.get_option("io.excel.xlsm.writer")))# default Excel reader engine for ‘xlsm’ filesprint("The default Excel reader engine for ‘xlsx’ files : " + str(pd.get_option("io.excel.xlsx.reader")))# default Excel writer engine for ‘xlsx’ filesprint("The default Excel writer engine for ‘xlsx’ files : " + str(pd.get_option("io.excel.xlsx.writer"))) |
Output :
