Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Get average and percentage non zero value

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get average and percentage non zero value
# 1  
Old 12-15-2017
Get average and percentage non zero value
How to calculate percentage non zero value occurrence base on value col 1 and 2
Code:
2017 a 0
2017 a 2
2017 a 4
2017 a 2
2017 a 0
2017 b 2
2017 b 6
2016 a 2
2016 a 2
2016 b 2
2016 b 8
2016 b 0
2016 b 0
2016 c 2
2016 c 2
2016 c 0

i manage to get average
Code:
# awk '{A[$1$2]++;B[$1$2]+=$3}END{for(X in A){print X,B[X]/A[X]}}' test
2016a 2
2016b 2.5
2017a 1.6
2016c 1.33333
2017b 4

what i want is another value base on = count record if col3 value>0 /count all record with same group ( ie, 2016a has 2 record larger then 0 so 2/2 =1)
Code:
2016a 2 1
2016b 2.5 0.5
2017a 1.6 0.6
2016c 1.33333 0.33
2017b 4 1

# 2  
Old 12-15-2017
Code:
awk '{A[$1$2]++;B[$1$2]+=$3; if ($3>0) C[$1$2]++}END{for(X in A){print X,B[X]/A[X],C[X]/A[X]}}' infile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Matrix with Percentage

Hi ALL, I have below example INPUT 1 (i/p 1)|INPUT 2 (i/p 2)|OUTPUT (o/p) Bharat Bazar|Bharat Bazar|True Positive Binny's Sales|<BLANK>|False Negative <BLANK>|Binny's|False Positive <BLANK>|<BLANK>|True Negative Bharat bazar|Bharat|True Positive binny's|binny|True Positive where in... (18 Replies)
Discussion started by: nikhil jain
18 Replies

2. Shell Programming and Scripting

Percentage calculation

Hi, I have a text file in below format. I trying to find a solution for finding percentage used for each of the NAMEs. Directory ALLOCATED USED NAME1 93MB 93KB NAME2 25G 62K NAME3 14G 873M NAME4 25G 62K NAME5 20G... (10 Replies)
Discussion started by: ctrld
10 Replies

3. Shell Programming and Scripting

Calculate Percentage

Hello, Ive got a bunch of numbers here e.g: 6065 6094 6348 6297 6161 6377 6338 6290 How do I find out if there is a difference between 10% or more between one of these numbers ? I am trying to do this in Bash.. but no luck so far.. Does anyone have an Idea ?? Thanx, - Pascal... (9 Replies)
Discussion started by: denbekker
9 Replies

4. Shell Programming and Scripting

Need to monitor OS in percentage

Hi, I am looking for generic commands / scripts that could run across platforms especially on HP Itanium boxes to give me % of free OS parameters For eg: Free Total Memory RAM : 20 % Free Total Swap Memory: 35% Free Total CPU utilisation: 44% Free Disk Space: /appl = 55%... (5 Replies)
Discussion started by: mohtashims
5 Replies

5. Shell Programming and Scripting

Percentage of occurence

Dear all, I have data like below and i need to add coloumn before the COUNT field to see the Percentage out of all COUNT field value for respective raw. ============================================= COUNT CODE sConnType tConnType... (6 Replies)
Discussion started by: Iroshan
6 Replies

6. Shell Programming and Scripting

Percentage calculation

i am trying to get percentage : but not able to do it: i tried : x=1 y=2 z=`expr $x/$y*100` it is not giving me result can u pls help on this (4 Replies)
Discussion started by: Aditya.Gurgaon
4 Replies

7. UNIX for Dummies Questions & Answers

percentage

How to calculate percentage of two values in unix. (5 Replies)
Discussion started by: venkatesht
5 Replies

8. Shell Programming and Scripting

How can i calculate percentage ??

i have 3 files like total.dat=18 equal.dat=14 notequal.dat=16 i need find the equal percentange means: equalpercentage = ($equal.dat / $total.dat * 100) How i can do this ? I tried some of the answers to calculate the percentage in this forums.but it couldn't worked.Some one please... (6 Replies)
Discussion started by: bobprabhu
6 Replies

9. Shell Programming and Scripting

awk percentage

how would you calculate percentage by per line? Given a column of 16 lines, grab each line and divide it by the sum of the entire column and multiply by 100? thanks ... (8 Replies)
Discussion started by: rockiefx
8 Replies

10. Programming

how do I calculate percentage ?

int percent (int a, int b) { if (b/a*100 > 25) return TRUE; else return FALSE; } I want to calculate what percentage of a is b. say if b = 48, a = 100 so b is 48% of a but wouldnt b/a give me 0 ??? what can be done ?? (6 Replies)
Discussion started by: the_learner
6 Replies
Login or Register to Ask a Question