Pandas printing ALL dtypes

Question

This seems like a very simple problem, however it's driving me round the bend. I'm sure it should be solved by RTFM, but I've looked at the options and I can see the one to fix it.

I just want to print the dtypes of all columns, currently I'm getting:

print df.dtypes
#>
Date         object
Selection    object
Result       object
...
profit    float64
PL        float64
cumPL     float64
Length: 11, dtype: object

I've tried setting options display.max_row, display.max_info_row, display.max_info_columns all to no avail.

What am i doing wrong?

Pandas version = 0.13.1

Update:

Turns out I was being and idiot and hadn't set display.max_row to a high enough value.

Solution was:

pd.set_option('display.max_rows', 20)

I think you've must have set it to a very low number yourself (the ``display.max_rows``), because that is 60 by default (so a series of 11 elements would never be truncated) — joris, Apr 19 '14 at 10:14
When going for raw printouts, I usually default to something like `print dict(df.dtypes)` — U2EF1, Apr 20 '14 at 00:54

score 66 · Answer 1 · answered Oct 16 '18 at 08:23

66

I tried this and worked:

df.info(verbose=True)

answered Oct 16 '18 at 08:23

chok68

875
9
10

score 14 · Answer 2 · answered Dec 09 '19 at 07:44

14

Do this:

with pd.option_context('display.max_rows', None, 'display.max_columns', None):
    print(df.dtypes)

answered Dec 09 '19 at 07:44

Nora_F

431
5
17

score 10 · Answer 3 · answered May 16 '17 at 07:52

10

another way around is to group by dtype as follows:

x = df.columns.to_series().groupby(df.dtypes).groups
x
{dtype('object'): ['Date', 'Selection', 'Result'], dtype('float64'): ['profit', 'PL', 'cumPL']

answered May 16 '17 at 07:52

Mshendy

303
3
11

1

how do you access the elements of that dictionary? – eleijonmarck Sep 11 '17 at 13:41

Pandas printing ALL dtypes

3 Answers3

Linked