Fsdb::Filter::dbsort - sort rows based on the the specified columns River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb - a flat-text database for shell scripting River stage zero No dependents

JOHNH/Fsdb-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter - base class for Fsdb filters River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbjoin - join two tables on common columns River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbmerge - merge all inputs in sorted order based on the the specified columns River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbmerge2 - merge exactly two inputs in sorted order based on the the specified columns River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbrowuniq - eliminate adjacent rows with duplicate fields, maybe counting River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbpipeline - allow db commands to be assembled as pipelines in Perl River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbcolstats - compute statistics on a fsdb column River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbrowaccumulate - compute a running sum of a column River stage zero No dependents

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-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbcolpercentile - compute percentiles or ranks for an existing column River stage zero No dependents

Compute a percentile of a column of numbers. The new column will be called *percentile* or *rank*. Non-numeric records are handled as in other programs. If the data is pre-sorted and only a rank is requested, no extra storage is required. In all othe...

JOHNH/Fsdb-2.68 - 19 Sep 2019 15:23:50 GMT

11 results (0.039 seconds)