How to display all columns of a Pandas DataFrame in Jupyter Notebook
Data Science

How to display all columns of a Pandas DataFrame in Jupyter Notebook

How to set the max columns in Pandas
Bartosz Mikulski
Bartosz Mikulski – 1 min read

Often, when we want to display the content of a Pandas dataframe in Jupyter Notebook, we end up with the result that fits on the screen but has some hidden columns. Isn’t it annoying? What do we do when it happens? I used to save the data frame to file and open it in Excel or select the one row I wanted to see and transpose the data frame to have all of the columns visible as rows (that works until you hit the limit of rows that can be displayed).

Fortunately, there is a better way. We can specify the maximum number of columns we want to see to some large value and get the friendly output in Jupyter without additional hassle.

pd.set_option('display.max_columns', 999)
Older post

Review of “Conversations On Data Science” by Roger D. Peng and Hilary Parker

Data Science book recommendation

Newer post

Row number in Apache Spark window — row_number, rank, and dense_rank

This article is mostly a “note to self” because I don’t want to google that anymore ;)

Related Posts

Career Data Science

I worked as a data scientist and that was the worst job I have ever had.

I believed in the Sexiest Job of 21 Century hype. I was wrong.
Published on: 04 Mar 2022

Data Science

How to remove outliers from Seaborn boxplot charts

Hide outliers when displaying boxplot in Seaborn
Published on: 14 Oct 2019

Data Science

Pandas stack and unstack explained

How to use the stack and unstack functions in Pandas
Published on: 23 Sep 2019

Are you looking for an experienced AI consultant? Do you need assistance with your RAG or Agentic Workflow?
Schedule a call, send me a message on LinkedIn. Schedule a call or send me a message on LinkedIn

>