Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Summing up rows data regarding 1st column
Top Forums Shell Programming and Scripting Summing up rows data regarding 1st column Post 302621287 by AAWT on Tuesday 10th of April 2012 07:00:54 AM
Old 04-10-2012
Summing up rows data regarding 1st column
Dear all,

I have one file like
Code:
   
  LABEL   A   B   C   D   E   F   G   H   I   J   K   L   M   N      
 G02100   64651.3   25630.7   8225.21   51238   267324   268005   234001   52410.9   18598.2   10611   10754.7   122535   267170   36631.4     
  G02100   12030.3   8260.15   8569.91   7901.76   6730.83   3060.29   4991.3   10213.1   5043.9   4889.69   3838.4   3652.25   3742.68   5945   
    G02100   10909.1   222.446   0   0   0   0   0   295.779   19.884   0   0   0   0   0      
 G02780   8287.85   8067.36   5764.61   7754.75   4428.79   1653.26   4524.88   6942.11   6309.85   6228.8   8280.75   3437.41   3310.83   4884.93     
  G02780   7780.28   19497.7   10218.1   10975.8   3154.82   191.512   64.78   5298.8   16604.7   12996.6   3010.33   751.934   143.949   9.5502       
G09200   6974.73   7790.54   3865.08   7108.96   3778.3   1625.9   4294.91   4277.2   4259.59   4709.11   7341.28   3574.67   3382.8   4967.7      
 G37770   6924.22   6072.77   1353.14   708.795   140.226   125.069   437.265   5715.5   2883.18   2494.85   5448.92   698.224   503.822   100.277   
    G74270   10681.8   11908.3   3564.38   10432.4   4826.1   2020.65   7799.51   8969.07   5302.4   4989.71   22158   7662.56   6693.63   4412.19   
    G74270   10060.6   6502.83   297.032   115.507   397.306   261.864   1399.25   3488.46   2995.85   1472.46   2026.57   537.095   935.669   606.438    
   G74270   9492.4   4574.97   506.054   288.768   327.193   527.636   861.574   6589.79   2372.82   1589.15   1395.78   769.837   1151.59   615.988      
 G74270   9318.15   20012.7   10330.1   267.767   0   0   0   12057.4   11963.5   17414   0   0   0   0       
G74270   9265.12   11326.2   1430.15   0   0   33.2215   53.4435   4762.92   9749.78   7251.19   0   17.9032   215.924   630.313  
     G35720   7575.73   11826.7   8415.9   6011.63   1834.62   582.353   1230.82   7020.41   13918.8   13757.8   1207.89   1432.25   359.873   816.542

i need to have an output file (summing up the values in rows according to the first column) like
Code:
       
  LABEL   A   B   C   D   E   F   G   H   I   J   K   L   M   N     
  G02100   87590.7   34113.3   16795.12   59139.76   274054.8   271065.3   238992.3   62919.78   23661.98   15500.69   14593.1   126187.3   270912.7   42576.4    
   G02780   16068.13   27565.06   15982.71   18730.55   7583.61   1844.772   4589.66   12240.91   22914.55   19225.4   11291.08   4189.344   3454.779   4894.48    
   G09200   6974.73   7790.54   3865.08   7108.96   3778.3   1625.9   4294.91   4277.2   4259.59   4709.11   7341.28   3574.67   3382.8   4967.7      
 G74270   48818.07   54325   16127.72   11104.44   5550.599   2843.372   10113.78   35867.64   32384.35   32716.51   25580.35   8987.395   8996.813   6264.929     
  G35720   7575.73   11826.7   8415.9   6011.63   1834.62   582.353   1230.82   7020.41   13918.8   13757.8   1207.89   1432.25   359.873   816.542

Please help me guys

Thanks
Last edited by AAWT; 04-10-2012 at 08:07 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Find different column numbers among rows in data

I want to find the different column numbers among rows in a file. For example: A001 a b c d e ... N A002 a b c d e ... N A003 a b c d e ... N+1 A004 a b c d e ... N A005 a b c d e ... N+2 : : For most of the lines I will have N columns (say 1000 rows) in each line except the line 3... (5 Replies)
Discussion started by: AMBER
5 Replies

