In Python, if there are many more number of columns in the dataframe, then not all the columns will be shown in the output display. So, let’s see how to widen output display to see more columns.
Method 1: Using pandas.set_option() function.
This function is used to set the value of a specified option.
Syntax: pandas.set_option(pat, value)
Returns: None
Example:
Python3
# importing numpy library import numpy as np # importing pandas library import pandas as pd # define a dataframe of # 2 rows and 100 columns # with random entries df = pd.DataFrame(np.random.random(200).reshape(2, 100)) # show the dataframe df |
Output:
To print the above output in a wider format using pandas.set_option() function.
Python3
# using pd.set_option() # to widen the output # display pd.set_option('display.max_columns', 100) # show the dataframe df |
Output:
Method 2: Using pd.options.display.max_columns attribute.
This attribute is used to set the no. of columns to show in the display of the pandas dataframe.
Example:
Python3
# importing numpy library import numpy as np # importing pandas library import pandas as pd # define a dataframe of # 15 rows and 200 columns # with random entries df = pd.DataFrame(np.random.randint(0, 100, size =(15, 200))) # show the dataframe df |
Output:
To print the above output in a wider format using pd.options.display.max_columns attribute.
Python3
# using an alternative # way to use # pd.set_option() method # to widen the output # display pd.options.display.max_columns = 200 # show the dataframe df |
Output:
