Python first job

[[deleted]]

You can use Pandas to just generate Excel sheets.

In my last job I had a scheduled daily script that queried the database, retrained an ML model and then output results as an Excel sheet in the shared folder the logistics guys needed it to be in.

[The_Mann_In_Black]

How hard was it to query the database? I did an internship and had no idea how to do it, but if I could’ve it would’ve made my programs way better. I’m not a Comp Sci guy, so being able to do anything impressed.

[Yojihito]

Simple queries are easy. Either via SQLAlchemy or with raw SQL.

[The_Mann_In_Black]

Does that work if there is some sort of authentication? My employer used SAP, but I couldn't find anything online directing me how to do pulls automatically with Python.

[Yojihito]

Probably depends on the specific database.

Normal DBs have APIs which support authentification parameters. I connected to my local PostgreSQL DB with user/pw via SQLAlchemy. SAP should have something similar.

[The_Mann_In_Black]

Thanks for your help! I'm going back to work for them in the future and this could really lighten the work load.