Converting objects in file to json in python

Question

I have a file with multiple objects like this:

{ 
    name: (sindey, crosby)
    game: "Hockey"
    type: athlete
},
{ 
    name: (wayne, gretzky)
    game: "Ice Hockey"
    type: athlete
}

...and I'd like to convert them to JSON format and output this:

[
    { 
        "name": "(sindey, crosby)",
        "game": "Hockey",
        "type": "athlete"
    },
    { 
        "name": "(wayne, gretzky)",
        "game": "Ice Hockey",
        "type": "athlete"
    }
]

If the input was in this format,

 name: (sidney, crosby) | game:"Hockey" |  type:athlete 
 name: (wayne, gretzky) | game:"Ice Hockey" |  type:athlete

I could implement using json dump with list and dict and it gives me the desired output

import json

f = open("log.file", "r")
content = f.read()
splitcontent = content.splitlines()

d = []
for v in splitcontent:
    l = v.split(' | ')
    d.append(dict(s.split(':',1) for s in l))


with open("json_log.json", 'w') as file:
    file.write((json.dumps(d, indent=4, sort_keys= False)))

How can I reformat this code to convert my input to JSON format?

@ScottHunter fixed, they're both meant to be in the same format. — learner22
– learner22, Commented Jun 6, 2022 at 13:02
Let's be clear: you have a non-standard file format and you have to write a parser for it. You wrote one for your other non-standard format; what is stopping your from writing one for your first one? — chepner
– chepner, Commented Jun 6, 2022 at 13:11
Please show what you have tried & what specific issues you are having with it. — Scott Hunter
– Scott Hunter, Commented Jun 6, 2022 at 13:15

chris b · Accepted Answer · 2022-06-06 18:02:44Z

2

With slight changes on the answer given by @sarah Messer. Changes involved

lines without the : separator skipped

Try this

import json


f = open("log.file", "r")
content = f.read()
splitcontent = content.splitlines()

d = []
appendage = {}
for line in splitcontent:

    if ('}' in line) or ('{' in line) or ('{' in line) or ('}' in line):
        # Append a just-created record and start a new one
        if appendage:
            d.append(appendage)
            appendage = {}
        continue

    key, val = line.split(':')

    if val.endswith(','):
        # strip a trailing comma
        val = val[:-1]
        print(val)
    # if val == "":
    #     pass
    # else:
    appendage[key] = val


with open("json_log.json", 'w') as file:
    file.write((json.dumps(d, indent=4, sort_keys=False)))

edited Jun 6, 2022 at 18:02

answered Jun 6, 2022 at 14:15

chris b

646 bronze badges

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

2 Comments

learner22 Over a year ago

any idea why it's outputting only the 2nd object 6 times. The output is in the format I needed but outputs the (wayne, gretzky).... object 6 times

chris b Over a year ago

@learner22 checkout the updated answer.

Sarah Messer · Accepted Answer · 2022-06-06 20:48:26Z

2

Something like this will probably work for most cases - you just have to handle the lines with curly braces separately from the lines with data:

import json

f = open("log.file", "r")
content = f.read()
splitcontent = content.splitlines()

d = []
appendage = {}
for line in splitcontent:
    if ('}' in line) or ('{' in line):
        # Append a just-created record and start a new one
        if appendage:
            d.append(appendage)
        appendage ={}
    else:
        key, val = line.split(':',1)
        if val.endswith(','):
            # strip a trailing comma
            val = val[:-1]
        appendage[key] = val


with open("json_log.json", 'w') as file:
    file.write((json.dumps(d, indent=4, sort_keys= False)))

I might also have some typos in there...

edited Jun 6, 2022 at 20:48

answered Jun 6, 2022 at 13:43

Sarah Messer

4,1152 gold badges31 silver badges51 bronze badges

Collectives™ on Stack Overflow

Converting objects in file to json in python

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related