#format the order date to datetime month and year revenue['Order Date'] = pd.to_datetime(revenue['Order Date'],format='%Y-%m').dt.to_period('M') #sum sales by month and year revenue = revenue.groupby(revenue['Order Date']).sum() #set date as index revenue.index = revenue.index.strftime('%m-%Y')