Sponsored Content
Full Discussion: Transpose a file
Top Forums Shell Programming and Scripting Transpose a file Post 302407907 by stateperl on Saturday 27th of March 2010 12:32:39 AM
Old 03-27-2010
Transpose a file

input

Code:
IndID    ID1    ID2    ID3
a1    a/a    b/b    c/c
a2    a/a    b/b    c/c
a3    a/b    b/b    c/d
a6    a/b    b/b    c/e
a8    a/a    b/c    c/e
a9    b/b    b/d    c/e

output
Code:
IDName    IndID    IDtype    C_No
ID1    a1    a/a    1
ID1    a2    a/a    1
ID1    a8    a/a    1
ID1    a3    a/b    2
ID1    a6    a/b    2
ID1    a9    b/b    3    
ID2    a1    b/b    1
ID2    a2    b/b    1
ID2    a3    b/b    1
ID2    a6    b/b    1
ID2    a8    b/c    2
ID2    a9    b/d    3


Note: C_No :: a/a=most frequent similar double letter in ID1 then it will be = 1
b/b=second most..................................ID1 then it will be = 3
a/b=...................dissimilar....................ID1 ...................= 2
Same applies to all IDnames but IDtypes may change
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

transpose file

Hi all, I have a file in the below format.... <A> B C <A> E F <A> G H I need the result file to be: <A>BC <A>EF <A>GH (3 Replies)
Discussion started by: new_ds_man
3 Replies

2. Shell Programming and Scripting

Transpose an entire text file

Hello all, I want to transpose the rows of a file to the columns (every characters include spaces), i.e.: input: abcdefg 123 456 output: a1 b2 c3 d e4 f5 g6 I wrote a script: #!/bin/csh -f (15 Replies)
Discussion started by: heavenfish
15 Replies

3. Shell Programming and Scripting

File Transpose

Hi ALL I have one input file say FILE1 which looks as below. a=1 b=2 c=3 a=4 b=5 c=6 . . . Here a,b,c...etc are variable names. The output file(FILE2) should look like 1,2,3 4,5,6 ..... ..... (5 Replies)
Discussion started by: 46019
5 Replies

4. Shell Programming and Scripting

Rows to Columns - File Transpose

Hi I have an input file and I want to transpose it but I need to take care that if any field is missing for a record it should be popoulated with space for that field - using a shell script INFILE ---------- emp=1 sal=2 loc=abc emp=2 sal=21 sal=22 loc=xyz emp=5 loc=abc OUTFILE... (10 Replies)
Discussion started by: 46019
10 Replies

5. Shell Programming and Scripting

Transpose a text file.

Hello, I have a text file which is like a matrix m rows and n columns. Now I want to convert it into n rows and m columns. Thanks for hint. (1 Reply)
Discussion started by: zhshqzyc
1 Replies

6. Shell Programming and Scripting

Transpose whole file and specific columns

Hi, I have a file like this a b c d e f g h i j k l Case1: I want to transpose the whole file Output1 a d g j b e h k c f i l Case2 Transpose a specific column - Say 3rd (6 Replies)
Discussion started by: jacobs.smith
6 Replies

7. Shell Programming and Scripting

File transpose problem

Hi Friends, I have a file with a structure like this: <file1.csv> field1,field2,field3,field4,field5,field6,field7,field8,field9,field10,field11,field12 Few Salient points on the file's structure (1)The fields from field1 to field6 is fixed and they would always be present in the file... (2 Replies)
Discussion started by: mehimadri12
2 Replies

8. UNIX for Dummies Questions & Answers

Transpose File

Have various files like this: InSlot=0x00000001 InPort=0x00000000 Inref=0x0000002f InSID=0x00000001 OutSlot=0x00000001 OutPort=0x00000002 Outref=0x00000000 OutSID=0x0000000b OutUName_2=14 InSlot=0x00000001 InPort=0x00000000 Inref=0x000001a8 InSID=0x00000001 OutSlot=0x00000001... (5 Replies)
Discussion started by: K@rlos
5 Replies

9. Shell Programming and Scripting

Transpose a txt file

Hello, I have a text file with 148 rows and 2532691 columns. I need to transpose the data. The command that I am using is awk ' { for (i=1; i<=NF; i++) { a = $i } } NF>p { p = NF } END { for(j=1; j<=p; j++) { str=a for(i=2; i<=NR; i++){ ... (6 Replies)
Discussion started by: nans
6 Replies

10. UNIX for Dummies Questions & Answers

Transpose a file

Hello, I have a file which looks like this Input: Sample Genotype Assay Well plate Sample1 T xx A01 1 Sample2 T xx A01 2 Sample3 T xx A01 3 Sample4 T xx A02 4 Sample5 T xx A02 5 Sample6 T xx A02 ... (4 Replies)
Discussion started by: nans
4 Replies
GO-FILTER-SUBSET(1p)					User Contributed Perl Documentation				      GO-FILTER-SUBSET(1p)

NAME
go-filter-subset.pl - extracts a subgraph from an ontology file SYNOPSIS
go-filter-subset.pl -id GO:0003767 go.obo go-filter-subset.pl -id GO:0003767 -to png go.obo | xv - go-filter-subset.pl -filter_code 'sub{shift->name =~ /transcr/}' go.obo DESCRIPTION
Exports a subset of an ontology from a file. The subset can be based on a specified set of IDs, a preset "subset" filter in the ontology file (eg a GO "slim" or subset), or a user-defined filter. The subset can be exported in any format, including a graphical image ARGUMENTS
-id ID ID to use as leaf node in subgraph. All ancestors of this ID are included in the exported graph (unless -partial is set) Multiple IDs can be passed -id ID1 -id ID2 -id ID3 ....etc -subset SUBSET_ID Extracts a named subset from the ontology file. (only works with obo format files). For example, a specific GO slim ONLY terms belonging to the subset are exported - the -partial option is automatically set -namespace NAMESPACE only terms in this namespace -filter_code SUBROUTINE advanced option A subroutine with which the GO::Model::Term object is tested for inclusion in the subgraph (all ancestors are automatically included) You should have an understanding of the go-perl object model before using this option Example: go-filter-subset -filter_code 'sub {shift->namespace eq 'molecular_function'}' go.obo (the same things can be achieved with the -namespace option) -partial If this is set, then only terms that match the user query are included. Parentage is set to the next recursive parent node in the filter For example, with the -subset option: if X and Y belong to the subset, and Z does not, and X is_a Z is_a Y, then the exported graph withh have X is_a Y -use_cache If this switch is specified, then caching mode is turned on. With caching mode, the first time you parse a file, then an additional file will be exported in a special format that is fast to parse. This file will have the same filename as the original file, except it will have the ".cache" suffix. The next time you parse the file, this program will automatically check for the existence of the ".cache" file. If it exists, and is more recent than the file you specified, this is parsed instead. If it does not exist, it is rebuilt. DOCUMENTATION <http://www.godatabase.org/dev> perl v5.14.2 2010-05-12 GO-FILTER-SUBSET(1p)
All times are GMT -4. The time now is 08:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy