I'll be having a look at your code to get ideas. I'll see if it runs on Linux.
I tend to play around with scripts using Jupyter Notebook as I can easily tweak them. I can dump to a normal py file if it's stable. I'm using Visual Studio Code at work, but have tried Pycharm before.
Python has libraries for everything and the ones for Hive make it easy to do lots of things.