How to Show All Columns of a Pandas DataFrame?

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: