create a data.frame based on tour rather than trip