awk to output the percentage of a field compared to length
The awk below using the sample input would output the following: Basically, it averages the text in $5 that matches if $7 < 30 . Sample Input
Output
My question is I can not seem to add the correct syntax that will also output the total # of lines in $6 that represent $5 and the % of 7 < 30 I know my words may not be all that helpful so hopefully the desired output will help. Thank you .
Desired output
the boild is only to show the math and does not need rto be included.
Last edited by cmccabe; 09-30-2015 at 05:57 PM..
Reason: fixed formatting; [mod] extra code tags, added details
Is there a command that sets a variable length?
I have a input of a variable length field but my output for that field needs to be set to 32 char.
Is there such a command?
I am on a sun box running ksh
Thanks (2 Replies)
Dear All,
1.txt (tab in between each value in a line)
a b c
a b c
a c d
you can see below, why with ~ i can output with tab, but = cannot?
# awk -F'\t' '$2 ~ /b/' 1
a b c
a b c
# awk -F'\t' '$2 = "b"' 1
a b c
a b c
a b d
... (1 Reply)
Hello Everyone,
I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table.
Input Data-
------ ------------------------ ---- -----------------
WFI001 Xxxxxx Control Work Item A Number of Records
------ ------------------------... (5 Replies)
In awk, how do I print all fields with a specified output field separator?
I have tried the following, which does not print the output FS:
echo a b c d | awk 'BEGIN{OFS = ";"}{print $0}' (3 Replies)
Hi all,
I have a requirement to replace a field with a character as per the length of the field.
Suppose i have a file where second field is of 20 character length. I want to replace second field with 20 stars (*). like ********************
As the field is not a fixed one, i want to do the... (2 Replies)
Need an awk script to calculate the percentage of value field and replace
I have a input file called file.txt with the following content:
john|622.5674603562933|8|br:1;cn:3;fr:1;jp:1;us:2
andy|0.0|12|**:3;br:1;ca:2;de:2;dz:1;fr:2;nl:1
in fourth filed of input file, calulate percentage of each... (1 Reply)
I have a input file called file.txt with the following content:
john|622.5674603562933|8|br:1;cn:3;fr:1;jp:1;us:2
andy|0.0|12|**:3;br:1;ca:2;de:2;dz:1;fr:2;nl:1
in fourth filed of input file, calulate percentage of each sub filed seperated by ; semicolon and replace value with percentage .
i... (11 Replies)
I have several questions about using awk. I'm hoping someone could lend me a hand. (I'm also hoping that my questions make sense.)
I have a file that contains pipe separated data. Each line has similar data but the number of fields and the field position on each line is variable. ... (3 Replies)
The awk below produces the current output, which will add +1 to $3. However, I am trying to add the length of the matching characters between $5 and $6 to $3. I have tried using sub as a variable to store the length but am not able to do so correctly. I added comments to each line and the... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT DEBIAN
bio::map::geneposition
Bio::Map::GenePosition(3pm) User Contributed Perl Documentation Bio::Map::GenePosition(3pm)NAME
Bio::Map::GenePosition - A typed position, suitable for modelling the various
regions of a gene.
SYNOPSIS
use Bio::Map::GenePosition;
use Bio::Map::GeneMap;
# say that the first transcript of a particular gene on a particular map
# (species) is 1000bp long
my $map = Bio::Map:GeneMap->get(-universal_name => 'BRCA2',
-species => 'human');
my $gene = $map->gene;
Bio::Map::GenePosition->new(-map => $map,
-element => $gene,
-start => 0,
-length => 1000,
-type => 'transcript');
# say that the coding region of the gene starts 30bp into the first
# transcript
Bio::Map::GenePosition->new(-map => $map,
-element => $gene,
-start => 30,
-length => 600,
-type => 'coding');
# A GenePosition isa PositionWithSequence, so can have sequence associated
# with it
my $exon = Bio::Map::GenePosition->new(-map => $map,
-element => $gene,
-start => 0,
-type => 'exon',
-seq => 'ATGGGGTGGG');
my $length = $exon->length; # $length is 10
DESCRIPTION
Define where various sub-regions (transcripts, exons, introns etc.) of a gene are. Do this so that you can then go onto to model other
mappable elements as having positions 20bp upstream of transcript 2, or 10bp into intron 3 etc., all without having to know the absolute
position of anything.
See Bio::Map::GeneRelative and t/Map/Map.t for more example usage.
FEEDBACK
Mailing Lists
User feedback is an integral part of the evolution of this and other Bioperl modules. Send your comments and suggestions preferably to the
Bioperl mailing list. Your participation is much appreciated.
bioperl-l@bioperl.org - General discussion
http://bioperl.org/wiki/Mailing_lists - About the mailing lists
Support
Please direct usage questions or support issues to the mailing list:
bioperl-l@bioperl.org
rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address
it. Please include a thorough description of the problem with code and data examples if at all possible.
Reporting Bugs
Report bugs to the Bioperl bug tracking system to help us keep track of the bugs and their resolution. Bug reports can be submitted via the
web:
https://redmine.open-bio.org/projects/bioperl/
AUTHOR - Sendu Bala
Email bix@sendu.me.uk
APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
new
Title : new
Usage : my $obj = Bio::Map::GenePosition->new();
Function: Builds a new Bio::Map::GenePosition object
Returns : Bio::Map::GenePosition
Args : -map => Bio::Map::GeneMap object
-element => Bio::Map::Gene object
-relative => Bio::Map::GeneRelative object
-type => 'transcript|coding|exon|intron', REQUIRED
-seq => string, length of this string will set the length
of this position's range
* If this position has no range, or if a single value can describe
the range *
-value => scalar : something that describes the single
point position or range of this
Position, most likely an int
* Or if this position has a range, at least two of *
-start => int : value of the start co-ordinate
-end => int : value of the end co-ordinate
-length => int : length of the range
map
Title : map
Usage : my $map = $position->map();
$position->map($map);
Function: Get/set the map the position is in.
Returns : L<Bio::Map::MapI>
Args : none to get
new L<Bio::Map::MapI> to set
element
Title : element
Usage : my $element = $position->element();
$position->element($element);
Function: Get/set the element the position is for.
Returns : L<Bio::Map::MappableI>
Args : none to get
new L<Bio::Map::MappableI> to set
type
Title : type
Usage : my $type = $position->type();
$position->type($type);
Function: Get/set the type of this position.
Returns : string
Args : none to get, OR
string transcript|coding|exon|intron to set
relative
Title : relative
Usage : my $relative = $position->relative();
$position->relative($relative);
Function: Get/set the thing this Position's coordinates (numerical(), start(),
end()) are relative to, as described by a RelativeI object.
Returns : Bio::Map::GeneRelative. The default GeneRelative returned has a
meaning that depends on the type() of GenePosition this is:
'transcript' : "relative to the start of the gene on the
Position's map"
'coding|exon|intron' : "relative to the start of the default
transcript of the gene on the Position's map"
Args : none to get, OR
Bio::Map::GeneRelative to set
seq
Title : seq
Usage : my $string = $position->seq();
Function: Get/set the sequence as a string of letters. If no sequence is
manually set by you, the position's map will be asked for the
sequence, and if available, that will be returned.
Returns : scalar
Args : Optionally on set the new value (a string). An optional second
argument presets the alphabet (otherwise it will be guessed).
perl v5.14.2 2012-03-02 Bio::Map::GenePosition(3pm)