[thablackbull]

The problem is that non-tech people have the exact opposite problem of what you experienced.

> copying some of the data into a new Excel file without making any mistakes (and that includes Excel not reformating your data to something else, like a dd-mm-yyyy to mm-dd-yyyy or making a date out of your Gene names

In your typical office environment, your regular analyst will run into issues where the date formatting is different between files, and there are one-off errors or issues here and there. In Excel, they are able to scan through and adjust as necessary. If you're asking them to figure out how to write the code to re-map and fix random issues in the data, that will be much more complicated to learn.

[teekert]

Yeah, this is probably true for many people. Still, I always offered people that click around in Excel all day a session with me to see what aspects we could automate. There is always a lot, but it never really sticks. Indeed, it is that dealing with edge case stuff.

I admit I did a lot of data.to_excel() -> fix some stuff and then -> pd.read_excel() again back in the day...