Writing json from two lists in Python

Question

I am new to Python. I have two lists. One is key list and another list is value list.

title = ["Code","Title","Value",....] value = [["100","abcd",100",...],["101","efgh",200",...],...] data={} data.setdefault("data",[]).append({"code": sp[0],"val": sp[2]})

this code gives me the following result.

{'data': [{'code': '100', 'val': '100'},{'code': '101', 'val': '200'}]}

But I want the result as the below,

{ "100": { "Title": "abcd", "Value": "100", ............, ............}, "101": { "Title": "efgh", "Value": "200", ............, ............} }

i.e., The first column of the value list should be the key of every Json array list and other items of the lists should be generated as key and value pair. How can I generate the Json array using Python code referring that two lists.

experiment · Accepted Answer · 2018-08-07 09:52:51Z

1

As it is not mentioned that about the size of list ,the below could would do the job.I am using python3.x

title = ["Code","Title","Value"]
value = [["100","abcd","100"],["101","efgh","200"]]
dic1={}
for i in range(len(title)-1):
    for j in range(len(title)-1):
        dic1.setdefault(value[i][0],{}).update({title[j+1]:value[i][j+1]})

Output is

{'101': {'Title': 'efgh', 'Value': '200'}, '100': {'Title': 'abcd', 'Value': '100'}}

I hope it is helpful!

edited Aug 7, 2018 at 9:52

answered Aug 7, 2018 at 9:47

experiment

3154 silver badges19 bronze badges

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

1 Comment

Smith Dwayne Over a year ago

Thank you experiment. It works and much helpful to understand more about Python.

Christian · Accepted Answer · 2018-08-07 09:53:28Z

1

You can build a dict with this lists. I made a quick snippet just for you to understand

title = ["Code","Title","Value"]
value = [['100','abcd','100'],['101','efgh','200']]
data={}

for whatever in value:
    your_titles = {}
    print(whatever[0])
    your_titles[title[1]] = whatever[1]
    your_titles[title[2]] = whatever[0]
    your_titles[title[0]] = whatever[2]
    data[whatever[0]] = your_titles
print(data)

The output: {'100': {'Code': '100', 'Value': '100', 'Title': 'abcd'}, '101': {'Code': '200', 'Value': '101', 'Title': 'efgh'}}

Please read this tutorial and try to make it yourself. This is not the optimal solution for this problem.

answered Aug 7, 2018 at 9:53

Christian

763 bronze badges

1 Comment

Smith Dwayne Over a year ago

Thank you Christian. Your solution is easy and more understandable.

Upasana Mittal · Accepted Answer · 2018-08-07 08:45:03Z

0

Make a data frame and then set the column to index and then convert it to json:

    data_frame = pd.DataFrame(columns = title, data = value)
    data = data_frame.set_index('Code')

    json1 = data.to_json(orient='index')

answered Aug 7, 2018 at 8:45

Upasana Mittal

2,6991 gold badge17 silver badges21 bronze badges

Collectives™ on Stack Overflow

Writing json from two lists in Python

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related