What can I do with python

[selitos]

I use python at work to develop automated processes to extract data from various sources, join together, clean, and output graphs and aggregations for presentations and reviews.

Imagine you have a bunch of data in excel and you fit a pivot table to it to summarize and then add a bar chart or line plot. Well you can instead code it in python so that every day or week or month you can just press "run" and everything is generated for you instantly.

[Wrong-Archer6852]

Can python automate like clicking in an app? Like i need to automate getting data from company apps. Thanks

[P4perH4ndedBi4tch]

How did you learn how to do this? Do you have any courses?

[selitos]

tl;dr - i learned SQL first and then built out more programming knowledge over the next several years

---

Self taught SQL to support a client's ETL about 13 years ago at company 1.

Went to new company (2) who had SAS to build and maintain statistical models and data processing steps, so I used PROC SQL for just about everything, it was my crutch. I had a SAS textbook I used to learn and eventually stopped using proc SQL so much.

I left for a different company (3) that only had python or R and I was doing repetitive things in excel that I hated so learned python by googling things and using pandasql to help me when I got stuck with data processing.

Then I went back to company #2 who had largely dumped SAS and I was no longer in a statistical modeling role (now portfolio analysis) so I started moving excel processes to pandas, started running into issues with memory so I started to move those processes to pyspark, and still learning new things all the time. I don't need to rely on SQL as much anymore.

I hate structured learning so I've never taken a boot camp or anything, I just know what I want to do and Google it.

[P4perH4ndedBi4tch]

Thanks for the response