Calculate Percentage Post: 302940990

Sponsored Content

Top Forums Shell Programming and Scripting Calculate Percentage Post 302940990 by Don Cragun on Friday 10th of April 2015 05:17:45 PM

04-10-2015

Registered User

Maybe this would be a good starting point:

Code:

awk '
NR == 1 {
	m = M = $1
	mn = NR
}
{	if($1 < m) {
		m = $1
		mn = NR
	}
	else if($1 > M) M = $1
	v[NR] = $1
}
END {	printf("minimum: %d, maximum: %d, difference: %.2f%%\n", 
		m, M, M * 100 / m - 100)
	for(i = 1; i <= NR; i++) 
		if(v[i] / m > 1.1)
			printf("Node %d(%d) is %.2f%% of node %d(%d)\n",
				i, v[i], v[i] * 100 / m, mn, m)
}' file

With your sample input, it produces the output:

Code:

minimum: 6065, maximum: 6377, difference: 5.14%

If we add the value 6800 to the end of your sample input, it produces:

Code:

minimum: 6065, maximum: 6800, difference: 12.12%
Node 9(6800) is 112.12% of node 1(6065)

If we change the 6800 to 5000, it produces the output:

Code:

minimum: 5000, maximum: 6377, difference: 27.54%
Node 1(6065) is 121.30% of node 9(5000)
Node 2(6094) is 121.88% of node 9(5000)
Node 3(6348) is 126.96% of node 9(5000)
Node 4(6297) is 125.94% of node 9(5000)
Node 5(6161) is 123.22% of node 9(5000)
Node 6(6377) is 127.54% of node 9(5000)
Node 7(6338) is 126.76% of node 9(5000)
Node 8(6290) is 125.80% of node 9(5000)

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk.

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

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

2. Shell Programming and Scripting

How to calculate the percentage for the values in column

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

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

4. Shell Programming and Scripting

Need an AWK script to calculate the percentage

Hi I need a awk script to calculate percentage. I have to pass the pararmeters in to the awk script and calculate the percentage. Sum = 50 passed = 43 failed = 7 I need to pass these value in to the awk script and calculate the percentage. Please advice me.

5. UNIX for Dummies Questions & Answers

Is it possible to extract rows with the same first column and then calculate its percentage?

A short excerpt of my .txt file looks like: CXRA3Z2J9MQKR B CXRA3Z2J9MQKR A CXRA3Z2J9MQKR C CXRA3Z2J9MQKR B A162JX4ML69UIC C A162JX4ML69UIC A FZ9Z19TI2XOA5 A FZ9Z19TI2XOA5 C FZ9Z19TI2XOA5 B FZ9Z19TI2XOA5 B BRNTTJUB8GXE9 A BRNTTJUB8GXE9 A ...

6. Shell Programming and Scripting

Script shell, how to calculate percentage?

hello, please can you help me. jj and kk are two numbers which are the result of an sql program. I would like to calculate the ratio jj/kk*100. I have done this: ratio=$((jj/kk * 100)) or ratio=`expr $jj \/ expr $kk) but the result is 0 What can i do? Thanks for help.

7. Shell Programming and Scripting

How to calculate what percentage of X value is there in the file?

Input File: 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...

8. Shell Programming and Scripting

Calculate percentage of a value accross m

I have 100 csv files like: file_city_1 file_city_2 file_city_3 file_city_4 City name is variable, there is 25 cities, each city has 4 region. Each of the 4 region contain some statistics like: parameter1 : number1 parameter1 : number2 ..... parameter50 : number50 ...

9. Shell Programming and Scripting

Calculate percentage of columns greater than certain value in a matrix using awk

This matrix represents correlation values. Is it possible to calculate the percentage of columns (a1, a2, a3) that have a value >= |0.5| and report the percentage that has positive correlation >0.5 and negative correlation <-0.5 separately. thanx in advance! input name a1 a2 a3...

10. Shell Programming and Scripting

Calculate percentage difference between two columns

I have a input text file in this format: ITEM1 10.9 20.1 ITEM2 11.6 12 ITEM3 14 15.7 ITEM5 20 50.6 ITEM6 25 23.6 I want to print those lines which have more than 5% difference between second and third columns.

LEARN ABOUT SUSE

xml::xpath::node

XPath::Node(3)						User Contributed Perl Documentation					    XPath::Node(3)

NAME

       XML::XPath::Node - internal representation of a node

API

       The Node API aims to emulate DOM to some extent, however the API isn't quite compatible with DOM. This is to ease transition from XML::DOM
       programming to XML::XPath. Compatibility with DOM may arise once XML::DOM gets namespace support.

   new
       Creates a new node. See the sub-classes for parameters to pass to new().

   getNodeType
       Returns one of ELEMENT_NODE, TEXT_NODE, COMMENT_NODE, ATTRIBUTE_NODE, PROCESSING_INSTRUCTION_NODE or NAMESPACE_NODE. UNKNOWN_NODE is
       returned if the sub-class doesn't implement getNodeType - but that means something is broken! The constants are exported by default from
       XML::XPath::Node. The constants have the same numeric value as the XML::DOM versions.

   getParentNode
       Returns the parent of this node, or undef if this is the root node. Note that the root node is the root node in terms of XPath - not the
       root element node.

   to_sax ( $handler | %handlers )
       Generates sax calls to the handler or handlers. See the PerlSAX docs for details (not yet implemented correctly).

MORE INFO

       See the sub-classes for the meaning of the rest of the API:

       o   XML::XPath::Node::Element

       o   XML::XPath::Node::Attribute

       o   XML::XPath::Node::Namespace

       o   XML::XPath::Node::Text

       o   XML::XPath::Node::Comment

       o   XML::XPath::Node::PI

perl v5.12.1							    2003-01-26							    XPath::Node(3)

10 More Discussions You Might Find Interesting

1. Programming

how do I calculate percentage ?

Discussion started by: the_learner

2. Shell Programming and Scripting

How to calculate the percentage for the values in column

Discussion started by: saleru_raja

3. Shell Programming and Scripting

How can i calculate percentage ??

Discussion started by: bobprabhu

4. Shell Programming and Scripting

Need an AWK script to calculate the percentage

Discussion started by: bobprabhu

5. UNIX for Dummies Questions & Answers

Is it possible to extract rows with the same first column and then calculate its percentage?

Discussion started by: pxalpine

6. Shell Programming and Scripting

Script shell, how to calculate percentage?

Discussion started by: likeaix

7. Shell Programming and Scripting

How to calculate what percentage of X value is there in the file?

Discussion started by: aroragaurav.84

8. Shell Programming and Scripting

Calculate percentage of a value accross m

Discussion started by: Meacham12

9. Shell Programming and Scripting

Calculate percentage of columns greater than certain value in a matrix using awk

Discussion started by: quincyjones

10. Shell Programming and Scripting

Calculate percentage difference between two columns

Discussion started by: ctrld

LEARN ABOUT SUSE

xml::xpath::node