Python Tuple to JSON output

Question

How do I turn this:

data = ((1, '2011-01-01'), (2, '2011-01-02'), (1, '2011-01-15'), (3, '2011-02-01'))

into this:

{
    "item": [
     "1",
     "2",
     "1",
     "3",
    ],
    "settings": {
     "axisx": [
      "2011-01-01",
      "2011-01-02",
      "2011-01-15",
      "2011-02-01"
     ],
     "axisy": [
      "0",
      "100"
     ],
     "colour": "ff9900"
     }
}

Or rather, are there any helpful resources that I can read so that I would be able to produce that JSON output? So I know I need to 'transform' my data into the right data structure. After that is it as easy as json.dumps(data)

Thanks

Where does the axisy bit come from?

phooji
– phooji

2011-02-23 07:04:30 +00:00
Commented Feb 23, 2011 at 7:04 — phooji
– phooji, Commented Feb 23, 2011 at 7:04
I figured :) See conversion code below...

phooji
– phooji

2011-02-23 07:13:13 +00:00
Commented Feb 23, 2011 at 7:13 — phooji
– phooji, Commented Feb 23, 2011 at 7:13

phooji · Accepted Answer · 2011-02-23 07:11:53Z

39

Use the json library.

Then convert your data using something like this:

somedict = { "item"     : [ x[0] for x in data ],
             "settings" : { "axisx" : [ x[1] for x in data ],
                            "axisy" : [ 0, 100],
                            "colour" : "ff9900" }
           }

and call:

print json.dumps(somedict)

answered Feb 23, 2011 at 7:11

phooji

10.4k3 gold badges41 silver badges46 bronze badges

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

2 Comments

super9 Over a year ago

Thanks, this was exactly what I needed. I'm still a beginner in Python as you can see!

Mahesha999 Over a year ago

am new to python...can we use these libraries (json or simplejson) to serialize/deserialize objects which are extensively used by python developers say pandas dataframe, series etc.

Alexander Sobolev · Accepted Answer · 2011-02-23 07:08:25Z

15

There is a json library.

import json

jsonObj = json.dumps(data)

Thats for json serializing. If you want output be formatted in some other way than you initial data variable, you should create another object, initialize it with values from data in the way you need and than use json library for serialization.

edited Feb 23, 2011 at 7:08

answered Feb 23, 2011 at 7:02

Alexander Sobolev

8894 silver badges13 bronze badges

Collectives™ on Stack Overflow

Python Tuple to JSON output

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related