treating corner case when missing data are empty strings instead of NA