Suppose my datasets are organized like so:
I want to combine the information from dataset 1 and dataset 2 such that my columns are DISEASE, BMIGRP, COUNT_A, and COUNT_B.
I don't want to lose any information. That is, I want to maintain all the DISEASES granted they exist in at least one of the datasets like so:
Is there an efficient way to achieve this? Thank you in advance.