I’ve continued working on my master table.I’ve been doing two things to the data,cleaning up the format it’s in,and substituting dummy values for those records where we don’t have values.I’ve also been doing a reasonableness check with the data by comparing our calendars and where the calendars said we were to the data we have.This has let me know what data we can safely get rid of,like the couple of testing streams we have from around hostels.

I’m almost done with cleaning up and should be able to just put all of my nice clean data (all in one format!!) into the fieldscience db.