Convert this python dictionary into JSON format? [duplicate]

Question

I have a python dictionary which I want to convert into json.

Python dictionary:

{"20090209.02s1.1_sequence.txt": [645045714, 3559.6422951221466, 206045184], "20090209.02s1.2_sequence.txt": [645045714, 3543.8322949409485, 234618880]}

Desired output:

{
       "file_name":"20090209.02s1.1_sequence.txt",
       "file_information": [645045714, 3559.6422951221466, 206045184],

    {
       "file_name":"20090209.02s1.2_sequence.txt",
       "file_information": [645045714, 3543.8322949409485, 234618880],

    }
}

Tried with json.dumps but I didn't get the desired output.

@AndyHayden: There is more going on here. This is not a pretty-printing problem. — Martijn Pieters
– Martijn Pieters, Commented Jun 18, 2013 at 11:12
Your output is invalid JSON; did you mean for this to be a list of dictionaries instead? — Martijn Pieters
– Martijn Pieters, Commented Jun 18, 2013 at 11:12
@AndyHayden: I've made an educated guess below. Let's see if that is good enough. — Martijn Pieters
– Martijn Pieters, Commented Jun 18, 2013 at 11:15
Yes the desire output I mentioned was invalid. The answer given by @Icfseth was what I wanted. — pynovice
– pynovice, Commented Jun 18, 2013 at 11:15

Bryce Siedschlaw · Accepted Answer · 2018-11-22 22:35:47Z

16

You need to first create a structure with the correct format:

import json

dict_ = {"20090209.02s1.1_sequence.txt": [645045714, 3559.6422951221466, 206045184], "20090209.02s1.2_sequence.txt": [645045714, 3543.8322949409485, 234618880]}
values = [{"file_name": k, "file_information": v} for k, v in dict_.items()]
json.dumps(values, indent=4)

Note that the desired JSON output does not look valid to me. Here's the output for this code:

[
    {
        "file_name": "20090209.02s1.1_sequence.txt", 
        "file_information": [
            645045714, 
            3559.6422951221466, 
            206045184
        ]
    }, 
    {
        "file_name": "20090209.02s1.2_sequence.txt", 
        "file_information": [
            645045714, 
            3543.8322949409485, 
            234618880
        ]
    }
]

edited Nov 22, 2018 at 22:35

Bryce Siedschlaw

4,2461 gold badge26 silver badges36 bronze badges

answered Jun 18, 2013 at 11:13

Samy Arous

6,81215 silver badges20 bronze badges

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

1 Comment

pynovice Over a year ago

Yes, this is what I want. I will accept your answer whenever I can.

Martijn Pieters · Accepted Answer · 2013-06-18 11:15:05Z

1

Split out your key-value pairs into separate dictionaries:

json.dumps([{'file_name': key, 'file_information': value} for key, value in yourdict.iteritems()])

Note that the order of your output will be arbitrary (dictionaries have no fixed ordering). You may want to sort the output to produce a predictable list:

from operator import itemgetter

data = [{'file_name': key, 'file_information': value} for key, value in yourdict.iteritems()]
data.sort(key=itemgetter('file_name'))
json.dumps(data)

This produces:

>>> data = [{'file_name': key, 'file_information': value} for key, value in yourdict.iteritems()]
>>> data.sort(key=itemgetter('file_name'))
>>> json.dumps(data)
'[{"file_name": "20090209.02s1.1_sequence.txt", "file_information": [645045714, 3559.6422951221466, 206045184]}, {"file_name": "20090209.02s1.2_sequence.txt", "file_information": [645045714, 3543.8322949409485, 234618880]}]'
>>> print json.dumps(data, indent=4)

[
    {
        "file_name": "20090209.02s1.1_sequence.txt",
        "file_information": [
            645045714,
            3559.6422951221466,
            206045184
        ]
    },
    {
        "file_name": "20090209.02s1.2_sequence.txt",
        "file_information": [
            645045714,
            3543.8322949409485,
            234618880
        ]
    }
]

edited Jun 18, 2013 at 11:15

answered Jun 18, 2013 at 11:09

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

4 Comments

pynovice Over a year ago

Hm I want to add those keys called file_name and file_information.

Samy Arous Over a year ago

I think you're missing the point here, the dict format and the json format are different :)

pynovice Over a year ago

Yes, this is what I wanted. +1

Guillaume Algis Over a year ago

I'd upvote as it is the same solution as lcfseth, but everything on one line ? really ?

Collectives™ on Stack Overflow

Convert this python dictionary into JSON format? [duplicate]

2 Answers 2

1 Comment

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Linked

Related