How to create JSON object in Python

Question

Hi I need to create a JSON object in the following format. How to go about it

{"user2_proximity": 3, "Wifi_1": -80, "Wifi_2": -40, "Wifi_3": -40, 
"thermostat": 18, "light": 0, "hour_of_day": 0, "user3_proximity": 3, 
"user1_proximity": 1, "day_of_week": 1, "security": 0, "minute_of_hour": 9, 
"Act_1": 1, "Act_2": 0, "Act_3": 0}

I'm confused... is that already JSON or a python dict? Those things look very similar. JSON stands for JavaScript Object Notation which is a way to serialize data to exchange among systems. There isn't such a thing as a "JSON object" but there are objects in programming languages like python and javascript that can be built from them. Is this a sting and you want a dict or is this a dict and you want a string? — tdelaney
– tdelaney, Commented Jan 9, 2017 at 7:23

user5994461 · Accepted Answer · 2021-07-29 23:29:18Z

31

source : https://docs.python.org/3/library/json.html

import json
data = {"user2_proximity": 3, "Wifi_1": -80, "Wifi_2": -40, "Wifi_3": -40, 
"thermostat": 18, "light": 0, "hour_of_day": 0, "user3_proximity": 3, 
"user1_proximity": 1, "day_of_week": 1, "security": 0, "minute_of_hour": 9, 
"Act_1": 1, "Act_2": 0, "Act_3": 0}

json_data = json.dumps(data)

edited Jul 29, 2021 at 23:29

user5994461

7,3724 gold badges46 silver badges69 bronze badges

answered Jan 9, 2017 at 7:20

Po Stevanus Andrianta

7125 silver badges11 bronze badges

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

6 Comments

Anagha Over a year ago

The value of all the key i.e, user2_proximity, wifi_1 etc will be changing. Only thermostat and light value are constant.

Mark Tolonen Over a year ago

@Anagha Update your question to be more specific, then. Read this.

Po Stevanus Andrianta Over a year ago

@Anagha you can change the value by data['wifi_1'] = 2, then convert it into json again

Grant Foster Over a year ago

This won't retain its order by the way, if you care about that.

Po Stevanus Andrianta Over a year ago

@GrantFoster is there way to retain the order?

|

Binoy S Kumar · Accepted Answer · 2019-07-30 18:14:25Z

response is a 2d array with values for keys/columns ("test_id","querytext","metrics").

[0]['testid1','query1','"metrics": { "ndcg@3": "1.0", "ndcg@7": "0.9" }'] [1]['testid2','query2','"metrics": { "ndcg@3": "1.0", "ndcg@7": "0.9" }']

column_names=("test_id","querytext","metrics")
    json_response={}
    for entry in response:
        if entry[0] not in json_response:
            json_response[entry[0]]=[]
        json_element={}
        json_element[column_names[1]]=entry[1]
        json_element[column_names[2]]=json.loads(entry[2])
        json_response[entry[0]].append(json_element)
    return json.dumps(json_response)

Now json_response will be of following format

{ "tesid1": [{ "querytext": "query1", "metrics": { "ndcg@3": "1.0", "ndcg@7": "0.9" } }], "testid2": [{ "querytext": "query2", "metrics": { "ndcg@3": "1.0", "ndcg@7": "0.9" } }] }

Collectives™ on Stack Overflow

How to create JSON object in Python

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related