For file-based workflows I made https://github.com/micans/pick — a command line tool to select from and modify text tables using column names. It’s robust (no more
cut
!), expressive (can replace entire scripts) and efficient (streaming; no need to load entire tables). I use it every day — I’m glued to the command line and try to avoid Python and R prompts.