Also check out Data Wrangler. http://vis.stanford.edu/wrangler/

It focuses on more mechanical transformations but has the ability to save the steps to a program which you can then use in a process pipeline.

(disclaimer, I haven't played with it in a few months so this is from memory)