How to display all the columns of dataframe without changing global printing option?

Question

I want to view all the columns of my dataframe. It has 30 columns. While trying to view a specific row, it gets truncated.

I can change the global printing option pd.set_option('display.max_columns', None).

But I don't want to do that. I only want to view all the columns(data in the columns) once. Is there any way or workaround?

As mentioned I only want to view all the columns only once. I don't want to view them all the time. — joshijai2, Apr 25 '20 at 16:38

score 2 · Accepted Answer · answered Apr 25 '20 at 16:34

2

You use it with a with statement:

with pd.option_context('display.max_columns', 30):
    #do your stuff

answered Apr 25 '20 at 16:34

Ralvi Isufaj

Thanks a lot. This works fine. Just add that we need to use `print(df.head())`, `df.head()` doesn't display anything. – joshijai2 Apr 25 '20 at 16:47

score 2 · Answer 2 · answered Apr 25 '20 at 16:41

2

If you want to display the entire DataFrame, you can convert it to HTML and display it with IPython's HTML renderer:

import pandas as pd
from IPython.display import HTML

df = ...
HTML(df.to_html())

But note that if your DataFrame is large, this may cause the notebook to be unstable.

answered Apr 25 '20 at 16:41

foglerit

This is also a cool way. Thanks @foglerit. Learnt something new. – joshijai2 Apr 26 '20 at 06:10

score -1 · Answer 3 · answered Apr 25 '20 at 16:33

-1

You can change global printing options,

Method 1:

pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)

Method 2:

pd.options.display.max_columns = None
pd.options.display.max_rows = None

Credit to Yolo

answered Apr 25 '20 at 16:33

k0rnik

I mentioned without "pd.set_option('display.max_columns', None)". – joshijai2 Apr 25 '20 at 16:39
Apologies, I see the issue. Can you tell me where do you display those columns? Are you using Jupyter Notebook or IDE? Bear in mind that you can also set maximum columns without using max_colwidth (you can also set it to None to prevent folding) – k0rnik Apr 25 '20 at 16:46
I am using Jupyter Notebook. I don't want to change maximum columns for the entire notebook. I just want to view the data of specific rows once. Btw @ralvi-isufaj already found out a solution. – joshijai2 Apr 26 '20 at 06:08

3 Answers3