Manipulate data in CSV file using Shell script

HI,
Can you guys please help me in creating Pivot table for below data using shell script?

Location_id| Effective_date| Picking_limit     
------- | ---------------- | ----------:
2000| 04/04/2020| 120
2001|  04/04/2020| 130
2002| 04/04/2020 | 150
2003| 04/04/2020| 100
2001| 04/04/2020| 140

I want output as below

Location_id| Picking_Limit    
------- | ---------------- :
2000| 120
2001|  170
2002| 150
2003| 100

Basically i prepared a pivot table for location id. Where ever location id is same i am adding value of picking limit and wanted to write in a new csv file.

Thanks,
Swetha. G

IFS=","
while read f1 f2
do
awk -F, '{ A[$1]+=$2 } END { OFS=","; for (x in A) print x,A[x]; }'

Any attempts / ideas / thoughts from your side? Did you search these forums?

IFS=","
while read f1 f2
do
awk -F, '{ A[$1]+=$2 } END { OFS=","; for (x in A) print x,A[x]; }' > /home/ec2-user/slotslatest.csv
done < Storewiseslots.csv