Excel (2) US dollars (1) as_of merge (1) assign (1) closest match (1) complex-joins (1) data-formatting (1) data-validation (1) dataframe (5) datetime (1) dollar-amounts (1) extract (1) formulas (1) group (1) hardcoded (1) historical-records (1) isna (1) legacy-systems (1) merge (1) merge_as_of (1) merge_asof (3) missing-data (1) month-end (1) nearest-match (1) negative-balances (1) pandas (12) pd.merge_asof() (1) python (1) regex (3) rounding (1) text-extraction (1) totals (1) unique (1) unique ID (2)