-
Notifications
You must be signed in to change notification settings - Fork 23
mean_vals
Martin Asser Hansen edited this page Oct 2, 2015
·
6 revisions
mean_vals find the mean values for given keys outputting a
record with keys of the type <key>_MEAN with the mean as values.
... | mean_vals [options]
[-? | --help] # Print full usage description.
[-x | --no_stream] # Do not emit records.
[-o <file> | --data_out=<file>] # Write result to file.
[-k <list> | --keys=<list>] # Comma separated list of keys.
[-l <string> | --list=<string>] # Key with ; separated values to calculate mean from.
[-I <file!> | --stream_in=<file!>] # Read input from stream file - Default=STDIN
[-O <file> | --stream_out=<file>] # Write output to stream file - Default=STDOUT
[-v | --verbose] # Verbose output.
Consider the following table in the file test.tab:
Human 123 78 0;1;2;3;4;5
Dog 45 81 6;7;8
Mouse 6 5 9
To find the mean value in the second column, read in the table with read_tab and then pipe to mean_vals:
read_tab -i test.tab | mean_vals -k V1 -x
V1_MEAN: 58.00
REC_TYPE: MEAN
---
To find the mean of two columns, just specify these:
read_tab -i test.tab | mean_vals -k V1,V2 -x
V1_MEAN: 58.00
REC_TYPE: MEAN
V2_MEAN: 54.67
---
To get the mean for keys where the values are a list of ; seperated values
use the -l switch:
read_tab -i test.tab | mean_vals -l V3
V3_MEAN: 2.50
V3: 0;1;2;3;4;5
V0: Human
V2: 78
V1: 123
---
V3_MEAN: 7.00
V3: 6;7;8
V0: Dog
V2: 81
V1: 45
---
V3_MEAN: 9.00
V3: 9
V0: Mouse
V2: 5
V1: 6
---
Martin Asser Hansen - Copyright (C) - All rights reserved.
August 2007
GNU General Public License version 2
http://www.gnu.org/copyleft/gpl.html
mean_vals is part of the Biopieces framework.