Search results for "dist:Fsdb Underscore"
Fsdb::Filter::dbroweval - evaluate code for each row of a fsdb file
Evaluate code for each row of the data. Typical actions are things like reformatting and other data transformations. Code can include embedded column names preceded by underscores; these result in the value of that column for the current row. The val...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcolmerge - merge multiple columns into one
For each row, merge multiple columns down to a single column (always a string), joining elements with ElementSeparator (defaults to a single underscore)....
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbformmail - write a shell script that will send e-mail to many people
Read a ``form mail'' message from the file FORMAT_FILE.TXT, filling in underscore-preceded column-names with data. Output a shell script which will send each message through some mail transport MECHANISM. Do not use this program for evil or I will ha...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbfilepivot - pivot a table, converting multiple rows into single wide row
Pivot a table, converting multiple rows corresponding to the same key into a single wide row. In a normalized database, one might have data with a schema like (id, attribute, value), but sometimes it's more convenient to see the data with a schema li...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcolscorrelate - find the coefficient of correlation over columns
Compute the coefficient of correlation over two (or more) columns. The output is one line of correlations. With exactly two columns, a new column *correlation* is created. With more than two columns, correlations are computed for each pairwise combin...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcolsplittocols - split an existing column into multiple new columns
Create new columns by splitting an existing column. The fragments of the column are each divided by ElementSeparator (default is underscore). This command is the opposite of dbcolmerge. Names of the new columns are given by splitting the name of the ...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcolsplittorows - split an existing column into multiple new rows
Split column into pieces, outputting one row for each piece. By default, any empty fields are ignored. If an empty field value is given with -e, then they produce output. When a null value is given, empty fields at the beginning and end of lines are ...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC