Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: counts based on percentage
Top Forums Shell Programming and Scripting counts based on percentage Post 302544671 by Diya123 on Thursday 4th of August 2011 12:55:28 PM
Old 08-04-2011
counts based on percentage
I have a file with multiple entries and I have calculated the percentages. Now I want to know how many of my entries are there between 1-10% 11-20% and so on..

Code:
chr1_14401_14450    0.211954217888936
chr1_14451_14500   1.90758796100042
chr1_14501_14550   4.02713013988978
chr1_14551_14600   6.14667231877914
chr1_14601_14650   8.2662144976685
chr1_14651_14700   10.3857566765579
chr1_14701_14750   12.5052988554472
chr1_14751_14800   14.6248410343366
chr1_14801_14850   16.7443832132259
chr1_14851_14900   18.8639253921153

My percentages are in double,so it needs to be rounded off to the nearest and then accordingly calculate. How can I do this in awk?

o/p

0-10 5
11-20 5
21-30 0
31-40 0

so on until
90-100% 0

Thanks,
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

counts

How can i do a simple record count in my shell script? i just want to count the number of records i receive from a specific file. (11 Replies)
Discussion started by: k@ssidy
11 Replies

2. UNIX for Dummies Questions & Answers

counts

To start I have a table that has ticketholders. Each ticket holder has a unique number and each ticket holder is associated to a so called household number. You can have multiple guests w/i a household. I would like to create 3 flags (form a, for a household that has 1-4 gst) form b 5-8 gsts... (3 Replies)
Discussion started by: sbr262
3 Replies

3. UNIX for Dummies Questions & Answers

wc -c counts 1 char more per line

Hi, this might be a basic question... why is that wc -c counts 1 more per line than what is there. for example, > cat dum1.txt 123 12 > wc -c dum1.txt 7 dum1.txt Thanks, Sameer. (4 Replies)
Discussion started by: ensameer
4 Replies

4. Shell Programming and Scripting

Counts based on occurances

Hi, I have a file with 2500 entries. There are many duplicates,triplicates symbols in my file in the first column and the second column has categories(high/medium/low) . I want to have count for the occurances of each category for each unique symbol ABC high ABC high ABC medium ABC ... (2 Replies)
Discussion started by: Diya123
2 Replies

5. Shell Programming and Scripting

Filtering lines for column elements based on corresponding counts in another column

Hi, I have a file like this ACC 2 2 21 aaa AC 443 3 22 aaa GCT 76 1 33 xxx TCG 34 2 33 aaa ACGT 33 1 22 ggg TTC 99 3 44 wee CCA 33 2 33 ggg AAC 1 3 55 ddd TTG 10 1 22 ddd TTGC 98 3 22 ddd GCT 23 1 21 sds GTC 23 4 32 sds ACGT 32 2 33 vvv CGT 11 2 33 eee CCC 87 2 44... (1 Reply)
Discussion started by: polsum
1 Replies

6. UNIX for Dummies Questions & Answers

Get counts from List

This is very easy , but I`m struggling .. please help modify my script, I want to count the number of h and n , from the second column group by the first. The second column is binary, can only have h and n. a h a h a n a n a h b h b h b h b h b h c n c h c h c h c h (2 Replies)
Discussion started by: jianp83
2 Replies

7. Shell Programming and Scripting

Different counts between programs and commands

In the attached file if I do a count for "aaaaaaaaaaaa" in either notepad++ or excel I get 118,456. However, when I do either grep -o aaaaaaaaaaaa 12A.txt | wc -w or awk '{ for (i=1;i<=NF;i++) if ( $i == "aaaaaaaaaaaa") c++ } END{ print c}' 12A.txt I... (3 Replies)
Discussion started by: cmccabe
3 Replies

8. Solaris

Capture PRSTAT based on CPU usage percentage

Hi, Recently i have write a simple script to capture CPU high usage based on prstat but i found out that it did capture correctly. I need to capture the rows that contains CPU usage more than 3%. Below line which i thought will capture CPU usage based CPU column in prstat(9th parameter) which is... (3 Replies)
Discussion started by: tharmendran
3 Replies

LEARN ABOUT MOJAVE

tiff2bw

tiff2bw(1)							   User Commands							tiff2bw(1)

NAME

       tiff2bw - convert a color TIFF image to grayscale

SYNOPSIS

       tiff2bw [options] input.tif output.tif

DESCRIPTION

       tiff2bw	converts an RGB or palette color TIFF image to a grayscale image by combining percentages of the red, green, and blue channels. By
       default, output samples are created by taking 28% of the red channel, 59% of the green channel, and 11% of the blue channel. To alter these
       percentages, use the -R. -G, and -B options.

OPTIONS

       The following options are supported:

       -B	       Specify the percentage of the blue channel to use. The default value is 11.

       -c	       Specify a compression scheme to use when writing image data:

		       -c g3		       CCITT Group 3 compression algorithm.

		       -c g4		       CCITT Group 4 compression algorithm.

		       -c lzw		       Lempel-Ziv and Welch algorithm. This is the default algorithm.

		       -c none		       No compression.

		       -c packbits	       PackBits compression algorithm.

		       -c zip		       Deflate compression algorithm.

       -G	       Specify the percentage of the green channel to use. The default value is 59.

       -R	       Specify the percentage of the red channel to use. The default value is 28.

       -r	       Write  data  with  a  specified number of rows per strip. By default, the number of rows per strip is selected so that each
		       strip is approximately 8 kilobytes.

OPERANDS

       The following operands are supported:

       input.tif       The name of the input TIFF file.

       output.tif      The name of the output file.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWTiff			   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |External			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       pal2rgb(1), tiffinfo(1), tiffcp(1), tiffmedian(1), libtiff(3)

NOTES

       Updated by Breda McColgan, Sun Microsystems Inc., 2004.

SunOS 5.10							    26 Mar 2004 							tiff2bw(1)
All times are GMT -4. The time now is 05:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy