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

SAMPLE USAGE

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

SEE ALSO

127       Fsdb.  dbcolhisto.
128
130       Copyright (C) 1991-2018 by John Heidemann <johnh@isi.edu>
131
132       This program is distributed under terms of the GNU general public
133       license, version 2.  See the file COPYING with the distribution for
134       details.
135
136
137
138perl v5.32.0                      2020-11-16                DBCOLPERCENTILE(1)
Impressum