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
Last activity: Jan 9, 2021, 06:40 PM