Can somebody explain the advantage of doing it on the command line vs in Python or R? What would a practical use case look like?
Why not just do it all in Python or R? That way you also get something that will probably work on non-unix platforms.
I like to use command line tools for for one-off tasks that I'm unlikely to repeat. If there's a task I know I'll need to repeat or is too cumbersome to do in a couple of lines, I'll reach for Python.