How to read date from an excel file in python?

Question

I have an excel file that its first column is written as 31.12.2018 23.30 and it continues for a year. how can I convert this in python in order to change it in a way that I could get the year, month, day, and hour separately. I want to use it for a machine learning project to see whether my time series data is stationary or non_stationary.

and assuming you already read it, do you get the formatted date ("31.12.18 23:30") or the "serial" Excel date value, where the integer part is the number of days from 01.01.1900 and the decimal part is the time? — gimix
– gimix, Commented Jul 1, 2021 at 13:22
You should take a look at pandas library. That would be the best way to achieve what you are trying to do. — Frederic Perron
– Frederic Perron, Commented Jul 1, 2021 at 20:31
thanks for helping ... actually I want to have a separate array for the month and another array for the year and another for the day after importing the column from excel into python — Maryam4747
– Maryam4747, Commented Jul 2, 2021 at 11:47

HostedPosted · Accepted Answer · 2021-07-01 14:02:42Z

1

You can use openpyxl.

You can load an excel sheet using it and get data from it.

Example:

>>> from openpyxl import load_workbook
>>> wb2 = load_workbook("file.xlsx")
>>> print(wb2.sheetnames)
['Sheet2', 'New Title', 'Sheet1']

answered Jul 1, 2021 at 14:02

HostedPosted

881 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read date from an excel file in python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related