ramkrishna-12/shipment_error ? reverse-engineered prompt

Build me a Python project that cleans up messy e commerce order data and turns it into one final analytics ready CSV.

I want it to take separate orders, products, and shipments files, fix common issues like duplicate order IDs, weird date formats, Excel serial dates, missing values, bad quantities, and currency formatting problems, then merge everything into one clean dataset. It should also calculate revenue from quantity times unit price paid, and handle shipment aggregation so the final output doesn’t create duplicate rows.

Please split the work into a simple cleaning step and a merge step, and make it easy to run from the command line. I’d also like a pipeline script that runs the whole flow end to end, plus GitHub Actions so the job can run automatically in CI and save the generated output as an artifact.

If you need to, look up current docs online for anything tricky, but keep the code straightforward and practical.