Formatting JSON output in Python

Question

How do I format my JSON output so that it looks human readable and I have a JSON file that looks like this:

{
"user1":{
    "Country":[
        "China", "USA", "Nepal"
    ],
     "Name": [
        "Lisbon"
    ]
},

"user2":{
    "Country":[
        "Sweden", "China", "USA"
    ],
     "Name": [
        "Jade"
    ]
},

"user3":{
    "Country":[
        "India", "China", "USA"
    ],
     "Name": [
        "John"
    ]
}

Here's my code:

user = raw_input("Enter user's name: ")
with open('Users.json') as f:
    data = json.load(f)

for k, v in data.items():
    if any(x in data[user]['Country'] for x in v['Country']):
        print(v['Name'])

So far my output looks like this:

[u'Lisbon']
[u'Jade']
[u'John']

I would like an output that looks like this, how do I go around that?:

Lisbon
Jade
John

Possible duplicate of [Suppress the u'prefix indicating unicode' in python strings](https://stackoverflow.com/questions/761361/suppress-the-uprefix-indicating-unicode-in-python-strings) — hyperTrashPanda, Feb 04 '19 at 12:35

score 1 · Accepted Answer · answered Feb 04 '19 at 12:35

1

You just need to change print(v['Name']) for print(v['Name'][0])

answered Feb 04 '19 at 12:35

luis.galdo

543
5
20

score 0 · Answer 2 · answered Feb 04 '19 at 12:33

The u in u'Jade' signifies that the string is encoded in Unicode. You can use print(unicode(v['Name'][0])) if you wish to print the bare string, but it makes no difference in the underlying data type.

You probably want to check out pretty-printing JSON if you will continue working on with JSON objects in Python.

score 0 · Answer 3 · answered Feb 04 '19 at 12:35

Thank you for the various answers people! But I managed to find figure it out on my own, I tweaked my print statement into this!

userName = raw_input("Enter user's name: ")
with open('extracted_data.json') as f:
    data = json.load(f)

for k, v in data.items():
    if any(x in data[userName]['Acceptable_country'] for x in v['Acceptable_country']):
        print(", ".join(v['Name']))

Formatting JSON output in Python

3 Answers3