pd.to_datetime output is 1970-01-01 00:00:00.0000

Asked May 03 '20 at 18:52

Active May 03 '20 at 18:52

Viewed 636 times

dt_corr = dt[["date","mean_press", "maxwind", "sun_dur","mean_rel_hum", "mean_temp", "mean_cloud", "max_temp_2m", ]].dropna()
dt_corr["year"] = dt_corr.date.dt.year
dt_corr.set_index("date")
dt_corr.index = pd.to_datetime(dt_corr.index, format='%Y/%m-%d')    #####why appears format green here ????? i don't get it
dt_corr

The index in any output is always like this: 1970-01-01 00:00:00.000033417 ##last for digits differ
I cannot coerce my index to datetime, to finally reasample my data and plot it. The format parameter doesn't change anything and appears in green in my codeline. What can I do?

asked May 03 '20 at 18:52

Jonas Apelt

What is the value of `dt_corr.index` before you try to format it? – Guy Incognito May 03 '20 at 19:04
its's like 2019-12-29 – Jonas Apelt May 03 '20 at 19:18
Well that doesn't match the `%Y/%m-%d` pattern does it? – Guy Incognito May 03 '20 at 19:22
What is the right pattern though? So far I tried plenty of. But doesn't change it. – Jonas Apelt May 03 '20 at 19:28
If you have a year (`%Y`), month (`%m`) and day (`%d`) each separated by dashes (`-`) the pattern is `%Y-%m-%d` – Guy Incognito May 03 '20 at 19:32
I actually tried this, but the problem remains. – Jonas Apelt May 03 '20 at 19:41

pd.to_datetime output is 1970-01-01 00:00:00.0000

0 Answers0

Linked