Sample Header Ad - 728x90

BASH: AWK pivot CSV into desired table

4 votes
2 answers
2413 views
I have been struggling with pivoting .csv file into desired table format using bash. My file o/p:
$ cat finalcount.csv
state,status,count
NW,CONGESTED,11
NW,CLEARED,9
ACT,CLEARED,7
ACT,CONGESTED,7
QLD,CLEARED,5
WA,CONGESTED,3
WA,CLEARED,2
VIC,CLEARED,3
VIC,CONGESTED,2
My desired o/p:
State   Congested  Cleared
ACT     7          7
NW      11         9
VIC     2          3
QLD     -          5
Please share your answer with explanation.
Asked by user8421137 (51 rep)
Dec 13, 2019, 09:19 PM
Last activity: Jan 9, 2021, 06:40 PM