df = pd.DataFrame({'Date': [200104, 200508, 201002, 201602, 199912, 200611]})
df['EndOfMonth'] = pd.to_datetime(df['Date'], format='%Y%m') + MonthEnd(1)
Find the end of the month Pandas DataFrame Series