Adding Grouped Mode as Additional Column in Original Dataset with Python Pandas

How to Aggregate Data and Display Last Two Values per Group Side by Side Using SQL PIVOT Clauses