I have 2 data frames and I want to use a function similar to excel vlookup.
Each data frame has different amount of rows, most entities appear on both data frames, but each data frame also includes entities that appear only on one of them.
I have data frames from July and June and I want to use vlookup so I have all entities from July report, and if there are entities that didn't appear in June but appear in July, I want it write 0.
This is what I tried to do- it did work, but the problem is that the merged data frame only contains entities that appear on both data frames:
AR <- merge(July,June,by="Customer Name")
Thanks in advance!
