Hey all, I am curious as to codes that would be used to add a column, based on a value that is in another column. For example, I want to make a column characterizing samples as "diseased" or "healthy", based on whether or not they have a "D" or "H" in their dataset id. For example, (the commas are supposed to separate)
dataset_id,bacteria,(would like to add a column here)
Site4H,268,healthy
Site4D,479,diseased
SIte8H,345,healthy
Site8D,567,disease