Optimizing SQL Queries for Conditional Summation

Remove Rows from One DataFrame Based on Certain Conditions with Pandas Indexing