Make lists from elements of JSON file

Question

I would like to make three different lists out of a JSON file (https://www.dropbox.com/s/woxtqy634g89f0r/tags.json?dl=0) say, A, B, and C:

A: (13,13,...,37)
B: (12,14,...,32)
C: ([-1.3875, 1.3875, -1.95 ], [[-2.775, -0., -0., ], .., [-0., 2.775, -0. ]])

Is there any quick and smart way to do it?

I tried in jupyter-notebook:

with open('tags.json', 'r') as f:
    tags = json.load(f)
tags['neb.00']

the output would give me

'13->12 0.2906332796567428 [-1.3875 1.3875 -1.95 ]'

And then I can do something like tags['neb.03'][0:2] to get 13 and so on. But this is not a good way of doing and I hope there is a proper way to do it. Could anyone help me, please?

"this is not a good way of doing" Why not?

Stop harming Monica
– Stop harming Monica

2019-09-26 19:29:32 +00:00
Commented Sep 26, 2019 at 19:29 — Stop harming Monica
– Stop harming Monica, Commented Sep 26, 2019 at 19:29

FMARAD · Accepted Answer · 2019-09-26 19:26:04Z

2

for k,v in data.items():
    A =v[:v.index('-')]
    B =v[v.index('>')+1:v.index('[')]
    C =v[v.index('[')::]
    print(k,A,B,C)

.items() iterates through dict keys(k) and values(v)

i don't know if that's the answer you were looking for but looking at your data, it seems like it has a stable structure. i guess you can append each value to a list.

edited Sep 26, 2019 at 19:26

answered Sep 26, 2019 at 19:20

FMARAD

1011 silver badge12 bronze badges

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

6 Comments

baban Over a year ago

Thanks @FMARAD. That's exactly I was looking for. It solved my problem!

baban Over a year ago

Hi, actually I realized there is a tiny bit of thing still left. If you look at 'C' in the main question, it's actually a list but what I am getting is a string obvioisuly like [-1.3875 1.3875 -1.95 ] but I want [-1.3875, 1.3875, -1.95 ]. Could you please help me with that?

FMARAD Over a year ago

C.strip("[]").split(",")

baban Over a year ago

Somehow that didn't work for me. It only changed from [-1.3875 1.3875 -1.95 ] to ['-1.3875 1.3875 -1.95 '].

FMARAD Over a year ago

so i just got on my PC, C. strip("[]").split() but this would give you list of strings, i guess you can manipulate that.

|

user2468968 · Accepted Answer · 2019-09-26 20:16:05Z

0

import json
import re

with open('tags.json', 'r') as f:
    tags = json.load(f)

A = []
B = []
C = []
for x in sorted(tags.keys()):
    m = re.search(r'(\d+)->(\d+) (\d+\.\d+) \[(.+)\]', tags[x])
    if not m:
        print("Not matching:", tags[x])
        continue
    A.append(int(m.group(1)))
    B.append(int(m.group(2)))
    C.append([float(y) for y in m.group(4).split()])

sorted() or other functions if you need your items ordered in a deterministic way.

edited Sep 26, 2019 at 20:16

answered Sep 26, 2019 at 19:23

user2468968

2863 silver badges9 bronze badges

2 Comments

baban Over a year ago

Didn't work for me. Giving me: AttributeError: 'NoneType' object has no attribute 'group'

user2468968 Over a year ago

That means the regex did not match. Your input is probably more complex than the example you posted. Edited to skip non-matching pattern so that you can refine the regex.

Collectives™ on Stack Overflow

Make lists from elements of JSON file

2 Answers 2

6 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related