Reshaping Pandas DataFrames with Partial Aggregation Using Dplyr and Tidyr.

Transposing a Table in SQL Server 2016: A Step-by-Step Guide to Using PIVOT