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