Count data types in pandas dataframe

Question

I have pandas.DataFrame with too much number of columns.

I call:

In [2]: X.dtypes

Out[2]: VAR_0001     object
        VAR_0002      int64
                 ...   
        VAR_5000      int64
        VAR_5001      int64

And I can't understand what types of data I have between VAR_0002 and VAR_5000

It's can be int64, int8, float64 and so on. I see in this blog native type of pandas.DataFrame but I think this is wrong information. How can I get this?

And other question. When I work on PC (Windows) and call this:

In [3]: X.dtypes[X.dtypes.map(lambda x: x=='bool')]

I get several columns with this type of data. But when I use this command on Mac, I get nothing. WAT?

Answer 1

To answer your first question do the following:

df.dtypes.value_counts()

Example:

In [4]:

df = pd.DataFrame({'a':[0], 'b':['asds'], 'c':[0]})
df.dtypes
Out[4]:
a     int64
b    object
c     int64
dtype: object
In [5]:

df.dtypes.value_counts()
Out[5]:
int64     2
object    1
dtype: int64