2. Shell Programming and Scripting

column data to rows every n line

Hi every one, I am trying to organise an input text file like: input 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 into an output as following: output file 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 (5 Replies)
Discussion started by: nxp
5 Replies

3. Shell Programming and Scripting

Transpose Column of Data to Rows

I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows: NAME=BOB ADDRESS=COLORADO PET=CAT NAME=SUSAN ADDRESS=TEXAS PET=BIRD NAME=TOM ADDRESS=UTAH PET=DOG I would... (7 Replies)
Discussion started by: docdave78
7 Replies

4. Shell Programming and Scripting

[Solved] Compare column data in all the rows

Hi.. In the below sorted input file.. I am comparing the first 3 columns of data one by one row and it is a pipeline delimitter file.. AA|BB|CC|line1 AA|BB|CC|ine4 AA|BB|CC|line2 BB|CC|DD|line3 BB|CC|DD|line5 If first 3 columns of data matches with any record in the file the... (4 Replies)
Discussion started by: NareshN
4 Replies

5. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5 (1 Reply)
Discussion started by: jacobs.smith
1 Replies

6. Shell Programming and Scripting

Summing up values of rows of numbers

data file contains failed=24 error=23 error=163 failed=36 error=903 i need to get a total count of each value above. i'm looking for the most efficient method to do this as the datafile i provided is just a sample. the actual data can be several hundred thousands of lines. so from... (3 Replies)
Discussion started by: SkySmart
3 Replies

7. Shell Programming and Scripting

Convert Column data values to rows

Hi all , I have a file with the below content Header Section employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies

8. Shell Programming and Scripting

Data rearranging from rows to column

Hello Everyone, I have a input file looks like -0.005-0.004-0.003-0.002-0.00100.0010.0020.0030.0040.005My desired output should look like -0.005 -0.004 -0.003 -0.002 -0.001 0 0.001 0.002 0.003 0.004 0.005I had some success in getting the desired output. But i face a problem when i... (15 Replies)
Discussion started by: dinesh.n
15 Replies

9. Shell Programming and Scripting

How to separate rows of data into another column?

I have data such as below where the value in second field is the same as that in the row after. 123456,22222,John,0,xyz 234567,22222,John1,1,cde 43212,3333,Jean,3,pip 84324,3333,Abel,2,cat I'd like to rearrange the output like below to put such records beside each other and separated with... (5 Replies)
Discussion started by: james2009
5 Replies

10. UNIX for Beginners Questions & Answers

How to transpose pieces of data in a column to multiple rows?

Hello Everyone, I am very new to the world of regular expressions. I am trying to use grep/sed for the following: Input file is something like this and there are multiple such files: abc 1 2 3 4 5 ***END*** abc 6 7 8 9 ***END*** abc 10 (2 Replies)
Discussion started by: shellnewuser
2 Replies

LEARN ABOUT SUNOS

iconv_mac_cyr

iconv_mac_cyr(5)					Standards, Environments, and Macros					  iconv_mac_cyr(5)

NAME

       iconv_mac_cyr - code set conversion tables for Macintosh Cyrillic

