05-04-2015
you are right. however it was based on 3 columns and here it is just two.
I noticed that if the column names are longer for example instead of c1 c1_abajgdhd_1234x, the script is printing bit wrong because some header names were not separated by tab.
Last edited by quincyjones; 05-04-2015 at 07:50 AM..
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear Unix Gurus,
I have a sample data set that looks like this
y1 y2 y3 y4 y5
x1 0.3 0.5 2.3 3.1 5.1
x2 1.2 4.1 3.5 1.7 1.2
x3 3.1 2.1 1.0 4.1 2.1
x4 5.0 4.0 6.0 7.0 1.1
I want to open it up so that I get
x1 y1 0.3
x2 y1 1.2
x3 y1 3.1
x4 y1 5.0
x1 y2 0.5
x2 y2... (3 Replies)
Discussion started by: tintin72
3 Replies
2. UNIX for Dummies Questions & Answers
Hi , I am struck while coding AWK script. Need your help to convert rows into columns. I should copy only those rows which are marked to Y in a file and ignore N rows. Please help me find a solution.
input file
1|abc|Y
2|cdf|Y
3|efg|N
4|xyz|Y
my output should be something like this... (2 Replies)
Discussion started by: rashmisb
2 Replies
3. Ubuntu
Hi all,
Is there a way to convert full data matrix to linearised left data matrix?
e.g full data matrix
Bh1 Bh2 Bh3 Bh4 Bh5 Bh6 Bh7
Bh1 0 0.241058 0.236129 0.244397 0.237479 0.240767 0.245245
Bh2 0.241058 0 0.240594 0.241931 0.241975 ... (8 Replies)
Discussion started by: evoll
8 Replies
4. Shell Programming and Scripting
is it possible to count the number of keys based on state and cell and output it as a simple matrix.
Ex: cell1-state1 has 2 keys
cell3-state1 has 4 keys.
Note: Insert 0 if no data available.
input
key states cell
key1 state1 cell1
key1 state2 cell1
key1 ... (21 Replies)
Discussion started by: quincyjones
21 Replies
5. Shell Programming and Scripting
Hi
I need to convert some columns form a html file to rows.
I do manage to make it works without help (some proud :) )
For some reason the offline status is not in bold, so I do need to remove the <b> tag from the other field to make this to work. All fields are not needed, so I test and... (5 Replies)
Discussion started by: Jotne
5 Replies
6. UNIX for Dummies Questions & Answers
Dear Unixers,
I'm having some difficulty in converting an n x m data matrix into a dataset of 3 columns and nxm rows. As an example I want to convert this dataset
2 3 4 5
2 0.0 0.0 0.1 0.1
6 -0.3 2.0 0.0 0.3
7 -0.6 -1.1 0.5 0.3
9 -0.9 -4.1 -0.7 0.5
... (2 Replies)
Discussion started by: tintin72
2 Replies
7. Shell Programming and Scripting
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies
8. Shell Programming and Scripting
This matrix represents correlation values.
Is it possible to calculate the percentage of columns (a1, a2, a3) that have a value >= |0.5| and report the percentage that has positive correlation >0.5 and negative correlation <-0.5 separately. thanx in advance!
input
name a1 a2 a3... (5 Replies)
Discussion started by: quincyjones
5 Replies
PR(1) General Commands Manual PR(1)
NAME
pr - print file
SYNOPSIS
pr [ option ] ... [ file ] ...
DESCRIPTION
Pr produces a printed listing of one or more files. The output is separated into pages headed by a date, the name of the file or a speci-
fied header, and the page number. If there are no file arguments, pr prints its standard input.
Options apply to all following files but may be reset between files:
-n Produce n-column output.
+n Begin printing with page n.
-h Take the next argument as a page header.
-wn For purposes of multi-column output, take the width of the page to be n characters instead of the default 72.
-f Use formfeeds instead of newlines to separate pages. A formfeed is assumed to use up two blank lines at the top of a page. (Thus
this option does not affect the effective page length.)
-ln Take the length of the page to be n lines instead of the default 66.
-t Do not print the 5-line header or the 5-line trailer normally supplied for each page.
-sc Separate columns by the single character c instead of by the appropriate amount of white space. A missing c is taken to be a tab.
-m Print all files simultaneously, each in one column,
Inter-terminal messages via write(1) are forbidden during a pr.
FILES
/dev/tty? to suspend messages.
SEE ALSO
cat(1)
DIAGNOSTICS
There are no diagnostics when pr is printing on a terminal.
4th Berkeley Distribution April 29, 1985 PR(1)