Maintaining Value of Last Row in Column Based on Conditions from Adjacent Columns Using Pandas in Python

Conducting an Inner Join Between Two Sheets: Array Formula vs Power Query