AttributeError: 'Int64Index' Object Has No Attribute 'month'

I have some time series data with three separate colums (Date, Time, kW) that looks like this: Date Time kW 3/1/2011 12:15:00 AM 171.36 3/1/2011 12:30:00 AM 181.44 3/1/2

Solution 1:

You can use datetime accessor and extract month

df['month'] = df['Date_Time'].dt.month