The real problem in this story was never the data. The real problem was the distinction between cleaning and automating, and the frustration is justified. Power Query is a useful tool for tidying up a messy spreadsheet, but it still leaves the human stuck in the loop: download, open, refresh, check, copy, email. That is not a workflow. That is a weekly ritual of manual labor dressed up as a solution. The author learned Python and pandas not because they wanted to become a programmer, but because they wanted the work to disappear. That is the point people keep missing.
When someone says "Power Query is good enough," they are comparing tools that do not do the same job. A broom is good at sweeping, but it will never vacuum the carpet. Cleaning tools are not worthless. They are saying that if your goal is to have the report sent before the agency owner wakes up on Friday, then a cleaning tool is the wrong frame entirely. Automation means the script runs, the PDF is generated, and the email is sent. No one opens a file. No one refreshes a query. The hours saved are not a side benefit. They are the entire product.
The resistance the author encountered is familiar. People hear "Python" and assume it is for complex data science projects, when in practice the author used it to solve a boring, repetitive problem that should have been solved years ago. That is not a technical challenge. That is a mindset issue. The author did not waste time learning a new skill for the sake of it. They invested in a tool that matches the job, and the job was automation, not cleaning.
The practical takeaway for anyone still stuck in the copy-paste cycle is simple: stop asking which cleaning tool is better and start asking which step of the process you want to eliminate entirely. If you are manually downloading exports and emailing reports, you are not doing data work. You are doing data entry with a nicer interface. This is not about Python versus Power Query. It is about recognizing that a broom will never be a vacuum cleaner, and there is no shame in wanting a robot to do the sweeping.