Showing all rows and columns of Pandas dataframe

Question

I am working with python 3 and the pandas package in visual studio code and I the print() function is not displaying correctly.

For example when I am using df.head() it looks good.

df.head() example

But If I use the print() statement I no longer see all of the columns next to each other, some of them get dragged down for some reason. And I can't see the entire data

print(df) example

Anyone knows what I can do to see the entire data, and all of the columns next to each other?

Don't use `print`. Just use `trading_history` without anything — Yevhen Kuzmovych, Mar 16 '21 at 14:21
Thanks a lot for your answer, that does work. But I still cannot see the entire data. I can only see the first 5 rows, the last 5 rows and the number of rows and columns I have. — Mihai Stoica, Mar 16 '21 at 14:24
print() is working, as documented. HTML table output is highly dependent on your notebook environment — OneCricketeer, Mar 16 '21 at 14:24

score 4 · Accepted Answer · answered Mar 16 '21 at 14:24

4

The problem comes from library pandas that cuts part of your dataframe when it's too long. Before your print, add this line:

pandas.set_option('max_row', None)

to display the entier row.

Also, you will be able to see all your data adding None argument in head():

trading.head(None)

answered Mar 16 '21 at 14:24

dallonsi

1,299
1
8
29

You are my hero, thanks a lot! – Mihai Stoica Mar 16 '21 at 14:32
7

In more recent versions of Pandas I think this needs to be qualified to `pandas.set_option('display.max_rows', None)` – Anton I. Sipos Oct 31 '22 at 02:33

Showing all rows and columns of Pandas dataframe

1 Answers1

Linked