Hello,
I am trying to remove values from one table from another and produce a new table with data of that of the full data set minus the one table.
I have tried the following in several iterations and am still having trouble. This seems like it should be easy to find but its turning out to not be.
So I have two tables both with the same layout with 36 columns. All labels are the same.
t1 has 19136 obs and pauci has 1495 obs end results should be a table t2 with 17641 obs
Not sure as to why this isnt working. Its only returning a table with the pauci results, I want the other portion.
My current code
t2 <- pauci[!(t1 %in% pauci),]
EDIT=========================== Ok so I am still having a problem, new code below....
t2 <- pauci[!(t1$Id %in% pauci$Id),]
What is happening is it is removing all values that are not in the pauci df and filling it with the pauci table and na values, image below. Any idea whats going on here?
I just want to remove the pauci table from the t1 table and create t2 with those results.