Python pandas Excel

dn PythonList at DancesWithMice.info
Fri Jul 17 17:08:50 EDT 2020


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 you importing the Excel data into the Python environment?
Are you able to import a single cell's value, eg "01/11/2017 00:00"
Assuming the import produces a string, are you able to "slice" the 
string into the requisite components?
-- 
Regards =dn


More information about the Python-list mailing list