Excel (2) US dollars (1) accounting (3) as_of merge (1) assign (1) automation (5) business-logic (1) closest match (1) complex-joins (1) credit-debit (1) data-analysis (1) data-cleaning (2) data-formatting (1) data-validation (1) database (1) dataframe (5) dates (1) datetime (1) dollar-amounts (1) excel (5) extract (1) fiscal-year (1) formulas (1) functions (1) government (1) group (1) groupby (1) hardcoded (1) historical-records (1) isna (1) legacy-systems (1) mapping (1) merge (1) merge_as_of (1) merge_asof (3) missing-data (1) month-end (1) nearest-match (1) negative-balances (1) pandas (19) pd.merge_asof() (1) pivot-tables (1) python (8) regex (3) rounding (1) running-totals (1) security (1) sql (1) text-extraction (1) text-parsing (1) totals (1) transform (1) unique (1) unique ID (2)