On August 19, 2020 7:32:45 PM GMT+02:00, J Conrado <jorge.confo...@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 -- https://mail.python.org/mailman/listinfo/python-list