Home / Questions / 254953
Accepted
efueyo
Asked: 2020-04-17 06:27:46 +0800 CST 2020-04-17 06:27:46 +0800 CST

Show all columns of a dataframe

  • 772

How can all the columns of a DataFrame be displayed on the screen? In my case, the execution indicates me with ellipses, the columns not shown.

                   EPSV  Acatis  Avantage   ...      Nasdaq  Nikkei_225  \

Date ...
2019-01-30 00:00:00 11.914 249.57 13.258 ... 7183.08 20556.539
2019-01-31 00:00:00 11.951 250.05 13.236 ... 7281.74 20773.490 2019-0:
00 11.954 250.90 13.272 ... 7263.87 20788.391
I will appreciate your help

pandas

2 Answers

  1. Best Answer

    The number of columns/rows displayed when the DataFrame is printed is bounded by default in the case of Jupiter Notebook. This and other relevant features when displaying data can be defined by pandas.options.display:

    >>> import pandas as pd
>>> pd.options.display.max_rows
60

>>> pd.options.display.max_columns
20

    If you want all of them to be displayed (unlimited number) you only have to assign Noneto these variables.

    pd.options.display.max_columns = None

    max_rowsand are used by pandas object max_columnsmethods such as to decide whether or are used to represent the object in a string. When executing in a terminal, the value is 0 by default, allowing Pandas to automatically detect the width of the terminal and switch to a smaller format in case all columns. When the execution is not done in the terminal qtconsole, IDLE, Notebook, etc it is not possible to perform the automatic detection of the size of the available area, in which case the default value is set to 20.__repr__()DataFrameto_string()info()

    If the value is exceeded, it is used ...as a placeholder and the actual dimensions of it are shown below.

    enter image description here

    There are multiple configuration options, the complete list and an explanation of what each one does can be seen in the documentation .

    • 4

  2. Copied from a notebook on the internet, it had placed, after the module import statements, others that limited the display. By silencing them, all the columns are already displayed.

    #pd.set_option('display.notebook_repr_html', False)
#pd.set_option('display.max_columns', 6)
#pd.set_option('display.max_rows', 10) 
#pd.set_option('display.width', 78) 
#pd.set_option('precision', 3)

    What I have not been able to do is find a website or tutorial that explains these and similar ones.

    • 1