Pandas split revenue according to threshold table
I have two dataframes, sales table & threshold table. Party A has to split revenue with Party B if the sales reach a certain threshold in either USD/AUD. This split is set by the threshold below, and can be changed anytime. For example, below shows a threshold change effective on 12 Dec 2025.