Add JSON objects to a list

Question

I have a function that generates a report from Excel file. For now, it work like:

import json

def get_dic_from_two_lists(keys, values):
    return { keys[i] : values[i] for i in range(len(keys)) }

def report(items):
    for i in range(items):
        dict_keys = ['name', 'age']
        dict_values = ['n', 'a']
        data = get_dic_from_two_lists(dict_keys, dict_values)
        report = json.dumps(data)
        print(report)
report(5)

Where items is number of reports to generate. It works good, but I need to append results into a list and separate JSON objects with a comma and, moreover, write everything to a file. Any good way to do it? append() function just doesn't seem to work out.

Thanks!

Can you fix the indentation and punctuation in your code so that it doesn't produce a syntax error? — khelwood
– khelwood, Commented Jun 27, 2017 at 7:53

vsenko · Accepted Answer · 2017-06-27 08:01:51Z

2

You can put all your report objects in the list and then convert it to JSON at once:

import json

def get_dic_from_two_lists(keys, values):
    return { keys[i] : values[i] for i in range(len(keys)) }

def report(items):
    data_list = []
    for i in range(items):
        dict_keys = ['name', 'age']
        dict_values = ['n', 'a']
        data = get_dic_from_two_lists(dict_keys, dict_values)
        data_list.append(data)

    reports = json.dumps(data_list)
    print(reports)

report(5)

answered Jun 27, 2017 at 8:01

vsenko

1,1498 silver badges20 bronze badges

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

1 Comment

Alice Jarmusch Over a year ago

Pure gold, understood my mistake. Thanks!

Collectives™ on Stack Overflow

Add JSON objects to a list

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related