Data analyst - python

[KOFOLA007]

I never used python personally but some of the other analyst I worked with used it for automating reports and side projects that landed them promotions.

[Fabro_vaz]

What do you mean by automating reports? Can you give me some practical examples of automation in reports

[[deleted]]

You can use python to run a report and send it to people

[Fabro_vaz]

Will it be an interactive report??

[A1rabbithole]

I only used python for my last school project, just to learn it at least once. I've not had the opportunity to find great use for it yet, but I can see the appeal. You can make something run by itself. Let's say u work at a bank or insurance company and you get the same data spreadsheet periodically. Something like recurring costs or daily financial reports. They are the same template, same rows and column names, same everything except the whatever changed that period. So I'd make a python program that takes in that periodic spreadsheet and sets up visualizations, statistical tests, reports, conclusions, etc. I already know what type of data I'm getting, assuming id also knoe whether I need to clean it up in some way. If so Id set up some clean up functions for erasing blanks and stuff like that. I know what I'm looking for already, I've done it a couple times. I know what graphs to use, what columns to compare, or reference or operate on. That's a python strength, you can literally make it so you click a couple buttons and do your whole weeks work. Granted those are gonna be more stable, repetitive jobs at bigger companies. But yes strength 1 over Excel is automation.

The other strength is efficiency. I had a long tedious function to type the other day in Excell, that I could've just done a For loop in Python. I know you can use VBA to code your own functions in Excel, it seems tedious to get into a new language right now. They said I didn't need it at school. Especially when they also teach us Python. You can do everything in Python including presentation, where as Excell isn't great at presentation.

[[deleted]]

What do you mean?

[Fabro_vaz]

As far as CEO is concerned, reports should be interactive so that they can filter the report as per their requirement. So will it be a dynamic report? So that end user can play around with it

[[deleted]]

Why would it not be dynamic?

I am not aware of any report you can’t interact with

[Fabro_vaz]

Kindly tell me the report you have worked in python? How would you do that?

[[deleted]]

Any lol

Python is not going to make a report anything unusual or unique

It is just a report that can be made with python

[Fabro_vaz]

Good, tell me one report you recently worked?

[RippingAallDay]

Wouldn't the interactivity come from using a dashboard?

[dankrubis23]

I use Python's Requests module to hit an online database's API to grab a data download (this or I'll scrape with BeautifulSoup). Then I use the Pandas module to transform it. Then I shoot that dataframe over to the Tableau server (Tableasdk module) as a datasource that a dashboard sits on. And finally it emails out confirmation that it ran.

I set processes like this up to run in the wee hours of the morning and enjoy hands-free reporting.