R thinks there are no NAs but there are!

Hi there, I was wondering if someone could help me out here.
I'm trying to omit the NA rows from my data, but R thinks there aren't any! (see bottom of image)

Does anyone know what's going on here?


NA values appear as simply NA, not as #N/A. What you have are probably character values of #N/A. That will force the entire column to be characters. Running the summary() function on the data frame will confirm this. You probably want to convert the #N/A to NA and then convert the columns to be numbers with as.numeric().

1 Like

Thank you, that worked!