07-08-2010
i want
sum (a+c+e) = ace
sum (b+d+f) = bdf
and
a/ace, c/ace, e/ace
b/bdf, d/bdf, f/bdf
sorry for not being clear. hope it is clear now.
Last edited by saint2006; 07-08-2010 at 05:45 PM..
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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)
Discussion started by: number10
1 Replies
3. UNIX for Dummies Questions & Answers
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)
Discussion started by: cosmologist
7 Replies
4. Shell Programming and Scripting
// 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)
Discussion started by: Daniel Gate
8 Replies
5. Shell Programming and Scripting
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)
Discussion started by: Ramesh M
2 Replies
6. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: justbow
2 Replies
7. Shell Programming and Scripting
hi Gurus,
I have an extract as seen below:
INPUT
2015-08-24 15:00:00.0 |TCSERVER01 |ServiceEventHandler |2283
2015-08-24 15:01:00.0 |TCSERVER01 |ServiceEventHandler |576
2015-08-24 15:02:00.0 |TCSERVER01 |ServiceEventHandler |833
2015-08-24 15:03:00.0 |TCSERVER01 |ServiceEventHandler... (6 Replies)
Discussion started by: reignangel2003
6 Replies
8. Shell Programming and Scripting
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)
Discussion started by: manas_ranjan
6 Replies
9. Shell Programming and Scripting
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
ace-mastermind
ace-of-penguins(6) User Commands ace-of-penguins(6)
NAME
ace-of_penguins - Solitaire-games with penguin-look
SYNOPSIS
ace-canfield
ace-freecell
ace-golf
ace-mastermind
ace-merlin
ace-minesweeper
ace-pegged
ace-solitaire
ace-spider
ace-taipei
ace-taipedit
ace-thornq
OPTIONS
None.
DESCRIPTION
From the author's intro.html: "The Ace of Penguins is a set of Unix/X solitaire games based on the ones available for Windows(tm) but with
a number of enhancements that make my wife like my versions better :-)"
ace-canfield
Solitary card-game
ace-freecell
Solitary card-game
ace-spider
Solitary card-game
ace-solitaire
Solitary card-game
ace-thornq
Solitary card-game
ace-golf
Another solitary card-game
ace-mastermind
Guess a secret combination of colors.
ace-merlin
Classical puzzle, rather frustrating.
ace-minesweeper
Find all hidden mines in a minefield.
ace-pegged
Classical board game.
ace-taipei
Asian puzzle, remove pairs of equal stones.
ace-taipedit
Editor for your own ace-taipei levels.
KEYS
All games use the same library of functions and thus the same keys:
F1 Online help.
Esc Esc or "Q" to leave the game.
NOTES
The upstream author DJ Delorie has written an informative webpage which is installed in /usr/share/doc/ace-of-penguins/intro.html
The original binaries were renamed to include prefix ace-* to avoid name clashes.
BUGS
If you encounter any bugs in this package, please report them to the Debian Bug Tracking System at http://bugs.debian.org/.
ENVIRONMENT
None.
FILES
None.
SEE ALSO
Other games in /usr/games
AUTHORS
Programs are by DJ Delorie, some by Martin Thornquist.
This manual page was written 1999-09-09 by Thimo Neubauer <thimo@debian.org> for the Debian GNU system (but may be used by others). Updated
2007-09-03 by Jari Aalto <jari.aalto@cante.net>. Released under license GPL v2 or (at your option) any later version.
ace-of-penguins 2012-03-23 ace-of-penguins(6)