How to sum a column 2 and column 3 Post: 302601097

Sponsored Content

Top Forums UNIX for Advanced & Expert Users How to sum a column 2 and column 3 Post 302601097 by Paulwintech on Thursday 23rd of February 2012 12:38:00 AM

02-23-2012

Registered User

Hi balajesuri,

Here is my below sample output file

Code:

bcbg  27   20 
blazer  34   30 
blazer  41   35 
boots  69   57 
boots  70   63 
converse  28   27 
converse  32   25 
dolce%20vita  47   42 
dolce%20vita  51   44 
dresses  22   13 
dresses  40   38 
dresses  46   35 
Ella%20moss  26   22 
flats  23   17 
flats  24   20 
free%20people  43   40 
free%20people  54   47 
frye  109   97 
frye  122   103 
frye  29   26 
handbags  27   20 
hive%20and%20honey  22   21 
hive%20and%20honey  24   20 
hunter  57   38 
hunter  64   50 
j%20brand  38   33 
j%20brand  39   34 
joie  39   34 
joie  51   43 
juicy%20couture  48   40 
juicy%20couture  65   52 
jumpsuit  29   27 
jumpsuit  38   34 
Kate%20spade  85   66 
Kate%20spade  89   75 
Lacoste  28   25 
Lacoste  33   30 
leopard  26   26 
lucky%20brand  38   33 
lucky%20brand  48   40 
marc%20jacobs  27   27 
Marc%20Jacobs  38   29 
Marc%20Jacobs  57   48 
maternity  48   38 
maternity  50   41 
maxi%20dress  49   41 
maxi%20dress  50   42 
maxi  25   21 
maxi  31   22 
michael%20kors  38   29 
michael%20kors  39   29 
Michael%20kors  73   62 
Michael%20kors  75   66 
nine%20west  29   25 
nine%20west  34   22 
order%20status  41   39 
order%20status  53   47 
peacock  38   31 
peacock  39   30 
pediped  31   23 
puma  29   23 
puma  30   26 
Rachel%20pally  38   30 
rain%20boots  29   22 
rose%20gold%20shoes  25   21 
rose%20gold  39   30 
rose%20gold  66   40 
rose%20gold  82   58 
Sam%20Edelman  34   28 
Sam%20Edelman  59   52 
sanctuary  23   18 
sanctuary  26   20 
scarf  23   20 
shoes  41   37 
shoes  45   35 
shoshanna  31   25 
sorel  31   27 
sperry  36   35 
sperry  40   34 
splendid  69   60 
splendid  82   69 
steve%20madden  35   28 
steve%20madden  40   37 
Steve%20madden  65   57 
Steve%20madden  68   59 
swedish%20hasbeens  25   22 
swim  31   24 
tinley%20road  43   41 
tinley%20road  62   50 
toms  106   87 
toms  88   74 
Tory%20burch  26   19 
true%20religion  31   30 
true%20religion  33   28 
ugg  28   23 
ugg  45   38 
Vince%20camuto  35   30 
Vince%20camuto  37   30 
wedges  28   23 
wedges  34   31

Regards
Paulwintech

Last edited by Paulwintech; 02-23-2012 at 01:43 AM..

Paulwintech

View Public Profile for Paulwintech

Find all posts by Paulwintech

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

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the...

3. UNIX for Dummies Questions & Answers

How to sum rows in e.g. column 1 by a category in e.g. column 2

Hi, I've shown an example of what I would like to achieve below. In the example file, I would like to sum the values in column 2 for each distinct category in column 3 (presumably making an array?) and print the sum as well as the category name and length (note:length always corresponds with...

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

5. Shell Programming and Scripting

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

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters...

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. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D...

8. UNIX for Beginners Questions & Answers

Sum the values in the column using date column

I have a file which need to be summed up using date column. I/P: 2017/01/01 a 10 2017/01/01 b 20 2017/01/01 c 40 2017/01/01 a 60 2017/01/01 b 50 2017/01/01 c 40 2017/01/01 a 20 2017/01/01 b 30 2017/01/01 c 40 2017/02/01 a 10 2017/02/01 b 20 2017/02/01 c 30 2017/02/01 a 10...

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

gnutls_pkcs12_bag_get_data

gnutls_pkcs12_bag_get_data(3)					      gnutls					     gnutls_pkcs12_bag_get_data(3)

NAME

       gnutls_pkcs12_bag_get_data - API function

SYNOPSIS

       #include <gnutls/pkcs12.h>

       int gnutls_pkcs12_bag_get_data(gnutls_pkcs12_bag_t bag, int indx, gnutls_datum_t * data);

ARGUMENTS

       gnutls_pkcs12_bag_t bag
		   The bag

       int indx    The element of the bag to get the data from

       gnutls_datum_t * data
		   where the bag's data will be. Should be treated as constant.

DESCRIPTION

       This  function  will  return  the  bag's data. The data is a constant that is stored into the bag.  Should not be accessed after the bag is
       deleted.

RETURNS

       On success, GNUTLS_E_SUCCESS (0) is returned, otherwise a negative error value.

REPORTING BUGS

       Report bugs to <bug-gnutls@gnu.org>.
       General guidelines for reporting bugs: http://www.gnu.org/gethelp/
       GnuTLS home page: http://www.gnu.org/software/gnutls/

COPYRIGHT

       Copyright (C) 2012 Free Software Foundation, Inc..
       Copying and distribution of this file, with or without modification, are permitted in any medium without  royalty  provided  the  copyright
       notice and this notice are preserved.

SEE ALSO

       The  full documentation for gnutls is maintained as a Texinfo manual.  If the info and gnutls programs are properly installed at your site,
       the command

	      info gnutls

       should give you access to the complete manual.  As an alternative you may obtain the manual from:

	      http://www.gnu.org/software/gnutls/manual/

gnutls								      3.1.15					     gnutls_pkcs12_bag_get_data(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I sum one column based on another column?

Discussion started by: phil_heath

2. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Discussion started by: amigarus

3. UNIX for Dummies Questions & Answers

How to sum rows in e.g. column 1 by a category in e.g. column 2

Discussion started by: auburn

4. Shell Programming and Scripting

Sum Of Column Based On Column Condition

Discussion started by: siramitsharma