awk to sum a column based on duplicate strings in another column and show split totals Post: 302882985

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I sum one column based on another column?

Hi, I am new to this forum and new to awk. I have a file that contains 2 columns. Heres an example of what it looks like: 10 + 20 + 40 + 50 - 70 - So the file is tab-delimited. What I want to do is add 10 to column 1 whenever column 2 is + and substract 10 from column 1...

2. Shell Programming and Scripting

Sum Of Column Based On Column Condition

I have a following inputfile MT,AP,CDM,TTML,MUM,GS,SUCC,3 MT,AP,CDM,TTSL,AP,GS,FAIL,9 MT,AP,CDM,RCom,MAH,GS,SUCC,3 MT,AP,CDM,RTL,HP,GS,SUCC,1 MT,AP,CDM,Uni,UPE,GS,SUCC,2 MT,AP,CDM,Uni,MUM,GS,SUCC,2 TTSL,AP,GS,MT,MAH,CDM,SUCC,20 TTML,AP,GS,MT,MAH,CDM,FAIL,10...

3. UNIX for Dummies Questions & Answers

Sum based on column 1

i have file input aaa ccc,45567,rterw,1 bbb dcs,564543,hjghgh,1 aaa ccc,454,rterw,6 i want to sum based on column 1 expected output aaa ccc,7 bbb dcs,1

4. UNIX for Dummies Questions & Answers

awk to sum column field from duplicate row/lines

Hello, I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file Name m/c usage abc xxx 10 abc xxx 20 abc xxx 5 xyz ...

5. UNIX for Dummies Questions & Answers

Sum based on certain column

I have file 1 1/1/2013 A 553.0763397 96 16582 X1 X3 X5 X7 X9 1/1/2013 B 600.8333588 195 11992 X2 X3 X6 X7 X9 1/1/2013 B 459.8333588 195 11992 X1 X3 X6 X7 X9 1/2/2013 A 844.2973022 306 19555 X1 ...

6. UNIX for Dummies Questions & Answers

awk solution to duplicate lines based on column

Hi experts, I have a tab-delimited file with one column containing values separated by a comma. I wish to duplicate the entire line for every value in that comma-delimited field. For example: $cat file 4444 4444 4444 4444 9990 2222,7777 6666 2222 ...

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

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

9. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

10. Shell Programming and Scripting

Sum of a column as new column based on header in a script

Hello, I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically I/p c1,c2,c3,c4,c5 10,20,30,40,50 20,30,40,50,60 If i want to find sum only column c1, c3 and output it as c6,c7 O/p c1,c2,c3,c4,c5,c6,c7 10,20,30,40,50,30,70...

LEARN ABOUT DEBIAN

math::symbolic::auxfunctions

Math::Symbolic::AuxFunctions(3pm)			User Contributed Perl Documentation			 Math::Symbolic::AuxFunctions(3pm)

NAME

       Math::Symbolic::AuxFunctions - Auxiliary functions for Math::Symbolic hierarchy

SYNOPSIS

	 use Math::Symbolic::AuxFunctions;

	 Math::Symbolic::AuxFunctions::acos($x);
	 # etc

DESCRIPTION

       This module contains implementations of some auxiliary functions that are used within the Math::Symbolic hierarchy of modules. In
       particular, this module holds all trigonometric functions used for numeric evaluation of trees by Math::Symbolic::Operator.

   EXPORT
       None. On purpose. If I wished this module would pollute others' namespaces, I'd have put the functions right where they're used.

TRIGONOMETRIC FUNCTIONS

   tan
       Computes the tangent sin(x) / cos(x).

   cot
       Computes the cotangent cos(x) / sin(x).

   asin
       Computes the arc sine asin(z) = -i log(iz + sqrt(1-z*z)).  Above formula is for complex numbers.

   acos
       Computes the arc cosine acos(z) = -i log(z + sqrt(z*z-1)).  Above formula is for complex numbers.

   atan
       Computes the arc tangent atan(z) = i/2 log((i+z) / (i-z)).  Above formula is for complex numbers.

   acot
       Computes the arc cotangent ( atan( 1 / x ) ).

   asinh
       Computes the arc hyperbolic sine asinh(z) = log(z + sqrt(z*z+1))

   acosh
       Computes the arc hyperbolic cosine acosh(z) = log(z + sqrt(z*z-1)).

OTHER FUNCTIONS

   binomial_coeff
       Calculates the binomial coefficient n over k of its first two arguments (n, k).

       Code taken from Orwant et al, "Mastering Algorithms with Perl"

   bell_number
       The Bell numbers are defined as follows:

	 B_0   = 1
	 B_n+1 = sum_k=0_to_n( B_k * binomial_coeff(n, k) )

       This function uses memoization.

AUTHOR

       Please send feedback, bug reports, and support requests to the Math::Symbolic support mailing list: math-symbolic-support at lists dot
       sourceforge dot net. Please consider letting us know how you use Math::Symbolic. Thank you.

       If you're interested in helping with the development or extending the module's functionality, please contact the developers' mailing list:
       math-symbolic-develop at lists dot sourceforge dot net.

       List of contributors:

	 Steffen Mueller, symbolic-module at steffen-mueller dot net
	 Stray Toaster, mwk at users dot sourceforge dot net
	 Oliver Ebenhoeh

SEE ALSO

       New versions of this module can be found on http://steffen-mueller.net or CPAN. The module development takes place on Sourceforge at
       http://sourceforge.net/projects/math-symbolic/

       Math::Symbolic

perl v5.10.1							    2011-01-01					 Math::Symbolic::AuxFunctions(3pm)