You are so right about data cleaning. That’s why I use Perl one liners to do part of job and do some in python and then do some in R. It’s all a process and heavily depends on dataset. I did create some modules in both r and python to make process easier. It’s all data exploration. Sometimes if I cleaned wrongly I realize at analysis stage, it’s good to be able to go back and repeat steps.