I have a dictionaries of list
[{
'LoanID' : 001,
'Applicant_Income.1' : 5000,
'Applicant_Occupation.1' : "Manager",
'Applicant_Income.2' : 3000,
'Applicant_Occupation.2' : "Accountant",
'LoanAmount' : 10000
},
{
'LoanID' : 002,
'Applicant_Income.1' : 6000,
'Applicant_Occupation.1' : "Senior Manager",
'Applicant_Income.2' : 2000,
'Applicant_Occupation.2' : "Services",
'LoanAmount' : 8000
}]
I need to create a new key ‘Applicant’ and move ‘Applicant_Income’ and ‘Applicant_Occupation’ inside that, result each dict in list looks like
{
'LoanID' : 001,
'Applicant' : [
{
'Applicant_Income' : 5000,
'Applicant_Occupation' : "Manager"
}'
{
'Applicant_Income' : 3000,
'Applicant_Occupation' : "Accountant"
}]
'LoanAmount' : 10000
},
{
'LoanID' : 002,
'Applicant' : [
{
'Applicant_Income' : 6000,
'Applicant_Occupation' : "Senior Manager"
}'
{
'Applicant_Income' : 2000,
'Applicant_Occupation' : "Services"
}]
'LoanAmount' : 8000
}
>Solution :
This should work (info is the list you defined above):
for d in range(len(info)):
info[d]['Applicant'] = [{'Applicant_Income.1': info[d]['Applicant_Income.1'], 'Applicant_Occupation.1': info[d]['Applicant_Occupation.1']}, {'Applicant_Income.2': info[d]['Applicant_Income.2'], 'Applicant_Occupation.2': info[d]['Applicant_Occupation.2']}]
del info[d]['Applicant_Income.1']
del info[d]['Applicant_Occupation.1']
del info[d]['Applicant_Income.2']
del info[d]['Applicant_Occupation.2']
Output:
[{'LoanID': '002',
'LoanAmount': 10000,
'Applicant': [{'Applicant_Income.1': 5000,
'Applicant_Occupation.1': 'Manager'},
{'Applicant_Income.2': 3000, 'Applicant_Occupation.2': 'Accountant'}]},
{'LoanID': '002',
'LoanAmount': 8000,
'Applicant': [{'Applicant_Income.1': 6000,
'Applicant_Occupation.1': 'Senior Manager'},
{'Applicant_Income.2': 2000, 'Applicant_Occupation.2': 'Services'}]}]