ADVERTISEMENT
ADVERTISEMENT

How to show all columns' names on a large Pandas DataFrame?

Given a Pandas DataFrame, we have to show all columns' names.
Submitted by Pranit Sharma, on May 29, 2022

In the real world, data is huge so is the dataset. While importing a dataset and converting it into DataFrame, if the number of columns is large, the default printing method does not print the entire columns. It compresses the rows and columns. In this article, we are going to learn how to expand the output display to see all the columns of DataFrame.

We can achieve this task with the help of pandas.set_option() method. The set_options() method allows us to set different properties according to our requirements. The display.max_columns() defines the total number of columns to be printed. If None is passed as an argument, all columns would be printed.

To work with pandas, we need to import pandas package first, below is the syntax:

import pandas as pd

Let us understand with the help of an example.

#  Importing pandas package
import pandas as pd
import random

# Creating an empty dictionary
d = {}

# Creating a large DataFrame of 20 columns
for i in range(1,21):
    d[i]=[ random.randint(100,500) for _ in range(10)]

df=pd.DataFrame(d)

# Viewing default DataFrame
print(df)

Output:

Example 1: Show all columns' names

Here, we have defined 20 columns but not all the columns are printed, to overcome this problem, we will use set_options('display.max_columns') method.

# Setting value of columns=20
pd.set_option('display.max_columns', 20)

# Viewing modified DataFrame
print(df)

Output:

Example 2: Show all columns' names

Python Pandas Programs »



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.