I have two data frames, first one is per image data:
ImageNumber Experiment Condition Gene AdditionalColumns
1 A Control X -
2 A Control Y -
3 A Control Z -
4 B Mutant ABI -
...
Second one is per object data:
ImageNumber ObjectNumber AdditionalColumns
1 1 -
1 2 -
1 3 -
2 1 -
3 1 -
3 2 -
3 3 -
4 1 -
4 2 -
I want to add Experiment, Condition and Gene columns to per object data frame according to ImageNumber:
ImageNumber ObjectNumber AdditionalColumns Experiment Condition Gene
1 1 - A Control X
1 2 - A Control X
1 3 - A Control X
2 1 - A Control Y
3 1 - A Control Z
3 2 - A Control Z
3 3 - A Control Z
4 1 - B Mutant ABI
4 2 - B Mutant ABI