HI all
I'm trying to write an awk script to print the min and max value in a range(s) contained in another file - the range values are in $2
EG
114,7964,1,y,y,n
114,7965,1,y,y,n
114,7966,1,y,y,n
114,7967,1,y,y,n
114,7969,1,y,y,n
114,7970,1,y,y,n
114,7971,1,y,y,n
114,7972,1,y,y,n... (3 Replies)
hi!
i have a file like the attachement.
I'd like to get for each line the min, max and average values. (there is 255 values for each line)
how can i get that ?
i try this, is it right?
BEGIN {FS = ","; OFS = ";";max=0;min=0;moy=0;total=0;freq=890}
$0 !~ /Trace1:/ {
... (1 Reply)
Is it possible to print max number of 2 columns - awk
note: print max if the integer is positive and print min if the integer is negative
input
a 1 2
b 3 4
c 5 1
d -3 -5
d -5 -3
output
a 2
b 4
c 5
d -5
d -5 (4 Replies)
Hi guys,
I already search on the forum but i can't solve this on my own.
I have a lot of files like this:
And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in... (4 Replies)
Hi, I have a list.txt file with number ranges and want to print/save new all.txt file with all the numbers and between the numbers.
== list.txt ==
65936
65938
65942 && 65943
65945 ... (7 Replies)
Hi all,
I have a list of numbers. I need an awk command to find out the numbers of elements (number of numbers, sort to speak), the average value the min and max value. Reading the list only once, with awk.
Any ideas?
Thanks! (5 Replies)
I want to create a form with data values in a dropdown list. The values in the dropdown list need to be generated on the fly from max, min and increment values contained in a mysql database.
Hopefully this makes sense, I really have no idea where to start :confused:
Thanks (6 Replies)
Hello,
I have this table:
chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67
chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885
chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 Replies
LEARN ABOUT DEBIAN
minccmp
MINCCMP(1) MINC User's Guide MINCCMP(1)NAME
minccmp - compare one or more minc file using comparator operators
SYNOPSIS
minccmp [<options>] <in1.mnc> <in2.mnc> [<inn.mnc> ...]
DESCRIPTION
minccmp will calculate simple statistical measures between two minc files or more by comparing all subsequent files to the first. The
results for each subseqent file are then returned in order. By default all statistics are calculated. If specifitc statistics are
requested via a command-line option, then only the requested statistics are printed.
A very useful feature of this program is the ability to restrict the set of voxels included in the statistic calculation, either by
restricting the range of included values (-floor, -ceil or -range), or by using a mask file (-mask) with a restricted range.
The comparison statistics available in minccmp are given below. Note that two of these (-xcorr and -zscore) are a very close approximation
to what is used in minctracc.
OPTIONS
Note that options can be specified in abbreviated form (as long as they are unique) and can be given anywhere on the command line.
General options-clobber
Overwrite an existing file.
-noclobber
Don't overwrite an existing file (default).
-debug Dump a lot of extra information (for when things go haywire).
-verbose
Print out extra information (more than the default).
-quiet Print out only the requested numbers
-max_buffer_size_in_kb size
Specify the maximum size of the internal buffers (in kbytes). Default is 4 MB.
-check_dimensions
Check that all input files have matching sampling in world dimensions (default).
-nocheck_dimensions
Ignore any differences in world dimensions sampling for input files .
Volume range options-floor min
A lower bound for ranges of data to include in statistic calculations.
-ceil max
An upper bound for ranges of data to include in statistic calculations.
-range min,max
A lower and upper bound for the ranges of data to include in statistics.
-mask filename.mnc
Name of file to be used for masking data included in statistic calculations.
Basic statistics-all Compute all statistical measures. This is the default.
-ssq Print the Sum Squared Difference between two input files
SSQ = Sum( (A-B)^2 )
-rmse Print the Root Mean Squared Error between two input files
RMSE = sqrt( 1/n * Sum((A-B)^2))
-xcorr Print the Cross Correlation between two input files
XCORR = Sum((A*B)^2) / (sqrt(Sum(A^2)) * sqrt(Sum(B^2))
-zscore
Print the z-score difference between two input files
ZSCORE = Sum( |((A - mean(A)) / stdev(A)) -
((B - mean(B)) / stdev(B))| ) / n
Generic options for all commands:
-help Print summary of command-line options and exit.
-version
Print the program's version number and exit.
AUTHOR
Andrew Janke
COPYRIGHTS
Copyright (C) 2010 by Andrew Janke
$Date: 2010-03-02 12:12:20 $ MINCCMP(1)