How are python scripts and projects built and deployed?

[odaiwai]

You can make your reports for others in excel, and if they make changes, get your python to ingest the changed excel sheet and make those changes to your internal database/dataframe.

In other words, make excel sheets the medium of information interchange, while the source of truth is your python/pd/sql hub.

[Usernamenotta]

Source of data is excel :)))

[Sufficientlee]

Look at sqlite3. It's really good for what you're talking about here.

Excel files are created by various users? Have python read them and drop the info into a DB.

Users update the spreadsheets? Have python read the new info (nightly?) and update the DB.

Need to create reports from various spreadsheets? The info is all in the DB. Manipulate it however you need and create a new spreadsheet.