pandas dtype output has extra row

Question

While playing around with pandas I started wondering about the output.

> df = pd.DataFrame({'col_1':[1,2,3], 'col_2':['a','b','c']})
> df.dtypes
  col_1     int64
  col_2    object
  dtype: object

The df.dtypes call gives three rows.

The first row shows that col_1 has an "integer" type.
The second row shows that col_2 has an "object" type, which is a string.
The third row mentions dtype: object... but what is this referring to?

The third row referring to datatype of `df.dtypes` series. – Space Impact Feb 04 '19 at 09:44 — Space Impact, Feb 04 '19 at 09:44
ahh! cool. feel free to post this as an answer. – cantdutchthis Feb 04 '19 at 09:47 — cantdutchthis, Feb 04 '19 at 09:47

score 2 · Accepted Answer · answered Feb 04 '19 at 09:47

2

The object returned by dtypes is a pandas.Series object, by default a Series shows it's dtype when printed, it's telling you it is a Series od mixed types (since you have int64 and object)

answered Feb 04 '19 at 09:47

Luc Blassel

394
4
15

it shows `object` only even if all the columns are `numeric`. – Sociopath Feb 04 '19 at 09:49

pandas dtype output has extra row

1 Answers1