Pandas has a cool function called
select_dtypes, which can take either
exclude or include (or both) as parameters. It filters the dataframe based on
dtypes. So in this case, you would want to include columns of dtype
np.datetime64. To filter by integers, you would use
[np.int64, np.int32,np.int16, np.int], for float:
[np.float32, np.float64, np.float16,np.float], to filter by numerical columns only:
[np.number].
df.select_dtypes(include=[np.datetime64])
Out:
date_col0 2017-02-011 2017-03-012 2017-04-013 2017-05-01
In:
df.select_dtypes(include=[np.number])
Out:
col1 col20 1 21 1 22 1 23 1 2
