How do i get rid of the NAs to get the actual values

A reprex has to be reproducible, I can't copy that code into my own R session and reproduce your problem because I don't have your csv file, that is why you get this error when you run the reprex() function.

#> Warning in file(file, "rt"): cannot open file 'RateAddOnsExcel.csv': No
#> such file or directory

Maybe this video would help you to understand what a reprex is about