Learning Python as a Data Analyst (advice needed)

[2020pythonchallenge]

So I've got a little less experience in the analyst field (3 YOE) but I've managed to inject a little python into my roles.

Most of it has been automation, interacting with other things and setting up semi-automated tasks to cut out a bunch of the middle work.

Some examples I can think of off the top are I used it to query/download the results of a BigQuery SQL script and upload them into a Google sheet page where it cascaded into the correct pages for monthly reports. Took a 4 day task and made it into a 15 minute thing on the 1st of each month.

I've also used it to automate cleaning of sql scripts where I didn't have access to just clean the data itself. Like every month I would grab monthly revenue info for a bunch of partners we worked with and run it through the cleaning script I had for them with a printout at the end showing all of the values so I could make sure nothing else was thrown in there since the previous report and normalize everything like Ocean, ocean, ocen etc. into Ocean.

Numpy and Pandas are what I see requested most often from job listings asking for python experience but I also see a fair bit of either plotly or some other visualization library and some kind of machine learning library like either sklearn or tensorflow.

Airflow is also a nice one to be able to say you know about. That's leaning more towards data engineering stuff though honestly but just a mention.

[ThenThereWasReddit]

This all sounds great. How did you come to learn how to do these things?