In this, I would like search from final_df_input based on columns Item & LC from the dataframe lctolc.
I want 2 dataframe outputs
- Which is having the elements Item,LC of final_df_input in lctolc
- Which is not having elements Item,LC of in lctolc
final_df_input
Item <- c("A", "A", "A", "A", "B", "B")
LC <- c("MW92", "OY01", "RM11" ,"LO99", "WK14", "RS11")
SS <- c(20, 10, 5, 99, 112, 30)
Freq <- c(0, 0, 1, 0, 0, 1)
final_df_input <- data.frame(Item, LC, SS, Freq, stringsAsFactors = F)
Item LC SS Freq
1 A MW92 20 0
2 A OY01 10 0
3 A RM11 5 1
4 A LO99 99 0
5 B WK14 112 0
6 B RS11 30 1
lctolc
Item <- c("A", "A", "A", "B", "B")
LC <- c("MW92", "OY01", "RM11", "WK14", "RS11")
ToLC <- c("OY01", "RM11", "RM02", "RS11", "ZM78")
lctolc <- data.frame(Item, LC, ToLC, stringsAsFactors = F)
Item LC ToLC
1 A MW92 OY01
2 A OY01 RM11
3 A RM11 RM02
4 B WK14 RS11
5 B RS11 ZM78
Output 1:
Item LC SS Freq
1 A MW92 20 0
2 A OY01 10 0
3 A RM11 5 1
4 B WK14 112 0
5 B RS11 30 1
Output 2:
Item LC SS Freq
1 A LO99 99 0