How to use this library

Set-up virtualenv and import rekon

$ pip install --user virtualenv
$ virtualenv .env
$ pip install rekon

Reconciliation inputs:

# import rekon library
from rekon import rekon

# instantiate an reconciliation instance
rec = rekon.Reconciliation()

# load sample data from package
rec.load_sample_data()

# run reconciliation on first column in col mapping and use sqlite db in memory
rec.reconcile(rec_col=1, sqlite_db=":memory:")

# view results (in pretty format)
rec.rec_results_pretty

# to output results to a zip and open file location
rec.output_report(output_dir='~/Desktop/EXAMPLE_OUTPUT',
                  file_name='rec-file',
                  output_format='zip',
                  open_file=True)

# to output results to a spreadsheet (i.e. 'xlsx') and open file location
rec.output_report(output_dir='~/Desktop/EXAMPLE_OUTPUT',
                  file_name='rec-file',
                  output_format='xlsx',
                  open_file=True)

0.1.6 (2018-09-18)

• Added ability to output reconciliation report to ‘zip’ or ‘xlsx’

• Added reconciliation stats for quick reference

0.1.5 (2018-09-17)

• First release on PyPI.

• ability to output reconciliations within console or in a jupyter notebook