Hi, May be this helps. dat1<- read.table(text=" Col1,Col2 High value,9 Low value,0 High value,7 Low value,0 Low value,0 No data,0 High value,8 No data,0 ",sep=",",header=TRUE,stringsAsFactors=FALSE) dat1$Col2[dat1$Col1=="No data"]<- NA dat1 # Col1 Col2 #1 High value 9 #2 Low value 0 #3 High value 7 #4 Low value 0 #5 Low value 0 #6 No data NA #7 High value 8 #8 No data NA
A.K. Hello, I am an R novice so excuse me if this is woefully straight forward, but I have tried the help files to no avail. I am trying to identify cells in 1 column with the value of 'No data', so I can change the values in the next column to 'Null'. Currently I am struggling with the data set, as it assigns both 'No data' and 'Low values' as zero which skews my analysis. I've tried a number of different attempts but just get the error unexpected symbol ? ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
