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