NAME
dbrowdiff - compute row-by-row differences of some column
SYNOPSIS
dbrowdiff [-B|-I] column
DESCRIPTION
For a given column, compute the differences between each row of the table. Differences are output to two new columns, absdiff and pctdiff.
Differences are either relative to the previous column (incremental mode), or relative to the first row (baseline mode), the default.
OPTIONS
- -B or --baseline
-
Select baseline mode (the default), where differences are relative to the first row.
- -I or --incremental
-
Select incremental mode, where differences are relative to the previous row.
- -f FORMAT or --format FORMAT
-
Specify a printf(3)-style format for output statistics. Defaults to
%.5g.
This module also supports the standard fsdb options:
- -d
-
Enable debugging output.
- -i or --input InputSource
-
Read from InputSource, typically a file name, or
-for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects. - -o or --output OutputDestination
-
Write to OutputDestination, typically a file name, or
-for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects. - --autorun or --noautorun
-
By default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. The
--(no)autorunoption controls that behavior within Perl. - --help
-
Show help.
- --man
-
Show full manual.
SAMPLE USAGE
Input:
#fsdb event clock:d
_null_getpage+128 815812813.281756
_null_getpage+128 815812813.328709
_null_getpage+128 815812813.353830
_null_getpage+128 815812813.357169
_null_getpage+128 815812813.375844
_null_getpage+128 815812813.378358
# | /home/johnh/BIN/DB/dbrow
# | /home/johnh/BIN/DB/dbcol event clock
Command:
cat DATA/kitrace.fsdb | dbrowdiff clock
Output:
#fsdb event clock:d absdiff:d pctdiff:d
_null_getpage+128 815812813.281756 0 0
_null_getpage+128 815812813.328709 0.046953 5.7554e-09
_null_getpage+128 815812813.353830 0.072074 8.8346e-09
_null_getpage+128 815812813.357169 0.075413 9.2439e-09
_null_getpage+128 815812813.375844 0.094088 1.1533e-08
_null_getpage+128 815812813.378358 0.096602 1.1841e-08
# | /home/johnh/BIN/DB/dbrow
# | /home/johnh/BIN/DB/dbcol event clock
# | dbrowdiff clock
SEE ALSO
Fsdb. dbcolmovingstats. dbrowuniq. dbfilediff.
dbrowdiff, dbrowuniq, and dbfilediff are similar but different. dbrowdiff computes row-by-row differences for a column, dbrowuniq eliminates rows that have no differences, and dbfilediff compares fields of two files.
CLASS FUNCTIONS
new
$filter = new Fsdb::Filter::dbrowdiff(@arguments);
Create a new dbrowdiff object, taking command-line arguments.
set_defaults
$filter->set_defaults();
Internal: set up defaults.
parse_options
$filter->parse_options(@ARGV);
Internal: parse command-line arguments.
setup
$filter->setup();
Internal: setup, parse headers.
run
$filter->run();
Internal: run over each rows.
AUTHOR and COPYRIGHT
Copyright (C) 1991-2022 by John Heidemann <johnh@isi.edu>
This program is distributed under terms of the GNU general public license, version 2. See the file COPYING with the distribution for details.