In Python 3.8, I have successfully loaded two JSON files and now need to merge them based on a specific condition.
Obj1 = [{'account': '223', 'colr': '#555555', 'hash': True},
{'account': '134', 'colr': '#666666', 'hash': True},
{'account': '252', 'colr': '#777777', 'hash': True}]
Obj2 = [{'sn': 38796, 'code': 'df', 'id': 199, 'desc': 'jex - #777777- gg2349.252'},
{'sn': 21949, 'code': 'se', 'id': 193, 'desc': 'jex - #555555 - gf23569'},
{'sn': 21340, 'code': 'se', 'id': 3, 'desc': 'jex - #666666 - gf635387'}]
# Desired Merged Result
Obj3 = [{'sn': 38796, 'code': 'df', 'id': 199, 'desc': 'jex - #777777- gg2349.252', 'account': '252', 'colr': '#777777', 'hash': True},
{'sn': 21949, 'code': 'se', 'id': 193, 'desc': 'jex - #555555 - gf23569', 'account': '223', 'colr': '#555555', 'hash': True},
{'sn': 21340, 'code': 'se', 'id': 3, 'desc': 'jex - #666666 - gf635387', 'account': '134', 'colr': '#666666', 'hash': True}]
I have attempted various methods such as append and extend from resources like Stack Overflow but still face difficulties with the specific condition.
The objective is to add elements from Obj1 into Obj2 at their appropriate positions based on the condition where if the colr value of an element in Obj1 matches part of the desc value in Obj2, then that entire element from Obj1 should be appended to the corresponding element in Obj2. Alternatively, creating a new Obj3 for displaying the updated values.
References consulted include: Append JSON Object, Append json objects to nested list, Appending json object to existing json object among others without success.
Hopefully, this clarifies the situation. Thank you.