### pdbsum - sum columns together `pdbsum` adds column data together based on keyed input. This is similar to `dbcolstats` and `dbmultistats`, but only performs addition (or subtraction) and can be faster on very large datasets where the rest of the analysis provided by the other tools are not needed. `dbsum` also supports keyed subtraction as well, as seen below. #### Example input (*myfile.fsdb*): ``` #fsdb -F s col1:l two:a andthree:d 1 key1 42.0 2 key2 123.0 3 key1 90.2 ``` #### Example command usage ``` $ pdbsum -k two -c col1 andthree -- myfile.fsdb ``` #### Example output ``` #fsdb -F t two col1:d andthree:d key1 4.0 132.2 key2 2.0 123.0 ``` #### Example Subtraction file If we have another file (*mysub.fsdb*), we can subtract results: ``` #fsdb -F s two:a andthree:d key1 10 key2 10 key1 10 ``` #### Example subtraction command: ``` pdbsum -k two -c col1 andthree -- myfile.fsdb mysub.fsdb ``` #### Example output of subtraction: Note how the two 10's in the key1 subtraction are added together to 20 before being subtracted from the sum of key1 (123.2) in the first file. *Note:* Also observe the typical floating point imprecision rounding problems that python is well known for displaying. ``` #fsdb -F t two andthree:d key1 112.19999999999999 key2 113.0 ```