Search Results

Search: Posts Made By: SwethaGorantla
20,231
Posted By SwethaGorantla
I could resolve my issue using awk
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
29,574
Posted By SwethaGorantla
How to merge data in 2 csv files using shell script?
csv1:

StoreID Emailcount

2000 3

2001 2


csv2:

StoreID Slotcount

2000 100

2001 120

Output required as below
StoreID ...
20,231
Posted By SwethaGorantla
Pivot table for data in CSV file using shell script
IFS=","
while read f1 f2
do
awk -F, '{ A[$1]+=$2 } END { OFS=","; for (x in A) print x,A[x]; }'
20,231
Posted By SwethaGorantla
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|...
Showing results 1 to 4 of 4

 
All times are GMT -4. The time now is 07:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy