An available utility, numsum, part of num-utils:
producing:
Information about numsum ( package available in the Debian repositories ):
Best wishes ... cheers, drl
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
numgrep
NUMGREP(1) User Contributed Perl Documentation NUMGREP(1)NAME
numgrep - This program is the numeric equivilent of the grep utility.
SYNOPSIS
numgrep [-dhlV] <FILE>
| numgrep [-dhlV] (Input on STDIN from pipeline.)
numgrep [-dhlV] (Input on STDIN. Use Ctrl-D to stop.)
DESCRIPTION
numgrep searches for different occurances of numbers through the use of numeric expressions.
OPTIONS -l Print the matching numbers out one per line
instead of printing the entire line they are on.
-h Help: You're looking at it.
-V Increase verbosity.
-d Debug mode. For developers
EXPRESSIONS
numgrep uses a special numeric expression matching system. Basically, it searches for ranges, factors and sequences of numbers. Here is a
list of the syntax characters and some sample expressions that will get you going:
/<expression>/
Put your expression or set of expressions between these
two forward slashes.
.. Range expression. A number must be used on the left
and/or right of this expression to specify that numbers
between, greater than or less than the numbers specified
should be matched.
, Expression sepeartor. The comma sepearates one complete
expression from another in a set enclosed by //.
m<n> Multiples of <n>. This operator, followed by a number
<n> will match any number <x> that is an integer
multiple of <n>. Meaning that <x> = <n> times <y>,
where <y> is any integer.
f<n> Factors of <n>. This operator, followed by a number <n>
will match any number <x> that is an integer factor of
<n>. Meaning that <x> = <n> divided by <y>, where <y>
is any integer.
NOTE: Checking for factors and multiples is very fast because it
is checked by doing a single modulus operation on two numbers.
Examples:
/2..10/ Match any number between 2 and 10.
/2..10,20..30/ Match any number between 2 and 10 or between 20 and 30.
/56,34,512,45,67/ Match any of the numbers 56, 34, 512, 45 or 67.
/m3/ Match any integer that is a multiple of 3.
/f1024/ Match any integer that is a factor of 1024.
$ numrange -N /1..1000/ | numgrep /f1024/
1
2
4
8
16
32
64
128
256
512
$
BUGS
numgrep can't handle certain situations properly. Such as if it encounters a number with leading zeros, it will treat it as an octal
number and thus might not match the way you would expect.
numgrep does not yet allow you to mix numbers and text in the matching expression. So you can not do something like 'numgrep
/port=0..1023/ firewall.log'. But this will be changed in the future.
SEE ALSO numaverage(1), numbound(1), numinterval(1), numnormalize(1), numprocess(1), numsum(1), numrandom(1), numrange(1), numround(1)COPYRIGHT
numgrep is part of the num-utils package, which is copyrighted by Suso Banderas and released under the GPL license. Please read the
COPYING and LICENSE files that came with the num-utils package
Developers can read the GOALS file and contact me about providing
submitions or help for the project.
BUGS
numgrep will round decimal numbers with more than 15 digits of accuracy. This is
mostly due to limit's in the way programming languages deal directly with numbers.
MORE INFO
More info on numgrep can be found at:
http://suso.suso.org/programs/num-utils/
perl v5.10.1 2009-10-31 NUMGREP(1)