csvedit

README

csvedit

A util that parses csv data and provides some basic editing. Because no one likes complicated regexes to deal with escaped commas when you have csvs with untrusted data.

Operations

• grep foo bar filters for rows where the column foo contains the substring bar
• grepv foo bar filters for rows where the column foo does not contain the substring bar
• cut foo removes all other columns, and returns column foo
• shuffle foo moves columns foo (and the others to the back) of the row
• sort foo stable sorts the rows by foo lexically
• sorti foo stable sorts the rows by foo as integers
• sortf foo stable sorts the rows by foo as floats

Multiple columns can be provided to cut, shuffle, sort, sorti, sortf by separating the names with a comma.

If multiple columns are provided to a sort, then the first column will always be sorted, and for tied values on the first column it will use the second column, and so on.

Example usage:

% cat samples/abc.csv | csvedit grepv B e
A,B,C
a,b,c
1,2,3
uno,dos,tres
% cat samples/abc.csv | csvedit grepv B e shuffle B,A
B,A,C
b,a,c
2,1,3
dos,uno,tres
% cat samples/abc.csv | csvedit grepv B e cut B,A    
B,A
b,a
2,1
dos,uno
% cat samples/nums.csv | csvedit sort English
Numeric,English
5,five
4,four
1,one
7,seven
77,seventy seven
6,six
66,sixty six
3,three
12,twelve
2,two
% cat samples/nums.csv | csvedit sorti Numeric
Numeric,English
1,one
2,two
3,three
4,four
5,five
6,six
7,seven
12,twelve
66,sixty six
77,seventy seven
% cat samples/abc.csv | csvedit join samples/abc_join.csv "A,D"
A,B,C,E,F
a,b,c,amanda,fun stuff
a,b,c,bobby,boring stuff
do,re,mi,charlotte,exciting stuff
alpha,beta,gamma,derek,sleepy stuff
alpha,beta,gamma,ela,alarming stuff
% cat samples/abc_join.csv | csvedit compact D
D,E,F
a,amanda,fun stuff
alpha,derek,sleepy stuff
do,charlotte,exciting stuff
exclusion,charlotte,exciting stuff
% cat samples/abc.csv | csvedit join samples/nums.csv "" | wc -l # this does a cartesian product of all records, so it can be used to add columns to all rows if only one row is present in the second csv
51
% cat samples/abc.csv | csvedit drop A          
B,C
b,c
2,3
re,mi
beta,gamma
dos,tres
% cat samples/abc.csv | csvedit rename A,B X,Y
X,Y,C
a,b,c
1,2,3
do,re,mi
alpha,beta,gamma
uno,dos,tres