DESCRIPTION

       The following code set conversions are supported:

       +---------------------------------------------------------------------+
       |		   Code Set Conversions Supported		     |
       +--------------+--------+--------------+--------+---------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |       Target	     |
       +--------------+--------+--------------+--------+---------------------+
       |Output	      |        |	      |        |		     |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |KOI8-R	      |koi8    | KOI8-R 	     |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |PC Cyrillic   |alt     | Alternative PC      |
       +--------------+--------+--------------+--------+---------------------+
       |Cyrillic      |        |	      |        |		     |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |MS 1251       |win5    | Windows Cyrillic    |
       +--------------+--------+--------------+--------+---------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   Mac Cyrillic to ISO 8859-5
       For the conversion of Mac Cyrillic to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |		     Conversions Performed			 |
       | Mac Cyrillic	  ISO 8859-5	  Mac Cyrillic	    ISO 8859-5	 |
       |24		 4		 276		  252		 |
       |200		 260		 277		  372		 |
       |201		 261		 300		  370		 |
       |202		 262		 301		  245		 |
       |203		 263		 302-311	  40		 |
       |204		 264		 312		  240		 |
       |205		 265		 313		  242		 |
       |206		 266		 314		  362		 |
       |207		 267		 315		  254		 |
       |210		 270		 316		  374		 |
       |211		 271		 317		  365		 |
       |212		 272		 320-327	  40		 |
       |213		 273		 330		  256		 |
       |214		 274		 331		  376		 |
       |215		 275		 332		  257		 |
       |216		 276		 333		  377		 |
       |217		 277		 334		  360		 |
       |220		 300		 335		  241		 |
       |221		 301		 336		  361		 |
       |222		 302		 337		  357		 |
       |223		 303		 340		  320		 |
       |224		 304		 341		  321		 |
       |225		 305		 342		  322		 |
       |226		 306		 343		  323		 |
       |227		 307		 344		  324		 |
       |230		 310		 345		  325		 |
       |231		 311		 346		  326		 |
       |232		 312		 347		  327		 |
       |233		 313		 350		  330		 |
       |234		 314		 351		  331		 |
       |235		 315		 352		  332		 |
       |236		 316		 353		  333		 |
       |237		 317		 354		  334		 |
       |240-246 	 40		 355		  335		 |
       |247		 246		 356		  336		 |
       |250-252 	 40		 357		  337		 |
       |253		 242		 360		  340		 |
       |254		 362		 361		  341		 |
       |255		 40		 362		  342		 |
       |256		 243		 363		  343		 |
       |257		 363		 364		  344		 |
       |260-263 	 40		 365		  345		 |
       |264		 366		 366		  346		 |
       |265-266 	 40		 367		  347		 |
       |267		 250		 370		  350		 |
       |270		 244		 371		  351		 |
       |271		 364		 372		  352		 |
       |272		 247		 373		  353		 |
       |273		 367		 374		  354		 |
       |274		 251		 375		  355		 |
       |275		 371		 376		  356		 |
       |375		 370						 |
       +-----------------------------------------------------------------+

   Mac Cyrillic to KOI8-R
       For the conversion of Mac Cyrillic to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | Mac Cyrillic  |    KOI8-R	| Mac Cyrillic	 |    KOI8-R	 |
       |24	       | 4		|276		 |272		 |
       |200	       | 341		|277		 |252		 |
       |201	       | 342		|300		 |250		 |
       |202	       | 367		|301		 |265		 |
       |203	       | 347		|302-311	 |40		 |
       |204	       | 344		|312		 |240		 |
       |205	       | 345		|313		 |261		 |
       |206	       | 366		|314		 |241		 |
       |207	       | 372		|315		 |274		 |
       |210	       | 351		|316		 |254		 |
       |211	       | 352		|317		 |245		 |
       |212	       | 353		|320-327	 |40		 |
       |213	       | 354		|330		 |276		 |
       |214	       | 355		|331		 |256		 |
       |215	       | 356		|332		 |277		 |
       |216	       | 357		|333		 |257		 |
       |217	       | 360		|334		 |260		 |
       |220	       | 362		|335		 |263		 |
       |221	       | 363		|336		 |243		 |
       |222	       | 364		|337		 |321		 |
       |223	       | 365		|340		 |301		 |
       |224	       | 346		|341		 |302		 |
       |225	       | 350		|342		 |327		 |
       |226	       | 343		|343		 |307		 |
       |227	       | 376		|344		 |304		 |
       |230	       | 373		|345		 |305		 |
       |231	       | 375		|346		 |326		 |
       |232	       | 377		|347		 |332		 |
       |233	       | 371		|350		 |311		 |
       |234	       | 370		|351		 |312		 |
       |235	       | 374		|352		 |313		 |
       |236	       | 340		|353		 |314		 |
       |237	       | 361		|354		 |315		 |
       |240-246        | 40		|355		 |316		 |
       |247	       | 266		|356		 |317		 |
       |250-252        | 40		|357		 |320		 |
       |253	       | 261		|360		 |322		 |
       |254	       | 241		|361		 |323		 |
       |255	       | 40		|362		 |324		 |
       |256	       | 262		|363		 |325		 |
       |257	       | 242		|364		 |306		 |
       |260-263        | 40		|365		 |310		 |
       |264	       | 246		|366		 |303		 |
       |265-266        | 40		|367		 |336		 |
       |267	       | 270		|370		 |333		 |
       |270	       | 264		|371		 |335		 |
       |271	       | 244		|372		 |337		 |
       |272	       | 267		|373		 |331		 |
       |273	       | 247		|374		 |330		 |
       |274	       | 271		|375		 |334		 |
       |275	       | 251		|376		 |300		 |
       |375	       | 370		|		 |		 |
       +---------------+----------------+----------------+---------------+

   Mac Cyrillic to PC Cyrillic
       For the conversion of Mac Cyrillic to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | Mac Cyrillic  |  PC Cyrillic	| Mac Cyrillic	 | PC Cyrillic	 |
       |24	       | 4		|355		 |255		 |
       |240-334        | 40		|356		 |256		 |
       |335	       | 360		|357		 |257		 |
       |336	       | 361		|360		 |340		 |
       |337	       | 357		|361		 |341		 |
       |340	       | 240		|362		 |342		 |
       |341	       | 241		|363		 |343		 |
       |342	       | 242		|364		 |344		 |
       |343	       | 243		|365		 |345		 |
       |344	       | 244		|366		 |346		 |
       |345	       | 245		|367		 |347		 |
       |346	       | 246		|370		 |350		 |
       |347	       | 247		|371		 |351		 |
       |350	       | 250		|372		 |352		 |
       |351	       | 251		|373		 |353		 |
       |352	       | 252		|374		 |354		 |
       |353	       | 253		|375		 |355		 |
       |354	       | 254		|376		 |356		 |
       |303	       | 366		|		 |		 |
       +---------------+----------------+----------------+---------------+

   Mac Cyrillic to MS 1251
       For the conversion of Mac Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | Mac Cyrillic  |    MS 1251	| Mac Cyrillic	 |   MS 1251	 |
       |24	       | 4		|255		 |40		 |
       |200	       | 300		|256		 |201		 |
       |201	       | 301		|257		 |203		 |
       |202	       | 302		|260-263	 |40		 |
       |203	       | 303		|264		 |263		 |
       |204	       | 304		|266		 |264		 |
       |205	       | 305		|267		 |243		 |
       |206	       | 306		|270		 |252		 |
       |207	       | 307		|271		 |272		 |
       |210	       | 310		|272		 |257		 |
       |211	       | 311		|273		 |277		 |
       |212	       | 312		|274		 |212		 |
       |213	       | 313		|275		 |232		 |
       |214	       | 314		|276		 |214		 |
       |215	       | 315		|277		 |234		 |
       |216	       | 316		|300		 |274		 |
       |217	       | 317		|301		 |275		 |
       |220	       | 320		|302		 |254		 |
       |221	       | 321		|303-306	 |40		 |
       |222	       | 322		|307		 |253		 |
       |223	       | 323		|310		 |273		 |
       |224	       | 324		|311		 |205		 |
       |225	       | 325		|312		 |240		 |
       |226	       | 326		|313		 |200		 |
       |227	       | 327		|314		 |220		 |
       |230	       | 330		|315		 |215		 |
       |231	       | 331		|316		 |235		 |
       |232	       | 332		|317		 |276		 |
       |233	       | 333		|320		 |226		 |
       |234	       | 334		|321		 |227		 |
       |235	       | 335		|322		 |223		 |
       |236	       | 336		|323		 |224		 |
       |237	       | 337		|324		 |221		 |
       |240	       | 206		|325		 |222		 |
       |241	       | 260		|326		 |40		 |
       |242	       | 245		|327		 |204		 |
       |243	       | 40		|330		 |241		 |
       |244	       | 247		|331		 |242		 |
       |245	       | 267		|332		 |217		 |
       |246	       | 266		|333		 |237		 |
       |247	       | 262		|334		 |271		 |
       |250	       | 256		|335		 |250		 |
       |252	       | 231		|336		 |270		 |
       |253	       | 200		|337		 |377		 |
       |254	       | 220		|362		 |324		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						  iconv_mac_cyr(5)
All times are GMT -4. The time now is 09:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy