Converting Python Dictionary to JSON Array

Question

I currently have a Python Dictionary that looks something like this:

OrderedDict([('2017-07-24', 149.7619), ('2017-07-25', 150.4019), ('2017-07-26', 151.1109), ...

that I am converting to JSON like so:

one_yr = json.dumps(priceDict)

Currently I am adding values to the dictionary from an SQL query by looping through it like so:

for i in query:
    date = i[0] 
    close = i[1]
    priceDict[date] = close

The problem is that this returns a JSON object, that i then have to convert to a JSON array.

I am wondering if I can just convert my Python Dictionary to a JSON array directly? Thanks.

But this is a dict. A dict maps to an object. If you don't want an object, why are you passing a dict? — Daniel Roseman
– Daniel Roseman, Commented Jul 25, 2018 at 19:12

nosklo · Accepted Answer · 2018-07-25 19:14:50Z

3

json.dumps(list(priceDict.items()))

But why do you have an OrderedDict in first place? If you pass the same list you passed to OrderedDict to json.dumps it will generate your array:

json.dumps([('2017-07-24', 149.7619), ('2017-07-25', 150.4019),....])

No need for OrderedDict in this case

edited Jul 25, 2018 at 19:14

answered Jul 25, 2018 at 19:13

nosklo

224k58 gold badges299 silver badges299 bronze badges

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

2 Comments

G_M Over a year ago

TypeError: Object of type odict_items is not JSON serializable ? json.dumps(list(price_dict.items()))?

ng150716 Over a year ago

Thanks for the response, I should have mentioned I am using a Highcharts (a javascript charting library), that depends on the data being in an array. Currently the data looks like so: var one_yr = [["2017-07-24", 41.8175], ["2017-07-25", 41.9946], ... ["2018-01-01", 42.6143]} and isn't being plotted.

Vibhor Karnawat · Accepted Answer · 2018-07-25 20:24:47Z

1

If you want to convert a Python Dictionary to JSON using the json.dumps() method.

`

import json 
from decimal import Decimal
d = {}
d["date"] = "2017-07-24"
d["quantity"] = "149.7619"
print json.dumps(d, ensure_ascii=False)

`

answered Jul 25, 2018 at 20:24

Vibhor Karnawat

1002 silver badges13 bronze badges

5 Comments

ng150716 Over a year ago

Unfortunately this seems to create a dict with only two values. IE: [('close', 149.7619), ('date', '2017-07-24')], the problem is I am looping through a series of values.

Vibhor Karnawat Over a year ago

@ng150716 you can keep on adding the values byd["close"] = "149.7619,150.4019"

ng150716 Over a year ago

Sorry, I'm very new to serializing data and a bit rusty with Python over-all, how would that fit into for loop?

Vibhor Karnawat Over a year ago

@ng150716their is no need of loop I guess d[""] = ([('2017-07-24', 149.7619), ('2017-07-25', 150.4019), ('2017-07-26', 151.1109,...)]) this might help you

ng150716 Over a year ago

Sorry, i don't think I explained clearly what i mean't, but I have to loop through an SQL query to add the values to the dict. I have updated my post to show what I mean.

Steven M · Accepted Answer · 2018-07-25 19:19:08Z

0

I removed the OrderedDict but kept all the other data, I think I understand the request. See if this works for you:

import json

my_dict = ([('2017-07-24', 149.7619), ('2017-07-25', 150.4019), ('2017-07-26', 151.1109)])

print(json.dumps(my_dict, indent=4, sort_keys=True))

answered Jul 25, 2018 at 19:19

Steven M

2041 gold badge4 silver badges13 bronze badges

1 Comment

ng150716 Over a year ago

Unfortunately no, this still seems to create an object not an array (the data is still encapuslated in curly braces { ... } as opposed to brackets [ ... ]

Collectives™ on Stack Overflow

Converting Python Dictionary to JSON Array

3 Answers 3

2 Comments

5 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related