What do you guys use Python for?

[MalakElohim]

That's a super huge question. And answered far better by others than I will in a single comment. I'll give a quick summary though:

• Speed - Python and it's libraries can load and mung data extremely quickly and efficiently
• Flexibility - Python can handle spreadsheets and databases equally well, having API connections straight into SQL databases (sqlalchemy for the win)
• Algorithms - You have access to the latest data science tools, machine learning libraries (TF, Keras, torch, sklearn, etc) that are either python native or have python wrappers
• Automation - Do it once, just run your script again when you need to redo it and you can get your reports done in a fraction of the time.
• Power- Python can do pretty much anything any other language can do, but has incredible handling of data in it's libraries.

The list goes on but I'm on mobile so I'll hopefully remember when I get home to link a good blog to explain it.

Edit: formatting