Sum up the column values group by using some field


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sum up the column values group by using some field
# 8  
Old 11-13-2012
Quote:
Originally Posted by manas_ranjan
Hi Pamu,

just in curious, what is the purpose of passing two times the file name at the end of command?

and if we want to format the output as below,
Code:
printf ("%10s %25s %10d\n",$1,$2,$3)

how to achieve ?
Here we are passing two times file name because we are performing operations twice on a file.

for your format try.

Code:
awk -F, 'NR==FNR{if($2 ~ /VAR/){X[$1]+=$3};next}
 {if($2 ~ /VAR/ ){if(! arr[$1]){$2="TOTAL_VAR";$3=X[$1];printf ("%10s %25s %10d\n",$1,$2,$3);arr[$1]++}else{P=0}}else{printf ("%10s %25s %10d\n",$1,$2,$3)}}'  file file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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... (6 Replies)
Discussion started by: Booo
6 Replies

2. 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... (9 Replies)
Discussion started by: tpk
9 Replies

3. Shell Programming and Scripting

Sum column values matching other field

this is part of a KT i am going thru. i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size. sample data attached. Desired output is 3 columns which will give the nth hour, number of entries in nth hour and... (3 Replies)
Discussion started by: alpha_1
3 Replies

4. 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 Replies)
Discussion started by: sargotrons
8 Replies

5. 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 ... (6 Replies)
Discussion started by: asjaiswal
6 Replies

6. Shell Programming and Scripting

Getting a sum of column values

I have a file in the following layout: 201008005946873001846130058030701006131840000000000000000000 201008006784994001154259058033001009527844000000000000000000 201008007323067002418095058034801002418095000000000000000000 201008007697126001722141058029101002214158000000000000000000... (2 Replies)
Discussion started by: jclanc8
2 Replies

7. Shell Programming and Scripting

Sum of column by group wise

Hello All , I have a problem with summing of column by group Input File - COL_1,COL_2,COL_3,COL_4,COL_5,COL_6,COL_7,COL_8,COL_9,COL_10,COL_11 3010,21,1923D ,6,0,0.26,0,0.26,-0.26,1,200807 3010,21,192BI ,6,24558.97,1943.94,0,1943.94,22615.03,1,200807 3010,21,192BI... (8 Replies)
Discussion started by: jambesh
8 Replies

8. 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... (6 Replies)
Discussion started by: amigarus
6 Replies

9. Shell Programming and Scripting

Column sum group by uniq records

Dear All, I want to get help for below case. I have a file like this. saman 1 gihan 2 saman 4 ravi 1 ravi 2 so i want to get the result, saman 5 gihan 2 ravi 3 like this. Pls help me. (17 Replies)
Discussion started by: Nayanajith
17 Replies

10. Shell Programming and Scripting

How to sum column 1 values

I have a file file like this. I want to sum all column 1 values. input A 2 A 3 A 4 B 4 B 2 Out put A 9 B 6 (3 Replies)
Discussion started by: suresh3566
3 Replies
Login or Register to Ask a Question
QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME
qrencode - Encode input data in a QR Code and save as a PNG or EPS image. SYNOPSIS
qrencode [OPTION]... [STRING] DESCRIPTION
Libqrencode is a library for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness. Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image. OPTIONS
-h, --help display help message. -o FILENAME, --output=FILENAME write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured symbols are written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified) -s NUMBER, --size=NUMBER specify the size of dot (pixel). (default=3) -l {LMQH}, --level={LMQH} specify error collectin level from L (lowest) to H (highest). (default=L) -v NUMBER, --symversion=NUMBER specify the version of the symbol. (default=auto) -m NUMBER, --margin=NUMBER specify the width of margin. (default=4) -d NUMBER, --dpi=NUMBER specify the DPI of the generated PNG. (default=72) -t {PNG,EPS,ANSI,ANSI256}, --type={PNG,EPS,ANSI,ANSI256} specify the type of the generated image. (default=PNG) -S, --structured make structured symbols. Version must be specified. -k, --kanji assume that the input text contains kanji (shift-jis). -c, --casesensitive encode lower-case alphabet characters in 8-bit mode. (default) -i, --ignorecase ignore case distinctions and use only upper-case characters. -8, --8bit encode entire data in 8-bit mode. -k, -c and -i will be ignored. -M, --micro encode in a Micro QR Code. (experimental) -V, --version display the version number and copyrights of the qrencode. [STRING] input data. If it is not specified, data will be taken from standard input. EXAMPLES
qrencode -l L -v 1 -o output.png 'Hello, world!' encode into a symbol version 1, level L. qrencode -iSv 1 --output=output.png read standard input and encode it into a structured-appended symbols in case-insensitive mode. AUTHOR
Written by Kentaro Fukuchi. RESOURCES
Main Web Site: http://fukuchi.org/works/qrencode/ Source code repository: https://github.com/fukuchi/libqrencode/ COPYRIGHT
Copyright (C) 2006-2012 Kentaro Fukuchi. qrencode 3.3.0 Feb. 29, 2012 QRENCODE(1)