Get label name on JSON Python

Question

i am a newbie on JSON, I want to get just 'label' from my JSON data here is my JSON data, i am using json.dumps to turn it into JSON format

a = json.dumps({"Name": "Robert",
   "Date" : "January 17th, 2017",
   "Address" : "Jakarta"})

I want to print just the label of my JSON data, is there any possible way to do it? The result that i want is

Name
Date
Address

Once this is JSON, this becomes difficult. Why don't you just use the Python data structure? JSON here makes no sense. — juanpa.arrivillaga
– juanpa.arrivillaga, Commented Jan 16, 2017 at 23:26

eyllanesc · Accepted Answer · 2017-01-16 23:44:25Z

4

You must convert json to dict and then the labels are the same as the keys.

import json
a = json.dumps({"Name": "Robert",
   "Date" : "January 17th, 2017",
   "Address" : "Jakarta"})
for key in json.loads(a):
    print(key)

output:

Name
Date
Address

Optional:

If you want to access the values of each item

import json
a = json.dumps({"Name": "Robert",
   "Date" : "January 17th, 2017",
   "Address" : "Jakarta"})
d = json.loads(a)
for key in d:
     print("key: {}, value: {}".format(key, d[key]))

Python2

for key, value in json.loads(a).iteritems():
     print("key: {}, value: {}".format(key, value))

Python3

for key, value in json.loads(a).items():
     print("key: {}, value: {}".format(key, value))

Output:

key: Name, value: Robert
key: Date, value: January 17th, 2017
key: Address, value: Jakarta

edited Jan 16, 2017 at 23:44

answered Jan 16, 2017 at 23:32

eyllanesc

246k19 gold badges205 silver badges282 bronze badges

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

7 Comments

Surya Avala Over a year ago

haha you posted the answer, literally while i was typing it. :D

eyllanesc Over a year ago

:P The solution is very simple :V

M. Agus Tri Mulyono Over a year ago

Thanks for the answer, and i got the result Date, Name and then Address at last, why it can happen? It should be like what you said

eyllanesc Over a year ago

@M.AgusTriMulyono If my answer helps you mark it correctly.

M. Agus Tri Mulyono Over a year ago

@eyllanesc the result what i got is Date, Name, then Address, why it can be happen, it should be Name, Date, then Address

|

Surya Avala · Accepted Answer · 2017-01-16 23:35:12Z

1

Assumptions made:

I assumed that you are using python3.x

You can do it as follows:

import json
a = json.dumps({"Name": "Robert", "Date" : "January 17th, 2017", "Address" : "Jakarta"})
a_dict = json.loads(a)
for key in a_dict.keys():
    print (key)

answered Jan 16, 2017 at 23:35

Surya Avala

15810 bronze badges

Comments

H.H · Accepted Answer · 2017-01-16 23:36:54Z

0

I think you need to use loads to create a json object. So in Python3:

import json

a = json.loads('{"Name":"Robert","Date":"January 17th, 2017","Address":"Jakarta"}')

for key, value in a.items() :
    print (key)

answered Jan 16, 2017 at 23:36

H.H

711 gold badge2 silver badges10 bronze badges

3 Comments

juanpa.arrivillaga Over a year ago

loads does not create a JSON "object". It deserializes a string in JSON format into a python object

H.H Over a year ago

I meant set of dicts from string

M. Agus Tri Mulyono Over a year ago

the result is Date, Name and Address, why it can be happen?

saket garg · Accepted Answer · 2020-10-15 04:02:47Z

Below python code will get the json file as input and produce a file with labels from json at all levels.

from re import sub
from os.path import abspath, realpath, join, dirname
import json
Srcfilename = input("Enter Srcfilename: ") 
file = abspath(Srcfilename)
file_open = open(file, 'r')
file_read = file_open.read()
#print(file_read)
jdata = json.loads(file_read)

def get_keys(dl, keys_list1):
        if isinstance(dl, dict):
            for key1,info1 in dl.items():
               # print(key1)
                keys_list1.append(key1)
                #print("\nlistinfo:",info1)
                if isinstance(info1, dict) or isinstance(info1, list)  :
                        get_keys(info1, keys_list1)
        elif isinstance(dl, list):
             if isinstance(dl[0], dict):
                for key2,info2 in dl[0].items():
                  #  print(key2)
                    keys_list1.append(key2)
                   # print("\nlistinfo:",info2)
                    if isinstance(info2, dict) or isinstance(info2, list)  :
                        get_keys(info2, keys_list1)
        keys_list1 = list(dict.fromkeys(keys_list1))                
        keylist='\n'.join(map(str, keys_list1))
        
        return keylist              
      

        
keys_list1=[]
Tgtfilename = input("Enter Tgtfilename: ") 
new_file = abspath(Tgtfilename)
new_file_open = open(new_file, 'w')
content=get_keys(jdata, keys_list1)
print (keys_list1)
new_file_open.write(content)
new_file_open.close()

Collectives™ on Stack Overflow

Get label name on JSON Python

4 Answers 4

7 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

7 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related