Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Create range of bins counting values and add the percentage
Top Forums UNIX for Beginners Questions & Answers Create range of bins counting values and add the percentage Post 303044451 by jiam912 on Friday 21st of February 2020 02:15:24 PM
Old 02-21-2020
Create range of bins counting values and add the percentage
Objective, create a table of range of bins to count the values for each range in column 2.

The purpose is to count at beginning all values in column 2 which contends value =0 or < 0.01
Then create the range of binnes counting values in column 2 > 0.01

The range of bins need to be extended to the MAX value in my case 20, even if these values are not found in the column.

Input file
Code:
121 0.98
121 0.98
121 1.47
121 1.47
121 0.00
121 0.00
121 0.00
121 0.10
121    2
121    3
121    7
121    0
121    0
121   10
121   12
121   15

Desired output file

Code:
            0    5    31.3%
 0.01 -  2.00    6    37.5%
 2.01 -  4.00    1     6.3%
 4.01 -  6.00    0     0.0%
 6.01 -  8.00    1     6.3%
 8.01 - 10.00    0     0.0%
10.01 - 12.00    2    12.5%
12.01 - 14.00    0     0.0%
14.01 - 16.00    1     6.3%
16.01 - 18.00    0     0.0%
18.01 - 20.00    0     0.0%
      > 20       0     0.0%
----------------------------
      Total:    16


Code Use
This code works well, but dont count values with exactly 0, and dont force the range of bins to the maximun value.

Code:
awk -v"MIN=0" -v"MAX=20" '
BEGIN   {delta = (delta=="")?2:delta
         MXBCK = (MAX / delta) + 1
        }

        {bucketNr = int(($2+delta) / delta)
         if (bucketNr > MXBCK) bucketNr = MXBCK
         cnt[bucketNr] ++
         TOT           ++ $2
         numBuckets = (numBuckets > bucketNr ? numBuckets : bucketNr)
        }

END     {
for (bucketNr=1; bucketNr<numBuckets; bucketNr++)      {end = beg + delta
         printf " %05.2f - %05.2f %6d %6.2f%%\n", beg, end, cnt[bucketNr], cnt[bucketNr] / TOT *100
         beg = end
         }
         printf "       > %5.2f %6d %6.2f%%\n", MAX, cnt[MXBCK], cnt[MXBCK] / TOT *100
         print "----------------------------"
         print "        Total:", TOT
        }
' file

Thanks in advance
Last edited by jiam912; 02-22-2020 at 06:13 AM..
 

10 More Discussions You Might Find Interesting

1. 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 Replies)
Discussion started by: saleru_raja
3 Replies

2. Shell Programming and Scripting

To Create range of values

Hi, I have a file with the below like values with integers only in sorted order (May or may not be in sequence) Eg: File1.txt ----------- 1 2 3 4 5 6 . . . . . 10000 My requirement here is to create a range of values out put to a temp k (4 Replies)
Discussion started by: shiva447
4 Replies

3. Shell Programming and Scripting

Howto: easy date range iteration/counting on GNU systems in the shell

Should work in any shell, but requires GNU date, although GNU date seems only to be happy for input dates between 1902 and 2037, inclusive (49673 days). Assume $a and $b hold two dates, e.g. set a=2010-03-27 set b=2010-04-04 Marginally faster: iterator: seq -f "$a +%1.0f days" 1 50000 |... (0 Replies)
Discussion started by: laddiebuck
0 Replies

4. UNIX for Dummies Questions & Answers

Working out the percentage between two values

Hi there, I am totally new to Unix, I am trying to work out the percentage between two values in a ksh shell script and assign the result to a variable. Value1=577 Values2=244 So the calculation would be as follows: ((Value1 - Value2) / Value1) * 100 How would I be able to achieve... (2 Replies)
Discussion started by: NextLevelAndi
2 Replies

5. Shell Programming and Scripting

return counting per hour percentage

We have a monitoring process for a load in unix box, during this process we are writing logs statements for each record, and during this process we are showing the counts per hour. Here is that how we are following log files statements: (just two lines printed here), these statements logged at... (1 Reply)
Discussion started by: skkuchipudi
1 Replies

6. Shell Programming and Scripting

Calculating frequency of values within bins

Hi, I am working with files containing 2 columns in which i need to come up with the frequency/count of values in col. 2 falling within specifics binned values of col. 1. the contents of a sample file is shown below: 15 12.5 15 11.2 16 0.2 16 1.4 17 1.6 18 4.5 17 5.6 12 8.6 11 7.2 9 ... (13 Replies)
Discussion started by: ida1215
13 Replies

7. Shell Programming and Scripting

Convert Column Values to a Range of Values

I have a list of columns with values that I need to transform into a row containing the range of each column. For example: "Column A" 1 2 3 4 10 12 14 15 16 17 18 "Column B" 1 4 5 6 (4 Replies)
Discussion started by: newbio
4 Replies

8. Shell Programming and Scripting

