Python Pandas split Date in day month year and hour
Brian Oney
brian.j.oney at googlemail.com
Wed Aug 19 14:00:39 EDT 2020
On August 19, 2020 7:32:45 PM GMT+02:00, J Conrado <jorge.conforte at inpe.br> wrote:
>
>
>Hi,
>
>
>I'm satarting using Pandas to read excel. I have a meteorological
>synoptic data and I have for date:
>
>
>0 2017-11-01 00:00:00
>1 2017-11-01 03:00:00
>2 2017-11-01 06:00:00
>3 2017-11-01 09:00:00
>4 2017-11-01 12:00:00
>.. ...
>229 2017-11-30 09:00:00
>230 2017-11-30 12:00:00
>231 2017-11-30 15:00:00
>232 2017-11-30 18:00:00
>233 2017-11-30 21:00:00
>
>
>I would like know how can I get for this array the values for day, month
>and hour:
>
>2017-11-01 03:00:00 year = 2017 month = 11 day = 1 and
> hour = 3
>
From the hip, I would use the strptime function (in the time module?)
time.strptime(string_value, '%F %T')
If I recall correctly, the doc for the specific strings is in the strptime function's doc.
This is just a starting point. Good luck!
HTH
More information about the Python-list
mailing list