Assign values conditionally in R

Question

I need to create a new variable and assign values to the row based on another categorical variable. The data table looks like this

Specifically, I want to create a variable called channel_num. If the strings in channelGrouping equal to "Direct", "Display" and "Paid Search", I will assign 0 to this row; if they equal to "Organic Search" and "Social", I will assign 1.

Answer 1

Assuming your datatable is named df:

df$channel_num <- ifelse(df$channelGrouping %in% c("Direct","Display","Paid Search"), 0, ifelse(df$channelGrouping %in% c("Organic Search","Social"), 1, NA))