How to calculate the percentage for the values in column

saleru_raja · #1 (**permalink**) 08-29-2008

Hi, I am having the file which contains the following two columns.
518 _factorial
256 _main
73 _atol
52 ___do_global_ctors
170 ___main
52 ___do_g
How can calculate the percentage of each value in the first column ?
first need to get the sum of the first column and then each value is divide by sum and multiply by 100 to get the percentage.
How can we write script for that ?

Thanks and Regards
Raja

Annihilannic · #2 (**permalink**) 08-29-2008

Try this:

Code:

awk '
        NR > max { max=NR }
        { tot+=$1; v[NR]=$1; d[NR]=$2 }
        END { for (i=1; i<=max; i++) { print v[i]*100/tot,v[i],d[i] } }

' inputfile

Franklin52 · #3 (**permalink**) 08-29-2008

Another approach:

Code:

awk 'NR==FNR{t+=$1;next}{printf("%.2f %s\n", $1/t*100, $2)}' file file

Annihilannic · #4 (**permalink**) 08-29-2008

Yep, that's much neater.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to read the column and print the values under that column	gemini106	Shell Programming and Scripting	6	03-28-2008 07:05 AM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
Use awk to calculate average of column 3	grossgermany	UNIX for Dummies Questions & Answers	6	07-27-2007 02:29 PM
calculate average of column 2	onthetopo	UNIX for Dummies Questions & Answers	0	07-06-2007 09:16 PM
how do I calculate percentage ?	the_learner	High Level Programming	6	04-18-2007 05:40 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by