Sponsored Content
Top Forums Shell Programming and Scripting Grouping and calculation of percentages Post 302608269 by polsum on Friday 16th of March 2012 05:27:08 PM
Old 03-16-2012
Grouping and calculation of percentages

Hi,

I have a table like this,

Group type L1 L2 L3 L4 L5 L6
A xx1 0 3 3 2 1 0
A xx2 2 2 2 1 7 2
B yy1 2 4 6 6 3 1
C yy2 7 7 7 0 2 3
C zz2 8 8 2 3 3 1
For each column L1 to L6, I need to calculate percentage for each "type" per column total in each "Group".

So, desired output is
Group type L1 L2 L3 L4 L5 L6
A xx1 0*100/2 3*100/5 3*100/5 2*100/3 1*100/8 0*100/2
A xx2 2*100/2 2*100/5 2*100/5 1*100/3 7*100/8 2*100/2
B yy1 2*100/2 4*100/4 6*100/6 6*100/6 3*100/3 1*100/1
C yy2 7*100/15 7*100/15 7*100/9 0*100/3 2*100/5 3*100/4
C zz2 8*100/15 8*100/15 2*100/9 3*100/3 3*100/5 1*100/4
I typed formulas, not actual percentages just to make things clear.

thanks in advance. Smilie

Last edited by polsum; 03-17-2012 at 01:07 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

egrep and grouping

i am using the c shell on solaris. directories i'm working with: ls -1d DIV* DIV_dental/ DIV_ibc/ DIV_ifc/ DIV_index/ DIV_pharm/ DIV_sectionI/ DIV_sectionI-title/ DIV_sectionI-toc/ DIV_sectionII-title/ DIV_sectionII-toc/ DIV_standing/ DIV_standing-toc/ DIV_title/ DIV_vision/ (1 Reply)
Discussion started by: effigy
1 Replies

2. Shell Programming and Scripting

ksh script using expr to calculate percentages

Within a ksh script on HP-UX I trying to calculate a percentage of a number (number/100 x percentage) using the below method and expr. TARPERC=`expr 16 / 100 \* 5` TARSUM=`expr 16 + $TARPERC` ZIPSUM=`expr $TARSUM \* 2` If the input is 16 outputs are: TARPERC: 0 TARSUM: 16 ZIPSUM: 32... (6 Replies)
Discussion started by: wurzul
6 Replies

3. UNIX for Advanced & Expert Users

Regarding the user grouping

I am new to the unix server. My question is: i have 10 users a b c d e f g h i j Among the 10 5 users are (normal) user and remainging 5 users are (qad) users How can i sepearte this one? How can i give the dlc access rights? Please provide the clear cut idea. (0 Replies)
Discussion started by: kingganesh04
0 Replies

4. Shell Programming and Scripting

Grouping each 2 lines

Whats a good way to group (by adding a new integer to the front of each line) pairs of lines, such that lines 1 & 2 are group 1, lines 3 & 4 are group 2, etc... ex input: A B C D etc... ex output: 1A 1B 2C 2D etc... (5 Replies)
Discussion started by: watingo
5 Replies

5. Shell Programming and Scripting

Comparing sizes in percentages of 2 files in bash

Hi guys, I hope you can enlight me with a script I'm doing for Solaris 10. Script goes like this: #!/usr/bin/bash fechahoy=`perl /export/home/info/John/fechamod.pl` fechayer=`perl /export/home/info/John/fecha.pl` echo $fechahoy echo $fechayer DAT1=`ssh ivt@blahblah ls -la... (1 Reply)
Discussion started by: sr00t
1 Replies

6. Shell Programming and Scripting

Script to provide percentages?

so i'm have been stifled here inn my attempts at this. i need to calculate an unusual figure. what is the percentage difference between 400 and 3? usually, to get the percentage, you just divide the smaller number by the bigger number. then multiply the answer by 100. in this case... (10 Replies)
Discussion started by: SkySmart
10 Replies

7. Shell Programming and Scripting

Diffing words - percentages

is there a way to do the following: say i have two words: WelcomeMattTom and WelcomeMTom How can i compare the two words to know how much alike, in percentages they are? like, how similar is WelcomeMTom to WelcomeMattTom? not clear yet? say i introduced a third word,... (6 Replies)
Discussion started by: SkySmart
6 Replies

8. Shell Programming and Scripting

Grouping

Hi all, I am using following command: perl program.pl input.txt output.txt CUTOFF 3 > groups_3.txt containing program.pl, two files (input.txt, output.txt) and getting output in groups_3.txt: But, I wish to have 30 files corresponding to each CUTOFF ranging from 0 to 30 using the same... (1 Reply)
Discussion started by: bioinfo
1 Replies

9. Shell Programming and Scripting

Name grouping

awk 'FNR==NR {a; next} $NF in a' genes.txt refseq_exons.txt > output.txt I can not figure out how to group the same name in $4 together. Basically, all the SKI together in separate rows and all the TGFB2. Thank you :). chr1 2160133 2161174 SKI chr1 218518675 218520389 TGFB2... (1 Reply)
Discussion started by: cmccabe
1 Replies

10. Shell Programming and Scripting

Grouping and Calculating

Hi All, I want to read the input file and store the output in the Output file. I pasted the sample Input and Output file below. Help me with this. Input file ================================= ITEM1 AAAAA 1 ITEM1 BBBBB 1 ITEM1 CCCCC 1 ITEM2 AAAAA 5 ITEM2 CCCCC 4... (1 Reply)
Discussion started by: humaemo
1 Replies
IMAGELAYEREFFECT(3)							 1						       IMAGELAYEREFFECT(3)

imagelayereffect - Set the alpha blending flag to use the bundled libgd layering effects

SYNOPSIS
bool imagelayereffect (resource $image, int $effect) DESCRIPTION
Set the alpha blending flag to use the bundled libgd layering effects. PARAMETERS
o $ image -An image resource, returned by one of the image creation functions, such as imagecreatetruecolor(3). o $effect - One of the following constants: o IMG_EFFECT_REPLACE - Use pixel replacement (equivalent of passing TRUE to imagealphablending(3)) o IMG_EFFECT_ALPHABLEND - Use normal pixel blending (equivalent of passing FALSE to imagealphablending(3)) o IMG_EFFECT_NORMAL - Same as IMG_EFFECT_ALPHABLEND. o IMG_EFFECT_OVERLAY - Overlay has the effect that black background pixels will remain black, white background pixels will remain white, but grey background pixels will take the colour of the foreground pixel. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 imagelayereffect(3) example <?php // Setup an image $im = imagecreatetruecolor(100, 100); // Set a background imagefilledrectangle($im, 0, 0, 100, 100, imagecolorallocate($im, 220, 220, 220)); // Apply the overlay alpha blending flag imagelayereffect($im, IMG_EFFECT_OVERLAY); // Draw two grey ellipses imagefilledellipse($im, 50, 50, 40, 40, imagecolorallocate($im, 100, 255, 100)); imagefilledellipse($im, 50, 50, 50, 80, imagecolorallocate($im, 100, 100, 255)); imagefilledellipse($im, 50, 50, 80, 50, imagecolorallocate($im, 255, 100, 100)); // Output header('Content-type: image/png'); imagepng($im); imagedestroy($im); ?> The above example will output something similar to:[NOT DISPLAYABLE MEDIA]Output of example : imagelayereffect() NOTES
Note This function requires GD 2.0.1 or later (2.0.28 or later is recommended). PHP Documentation Group IMAGELAYEREFFECT(3)
All times are GMT -4. The time now is 01:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy