In this post, we will see how to resolve Specify which column(s) a specific date appears in R
Question:I have a subset of my data in a dataframe (dput codeblock below) containing dates in which a storm occurred (“Date_AR”). I’d like to know if a storm occurred in the north, south or both, by determining whether the same date occurred in the “Date_N” and/or “Date_S” column/s.
For example, the first date is Jan 17, 1989 in the “Date_AR” column. In the location column, I would like “S” to be printed, since this date is found in the “Date_S” column. If Apr 5. 1989 occurs in “Date_N” and “Date_S”, the I would like a “B” (for both) to be printed in the location column.
Thanks in advance for the help! Apologies if this type of question is already out there. I may not know the keywords to search.
dplyr::case_whenyou could do:
If you have better answer, please add a comment about this, thank you!