Sponsored Content
Top Forums Shell Programming and Scripting Merge column headers and transpose Post 302737667 by giuliangiuseppe on Thursday 29th of November 2012 11:27:57 AM
Old 11-29-2012
Merge column headers and transpose

Hello Everyone!
I am new on this forum and this is my first post. I wish to apologize for my, not canonical, English.
I would like to solve this problem but I have no clue of how do it!I will be grateful if someone could help me!
I have a table like this:
Code:
gene TF1 TF2 TF3 TF4
gene1 1 2 3 4
gene2 1 1 4 4
gene3 1 2 3 3
gene4 1 2 3 4
gene5 1 2 1 3
gene6 2 2 1 2
gene7 3 3 1 3
gene8 2 3 1 4

Each row is a gene and each column a transcription factor.The number in the intersection means if the TF there is, there is not, is upregulated, is downregulated.
Now what I would like to obtain is something like that:
Code:
gene TF
gene1TF1 1
gene1TF2 2
gene1TF3 3
gene1TF4 4
gene2TF1 1
gene2TF2 1
gene2TF3 4
gene2TF4 4
and so on

Adding at each gene the TF and the relative number!I get crazy!
I really hope that someone could help me!
Thanks a lot

Giuliano

Last edited by joeyg; 11-29-2012 at 02:29 PM.. Reason: corrected spelling
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing Headers and a Column

I have a text file in unix with a layout like this Column 1 - 1-12 Column 2 - 13-39 Column 3 - 40-58 Column 4 - 59-85 Column 5 - 86-120 Columbn 6 - 121-131 The file also has a header on the first 6 lines of each page. Each page is 51 lines long. So I want to remove the header from each... (30 Replies)
Discussion started by: DerangedNick
30 Replies

2. Shell Programming and Scripting

Excel Column Headers

cat ABC.log | egrep "Error 500" >> /tmp/Logs.log egrep "<Mango>.*<.Mango>" Logs.log | sed -e "s/^.*<Mango/<Mango/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp1.xls egrep "<Apple>.*<.Apple>" Logs.log | sed -e "s/^.*<Apple/<Apple/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp2.xls print Heading1,... (1 Reply)
Discussion started by: pk_eee
1 Replies

3. UNIX for Dummies Questions & Answers

Sort by Column Headers

Hi All, I am new to UNIX can you please help me to sort a file with different columns my file looks like this $ cat gaut.txt UID PID PPID PGID SID C STIME TTY TIME CMD liveuser 3008 2892 3008 3008 0 11:58 ? 00:00:00 gnome-session liveuser 3019 1 ... (8 Replies)
Discussion started by: cgk1983
8 Replies

4. Shell Programming and Scripting

Transpose multipe columns to rows and adding headers

Hi, I found the following awk script to transpose multiple (3) columns to multiple rows: #=== BEGIN {FS=","} { for (i=1;i<=NF;i++) { arr=$i; if(nf<= NF) nf=NF; } nr=NR } END { for(i=1;i<=nf;i++) { (8 Replies)
Discussion started by: Gery
8 Replies

5. Shell Programming and Scripting

Merge Multiple Files and Transpose

Looking to join three files and then transpose some columns from multiple rows into a single row. File Info: FIELD TERMINATED BY '^' ENCLOSED BY '~' LINE TERMINATED BY '\r\n' FIRST FILE (FOOD_DES.txt) ~01001~^~0100~^~Butter, salted~^~BUTTER,WITH... (2 Replies)
Discussion started by: mkastin
2 Replies

6. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ... (6 Replies)
Discussion started by: popesk
6 Replies

7. Shell Programming and Scripting

Transpose from 2nd column till the last column

Hi I have 5 columns like this a b c d e f g h i j k l m n o From 2nd column till the 5th column of every record, I would like to transpose them as rows, so my output file contains only one row a b c d e f g h i j (9 Replies)
Discussion started by: jacobs.smith
9 Replies

8. Shell Programming and Scripting

Transpose Second column only

Hi Folks, My input file is like this cat input abcd:efgh:jklm 123,456,67,78,89,90 hi:kil:op 76,78,12,3456, unix:linux:shell:bash 111,111 My expected output abcd:efgh:jklm hi:kil:op unix:linux:shell:bash 123 76 111 456 78 111 67 12 78 3456 89 90 (5 Replies)
Discussion started by: jacobs.smith
5 Replies

