I have two separate files that I would like to combine. Each have 7 columns as such:
1 10 6 0.02 A 45 0.17
1 15 6 0.03 A 67 0.17
2 33 6 0.10 A 23 0.17
and
1 10 6 0.04 B 87 0.17
1 12 6 0.12 B 93 0.17
2 33 6 0.08 B 45 0.17
I would like to combine column 1 and 2 of each files while removing duplicates and then add column 4 5 6 from each file to the corresponding combination of column 1 and 2. Then if columns 1 and 2 don't match I would like them to be printed however for the file lacking for it to put 0 instead of column 4 5 and 6 such that the final file would be
1 10 0.02 A 45 0.04 B 87
1 12 0 0 0 0.12 B 93
1 15 0.03 A 67 0 0 0
2 33 0.10 A 23 0.08 B 45