changed the default string for missing data and removed the eid column