Print sum and relative value of the sum Post: 302435839

9 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

loop + sum + print using awk

Hi, I am unable sum of each column in the loop usng awk command. Awk is not allowing the parameters in the command. i am facing the below error. awk: 0602-562 Field $() is not correct. Source file abc.txt 100,200,300,400,500,600,700,800,900 101,201,301,401,501,601,701,801,901 ...

3. UNIX for Dummies Questions & Answers

Getting the sum

I am trying to get the sum of the first column of a file. When I use the same method for other files it works just fine... for some reason for the file below it gives me an error that I don't understand... I tried looking at different lines of the file and tried different things, but I still...

4. Shell Programming and Scripting

sum from ls -al |awk '{print $5}'

// AIX 5.3 & AIX 6.1 ls -al |awk '{print $5}' This gives each file's size in byte. I need to get: - the sum of all files in Giga bytes with loop. - excluding the size of directories (ls -al returns the size of directories). There are hundreds and thousands of files, so summing up...

5. Shell Programming and Scripting

Search two patterns using awk to print the variable sum

Coins.txt: gold 1 1986 USA American Eagle gold 1 1908 Austria-Hungary Franz Josef 100 Korona silver 10 1981 USA ingot gold 1 1984 Switzerland ingot gold 1 1979 RSA Krugerrand gold 0.5 1981 RSA Krugerrand gold 0.1 1986 PRC Panda silver 1 1986 USA Liberty dollar gold 0.25 1986 USA Liberty...

6. Shell Programming and Scripting

Sum value in a row and print the max

I have the input file in attached. I want the output file : Date , Time , Max_Bearer 11/01/2013 , 23:00 , 1447.894167 11/02/2013 , 00:00 , 1429.266667 11/03/2013 , 00:00 , 712.3175 11/04/2013 , 22:00 , 650.9533333 11/05/2013 , 23:00 , 665.9558333 11/06/2013 , 23:00 , 659.8616667...

7. Shell Programming and Scripting

How to get the sum?

8. Shell Programming and Scripting

awk sum of all columns needs to print exact amount

Hi I have attached txt file as input, and i'm able to calculate sum of columns at the end but the format of sum is not coming up right. awk -F"," '{for (i=4;i<=NF;i++) sum+=$i}{print}; END { sum="Total:"; for (i=1;i<=NF;i++) {printf sum ","} print "\n"}' input.txt check the o/p file, at...

9. Shell Programming and Scripting

awk - Print Sum

Hi, I have an awk command that I am using, and part of it sums COL_9 however when I read the output it is not including decimal places; awk ' BEGIN{FS=OFS=","} NR==1{print;next} {a+=$9 c = $12 d = $18 } END{for(i in a) {split(i,b,";"); print $1, $2, $3, b, $5, $6, b, b, a, $10, $11,...

LEARN ABOUT DEBIAN

amc-association-auto

AMC-ASSOCIATION-AU(1)					       Auto Multiple Choice					     AMC-ASSOCIATION-AU(1)

NAME

       AMC-association-auto - automatic association between students and answer sheets for AMC multiple choice exams.

SYNOPSIS

       auto-multiple-choice association-auto --data project-data-dir --notes-id id --liste students-list.csv [--encodage-liste list-encoding]
			    --liste-key key

DESCRIPTION

       The AMC-association-auto.pl command associates students with their answer sheet (when there are no errors from students when coding their
       student number and no error during data capture). See the section called "Identification of the students" from english user documentation
       for details.

       --data project-data-dir
	   gives the directory where data files are (see for example AMC-prepare(1)).

       --notes-id id
	   gives the identification string of the code provided for student numbers (command AMCcode in the LaTeX source file).

       --liste students-list.csv
	   gives the students list.

       --encodage-liste list-encoding
	   gives the students list file encoding (default is utf-8).

       --liste-key key
	   gives the column name where to find the student number in the students list.

       --debug file.log
	   gives a file to fill with debugging information.

AUTHORS

       Alexis Bienvenue <paamc@passoire.fr>
	   Main author

       Jean Berard
	   Translation from French

       Georges Khaznadar
	   Translation from French

COPYRIGHT

       Copyright (C) 2008-2012 Alexis Bienvenue

       This document can be used according to the terms of the GNU General Public License, version 2 or later.

Auto Multiple Choice 1.1.1					    06/19/2012						     AMC-ASSOCIATION-AU(1)