Python is a good scripting language for that purpose. SQL is also helpful (AFAIK). Where to learn all about data wrangling? Are there books, courses, tutorials?
What other tools or languages can one learn for the purpose?
(Specifically the "transform" part.)