|
|||||||
| Forums | Search Forums | Register | Forum Rules | Man Pages | Albums | FAQ | Members | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
12-17-2012
|
||||
|
||||
|
How to calculate what percentage of X value is there in the file?
Input File: Code:
5081 2058 175 8282 2358 7347 6612 3459 END OF INPUT FILE I need to know how to calculate minimum,maximum,average of the values in the file and also what percentage is the values over some user defined value for example 1000 and what percentage of value is over 5000. By using the following command mentioned below i was able to find the minimum ,maximum and average but having problem in calculatung perctangae. Code:
awk 'NR==1{min=$1;max=$1;sum+=$1;next}{if ($1<min) min=$1;if ($1>max)
max=$1;sum+=$1}END{print "min: "min", max: "max",NR: "NR", avg: "sum/NR}' INPUT FILE
Last edited by Scott; 12-17-2012 at 02:39 PM.. Reason: Code tags! |
| Sponsored Links | ||
|
|
#2
12-17-2012
|
||||
|
||||
|
Code:
awk ' BEGIN { max=sum=0; th=fv=0; } NR==1 { min=$1; } {
val=$1;
sum+=val;
if(val<min) { min=val; }
if(val>max) { max=val; }
if(val>1000) { th++; }
if(val>5000) { fv++; }
} END {
printf "Min: %d Max: %d Avg: %d 1000 per: %d 5000 per: %d\n", min, max, (sum/NR), (th/NR * 100), (fv/NR * 100);
} ' filename |
| Sponsored Links | ||
|
|
#3
12-17-2012
|
||||
|
||||
|
Here is a version where you can Set limits for F1 and F2 on the command line: Code:
awk -vF1=1000 -vF2=5000 'FNR==1 {min=$1}
{
sum+=$1;
if($1<min) min=$1
if($1>max) max=$1
th+=($1>F1)
fv+=($1>F2)
}
END {
printf "Min: %d Max: %d Avg: %d above %d: %d%% above %d: %d%%\n", min, max, sum/NR, F1, th/NR*100, F2, fv/NR * 100
} ' infile |
| Sponsored Links | ||
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Script shell, how to calculate percentage? | likeaix | Shell Programming and Scripting | 3 | 08-04-2011 10:30 AM |
| Need an AWK script to calculate the percentage | bobprabhu | Shell Programming and Scripting | 8 | 11-07-2008 04:42 AM |
| How can i calculate percentage ?? | bobprabhu | Shell Programming and Scripting | 6 | 10-31-2008 09:37 AM |
| How to calculate the percentage for the values in column | saleru_raja | Shell Programming and Scripting | 3 | 08-29-2008 03:15 AM |
| how do I calculate percentage ? | the_learner | Programming | 6 | 04-18-2007 04:40 PM |
|
|
Linear Mode
