I’m an actuarie and a Linux user at home. At work I’m forced to use excel but I do everything I can on python.
I think Microsoft recently introduced Python support in Excel, so maybe you can combine both.
As far as I know, the only thing that the new python integration helps with is that users don’t have to install Python or have to know how to use pip to install packages like pandas, because Python doesn’t run locally. It is neat how you can visualize data and show it inline with the Excel document though. My industry is very regulated, so we won’t be able to use it since the data you pass to Python goes to Azure for processing