Excel (2) US dollars (1) as_of merge (1) assign (1) closest match (1) dataframe (5) extract (1) formulas (1) group (1) hardcoded (1) merge (1) merge_as_of (1) merge_asof (1) pandas (6) pd.merge_asof() (1) regex (2) totals (1) unique (1) unique ID (2)