Python Spyder: 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?](https://stackoverflow.com/questions/49188960/how-to-show-all-of-columns-name-on-pandas-dataframe) — Sabito 錆兎 stands with Ukraine, Oct 21 '20 at 02:19

CypherX · Accepted Answer · 2020-10-24T19:50:19.053

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.

Thank you! exactly what I was looking for. – Oct 21 '20 at 02:42 — , Oct 21 '20 at 02:42

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

1 Answers1

Solution

To not wrap the output into multiple lines do this

References

Linked