I have a DATE column like this,
DATE CÓDIGO ... UNIDADE VALOR
0 2009.06 10000.0 ... NaN NaN
1 2009.06 10100.0 ... NÃO SE APLICA .
2 2009.06 10101.0 ... M2 0.46
3 2009.06 10102.0 ... UN 15.15
I want to convert it to date format %Y%m
.
Applying the code,
df['DATA'] = pd.to_datetime(df['DATA'], format='%Y.%m')
I get this,
0 1970-01-01 00:00:00.000002009
1 1970-01-01 00:00:00.000002009
2 1970-01-01 00:00:00.000002009
3 1970-01-01 00:00:00.000002009
4 1970-01-01 00:00:00.000002009
Name: DATA, dtype: datetime64[ns]
Thanks for the help!