---
title: "How to display all columns of a Pandas DataFrame in Jupyter Notebook"
description: "How to set the max columns in Pandas"
author: "Bartosz Mikulski"
author_bio: "Principal AI Engineer & MLOps Architect. I bridge the gap between \"it works in a notebook\" and \"it works for 200 million users.\""
author_url: https://mikulskibartosz.name
author_linkedin: https://www.linkedin.com/in/mikulskibartosz/
author_github: https://github.com/mikulskibartosz
canonical_url: https://mikulskibartosz.name/how-to-display-all-columns-of-a-pandas-dataframe-in-jupyter-notebook
---

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).

![Hidden columns](/images/2019-05-06-how-to-display-all-columns-of-a-pandas-dataframe-in-jupyter-notebook/hidden.png)

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)
```

![Visible columns](/images/2019-05-06-how-to-display-all-columns-of-a-pandas-dataframe-in-jupyter-notebook/visible.png)