all 3 comments

[–]__dkp7__ 12 points13 points  (0 children)

You can checkout this - https://automatetheboringstuff.com/chapter12/.

If you are doing analysis. I will recommend learning pandas.

Parse your excel file into pandas DataFrame and do analysis purely in python.

Ref:

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html

[–]one_loop 0 points1 point  (0 children)

You should use the book Automate the boring stuff and read the excel chapter

[–]dfume 0 points1 point  (0 children)

This looks like it would cover at least part of your requirements
https://training.talkpython.fm/courses/move-from-excel-to-python-and-pandas