Multiple value insertion in json from two different lists using python

Question

I have 2 lists from these two lists i have to place values in multiple rows data is json file in which these values need to be placed listA = [A,B,C,D] listB = [11,12,13,14]

Result I would like to see as in json file as

"A" : [{
section = 11
}],
"B" : [{
section = 12
}]'
"C" : [{
section = 13
}]
"D" : [{
section = 14
}]

but currently i am getting as below

"A" : [{
section = 14
}],
"B" : [{
section = 14
}]'
"C" : [{
section = 14
}]
"D" : [{
section = 14
}]

The code i am using is below,here data is main json file where i need to place value

for j in listA:
  for k in listB:
       if j == 'A' :
            data[j][0]["section"] =  str(k)

       elif j == 'B':
             data[j][0]["section"] =  str(k)

       elif j == 'C' :
            data[j][0]["section"] =  str(k)
       elif j == 'D' :
            data[j][0]["section"] =  str(k)

Andrej Kesely · Accepted Answer · 2022-07-05 10:24:44Z

1

I hope I've understood your question well. If you have data in this format:

data = {
    "A": [{"section": ""}],
    "B": [{"section": ""}],
    "C": [{"section": ""}],
    "D": [{"section": ""}],
}

Then you can use zip() to iterate over listA and listB simultaneously:

listA = ["A", "B", "C", "D"]
listB = [11, 12, 13, 14]

for a, b in zip(listA, listB):
    data[a][0]["section"] = b

print(data)

Prints:

{
    "A": [{"section": 11}],
    "B": [{"section": 12}],
    "C": [{"section": 13}],
    "D": [{"section": 14}],
}

answered Jul 5, 2022 at 10:24

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple value insertion in json from two different lists using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related