I have several fairly large csv files that I need to sum the values of each column in and transpose the column header.
Sample csv:
col1,col2,col3
enabled,disabled,active
disabled,disabled,enabled
N/A,enabled,active
enabled,N/A,disabled
Desired output:
col1,2 enabled,1 disabled,1 N/A
col2,1 enabled,2 disabled,1 N/A
col3,1 enabled,1 disabled,2 active
The actual csv has a lot more columns and rows so it would be preferable that it is able to iterate the file automatically. I could probably come up with some hack job of an awk program to do one column at a time but would prefer to be able to the entire file at once and don't know where to start with that. The output doesn't need to be in the exact format I've included but at least similar.