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

Understanding Table Differences in Excel Using Power Query and VLOOKUP