How to fill the value of the column based on the condition of another column?

Question

I want to fill the value of pca.data$Type with 'DMSO' but the condition is that if the 'DMSO' is present in the column of pca.data$sample in R.

pca.data$Type[pca.data$sample %in% "DMSO"]='DMSO'

The following is my sample data:

Sample	Type
BEL5438.DMSO.1	DMSO
BEL5438.DMSO.2	DMSO
BEL5438.DMSO.3	DMSO
BEL5438.JQ1.1	JQ1
BEL5438.JQ1.2	JQ1
BEL5438.JQ1.3	JQ1
HCCC6478.DMSO.1	DMSO
HCCC6478.DMSO.2	DMSO
HCCC6478.DMSO.3	DMSO

 

 

Answer 1

You can simply use the following code for getting your desired output.

pca.data$Type[grep("DMSO", pca.data$sample)] = "DMSO"

If you are a beginner and want to know more about R, then do checkout the following R programming tutorial that will help you in understanding the basics of R.