The CSV file extension appears on text documents that contain comma-separated values. Like spreadsheet data, each line in a CSV file separates into individual values that correspond with the cells ...

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 ...