PyFSDB Command Line Tools¶
The following shell tools come with PyFSDB and can be used for generic command line processing of FSDB data. We break the list of tools up into different categories (although some tools may technical belong to multiple categories, we place them in only one).
Note: the python based tools begin with the pdb prefix to distinguish themselves from their perl counter-parts (which begin with db).
Data filtering and modification tools¶
Contents:
- pdbrow - select a subset of rows based on a filter
- pdbroweval - alter rows based on python expressions or code
- pdbensure - ensure certain columns are present in the data
- pdbaugment - join rows from one FSDB files into another
- pdbfgrep - join rows from one FSDB files into another
- pdbnormalize - normalize a bunch of columns
- pdbcdf - find all unique values of a key column
- pdbdatetoepoch - translate a date-string based column to unix epochs
- pdbepochtodate - translate a unix epoch column to a date-string column
- pdbkeyedsort - find all unique values of a key column
- pdbsum - sum columns together
- pdbzerofill - fills a columns with zeros (or other value) when blank
Data conversion tools¶
Contents:
- pdb2to1 - strip typing information from the FSDB header
- pdbaddtypes - strip typing information from the FSDB header
- pdbformat - create formatted text per row in an FSDB file
- pdbjinja - process an FSDB file with a jinja template
- pdb2tex - create a latex table using the data in a FSDB file
- pdb2sql - uploads an FSDB file into a database
- pdbsplitter - split an FSDB file into multiple files
- pdbfullpivot - translate a date-string based column to unix epochs
- pdbreescape - regexp escape strings from a column