remove rows with missing Id values from data