I need help to automatize a very boring task with Python
I work as a digital marketer and often find myself having to clean and normalize data in Excel so I can import it to our company’s CRM.
Basically, I have to check the data in certain cells of the spreadsheet and perform lots of Search & Replace operations; always with the same kind of data.
For example, I’ve got a ‘role’ column with values in French and I have to translate them into Spanish:
- Enseignant -> Profesor
- Coordinateur -> Coordinador
- Directeur -> Director
- Autre -> Otros
It’s quite a boring job and I’m sure that Python could help me automatize it, but I’m just a beginner coder and can’t do it on my own yet.
Could anyone give me a hand to just start out?
Thanks a lot in advance