9. Shell Programming and Scripting

Merge csvs with column headers

hello gurus, Somebody must have done this before, I couldn't find anything. Please redirect me if this was solved before, and if not please help. To the problem now, I have multiple csv files (about 1000) which I need to concatenate by column header. The final file should have a superset... (4 Replies)
Discussion started by: abh.kumar
4 Replies

10. Shell Programming and Scripting

Transpose from row to column using timestamp in first column

Gents, Transpose from row to column, taking in consideration the first column, which contends the date. Input file 72918,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009 72918,2356,2357,2358,2359,2360,2361,2362,2363,2364 72918,0,0,0,0,0,0,0,0,0... (12 Replies)
Discussion started by: jiam912
12 Replies
Bio::Map::GeneMap(3pm)					User Contributed Perl Documentation				    Bio::Map::GeneMap(3pm)

NAME
Bio::Map::GeneMap - A MapI implementation to represent the area around a gene SYNOPSIS
use Bio::Map::GeneMap; use Bio::Map::Gene; use Bio::Map::TranscriptionFactor; use Bio::Map::GeneRelative; # make some maps that will represent an area around a particular gene in # particular species (by default, the map represents the area in the genome # 1000bp upstream of the gene) my $map1 = Bio::Map::GeneMap->get(-gene => 'BRCA2', -species => 'human', -description => 'breast cancer 2, early onset'); my $map2 = Bio::Map::GeneMap->get(-gene => 'BRCA2', -species => 'mouse'); # model a TF that binds 500bp upstream of the BRCA2 gene in humans and # 250bp upstream of BRCA2 in mice my $rel = Bio::Map::GeneRelative->new(-description => "gene start"); my $tf = Bio::Map::TranscriptionFactor->get(-universal_name => 'tf1'); Bio::Map::Position->new(-map => $map1, -element => $tf, -start => -500, -length => 10, -relative => $rel); Bio::Map::Position->new(-map => $map2, -element => $tf, -start => -250, -length => 10, -relative => $rel); # find out all the things that map near BRCA2 in all species foreach my $map ($gene->known_maps) { foreach my $thing ($map->get_elements) { next if $thing eq $gene; foreach my $pos ($thing->get_positions($map)) { print "In species ", $map->species, ", ", $thing->universal_name, " maps at ", $pos->value, " relative to ", $pos->relative->description, " of gene ", $gene->universal_name, " "; } } } # a GeneMap isa PrimarySeq and so can have sequence associated with it $map1->seq('ATGC'); my $subseq = $map1->subseq(2,3); # TG DESCRIPTION
Model the abstract notion of the area around a gene - you don't care exactly where this area is in the genome, you just want to be able to say "something binds upstream of gene X" and "something else binds 20bp upstream of the first something" etc. It's useful for modelling transcription factor bindings sites, letting you find out which transcription factors bind near a gene of interest, or which genes are bound by a transcription factor of interest. See 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::GeneMap->new(); Function: Builds a new Bio::Map::GeneMap object (that has placed on it a mappable element (Bio::Map::Gene) representing a gene). Returns : Bio::Map::GeneMap Args : -gene => string name of the gene this map will be for (in a form common to all species that have the gene, but unique amongst non-orthologous genes) or a Bio::Map::Gene object, REQUIRED -species => Bio::Taxon or string representing species, REQUIRED -uid => string, unique identifier for this map (must be unique amongst all gene/species combinations) -description => string, free text description of the gene -upstream => int, the number of bases the map extends before the start of the gene element (default 1000). -downstream => int, the number of bases the map extends beyond the end of the gene element (default 0). -seq => string, the sequence of the map, presumably the genomic sequence -upstream bases of the gene, including the gene, and -downstream bases of the gene get Title : get Usage : my $map = Bio::Map::GeneMap->get(); Function: Builds a new Bio::Map::GeneMap object (like new()), or gets a pre-existing one that corresponds to your arguments. Returns : Bio::Map::GeneMap Args : -gene => string name of the gene this map will be for (in a form common to all species that have the gene, but unique amongst non-orthologous genes) or a Bio::Map::Gene object, REQUIRED -species => Bio::Taxon or string representing species, REQUIRED -uid => string, unique identifier for this map (must be unique amongst all gene/species combinations) -description => string, free text description of the gene -upstream => int, the number of bases the map extends before the start of the gene element (default 1000). -downstream => int, the number of bases the map extends beyond the end of the gene element (default 0). -seq => string, the sequence of the map, presumably the genomic sequence -upstream bases of the gene, including the gene, and -downstream bases of the gene If you supply a -uid, and a map had previously been created and given that uid, that same map object will be returned. Otherwise, the combination of -gene and -species will be used to determine if the same map had previously been made. If a corresponding map hadn't previously been made, a new map object will be created and returned. unique_id Title : unique_id Usage : my $id = $map->unique_id; Function: Get/set the unique ID for this map Returns : string Args : none to get, OR string to set species Title : species Usage : my $species = $map->species; Function: Get/set Species for a map. It is not recommended to change this once set. Returns : Bio::Taxon object or string Args : none to get, OR Bio::Taxon or string to set type Title : type Usage : my $type = $map->type Function: Get Map type Returns : string 'gene' Args : none gene Title : gene Usage : my $gene = $map->gene; $map->gene(-gene => $gene); Function: Get/set the mappable element on this map that represents the gene this map is for. Once set, it is not recommended to re-set the gene to something else. Behaviour in that case is undefined. Returns : Bio::Map::Gene Args : none to get, OR to set: -gene => Bio::Map::Gene or string of the universal name (see Bio::Map::Gene docs), REQUIRED -description => string, applied to the Bio::Map::Gene -upstream => int, the number of bases the map extends before the start of the gene element (default 1000). -downstream => int, the number of bases the map extends beyond the end of the gene element (default 0). universal_name Title : universal_name Usage : my $name = $map->universal_name Function: Get/set the name of Bio::Map::Gene object associated with this map. It is not recommended to change this once set. Returns : string Args : none to get, OR string to set upstream Title : upstream Usage : my $distance = $map->upstream; $map->upstream($distance); Function: Get/set how long the map is before the start of the Bio::Map::Gene object on this map. Returns : int Args : none to get, OR int to set (the number of bases the map extends before the start of the gene) downstream Title : downstream Usage : my $distance = $map->downstream; $map->downstream($distance); Function: Get/set the nominal end of the map relative to the end of the Bio::Map::Gene object on this map. Returns : int Args : none to get, OR int to set (the number of bases the map extends beyond the end of the gene) length Title : length Usage : my $length = $map->length(); Function: Retrieves the length of the map. This is normally the length of the upstream region + length of the gene + length of the downstream region, but may be longer if positions have been placed on the map beyond the end of the nominal downstream region. Returns : int Args : none seq Title : seq Usage : $string = $obj->seq() Function: Get/set the sequence as a string of letters. When getting, If the GeneMap object didn't have sequence attached directly to it for the region requested, the map's gene's database will be asked for the sequence, and failing that, the map's gene's positions will be asked for their sequences. Areas for which no sequence could be found will be filled with Ns, unless no sequence was found anywhere, in which case undef is returned. Returns : string Args : Optionally on set the new value (a string). An optional second argument presets the alphabet (otherwise it will be guessed). subseq Title : subseq Usage : $substring = $obj->subseq(10, 40); Function: Returns the subseq from start to end, where the first base is 1 and the number is inclusive, ie 1-2 are the first two bases of the sequence. If the GeneMap object didn't have sequence attached directly to it for the region requested, the map's gene's database will be asked for the sequence, and failing that, the map's gene's positions will be asked for their sequences. Areas for which no sequence could be found will be filled with Ns, unless no sequence was found anywhere, in which case undef is returned. subseq requests that extend beyond the end of the map will throw. Returns : string Args : integer for start position AND integer for end position OR Bio::LocationI location for subseq (strand honored) OR Bio::RangeI (eg. a Bio::Map::PositionI) perl v5.14.2 2012-03-02 Bio::Map::GeneMap(3pm)
All times are GMT -4. The time now is 10:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy