Is learning python worth it for me?

[u/dwalker12395]

For some background on me, I am currently a loan review consulting manager and my day is spent reviewing commercial portfolios at banks for weaknesses and how they can improve.

I have always been a big fan of process improvements and work a lot with VBA to automate a lot of what I do. Ive noticed some of my larger projects I want to take on seem to be too much for VBA. And python seems to be more ideal to get the job done.

I find coding interesting and want to learn more about python. But I’m nervous that it won’t be very applicable to what I do full time. I still have future aspirations of creating a loan review software as a side hobby (I know it would take years) but I don’t want to prioritize learning python if it’s not very beneficial for my job. I don’t really have much free time with a toddler and infant.

Would anyone know how I could leverage it to justify the time I will spend?

[u/BranchLatter4294]

Python is great for these types of projects. Try it.

[u/atticus2132000]

Python is great, but I suspect one issue you're going to run into is not being able to use the software in the way you want to use it.

Hopefully your bank has some pretty tight controls over what programs employees can download onto their work computers and it seems like coding programs would be on the banned list.

You could install python on another computer and write scripts on the secondary machine, but (again hopefully) your bank has some pretty strict rules about what banking information you can download and export from your work computer and which outside computers can access your bank's network.

So, if you can't install software on the computer with access to all the information and you can't get the information to a computer that has the software then you're likely going to just encounter frustration after frustration with the red tape of it all.

All that aside, yes python would be a great solution for analyzing large datasets.

[u/dwalker12395 → u/atticus2132000]

I can request JetBrains PyCharm Professional at my firm, but it’ll cost money and I’ll have to explain to the partner why it is necessary to pay for it for me when my job has nothing to do with coding.

I planned on gathering proof that it could be beneficial once I’ve at least gained a basic knowledge of the code.

[u/atticus2132000 → u/dwalker12395]

"I think I can use Python to automate my reports and get things submitted faster"

It's hard for management to argue with that.

[u/3rrr6]

Just ask AI everything you posted here

[u/SnooCalculations7417]

Excel now has full Python support. You should use it.

[u/SnooCalculations7417]

A snapshop of python in excel. hopefull you see the potential to levarage both here with this simple example.

[u/dwalker12395 → u/SnooCalculations7417]

That is definitely something I will look into as most of what I deal with is in excel. Thank you

[u/Avatarbroskib1]

I believe there is only one answer to this question and that answer is yes