reading json file python

Question

js = {"Alex":{"b_":{"ep_0":"[1,2,3]"}, "g_":{"ep_0":"[3,4,5]"}, "f_":{"ep_0":"[3,4,5]", "ep_1":"[3,4,5]"}},
      "Sam":{"b_":{"ep_0":"[1,2,3]"}, "g_":{"ep_0":"[3,4,5]"}},
      "Joe":{"b_":{"ep_0":"[1,2,3]"}, "g_":{"ep_0":"[3,4,5]"}, "f_":{"ep_1":"[31,44,56]"}}
      }

I need to read ep_0 and ep_1 for each user, here is my snipped code:

users = [i for i in js.keys()]
data = {}
final_data = {}
for key in users:
        for user in js[key].keys():
            if 'f_' not in key:
                continue
            for z in js[users]['f_']:
                if 'ep_0' not in z:
                    continue
                data['ep0'] = js[user]['f_']['ep_0']
                if 'ep_1' not in z:
                    continue
                data['ep1'] = js[user]['f_']['ep_1']
                final_data[user] = data

    print(final_data)

the output of my code is {} and desire output should be:

{'Alex': {'f_':{'ep_0':'[3,4,5]', 'ep_1':'[3,4,5]'}}, 'Joe': { 'f_':{'ep_1':'[31,44,56]'}} }

use print() in different places to see values in variables - this helps you to see where is the problem. — furas
– furas, Commented Jul 16, 2019 at 16:27
Nothing you're showing here is JSON. Your js = ... is assigning a Python data structure; to be JSON, it would need to have double quotes -- unless you're referring to the lists in the inner strings being JSON? — Charles Duffy
– Charles Duffy, Commented Jul 16, 2019 at 16:36

Deepak Kabbur · Accepted Answer · 2019-07-16 17:21:37Z

1

Here is my simple solution to your problem.

final_data = {}
for user in js.keys():
    if 'f_' not in js[user]:
        continue
    final_data[user] = { "f_": js[user]['f_']}

print(final_data)

Output

{'Alex': {'f_': {'ep_0': '[3,4,5]', 'ep_1': '[3,4,5]'}}, 'Joe': {'f_': {'ep_1': '[31,44,56]'}}}

answered Jul 16, 2019 at 17:21

Deepak Kabbur

80216 silver badges25 bronze badges

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

Comments

Prune · Accepted Answer · 2019-07-16 16:48:05Z

I think that your most glaring problem is

users = [i for i in js.keys()]
...
        for z in js[users]['f_']:

users is a poorly-formed list of the keys in your dict. Just what do you expect js[users] to mean?

However, your first problem is the combination

for key in users:
    for user in js[key].keys():
        if 'f_' not in key:

users is the list of names: Alex, Sam, Joe. How do you expect to find f_ in that list? You've incorrectly connected your variables.

I strongly recommend that you start over with your coding. Employ incremental programming. Write a couple of lines that do one step of your process. Insert print statements to test that they do what you expect. Only after you've proved that, do you add more lines.

The problem you're facing here is that you wrote too much code at once, making several mistakes, and you're now in a situation where a single fix cannot get you any reasonable output.

Been there, done that, and I have all too many t-shirts from my forays into my own creations.

Moira Jones · Accepted Answer · 2019-07-16 16:48:25Z

0

I'm seeing js[users] in a few places in your code. You probably mean js[user], since users is just the list of keys from js, not a key itself. Try fixing that and see if it helps you.

answered Jul 16, 2019 at 16:48

Moira Jones

3691 silver badge7 bronze badges

1 Comment

Elham Over a year ago

Thank you for mentioning it (it was correct in my code and I edited my question as well). I can get the ep_0 if I remove the condition of ep_1.

Collectives™ on Stack Overflow

reading json file python

3 Answers 3

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Related