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 SUSE

uuid

uuid(n) 							       uuid								   uuid(n)

__________________________________________________________________________________________________________________________________________________

NAME

       uuid - UUID generation and comparison

SYNOPSIS

       package require Tcl  8.2

       package require uuid  ?1.0.1?

       ::uuid::uuid generate

       ::uuid::uuid equal id1 id2

_________________________________________________________________

DESCRIPTION

       This package provides a generator of universally unique identifiers (UUID) also known as globally unique identifiers (GUID). This implemen-
       tation follows the draft specification from (1) although this is actually an expired draft document.

COMMANDS

       ::uuid::uuid generate
	      Creates a type 4 uuid by MD5 hashing a number of bits of variant data including the time and hostname.  Returns the string represen-
	      tation of the new uuid.

       ::uuid::uuid equal id1 id2
	      Compares two uuids and returns true if both arguments are the same uuid.

EXAMPLES

       % uuid::uuid generate
       b12dc22c-5c36-41d2-57da-e29d0ef5839c

REFERENCES

       [1]    Paul J. Leach, "UUIDs and GUIDs", February 1998.	(http://www.opengroup.org/dce/info/draft-leach-uuids-guids-01.txt)

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category uuid of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       GUID, UUID

COPYRIGHT

       Copyright (c) 2004, Pat Thoyts <patthoyts@users.sourceforge.net>

uuid								       1.0.1								   uuid(n)

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 SUSE

uuid