data prep and exploration for eltonian guild stuff