Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Add the values in second and third columns with group by on first column.
Top Forums Shell Programming and Scripting Add the values in second and third columns with group by on first column. Post 302770018 by pamu on Thursday 14th of February 2013 07:31:40 AM
Old 02-14-2013
Quote:
Originally Posted by angshuman
I just need to make a small change to it so that the last filed in the out put always displays two decimal places.
try this..

Code:
awk -F "|" '{A[$1]+=$2;B[$1]+=$3;}END{for(i in A){printf "%s|%s|%0.02f\n", i,A[i],B[i]}}' file

Quote:
Originally Posted by angshuman
May I request your help on this and can I request you to explain the code?
Code:
awk -F "|" '{    # Define | as a Field Separator
A[$1]+=$2;        # Add $2 to the array A having index of $1
B[$1]+=$3;}        # Add $3 to the array B having index of $1
END{for(i in A)    # Get all the indexes of array A in i

{printf "%s|%s|%0.02f\n", i,A[i],B[i]}}' file        # Print i(means $1),A[i](means sum of all $2 for the particular $1),B[i](means sum of all $3 for the particular $1). Used 0.02f here for floating purpose.

Hope this helps you.

Regards,

pamu
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies

2. Shell Programming and Scripting

how to flip values of two columns and add an extra column

Hi guys, Couldn't find the solution of this problem. Please Help! I have a file- Input_File TC200232 92 30 TC215306 2 74 TC210135 42 14 I want an output file in which if column2>column3, the values are swapped and an additional column with value Rev_Com is... (4 Replies)
Discussion started by: smriti_shridhar
4 Replies

3. Shell Programming and Scripting

Merge group numbers and add a column containing group names

I have a file in the following format. Groups of data merge together and the group number is indicated above each group. 1 adrf dfgr dfg 2 dfgr dfgr 3 dfef dfr fd 4 fgrt fgr fgg 5 fgrt fgr (3 Replies)
Discussion started by: Lucky Ali
3 Replies

4. Shell Programming and Scripting

Merge group numbers and add a column containing group names

Hi All I do have a file like this with 6 columns. Groups of data merge together and the group number is indicated above each group. 1 1 12 26 289 3.2e-027 GCGTATGGCGGC 2 12 26 215 6.7e+006 TTCCACCTTTTG 3 9 26 175 ... (1 Reply)
Discussion started by: Lucky Ali
1 Replies

5. Shell Programming and Scripting

Sum up the column values group by using some field

12-11-2012,PNL,158406 12-11-2012,RISK,4564 12-11-2012,VAR_1D,310101 12-11-2012,VAR_10D,310101 12-11-2012,CB,866 12-11-2012,STR_VAR_1D,298494 12-11-2012,STR_VAR_10D,309623 09-11-2012,PNL,1024106 09-11-2012,RISK,4565 09-11-2012,VAR_1D,317211 09-11-2012,VAR_10D,317211 09-11-2012,CB,985... (7 Replies)
Discussion started by: manas_ranjan
7 Replies

6. Shell Programming and Scripting

Average of columns with values of other column with same name

I have a lot of input files that have the following form: Sample Cq Sample Cq Sample Cq Sample Cq Sample Cq 1WBIN 23.45 1WBIN 23.45 1CVSIN 23.96 1CVSIN 23.14 S1 31.37 1WBIN 23.53 1WBIN 23.53 1CVSIN 23.81 1CVSIN 23.24 S1 31.49 1WBIN 24.55 1WBIN 24.55 1CVSIN 23.86 1CVSIN 23.24 S1 31.74 ... (3 Replies)
Discussion started by: isildur1234
3 Replies

7. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies

8. Shell Programming and Scripting

Splitting the numeric vs alpha values in a column to distinct columns

How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns: So if the source file had a column like: Value: |1 | |2.3| | | |No| I would... (7 Replies)
Discussion started by: driftlogic
7 Replies

9. UNIX for Beginners Questions & Answers

Group by columns and add sum in new columns

Dear Experts, I have input file which is comma separated, has 4 columns like below, BRAND,COUNTRY,MODEL,COUNT NIKE,USA,DUMMY,5 NIKE,USA,ORIGINAL,10 PUMA,FRANCE,DUMMY,20 PUMA,FRANCE,ORIGINAL,15 ADIDAS,ITALY,DUMMY,50 ADIDAS,ITALY,ORIGINAL,50 SPIKE,CHINA,DUMMY,1O And expected output add... (2 Replies)
Discussion started by: ricky1991
2 Replies

10. UNIX for Beginners Questions & Answers

Copy columns from one file into another and get sum of column values and row count

I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv abc.csv- UTF-8,,,,,,,,,,,,,,,,,,,,,,,,, ... (6 Replies)
Discussion started by: Tahir_M
6 Replies

LEARN ABOUT DEBIAN

pclock

PCLOCK(1)						      General Commands Manual							 PCLOCK(1)

NAME

       pclock - pixmap clock

SYNOPSIS

       pclock [options]

DESCRIPTION

       This  manual  page  documents  briefly  the pclock command.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

       pclock is a program that places a small analog clock program on the desktop of X.  It was designed to run under the WindowMaker window man-
       ager.  It uses any 64x64 pixmap as a background.

OPTIONS

       The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
       dash.  A summary of options is included below.

       -B PIXMAP, --background=PIXMAP
	      Use the given pixmap as the clock background (size must be 64x64).

       -H COLOR, --hands-color=COLOR
	      Draw the hands (hour, minute and second) in the specified color.

       -S COLOR, --second-hand-color
	      Draw the second hand in the specified color

       -h, --help
	      Show summary of options.

       --hour-hand-length=INT
	      Draw the hour hand with the specified length of INT.

       --minute-hand-length=INT
	      Draw the minute hand with the specified length of INT.

       --second-hand-length=INT
	      Draw the second hand with the specified length of INT.

       --second-hand-width=INT
	      Draw the minute hand with the specified width of INT.

       -s, --second-hand
	      Don't display the second hand.

       -v, --version
	      Show version of program.

       -w, --withdrawn
	      Don't start up in a withdrawn (iconic) state.

AUTHOR

       This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others).	The  soft-
       ware is copyrighted (c) 1998 by and released under the GPL v2.

       Author: Alexander Kourakos <Alexander@Kourakos.com>
	  Web: http://www.kourakos.com/~awk/pclock/

																	 PCLOCK(1)
All times are GMT -4. The time now is 05:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy