Convert float to YYYYMM Pandas

Question

The date column that I have in the dataframe is of float type.

I was able to convert it in to YYYY-MM-DD format using the below:

pd.to_datetime(df['Date'], format = '%Y%m%d')

How can I convert it to YYYY-MM? tried the below and it didn't help.

pd.to_datetime(df['Date'], format = '%Y%m')

Answer 1

I think you need strftime for string:

pd.to_datetime(df['Date'], format = '%Y%m%d').dt.strftime('%Y%m')

Or for month periods:

pd.to_datetime(df['Date'], format = '%Y%m%d').dt.to_period('m')