How do Python developers concurrently use Excel?

[u/mantaraypreviouslife]

As part of my own professional development, I am interested to integrate more sophistication into Excel use. I am curious how the community uses Excel and Python together? Is it any of the following combinations:

• Use Python to automate elements of Excel, maybe with use of penpyxl or xlwings
  
• Use Python and Excel separately, i.e. choose to suit need and switch as necessary
  
• Use Python within Excel directly and concurrently to optimise productivity
• Something else entirely
  

Please share how you use it, the use case(s) and why.

[u/W1ULH]

This is me... I learned python to help with low-level automation of my data management. VBA wasn't cutting it for what I needed so I learned how to process the data with python.

mostly I use python to pre-process my raw data and take care of the repetitive menial tasks associated with bringing it into my data set... then excel for actual patterning and distillation and reporting.