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)
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
... (1 Reply)
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... (7 Replies)
// 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... (8 Replies)
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... (2 Replies)
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... (6 Replies)
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,... (1 Reply)
Discussion started by: Ads89
1 Replies
LEARN ABOUT DEBIAN
amc-note
AMC-NOTE(1) Auto Multiple Choice AMC-NOTE(1)NAME
AMC-note - computes marks after scans data capture for AMC multiple choice exams.
SYNOPSIS
auto-multiple-choice note --data project-data-dir [--seuil threshold] [--grain granularity] [--arrondi rounding] [--notemin min]
[--notemax max] [--no-plafond | --plafond]
DESCRIPTION
The AMC-note.pl command computes marks for all students from the scoring strategy extracted from the LaTeX source file by AMC-prepare(1)
and from the data capture reports made by AMC-analyse(1).
--data project-data-dir
gives the directory where data files are (see for example AMC-meptex(1)).
--seuil threshold
gives the black ratio threshold (see AMC-analyse(1)) for deciding whether a box is ticked or not.
--grain granularity --arrondi rounding
ask marks to be rounded to a multiple of granularity. If rounding is 'i', rounding is done from below (as with floor(3)). If rounding
is 'n', rounding is done to the nearest multiple of granularity. If rounding is 's', rounding is done from above (as with ceil(3)). For
example, with options "--grain 0.25 --arrondi s", mark 6.285 is rounded to 6.5.
--notemin min
with this option, all marks below min will be replaced by min.
--notemax max
gives the mark to associate to a sheet where all answers are correct. If not used, marks are not scaled.
--plafond
with this option, all marks above max will be replaced by max.
--debug file.log
gives a file to fill with debugging information.
--postcorrect-student s --postcorrect-copy c
requests port-correction from the completed answer sheet identified by student and copy numbers. In post-correction mode, correct
answers are not extracted from the LaTeX source file, but taken from the answers given on this sheet.
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-NOTE(1)