Created by: qauge
What about adding a csvsed utility to csvkit?
I think the name speaks for itself. Here is a short example:
$ cat sample.csv \
| csvsed -c Wage -m s/,//g \ # remove commas from the Wage column
| csvsed -c Status -m 'y/A-Z/a-z/' \ # convert Status to all lowercase
| csvsed -c Status -m 's/.*(ok|good).*/\1/' # restrict to keywords 'ok' & 'good'
The code (GPL) is adapted from https://github.com/metagriffin/csvsed with the authorization of its original author (metagriffin).
csvkit is amazing, by the way. I used it intensively during the last year. Thank you!