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... (5 Replies)
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 Replies)
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 Replies)
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 ... (3 Replies)
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... (16 Replies)
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... (1 Reply)
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... (4 Replies)
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... (8 Replies)
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. (3 Replies)
Discussion started by: ricbha
3 Replies
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)