I have a HUGE amount of respect for the people on this forum, so I thought maybe I could get your opinions to see how far off the mark I am.

I work in an environment which is becoming increasingly riddled with data scientists. The kind who are in their early-mid 20's and have multiple PHD's. The kind who discuss progress in the neural networks they're programming at home in their spare time. They're everywhere.

The rest of us are being pressed to pick up Python - many of whom are 'getting it' after just series of online tutorials. Many others, like myself, are not. I find it horribly unintuitive and struggle to get even the basic entry level stuff to work without hours of rage inducing focus. I've done numerous tutorials, watched videos, and posted on Python forums, and am really having a hard time. VBA is so much more readable and logical to me.

The only advantage I see with Python is that it can handle large files much more quickly (I'm not talking about using it for deep machine learning here, just processing basic data). I suppose having access to the libraries is nice, but how do you even know what's in them? Ugh.

Anyway, I'm just wondering if the challenges in converting your thinking from VBA to Python has left any of you bewildered, confused, and humiliated, as it has for me. Or have you been able to pick it up and do anything useful with it?

Thanks for any input!