1) # Set index to the week df = df.set_index('week') # Change all data types to 'int' df = df.astype(int) # Extract Month and Year Columns df['month'] = df.index.astype('datetime