I have a dataset in 2 CSV files, example: data1.csv id site 1 wer 1 wer 2 fgas 3 vbcx 3 yhte data2.csv id name 1 bob 2 jill 3 jack What I want the output to be is result.csv id name site 1 bob wer ...