Pergunta de entrevista da empresa MarketAxess

Given a pandas dataframe, do some basic cleaning and aggregation.