Initially, my dataframe had a Month column containing numbers representing the months.

I typed df["Month"] = pd.to_datetime(df["Month"]) and I get this...

I would like to just retain just the dates and not the time. Any solutions?

CodePudding user response：

get the date from the column using df['Month'].dt.date

CodePudding user response：

Use format='%m' in to_datetime:

df["Month"] = pd.to_datetime(df["Month"], format='%m') 
print (df)
       Month
0 1900-01-01
1 1900-02-01
2 1900-03-01
3 1900-04-01 

CodePudding user response：

you can use timedelt

days=timedelta(months=1)