Transpose columns to row Post: 302980580

Sponsored Content

Top Forums Shell Programming and Scripting Transpose columns to row Post 302980580 by RavinderSingh13 on Tuesday 30th of August 2016 12:08:04 PM

08-30-2016

Moderator

Hello jiam912,

In case you wanted each number which is missed starting from 1 to till last line of Input_file, then following may help you in same(Not tested though).

Code:

awk '{A[substr($0,4,2)+0]++} END{for(i=0;i<=NR;i++){Q=Q?Q OFS sprintf("%02d",i):sprintf("%02d",i);V=V?V OFS (A[i]=A[i]?A[i]:0):(A[i]=A[i]?A[i]:0)};print Q ORS V}' OFS="\t"  Input_file

EDIT: Adding a non-one liner form of solution on same.

Code:

awk '{
        A[substr($0,4,2)+0]++
     }
     END{
                for(i=0;i<=NR;i++){
                                        Q=Q?Q OFS sprintf("%02d",i):sprintf("%02d",i);
                                        V=V?V OFS (A[i]=A[i]?A[i]:0):(A[i]=A[i]?A[i]:0)
                                  };
                print Q ORS V
        }
    ' OFS="\t"   Input_file

Thanks,
R. Singh

Last edited by RavinderSingh13; 08-30-2016 at 01:11 PM.. Reason: Added a non-one liner form of solution now.

This User Gave Thanks to RavinderSingh13 For This Post:

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Row to column transpose

Can we transpose rows to columns? Fields within row are separated by a comma.

2. Shell Programming and Scripting

Transpose - Multiple row to Multiple columns

I have seen many posts to transpose rows into columns, but not for multiple rows to columns..so please help me how to do this.. I have around 1000 rows and 1000 columns, i want to transpose it.. A1 A2 A3 B1 B2 B3 C1 C2 C3 D1 D2 D3 I want output to be like A1 B1 C1 D1 A2 B2 C2 D2...

3. Shell Programming and Scripting

Transpose column to row

Hi i have a file which has values seperated by "," as shown below and I want to transpose for every doc_id in one row. Input: DOC_ID,KEYWORD 105,REGISTROS 105,GEOLOGIA 105,NUCLEOS 105,EXPEDIENTE 105,PROGRAMAS 10025,EXPEDIENTE 10025,LOCALIZACIONES 10025,OFICIOS 10025,PROGRAMAS...

4. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Hi, I have a tab-delimited file as follows: 1 1 2 2 3 3 4 4 a a b b c c d d 5 5 6 6 7 7 8 8 e e f f g g h h 9 9 10 10 11 11 12 12 i i j j k k l l 13 13 14 14 15 15 16 16 m m n n o o p p The output I need is: 1 1 a a 5 5 e e 9 9 i i 13...

5. Shell Programming and Scripting

Column to row Transpose

Hi Folks, Iam a kinda newbie to unix shell scripting, the scenario is i have a text file containing the following info Charlie chicago 15 Charlie newyork 26 jonny chicago 14 jonny newyork 15 joe chicago 15 joe newyork 18output should be Name chicago ...

6. Shell Programming and Scripting

To transpose row into column

Hi All, In shell, I have below data coming from some some text file as below: . 351706 5861.8 0.026 0.012 12.584 0.026 0.012 12.582 0.000 0.000 0.000 Now i need the above data to be transposed as below 351706...

7. Shell Programming and Scripting

Transpose row to column

I'm using the testawk.awk from the following thread https://www.unix.com/shell-programming-and-scripting/18897-row-column-transpose.htmlI'm getting the following output fieldname1 data1 fieldname2 data2 fieldname3 data3 How can I get like this instead 1 fieldname1 data1 2 fieldname2 data2...

8. UNIX for Beginners Questions & Answers

Transpose a sequence of symbols from row to one columns (no separators))

Hi all, I have a data file. It contains one header line followed by a new line which is one row of different characters without separators (charahters can be dots, dash, capital and small letters). What I need is ignoring header line to transpose these characters so they form a column. So, from...

9. Shell Programming and Scripting

How transpose column in a row?

Hello guys, First of all happy holidays and happy new year. I'm new in bioinformatic and also it is my first time that I write in this forum. Therefore, sorry if I make some mistakes. I'm writing to ask your help to fix a problem: I have a file like this: gene1 GO:0016491|GO:0055114...

10. UNIX for Beginners Questions & Answers

Transpose the Row and column

Hi, I have data in form of A ram B shyam C seeta D geeta A bob B methew C Richad D Mike and i want it in this form. A B C D ram shyam seeta geeta bob methew Richard Mike. please help by providing the scripting for this.

LEARN ABOUT DEBIAN

gri_merge

GRI_MERGE(1)						      General Commands Manual						      GRI_MERGE(1)

NAME

       gri_merge - merge multiple Gri output files into a single PostScript file.

USAGE (style 1):
	      gri_merge [OPTIONS] CxR a.ps b.ps ... > merged_file.ps

       Merges  the  files  onto one page, in 'C' columns and 'R' rows.	The CxR files are given in the order of words on a page.  The page is pre-
       sumed to be 8.5x11in in size, as are all the input files, and the input files are sized to fit, and kept in natural scale.

USAGE (style 2):
	      gri_merge [OPTIONS] xcm ycm enlarge a.ps [b.ps ...] > merged_file.ps

       Where `enlarge' is a scale factor applied after offsetting `xcm' to the right and `ycm' upward.

   EXAMPLE (style 2):
	      The following

       gri_merge 2 12 .5 a.ps 

	      12 12 .5 b.ps 

	      2 2 .5 c.ps 

	      12 2 .5 d.ps > all.ps

       produces 4 panels from gri plots done using margins and sizes as specified in the following lines in a gri commandfile

	      set x margin 2

	      set x size 15

	      set y margin 2

	      set y size 15

       The OPTIONS, available if your 'perl' has 'getopts' library, are:

       -u graylevel -- set graylevel for underlay beneath panels, by default 0.75.

	      Values range from 0 (black) to 1 (white), although a value of precisely 1 means do NOT draw underlay.

       -b graylevel -- Set value for background under individual panels, again 0

	      for black to 1 for white, with 1 meaning no drawing.

       -h     -- Print this help message and quit.

SEE ALSO

       gri(1), gri_unpage(1)

gri_merge							       2009							      GRI_MERGE(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Row to column transpose

Discussion started by: videsh77

2. Shell Programming and Scripting

Transpose - Multiple row to Multiple columns

Discussion started by: ganeshss

3. Shell Programming and Scripting

Transpose column to row

Discussion started by: juelillo

4. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Discussion started by: mvaishnav