Drop NA values in an imported xlxs document with R
its should be working

data_set&lt;-na.omit(un)


If want to handle NA's to mean or median:

na.mean(un, option = "mean")


Source:
https://www.rdocumentation.org/packages/imputeTS/versions/2.7/topics/na.mean