Re: Python pandas Excel

2020-07-18 Thread Peter Otten
J Conrado wrote: > > > > > > > > > > > > HI, > > > I have an excel file with several columns, the first day/month,/year and > hour: > > > Data > 01/11/2017 00:00 > 01/11/2017 03:00 > 01/11/2017 06:00 > 01/11/2017 09:00 > 01/11/2017 12:00 > 01/11/2017 15:00 > 01/11/2017 18:00 > 01/11

Re: Python pandas Excel

2020-07-17 Thread dn via Python-list
On 18/07/20 11:06 AM, Dennis Lee Bieber wrote: On Sat, 18 Jul 2020 09:08:50 +1200, dn via Python-list declaimed the following: Assuming the import produces a string, are you able to "slice" the string into the requisite components? Given the OP's stated output -- I would suspect they

Re: Python pandas Excel

2020-07-17 Thread dn via Python-list
On 18/07/20 3:36 AM, J Conrado wrote: HI, I have an excel file with several columns, the first day/month,/year and hour: Data 01/11/2017 00:00 01/11/2017 03:00 ... Please, how can I get four arrays for day, month, year and hour this column of my excel. What do you have so-far? How are y

Python pandas Excel

2020-07-17 Thread J Conrado
HI, I have an excel file with several columns, the first day/month,/year and hour: Data 01/11/2017 00:00 01/11/2017 03:00 01/11/2017 06:00 01/11/2017 09:00 01/11/2017 12:00 01/11/2017 15:00 01/11/2017 18:00 01/11/2017 21:00 02/11/2017 00:00 02/11/2017 03:00 02/11/2017 06:00 02/11/