Remove Duplicate Entries Based on Highest Value in Another Column - SQL Query

Working with Pandas DataFrames in Python: Duplicate Rows and Add Conditions Using NumPy and Pandas Functions