I have a huge matrix file containing some 1.5 million rows and 6000 columns. The matrix looks something like this:
I want to add all the numbers in the columns of this matrix and display the result to my stdout. This means that the numbers in the first column are:
When I add all of them up the result is 15 and in this way the sum of numbers present in the second column is 19 and third is 23. Hence my output should look like this:
I can add the numbers in the first column like this:
But don't know how to do it for the entire matrix of 6000 columns.
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)
Hi everyone
I am very new at awk and to me the task I need to get done is very very challenging... Nevertheless, after admiring how fast and elegant issues are being solved here I am sure this is my best chance.
I have a 2D data file (input file is a plain tab-delimited text file). The first... (1 Reply)
Hi All,
I have some data like below.
Step1,Param1,Param2,Param3
1,2,3,4
2,3,4,5
2,4,5,6
3,0,1,2
3,0,0,0
3,2,1,3
........
so on
Where I need to find the median(arithmetic) of each column from Param1...to..Param3 for each set of Step1 values.
(Sort each specific column, if the... (5 Replies)
Hi guys,
here https://www.unix.com/shell-programming-scripting/193043-3-column-csv-correlation-matrix-awk-perl.html I found awk script converting
awk '{
OFS = ";"
if (t) {
if (l != $1)
t = t OFS $1
} else t = OFS $1
x = x ? x OFS $NF : $NF
l = $1
}... (2 Replies)
Hello!
I'm new to linux programming. It would be great if you could help me out.
I have a matrix of kind:
10 30.0
20 190.5
40 180.
50 320.5
I would like
to substract 180 from column 2 If the value is >180
to add 180 for column 2 If the value is <180
nothing if it is equal to... (3 Replies)
Hello all,
I am quite new in this but I need some help to keep going with my analysis.
I am struggling with a short script to read a square matrix and convert it in two collumns.
A B C D
A 0.00 0.06 0.51 0.03
B 0.06 0.00 0.72 0.48
C 0.51 0.72 0.00 ... (7 Replies)
How can i convert two columns in to o and 1 matrix. thnks
Input
a c1
b c2
c c1
d c3
e c4
output
c1 c2 c3 c4
a 1 0 0 0
b 0 1 0 0
c 1 0 0 0
d 0 0 ... (5 Replies)
The following code transform the matrix to columns. Is it possible to do it other way around ( get the input from the output) ?
input
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
output
x1 y1 0.3
x2 y1 1.2
x3... (1 Reply)
Discussion started by: quincyjones
1 Replies
LEARN ABOUT DEBIAN
viewperl
VIEWPERL(1) User Commands VIEWPERL(1)NAME
viewperl - quickly view syntax highlighted Perl code
SYNOPSIS
viewperl [OPTION]... FILE...
DESCRIPTION
View a Perl source code file, syntax highlighted.
-c, --code=CODE
view CODE, syntax highlighted
-l, --lines
display line numbers
-L, --no-lines
supress display of line numbers (default)
-m, --module=FILE
consider FILE the name of a module, not a file name
-n, --name
display the name of each file (default)
-N, --no-name
supress display of file names (implied by --no-reset)
-p, --pod
display inline POD documentation (default)
-P, --no-pod
hide POD documentation (line numbers still increment)
-r, --reset
reset formatting and line numbers each file (default)
-R, --no-reset
supress resetting of formatting and line numbers
-s, --shift=WIDTH
set tab width (default is 4)
-t, --tabs
translate tabs into spaces (default)
-T, --no-tabs
supress translating of tabs into spaces
--help display this help and exit
Note that module names should be given as they would appear after a Perl `use' or `require' statement. `Getopt::Long', for example.
Each string given using -c is considered a different file, so line number and formatting resets will apply.
View a Perl source code file, syntax highlighted.
-c, --code=CODE
view CODE, syntax highlighted
-l, --lines
display line numbers
-L, --no-lines
supress display of line numbers (default)
-m, --module=FILE
consider FILE the name of a module, not a file name
-n, --name
display the name of each file (default)
-N, --no-name
supress display of file names (implied by --no-reset)
-p, --pod
display inline POD documentation (default)
-P, --no-pod
hide POD documentation (line numbers still increment)
-r, --reset
reset formatting and line numbers each file (default)
-R, --no-reset
supress resetting of formatting and line numbers
-s, --shift=WIDTH
set tab width (default is 4)
-t, --tabs
translate tabs into spaces (default)
-T, --no-tabs
supress translating of tabs into spaces
--help display this help and exit
Note that module names should be given as they would appear after a Perl `use' or `require' statement. `Getopt::Long', for example.
Each string given using -c is considered a different file, so line number and formatting resets will apply.
viewperl August 2007 VIEWPERL(1)