Some answers where I put in a little more effort than my other answers:

• GroupBy pandas DataFrame and select most common value

• How can I pivot a dataframe?

• Pandas: group by and Pivot table difference

• How do I select rows from a DataFrame based on column values?

• pandas create new column based on values from other columns / apply a function of multiple columns, row-wise