You're provided a dataframe of used cars using pandas. Group the data by 'type' and calculate the average mileage for each car type.