Show all colums of a pandas-dataframe in ".describe()"

Question

I am stuck here, but I it's a two part question. Looking at the output of .describe(include = 'all'), not all columns are showing; how do I get all columns to show?

This is a common problem that I have all of the time with Spyder, how to have all columns to show in Console. Any help is appreciated.

import matplotlib.pyplot as plt
import pandas as pd
import scipy.stats as stats
import seaborn as sns

mydata = pd.read_csv("E:\ho11.csv")
mydata.head()
print(mydata.describe(include="all", exclude = None))

mydata.info()

OUTPUT:

code output

Does this answer your question? How to show all of columns name on pandas dataframe? — Sabito
– Sabito, Commented Oct 21, 2020 at 2:19

CypherX · Accepted Answer · 2020-10-24 19:50:19Z

14

Solution

You could use either of the following methods:

Method-1:

source

pd.options.display.max_columns = None

Method-2:

source

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

# to reset this
pd.reset_option('display.max_columns')

Method-3:

source

# assuming df is your dataframe
pd.set_option('display.max_columns', df.columns.size)

# to reset this
pd.reset_option('display.max_columns')

Method-4:

source

# assuming df is your dataframe
pd.set_option('max_columns', df.columns.size)

# to reset this
pd.reset_option('max_columns')

To not wrap the output into multiple lines do this

source

pd.set_option('display.expand_frame_repr', False)

References

I will recommend you to explore the following resources for more details and examples.

edited Oct 24, 2020 at 19:50

answered Oct 21, 2020 at 2:15

CypherX

7,4034 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user14077223 Over a year ago

Thank you! exactly what I was looking for.

tacitdenial · Accepted Answer · 2022-08-21 18:50:50Z

1

Since you are using Spyder the easiest thing to do would be:

myview = mydata.describe()

Then you can inspect 'myview' in the variable explorer.

answered Aug 21, 2022 at 18:50

tacitdenial

111 bronze badge

Comments

DrWhat · Accepted Answer · 2022-12-14 09:05:43Z

0

Using pd.set_option listed column names in the console truncated in the middle with three dots.

To print a full list of the column names from a dataframe to the console in Spyder:

list(df.columns)

answered Dec 14, 2022 at 9:05

DrWhat

2,4906 gold badges25 silver badges38 bronze badges

Collectives™ on Stack Overflow

Show all colums of a pandas-dataframe in ".describe()"

3 Answers 3

Solution

To not wrap the output into multiple lines do this

References

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Solution

To not wrap the output into multiple lines do this

References

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related