data wrangling code

generates various aggressions and joins