Skip to content
Related Articles

Related Articles

How to Show All Columns of a Pandas DataFrame?

Improve Article
Save Article
Like Article
  • Last Updated : 19 Dec, 2021

In this article, we will discuss how to Show All Columns of a Pandas DataFrame.

Using set_option() method

We will use the pandas set_option() method. This method will set the specified option’s value.

Syntax :

 pandas.set_option(pat, value)

Parameters :

  • pat : Regexp which should match a single option.
  • value : New value of option.

Returns :

 None

Raises

if no other option exists, the OptionError is raised

To view and download the CSV file used in the below example click train.csv.

Example:

Without using the set_option() method: 

Python3




# importing packages
import pandas as pd
  
# importing 'train.csv'
data = pd.read_csv('train.csv')
data.head()

Output:

Example:

After using the set_option() method:

Here we have given ‘display.max_columns’ as an argument to view the maximum columns from our dataframe.

Python3




# importing packages
import pandas as pd
  
# importing 'train.csv'
data = pd.read_csv('train.csv')
  
pd.set_option('display.max_columns', None)
data.head()

Output:

We can view all columns, as we scroll to the right, unlike when we didn’t use the set_option() method. If we only want to view a certain number of columns:

Syntax:

pd.set_option(‘display.max_columns’, n)

where, n is an integer.

Example:

Python3




# importing packages
import pandas as pd
  
# importing 'train.csv'
data = pd.read_csv('train.csv')
pd.set_option('display.max_columns', 4)
data.head()

Output:


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!