Want the UNIX code - I want to sum of the 1st column wherever the first 2nd and 3rd columns r equal Post: 302930041

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Want the UNIX code - I want to sum of the 1st column wherever the first 2nd and 3rd columns r equal Post 302930041 by senhia83 on Monday 29th of December 2014 07:17:29 PM

12-29-2014

Registered User

Try

Code:

 
 awk '{arr[$2" "$3]+=$1} END {for (i in arr) {print arr[i],i}}'  infile

Your example

Code:

 
 $ cat > tmp1
 8859 0 subscriberCreate
 18 0 subscriberPaymentMethodChange
 1650 0 subscriberProfileUpdate
 7668 0 subscriberStatusChange
 13 4020100 subscriberProfileUpdate
 1 4020129 subscriberStatusChange
 2 4020307 subscriberCreate
 8831 0 subscriberCreate
 14 0 subscriberPaymentMethodChange
 1570 0 subscriberProfileUpdate
 7878 0 subscriberStatusChange
 12 4020100 subscriberProfileUpdate
 1 4020129 subscriberStatusChange
  
 $ awk '{arr[$2" "$3]+=$1} END {for (i in arr) {print arr[i],i}}' tmp1
 32 0 subscriberPaymentMethodChange
 17690 0 subscriberCreate
 2 4020307 subscriberCreate
 15546 0 subscriberStatusChange
 3220 0 subscriberProfileUpdate
 25 4020100 subscriberProfileUpdate
 2 4020129 subscriberStatusChange

This User Gave Thanks to senhia83 For This Post:

senhia83

View Public Profile for senhia83

Find all posts by senhia83

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help sum columns by break in first column with awk or sed or something.

I have some data that is something like this? item: onhand counted location ITEM0001 1 0 a1 ITEM0001 0 1 a2 ITEM0002 5 0 b5 ITEM0002 0 6 c1 I want to sum up...

2. Shell Programming and Scripting

sum multiple columns based on column value

i have a file - it will be in sorted order on column 1 abc 0 1 abc 2 3 abc 3 5 def 1 7 def 0 1 -------- i'd like (awk maybe?) to get the results (any ideas)??? abc 5 9 def 1 8

3. Shell Programming and Scripting

grep data on 2nd line and 3rd column

How do I grep/check the on-hand value on the second line of show_prod script below? In this case it's a "3". So if it's > 0, then run_this, otherwise, quit. > ./show_prod Product Status Onhand Price shoe OK 3 1.1

4. Shell Programming and Scripting

split on the basis of 2nd and 3rd column

file A aa 22 48 ab 22 48 tcf 50 76 gf 50 76 h 89 100 yh 89 100 how can we split the file on the basis of common 2 and third column output like file A-1 aa 22 48 ab 22 48 file A-2 cf 50 76 gf 50 76

5. Shell Programming and Scripting

1st column,2nd column on first line 3rd,4th on second line ect...

I need to take one column of data and put it into the following format: 1st line,2nd line 3rd line,4th line 5th line,6th line ... Thanks!

6. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3...

7. Linux

Print the 1st column and the value in 2nd or 3rd column if that is different from the values in 1st

8. Shell Programming and Scripting

Sum of Columns Base on First Column

Input :- Hd1;Hd2:hd3;Hd4;Hd5 X;1;2;3;4 Y;2;3;5;6 Z;3;5;6;7 X;10;11;24;16 Y;11;23;21;1 Z;10;13;14;15 X;0;1;2;0 K;0;0;0;0 K;0;0;0;0 I want Sum Data base on first column; Hd1;Hd2:hd3;Hd4;Hd5 X;11;14;29;20 Y;12;26;26;7 Z;13;18;20;22 K;0;0;0;0

9. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

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,,,,,,,,,,,,,,,,,,,,,,,,, ...

LEARN ABOUT PHP

locale_get_all_variants

LOCALE_GET_ALL_VARIANTS(3)						 1						LOCALE_GET_ALL_VARIANTS(3)

Locale::getAllVariants - Gets the variants for the input locale

	Object oriented style

SYNOPSIS

       publicstatic array Locale::getAllVariants (string  $locale)

DESCRIPTION

	Procedural style
       array locale_get_all_variants (string  $locale)

	Gets the variants for the input locale

PARAMETERS

	      o $locale
		- The locale to extract the variants from

RETURN VALUES

	The array containing the list of all variants subtag for the locale or NULL if not present

EXAMPLES

       Example #1

	      locale_get_all_variants(3) example

	      <?php
	      $arr = locale_get_all_variants('sl_IT_NEDIS_ROJAZ_1901');
	      var_export( $arr );
	      ?>

       Example #2

	      OO example

	      <?php
	       $arr = Locale::getAllVariants('sl_IT_NEDIS_ROJAZ_1901');
	       var_export( $arr );
	      ?>

       The above example will output:

       array (
	   0 => 'NEDIS',
	   1 => 'ROJAZ',
	   2 => '1901',
       )

SEE ALSO

       locale_get_primary_language(3), locale_get_script(3), locale_get_region(3).

PHP Documentation Group 												LOCALE_GET_ALL_VARIANTS(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help sum columns by break in first column with awk or sed or something.

Discussion started by: syadnom

2. Shell Programming and Scripting

sum multiple columns based on column value

Discussion started by: jjoe

3. Shell Programming and Scripting

grep data on 2nd line and 3rd column

Discussion started by: joker_789us

4. Shell Programming and Scripting

split on the basis of 2nd and 3rd column

Discussion started by: cdfd123