Merge JSON to list

Question

I have 2 json files! f1.json and f2.json

Contents: "f1.json"

{
  "tests":
    [
      {"a": "one", "b": "two"},
      {"a": "one", "b": "two"}
    ]
}

Contents: "f2.json"

{
  "tests":
    [
      {"c": "three", "d": "four"}
    ]
}

Required output - in list format

[{a:"one",b:"two"},{a:"one",b:"two"},{c:"three",d:"four"}]

I'm getting the same output in the "unicode" format. Does anyone have a way to get it without the unicode?

My output

[{u'a': u'one', u'b': u'two'}, {u'a': u'one', u'b': u'two'}, {u'c': u'three', u'd': u'four'}]

Code:

files=['t1.json','t2.json']      


import json,ast                          

empty = []                             


for elements in files:           
    fh = open(elements, 'r')             
    filedata = fh.read()                 
    fh.close()                           
    data = json.loads(filedata)          

    empty.append(data['tests'])        
final = []                            
for elements in empty:                 
    for dict in elements:                
        final.append(dict)            
print final

you're printing a python list, so your output is in python list format. If you want your output in JSON format, you should probably convert your data to JSON before printing: `print json.dumps(final)` — Hamms, Jun 14 '17 at 00:34
I very much doubt that. But another good solution would be to upgrade to python3 — Hamms, Jun 14 '17 at 00:38
I dont want the output to be string! it has to be in the dict format. Doing what you suggested does solve the issue but creates an ever bigger issue for me — Arohi Gupta, Jun 14 '17 at 00:41
It is in the dict format. The unicode markers are valid python — Hamms, Jun 14 '17 at 00:42
see https://stackoverflow.com/questions/761361/suppress-the-uprefix-indicating-unicode-in-python-strings — Hamms, Jun 14 '17 at 00:43
Not clear what's wrong with the data. It's a dictionary. You can access it fine — OneCricketeer, Jun 14 '17 at 02:28

zhenguoli · Answer 1 · 2017-06-14T02:32:54.073

0

You could get string object instead of Unicode ones from JSON.

Refer to Mark Amery's function and How to get string objects instead of Unicode ones from JSON in Python?

So you can convert the Unicode data(variable) to string object in your code after the line:

data = json.loads(filedata)
data = byteify(data)    # Add this line according to Mark Amery's function

edited Jun 14 '17 at 02:32

answered Jun 14 '17 at 02:21

zhenguoli

2,268
1
14
31

score 0 · Answer 2 · answered Jun 14 '17 at 02:41

0

try below code

import json

l = []
files=['t1.json','t2.json']
for file in files:
   with open(file, 'r') as file:
       d = json.loads(file.read())
       l.extend(d["tests"])
print l

answered Jun 14 '17 at 02:41

anjaneyulubatta505

10,713
1
52
62

Merge JSON to list

2 Answers2