When the condition has length > 1 in ifelse in r and there are more than 2 statements how to use ifelse?
I have a data set wherre I want to categorise people in to categories using sveveral arguments.
I have used if else,
I wanted to do was that to get another column containing these categories as primary,secondary,secondaryT and etc.But it seems not to work.
if ( SEX=="MALE" & SPORT=="CADET" & Bazett_formula 400 ) {"Secondary"
} else if ( SEX=="FEMALE" & SPORT=="CADET" & Bazett_formula
Can there be other sport than "CADET"? If not, the solution is simple:
CATEGORY
Actually there are more than 1 sport.Jean Maccairo and Jochen Wilhelm thanx.But my problem is I have a data set which have seperate rows for sex,sport and the formula.
WhaT i WANT IS A SEPERATE COLUMN TO BE ADDED THAT CATEGORISE THEM AS PRIMARY,SECONDARY AND ETC.
i HAVE TRIED TO DO THIS WITH MUTATE AND CBIND,BUT FAILED.
aNYWAY UR ANSWERS UPLIFTED ME.tHANX
could you give us a subset of your file/data set as an example, I have problems to figure it out.
It sounds like you may be using the tidyverse. If so, I suspect that the syntax you are looking for is handled better by case_when... This allows you to put a boolean, TRUE/FALSE/ statement and then ~ and the output. Just note that if your output includes NA, you will need to match the NA type to the other outputs, so NA_character for the cexample below
data %>%
mutate( new_categorical = case_when( variable < 40 ~ "Category 1",
variable >= 40 & variable < 50 ~ "Category 2",
variable >= 50 ~ "Category 3",
.TRUE ~ NA_character ) )
It seems like you're over-thinking it.
using data.table (as God intended) just do something like:
require(data.table)
dt
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics
- Statistical Software
- R Statistical Package