Delete row if both percentage values are equal to zero

Hello, I have compiled a script but I have stucked at one point. Each line contains two pcs of % value and what I want to do is to delete any line if both % values are zero. data: expected output: ow3 should be deleted as both percentage value in related line are equal to zero. ... (2 Replies)
Discussion started by: baris35
2 Replies

9. Shell Programming and Scripting

Create range of values and count values.

Gents, It is possible to generate a range of values according to column 1 and count the total of rows in the range. example input 15.3 15.5 15.8 15.9 16.0 16.1 16.8 17.0 17.5 18.0 output desired 15.0 - 15.9 = 4 (10 Replies)
Discussion started by: jiam912
10 Replies

10. UNIX for Beginners Questions & Answers

Create bins with totals and percentage

I would like to create bins to get histogram with totals and percentage, e.g. starting from 0. If possible to set the minimum and maximum value in the bins ( in my case value min=0 and max=20 ) Input file 8 5 10 1 11 4 12 4 12 4 13 5 16 7 18 9 16 9 17 7 18 5 19 5 20 1 21 7 (10 Replies)
Discussion started by: jiam912
10 Replies

LEARN ABOUT DEBIAN

condor_cod

condor_cod(1)						      General Commands Manual						     condor_cod(1)

Name
       condor_cod manage - COD machines and jobs

Synopsis
       condor_cod [-help -version]

       condor_codrequest[-pool	centralmanagerhostname[:portnumber]-name  scheddname][-addr "<a.b.c.d:port>"] [[-help -version] [-debug -timeout N
       -classad file] ] [-requirements expr] [-lease N]

       condor_codrelease-id ClaimID[[-help -version] [-debug -timeout N -classad file] ] [-fast]

       condor_codactivate-id ClaimID[[-help -version] [-debug -timeout N -classad file] ] [-keyword string -jobad  filename  -cluster  N  -proc  N
       -requirements expr]

       condor_coddeactivate-id ClaimID[[-help -version] [-debug -timeout N -classad file] ] [-fast]

       condor_codsuspend-id ClaimID[[-help -version] [-debug -timeout N -classad file] ]

       condor_codrenew-id ClaimID[[-help -version] [-debug -timeout N -classad file] ]

       condor_codresume-id ClaimID[[-help -version] [-debug -timeout N -classad file] ]

       condor_coddelegate_proxy-id ClaimID[[-help -version] [-debug -timeout N -classad file] ] [-x509proxy ProxyFile]

Description
       condor_codissues commands that manage and use COD claims on machines, given proper authorization.

       Instead of specifying an argument of request, release, activate, deactivate, suspend, renew, or resume, the user may invoke the condor_cod-
       tool by appending an underscore followed by one of these arguments. As an example, the following two commands are equivalent:

	  condor_cod  release -id "<128.105.121.21:49973>#1073352104#4"

	  condor_cod _release -id "<128.105.121.21:49973>#1073352104#4"

       To make these extended-name commands work, hard link the extended name to the condor_codexecutable. For example on a Unix machine:

       ln condor_cod _request condor_cod

       The requestargument gives a claim ID, and the other commands (release, activate, deactivate, suspend, and resume) use  the  claim  ID.  The
       claim ID is given as the last line of output for a request, and the output appears of the form:

       ID of new claim is: "<a.b.c.d:portnumber>#x#y"

       An actual example of this line of output is

       ID of new claim is: "<128.105.121.21:49973>#1073352104#4"

       Also see section 4.3for more a complete description of COD.

Options
       -help

	  Display usage information

       -version

	  Display version information

       -pool centralmanagerhostname[:portnumber]

	  Specify a pool by giving the central manager's host name and an optional port number

       -name scheddname

	  Send the command to a machine identified by scheddname

       -addr <a.b.c.d:port>

	  Send the command to a machine located at "<a.b.c.d:port>"

       -lease N

	  For the requestof a new claim, automatically release the claim after Nseconds.

       request

	  Create a new COD claim

       release

	  Relinquish a claim and kill any running job

       activate

	  Start a job on a given claim

       deactivate

	  Kill the current job, but keep the claim

       suspend

	  Suspend the job on a given claim

       renew

	  Renew the lease to the COD claim

       resume

	  Resume the job on a given claim

       delegate_proxy

	  Delegate an X509 proxy for the given claim

General Remarks
Examples
Exit Status
       condor_codwill exit with a status value of 0 (zero) upon success, and it will exit with the value 1 (one) upon failure.

Author
       Condor Team, University of Wisconsin-Madison

Copyright
       Copyright  (C)  1990-2012  Condor  Team,  Computer  Sciences Department, University of Wisconsin-Madison, Madison, WI. All Rights Reserved.
       Licensed under the Apache License, Version 2.0.

       See the Condor Version 7.8.2 Manualor http://www.condorproject.org/licensefor additional notices. condor-admin@cs.wisc.edu

								  September 2012						     condor_cod(1)
All times are GMT -4. The time now is 05:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy