#!/usr/bin/env python
# coding: utf-8

# In[1]:


import pandas as pd


# In[2]:


df = pd.DataFrame({'a': [1, 2, 1, 3],
                   'b': [0.4, 1.1, 0.1, 0.8],
                   'c': ['X', 'Y', 'X', 'Z'],
                   'd': [[0, 0], [0, 1], [1, 0], [1, 1]],
                   'e': [True, True, False, True]})


# In[3]:


df['f'] = pd.to_datetime(['2018-01-01', '2018-03-15', '2018-02-20', '2018-03-15'])


# In[4]:


print(df)


# In[5]:


print(df.dtypes)


# In[6]:


print(df.select_dtypes(include=int))


# In[7]:


print(df.select_dtypes(include='int'))


# In[8]:


print(df.select_dtypes(include='int64'))


# In[9]:


print(df.select_dtypes(include='int32'))


# In[10]:


print(df.select_dtypes(include=[int, float, 'datetime']))


# In[11]:


print(df.select_dtypes(include='number'))


# In[12]:


print(df.select_dtypes(include=object))


# In[13]:


print(type(df.at[0, 'c']))


# In[14]:


print(type(df.at[0, 'd']))


# In[15]:


print(df.select_dtypes(exclude='number'))


# In[16]:


print(df.select_dtypes(exclude=[bool, 'datetime']))


# In[17]:


print(df.select_dtypes(include='number', exclude=int))


# In[18]:


# print(df.select_dtypes(include=[int, bool], exclude=int))
# ValueError: include and exclude overlap on frozenset({<class 'numpy.int64'>})