combine 3 files by grouping

Shell Programming and Scripting
1

I have a file, which is really large but i shortened it:

A3059GVS        1       A       01      Plate_1 40      25.37016        14.6298
A3059GVS        2       A       01      Plate_2 40      26.642002       13.3583
A3059GVS        3       A       02      Plate_1 40      25.381462       14.6185
A3059GVS        4       A       02      Plate_2 40      26.452559       13.5474
A3059GVS        5       A       03      Plate_1 40      25.547625       14.4524
A3059GVS        6       A       03      Plate_2 40      26.368746       13.6313
A3059GVS        7       A       04      Plate_3 40      24.91846        15.0815
A3059GVS        8       A       04      Plate_4 40      26.162086       13.8373
A3059GVS        9       A       05      Plate_3 40      24.230042       15.7722
A3059GVS        10      A       05      Plate_4 40      25.976826       14.0232
....
....
A3059GVT        1       A       01      Plate_1 40      25.37016        14.6298
A3059GVT        2       A       01      Plate_2 40      26.642002       13.3582
A3059GVT        3       A       02      Plate_1 40      25.381462       14.6185
A3059GVT        4       A       02      Plate_2 40      26.452559       13.5474
A3059GVT        5       A       03      Plate_1 40      25.547625       14.4524
A3059GVT        6       A       03      Plate_2 40      26.368746       13.6311
A3059GVT        7       A       04      Plate_3 40      24.91846        15.0815
A3059GVT        8       A       04      Plate_4 40      26.162086       13.8379
A3059GVT        9       A       05      Plate_3 40      24.230042       15.7732
A3059GVT        10      A       05      Plate_4 40      25.976826       14.0232
....
....
A3059GVU        1       A       01      Plate_1 40      25.37016        14.6298
A3059GVU        2       A       01      Plate_2 40      26.642002       13.3581
A3059GVU        3       A       02      Plate_1 40      25.381462       14.6185
A3059GVU        4       A       02      Plate_2 40      26.452559       13.5478
A3059GVU        5       A       03      Plate_1 40      25.547625       14.4524
A3059GVU        6       A       03      Plate_2 40      26.368746       13.6316
A3059GVU        7       A       04      Plate_3 40      24.91846        15.0815
A3059GVU        8       A       04      Plate_4 40      26.162086       13.8379
A3059GVU        9       A       05      Plate_3 40      24.230042       15.7702
A3059GVU        10      A       05      Plate_4 40      25.976826       14.0232

The first column is an ID for 3 seperate grouping of 4 "Plate_1-4"
i need to append two more columns from two seperate files:
med.txt

Plate_1 14.29425
Plate_2 13.787
Plate_3 13.13745
Plate_4 16.64165
Plate_1 12.00325
Plate_2 17.2352
Plate_3 12.7458
Plate_4 17.16795
Plate_1 13.2605
Plate_2 17.2394
Plate_3 5.20885
Plate_4 9.649275

dev.txt

Plate_1 2.513278
Plate_2 0.5764198
Plate_3 0.4848839
Plate_4 0.8792527
Plate_1 1.781646
Plate_2 0.5698595
Plate_3 0.4665879
Plate_4 0.5185251
Plate_1 0.5510285
Plate_2 1.800977
Plate_3 5.690574
Plate_4 6.47827

the two new files are grouped 1-4 associated with A3059GVS-U

what is the best approach to append two more columns in respect to the first column.

2

I don't see that in your example data... Is it just not shown, or is the -U inferred from something?

working on an awk something..

---------- Post updated at 01:41 PM ---------- Previous update was at 01:37 PM ----------

awk -v ROW="A3059GVS-U" '
BEGIN {
        while (getline <"col1file") COLA[$1]=$2
        while (getline <"col2file") COLB[$1]=$2
        }

{       if($1 == ROW)
                $0=sprintf("%s %s %s", $0, COLA[$1], COLB[$1]);
} 1' datafile > newfile
3

med.txt and dev.txt have two coulmns. Plate_1 to Plate_4 three times. Reason is the first big file at the first column has only three values:
A3059GVS, A3059GVT, A3059GVU

4

How's it supposed to tell which things you want added to what columns when neither the name nor the order has anything to do with it?

5

i hit enter too soon. the two small files both have column two, i want to append to the original file associated with. example:
Plate_1 xxxxx and A30590GVS
Plate_2 xxxxx and A30590GVS
Plate_3 xxxxx and A30590GVS
Plate_4 xxxxx and A30590GVS

Plate_1 xxxxx and A30590GVT
Plate_2 xxxxx and A30590GVT
Plate_3 xxxxx and A30590GVT

and so on

---------- Post updated at 04:54 PM ---------- Previous update was at 04:31 PM ----------

darn forgot to intially mention for the main file column 1 and 5 are the important arrangments which reflect med.txt and dev.txt
the second column of the two smaller files need to be aligned with column 1 and 5 for the new output.
med.txt and dev.txt are calculations from the main file.

---------- Post updated at 05:33 PM ---------- Previous update was at 04:54 PM ----------

i am looking into a different approach by changing the output on med.txt and dev.txt which will associate it with the first column of the original file.
Apologies in advance for not starting off clear.