Hello,
I need assistance merging two different data sets together. The two datasets look like this:
HAVE1
Week_Start Hospital Samples Average
07/05/2020. Name1. 2. 2
07/05/2020. Name2. 3 3
07/05/2020. Name3. 1. 1
07/12/2020. Name1. 2. 2
07/12/2020. Name2. 3 3
07/12/2020. Name3. 1. 1
Have2
Week_Start Hospital. Cases
07/05/2020. Name1. 10
07/12/2020. Name1. 25
What I want is to merge the datasets to add the cases column specifically for Hospital Name1. For example, what I WANT;
Week_Start Hospital Samples Average. Cases
07/05/2020. Name1. 2. 2. 10
07/05/2020. Name2. 3 3. --
07/05/2020. Name3. 1. 1. --
07/12/2020. Name1. 2. 2. 25
07/12/2020. Name2. 3 3. --
07/12/2020. Name3. 1. 1. --
Thank you so much for any help you can provide!