#pandas datetimeindex docs: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DatetimeIndex.html df['month'] = pd.DatetimeIndex(df['birth_date']).month df.head()