This is my dataframe/data.table that shows what people has already eaten and my target field NextItem
which is one next random item(uneaten) that they may eat
library(data.table)
dt <- fread('
Name ItemEaten NextItem
John rice banana
John butter banana
Sarah bread apple
Vinny apple coke
')
And this vector x
is my universe of food items:
x<- c("apple","pepsi","rice","coke","banana","butter","bread")
The NextItem
field should only include food items from the x
vector that is not already eaten by the given individual(not in ItemEaten
Field). For example, John has already eaten rice & butter
,thats why John should have one of the five remaining food items in the NextItem
field. I have tried dt[,NextItem:= sample(x- ItemEaten,1),with=Name]
Aucun commentaire:
Enregistrer un commentaire