Change the Blank Cells to “NA”

by

I’m assuming you are talking about row 5 column “sex.” It could be the case that in the data2.csv file, the cell contains a space and hence is not considered empty by R.

Also, I noticed that in row 5 columns “axles” and “door”, the original values read from data2.csv are string “NA”. You probably want to treat those as na.strings as well. To do this, 

dat2 <- read.csv("data2.csv", header=T, na.strings=c("","NA"))

EDIT:

I downloaded your data2.csv. Yes, there is a space in row 5 column “sex”. So you want

na.strings=c(""," ","NA")

More Related Contents:

  1. How to number/label data-table by group-number from group_by?
  2. How can you read a CSV file in R with different number of columns
  3. Display a time clock in the R command line
  4. R compare multiple values with vector and return vector [duplicate]
  5. Read a UTF-8 text file with BOM
  6. ggplot side by side geom_bar()
  7. How to escape a backslash in R? [duplicate]
  8. How to GeoCode a simple address using Data Science Toolbox
  9. calculating mean for every n values from a vector
  10. How do I copy and paste data into R from the clipboard?
  11. How to install a package from a download zip file
  12. Read and rbind multiple csv files
  13. Loading many files at once?
  14. R – Group by variable and then assign a unique ID [duplicate]
  15. How I can select rows from a dataframe that do not match?
  16. Remove facet_wrap labels completely
  17. data.table row-wise sum, mean, min, max like dplyr?
  18. Triple exclamation marks on R
  19. R command line passing a filename to script in arguments (Windows)
  20. Calculate percentage of each category in each group in R [duplicate]
  21. dplyr: put count occurrences into new variable [duplicate]
  22. display a matrix, including the values, as a heatmap
  23. How to automatically adjust the width of each facet for facet_wrap?
  24. Convert accented characters into ascii character
  25. Calculate mean across rows with NA values in R
  26. Is it possible to jitter two ggplot geoms in the same way?
  27. in r combine a list of lists into one list
  28. Convert numeric to date
  29. How to combine two lists in R
  30. Change the position of the strip label in ggplot from the top to the bottom?

Leave a Comment