I am trying to manipulate a big data set, but I will use a simple example here. I am trying to add two columns to form a third column.
Input CSV
1,11
2,12
3,13
4,14
5,15
Desired Output CSV
1,11,12
2,12,14
3,13,16
4,14,18
5,15,20
I have been trying the below line and I am getting the wrong output.
awk -F, '{$3=$1+$2;} {print $1,$2,$3}' OFS=, filename.csv