1Fsdb::Filter::dbcolpercUesnetrilCeo(n3t)ributed Perl DocFusmdebn:t:aFtiilotner::dbcolpercentile(3)
2
3
4

NAME

6       dbcolpercentile - compute percentiles or ranks for an existing column
7

SYNOPSIS

9           dbcolpercentile [-rplhS] column
10

DESCRIPTION

12       Compute a percentile of a column of numbers.  The new column will be
13       called percentile or rank.  Non-numeric records are handled as in other
14       programs.
15
16       If the data is pre-sorted and only a rank is requested, no extra
17       storage is required.  In all other cases, a full copy of data is
18       buffered on disk.
19

OPTIONS

21       -p or --percentile
22           Show percentile (default).
23
24       -P or --rank or --nopercentile
25           Compute ranks instead of percentiles.
26
27       --fraction
28           Show fraction (percentage, except between 0 and 1, not cumulative
29           fraction).
30
31       -a or --include-non-numeric
32           Compute stats over all records (treat non-numeric records as zero
33           rather than just ignoring them).
34
35       -S or --pre-sorted
36           Assume data is already sorted.  With one -S, we check and confirm
37           this precondition.  When repeated, we skip the check.
38
39       -f FORMAT or --format FORMAT
40           Specify a printf(3)-style format for output statistics.  Defaults
41           to "%.5g".
42
43       -T TmpDir
44           where to put tmp files.  Also uses environment variable TMPDIR, if
45           -T is not specified.  Default is /tmp.
46
47       Sort specification options (can be interspersed with column names):
48
49       -r or --descending
50           sort in reverse order (high to low)
51
52       -R or --ascending
53           sort in normal order (low to high)
54
55       -n or --numeric
56           sort numerically (default)
57
58       -N or --lexical
59           sort lexicographically
60
61       This module also supports the standard fsdb options:
62
63       -d  Enable debugging output.
64
65       -i or --input InputSource
66           Read from InputSource, typically a file name, or "-" for standard
67           input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
68           objects.
69
70       -o or --output OutputDestination
71           Write to OutputDestination, typically a file name, or "-" for
72           standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
73           Fsdb::BoundedQueue objects.
74
75       --autorun or --noautorun
76           By default, programs process automatically, but Fsdb::Filter
77           objects in Perl do not run until you invoke the run() method.  The
78           "--(no)autorun" option controls that behavior within Perl.
79
80       --help
81           Show help.
82
83       --man
84           Show full manual.
85

SAMPLE USAGE

87   Input:
88           #fsdb name id test1
89           a 1 80
90           b 2 70
91           c 3 65
92           d 4 90
93           e 5 70
94           f 6 90
95
96   Command:
97           cat DATA/grades.fsdb | dbcolpercentile test1
98
99   Output:
100               #fsdb name id test1 percentile
101               d       4       90      1
102               f       6       90      1
103               a       1       80      0.66667
104               b       2       70      0.5
105               e       5       70      0.5
106               c       3       65      0.16667
107               #  | dbsort -n test1
108               #   | dbcolpercentile test1
109
110   Command 2:
111           cat DATA/grades.fsdb | dbcolpercentile --rank test1
112
113   Output 2:
114               #fsdb name id test1 rank
115               d       4       90      1
116               f       6       90      1
117               a       1       80      3
118               b       2       70      4
119               e       5       70      4
120               c       3       65      6
121               #  | dbsort -n test1
122               #   | dbcolpercentile --rank test1
123

SEE ALSO

125       Fsdb.  dbcolhisto.
126

CLASS FUNCTIONS

128   new
129           $filter = new Fsdb::Filter::dbcolpercentile(@arguments);
130
131       Create a new dbcolpercentile object, taking command-line arguments.
132
133   set_defaults
134           $filter->set_defaults();
135
136       Internal: set up defaults.
137
138   parse_options
139           $filter->parse_options(@ARGV);
140
141       Internal: parse command-line arguments.
142
143   setup
144           $filter->setup();
145
146       Internal: setup, parse headers.
147
148   _count_rows
149           $n = $self->_count_rows()
150
151       Interpose a filter on "$self-"{_in}> that counts the rows.
152
153   run
154           $filter->run();
155
156       Internal: run over each rows.
157

159       Copyright (C) 1991-2018 by John Heidemann <johnh@isi.edu>
160
161       This program is distributed under terms of the GNU general public
162       license, version 2.  See the file COPYING with the distribution for
163       details.
164
165
166
167perl v5.28.1                      2018-02-17  Fsdb::Filter::dbcolpercentile(3)
Impressum