Help getting a code in awk - Want to know how much of the data is covered by entries Post: 303037835

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Help getting a code in awk - Want to know how much of the data is covered by entries Post 303037835 by Flebman on Wednesday 14th of August 2019 12:07:10 PM

08-14-2019

Registered User

Help getting a code in awk - Want to know how much of the data is covered by entries

Here is my data structure.

Code:

# id1    id2    len   start    end
# 9     16792   5475   4181     4232
# 11    16792   2317   1086     1137
# 11    32879   2317      8       60
# 11    32858   2317     10       52
# 11    30670   2317     17       63
# 14    12645    532      3       67
# 14    12645    532    158      222
# 14    11879    532      3      223
# 18    23847    644     64      285
# 18    30160    644     98      285
# 18    30160    644    345      477
# 18    30160    644    516      644

I want to get the coverage of id1 based on its length (column len) considering all entries start and end values. The problem is that the multiple entries can have juxtapose values so considering the values in all entries would overrate the coverage. Also considering the smallest start value and biggest end value doesn't account for all since it can have gaps where not all length is represented.

My expected result should be something like this

Code:

 9 --- 50 / 5475  = 0.009
11 --- 106 / 2317 = 0.046
14 --- 220 / 532  = 0.414
18 --- 481 / 644  = 0.75

Last edited by Scrutinizer; 08-14-2019 at 02:02 PM.. Reason: code tags

Flebman

View Public Profile for Flebman

Find all posts by Flebman

We Also Found This Discussion For You

1. Shell Programming and Scripting

awk code to ignore the first occurence unknown number of rows in a data column

Hello experts, Shown below is the 2 column sample data(there are many data columns in actual input file), Key, Data A, 1 A, 2 A, 2 A, 3 A, 1 A, 1 A, 1 I need the below output. Key, Data A, 2 A, 2 A, 3 A, 1 A, 1 A, 1

LEARN ABOUT OSF1

mkproto

mkproto(8)						      System Manager's Manual							mkproto(8)

NAME

       mkproto - Constructs a prototype file system

SYNOPSIS

       mkproto special proto

DESCRIPTION

       The  mkproto command is used to bootstrap a new file system.  First a new file system is created using newfs.  mkproto is then used to copy
       files from the old file system into the new file system according to the directions found in the prototype file proto.  The prototype  file
       contains  tokens separated by spaces or newlines.  The first tokens comprise the specification for the root directory.  File specifications
       consist of tokens, giving the mode, the user ID, the group ID, and the initial contents of the file.  The  syntax  of  the  contents  field
       depends on the mode.

       The mode token for a file is a 6-character string.  The first character specifies the type of the file.	(The characters -bcd specify regu-
       lar, block-special, character-special, and directory files, respectively.) The second character of the type is either a u or a - (dash)	to
       specify	setuid mode or not.  The third character is either a g or a - (dash) for the setgid mode.  The rest of the mode is a 3-digit octal
       number, giving the owner, group, and other read, write, execute permissions.  (See the chmod(1) command for more information.)

       Two decimal number tokens come after the mode; they specify the user and group IDs of the owner of the file: If the file is a regular file,
       the  next token is a pathname from which the contents and size are copied.  If the file is a block-special or a character-special file, two
       decimal number tokens follow, giving the major and minor device numbers.  If the file is a directory, mkproto makes the entries . (dot) and
       .. (dot dot) and then reads a list of names and (recursively) file specifications for the entries in the directory.  The scan is terminated
       with the token $.

       The following listing shows a sample prototype specification.  d--777 3 1 usr  d--777 3 1      sh   ---755 3 1 /bin/sh	   ken	d--755 6 1
		 $	b0   b--644 3 1 0 0	 c0   c--644 3 1 0 0	  $ $

FILES

       Specifies the command path

RELATED INFORMATION

       Commands:  fsck(8), fsdb(8), newfs(8).  delim off

																	mkproto(8)

We Also Found This Discussion For You

1. Shell Programming and Scripting

awk code to ignore the first occurence unknown number of rows in a data column

Discussion started by: ks_reddy

LEARN ABOUT OSF1

mkproto