### Search results for "module:Fsdb::Filter::dbsort"

###
Fsdb::Filter::dbsort - sort rows based on the the specified columns

Sort all input rows as specified by the numeric or lexical columns. Dbsort consumes a fixed amount of memory regardless of input size. (It reverts to temporary files on disk if necessary, based on the -M and -T options.) The sort should be stable, bu...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter - base class for Fsdb filters

Fsdb::Filter is the virtual base class for Fsdb filters. Users will typically invoke individual programs via the command line (for example, see dbcol(1)) or string together several in a Perl program as described in dbpipeline(3). For new Filter devel...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbjoin - join two tables on common columns

Does a natural, inner join on TABLE1 and TABLE2 the specified columns. With the "-a" option, or with "-t outer" it will do a natural, full outer join. (Database review: inner joints output records only when there are matches in both tables and will o...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbmerge - merge all inputs in sorted order based on the the specified columns

Merge all provided, pre-sorted input files, producing one sorted result. Inputs can both be specified with "--input", or one can come from standard input and the other from "--input". With "--xargs", each line of standard input is a filename for inpu...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbmerge2 - merge exactly two inputs in sorted order based on the the specified columns

Merge exactly two sorted input files, producing one sorted result. Inputs can both be specified with "--input", or one can come from standard input and the other from "--input". Inputs must have identical schemas (columns, column order, and field sep...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbrowuniq - eliminate adjacent rows with duplicate fields, maybe counting

Eliminate adjacent rows with duplicate fields, perhaps counting them. Roughly equivalent to the Unix uniq command, but optionally only operating on the specified fields. By default, *all* columns must be unique. If column names are specified, only th...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbpipeline - allow db commands to be assembled as pipelines in Perl

This module makes it easy to create pipelines in Perl using separate processes. (In the past we used to use perl threads.) By default (as with all Fsdb modules), input is from STDIN and output to STDOUT. Two helper functions, fromfile and tofile can ...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbcolstats - compute statistics on a fsdb column

Compute statistics over a COLUMN of data. Records containing non-numeric data are considered null do not contribute to the stats (with the "-a" option they are treated as zeros). Confidence intervals are a t-test (+/- (t_{a/2})*s/sqrt(n)) and assume ...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbrowaccumulate - compute a running sum of a column

Compute a running sum over a column of data, or of a constant incremented per row, perhaps to generate a cumulative distribution. What to accumulate is specified by "-c" or "-C". The new column is named by the "-N" argument, defaulting to "accum"....

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC###
Fsdb::Filter::dbcolpercentile - compute percentiles or ranks for an existing numeric column

Compute a percentile, ranking, or weighted percentile of a column of numbers. The new column will be called *percentile* or *rank* or *weighted* depending on the mode. Ordering is given by the specifed column. In weighted mode, by default the same co...

JOHNH/Fsdb-3.0 - 04 Apr 2022 22:44:17 UTC