Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Percentage of occurence

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Percentage of occurence
# 1  
Old 06-04-2013
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.

Code:
=============================================
COUNT           CODE         sConnType                  tConnType
=============================================
265873          171          uehRrcConn                 uehPacketEulHs
239103          171          uehPacketCch               uehPacketEulHs
56746           500          uehRrcConn                 uehPacketEulHs
51734           171          uehPacketEulHs             uehPacketEulHs
28244           54           uehPacketCch               uehPacketEulHs
22422           171          uehPacket128Hs             uehPacket384Hs

Expected format
Code:
=============================================
PERCENTAGE COUNT           CODE         sConnType                  tConnType
=============================================
    X                  265873          171          uehRrcConn                 uehPacketEulHs
                       239103          171          uehPacketCch               uehPacketEulHs
                       56746           500          uehRrcConn                 uehPacketEulHs
                       51734           171          uehPacketEulHs             uehPacketEulHs
                       28244           54           uehPacketCch               uehPacketEulHs
                       22422           171          uehPacket128Hs           uehPacket384Hs

Where X = 100*265873/(265873+239103+56746+51734+28244+22422)

Thanks in advance.

Rgds,
Iroshan
Last edited by Scott; 06-04-2013 at 05:38 AM.. Reason: Please use code tags
# 2  
Old 06-04-2013
What have you tried so far?
# 3  
Old 06-04-2013
In the below code reading file twice

Code:
  awk 'BEGIN{print "PERCENTAGE COUNT CODE sConnType tConnType"}
    NR==FNR && NR>1{sum+=$1;next}
    {if(FNR>1){print 100*$1/sum,$0}}' file.txt file.txt

# 4  
Old 06-04-2013
So far, i didn't have a logic to print that. I only can get Text file like this from processing TEXT files using "awk/sed/sort/uniq/grep" commands.
Hope UNIX command can do that.

Rgds,
Iroshan
# 5  
Old 06-04-2013
Ok, then I reinstate the post from pravin27 (post #3, which I had previously hidden).

If you don't understand any part of it, it's important that you say.

Repliers, please note: documented solutions are encouraged!
# 6  
Old 06-04-2013
Thanks for the solution it works for me as i Expected.

Rgds,
Iroshan
# 7  
Old 06-04-2013
Hi Scott,

I will take care going forward.. Apologies..

Thanks
Pravin
This User Gave Thanks to pravin27 For This Post:
Scott
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

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

4. Shell Programming and Scripting

Print between patterns - first occurence, second occurence etc

I have a file # cat asasas AAAAAA 11 22 33 44 BBBBB NILNILNIL AAAAAA 22 33 44 55 66 77 88 BBBBB NILNILNIL (2 Replies)
Discussion started by: anil510
2 Replies

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

6. UNIX for Dummies Questions & Answers

percentage

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

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

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

9. Linux

filesystem percentage

hi guys, im new in linux i need your help. my problem is how can i take the % here's the sample Available Used(%) Mounted On 1.2G 73% /var 299.3M 72% /home 520.3M 88% /home/file 164.8M 84% /home/prd 812.6M 79% ... (2 Replies)
Discussion started by: hdroid0326
2 Replies

10. Shell Programming and Scripting

percentage by line

hi, I am new to awk.. and getting used to the scripts. I have a small data set 5 coulms.. 16 rows. 1) I am trying to remove the percentages of each line of colum 3..like first line divided the sum of colum 3 divided by 100 and print it out. removing hte percentages of each line I would really... (3 Replies)
Discussion started by: rockiefx
3 Replies
Login or Register to Ask a Question