Parsing JSON file with multiple arrays using Python

Question

I tried to retrieve the data from JSON file and assign them into object type like code the below. The data has multiple arrays in order with lat and lng. Using Python how could I deal with this one?

Current Python code*

import os
from flask import Flask, render_template, abort, url_for, json
import json

app = Flask(__name__)

...
with open('./data/file.json', 'r') as myfile:
    data = myfile.read()
    features = json.loads(data)['features']
    for o in features:
        print(o['coordinates'])). <----'Data from JSON file'
...
app.run(host='localhost', debug=True)

Orginal JSON file

{
    "features": [{
        "coordinates": [
            [
                [
                    -79.3998992207101,
                    43.770625433748776
                ],
                [
                    -79.39977945240246,
                    43.770651091617324
                ],
                [
                    -79.39970177723474,
                    43.77046066096583
                ],
                [
                    -79.39982154480901,
                    43.77043500133246
                ],
                [
                    -79.3998992207101,
                    43.770625433748776
                ]
            ]
        ]
    }]
}

Data from JSON file

[[[-79.3998992207101, 43.770625433748776], [-79.39977945240246, 43.770651091617324], [-79.39970177723474, 43.77046066096583], [-79.39982154480901, 43.77043500133246], [-79.3998992207101, 43.770625433748776]]]

Result I am aiming at

var triangleCoords = [
    {lat: -79.3998992207101, lng: 43.770625433748776},
    {lat: -79.39977945240246, lng: 43.770651091617324},
    {lat: -79.39970177723474, lng: 43.77042949785241},
    {lat: -79.39987169202237, lng: 43.77039053223808}
    .....
  ];

@KlausD. Thank you for your comment. I edited the post. Could you check it again? — CalgaryFlames
– CalgaryFlames, Commented Jul 13, 2020 at 20:58
You access features immediate, but there's nothing like that in your file. — Klaus D.
– Klaus D., Commented Jul 13, 2020 at 21:05
@KlausD. Sorry to make you confused. I posted the original JSON file as well. — CalgaryFlames
– CalgaryFlames, Commented Jul 13, 2020 at 21:08

Sherzod Sadriddinov · Accepted Answer · 2020-07-13 21:43:06Z

1

You can use this really easy function, just replace print(o['coordinates'])) with function name as I show in example

def unpack_coordinates(coordinates):
    coordinates_list = list()
    for item in coordinates[0]:
        coordinates_list.append({"lat": item[0], "lng": item[1]})
    return coordinates_list

# Your Flask code
...
with open('JSON.json', 'r') as myfile:
    data = myfile.read()
    features = json.loads(data)["features"]
    for o in features:
        print(unpack_coordinates(o["coordinates"]))
...

Output

[
    {'lat': -79.3998992207101, 'lng': 43.770625433748776}, 
    {'lat': -79.39977945240246, 'lng': 43.770651091617324}, 
    {'lat': -79.39970177723474, 'lng': 43.77046066096583}, 
    {'lat': -79.39982154480901, 'lng': 43.77043500133246}, 
    {'lat': -79.3998992207101, 'lng': 43.770625433748776}
]

answered Jul 13, 2020 at 21:43

Sherzod Sadriddinov

1166 bronze badges

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

Comments

bigbounty · Accepted Answer · 2020-07-13 21:33:41Z

0

Keep only original json file in context here

In [87]: a = json.laod(open("./data/file.json"))
In [88]: triangleCoords = []

In [89]:  for i in a["features"]:
    ...:     for j in i["coordinates"][0]:
    ...:        triangleCoords.append({"lat":j[0],"lng":j[1]})
    ...:

In [90]: triangleCoords
Out[90]:
[{'lat': -79.3998992207101, 'lng': 43.770625433748776},
 {'lat': -79.39977945240246, 'lng': 43.770651091617324},
 {'lat': -79.39970177723474, 'lng': 43.77046066096583},
 {'lat': -79.39982154480901, 'lng': 43.77043500133246},
 {'lat': -79.3998992207101, 'lng': 43.770625433748776}]

answered Jul 13, 2020 at 21:33

bigbounty

17.5k7 gold badges45 silver badges76 bronze badges

Comments

Vishal Singh · Accepted Answer · 2020-07-13 21:42:27Z

depending upon how you truncated you JSON there is a possibility of making it less nested.

import json

with open('./data/file.json', 'r') as myfile:
    data = myfile.read()
    features = json.loads(data)["features"]
    triangleCoords = []
    for o in features:
        for key, values in o.items():
            for value in values:
                for v in value:
                    triangleCoords.append({"lat": v[0], "lng": v[1]})

print(triangleCoords)

Output:

[
    {"lat": -79.3998992207101, "lng": 43.770625433748776},
    {"lat": -79.39977945240246, "lng": 43.770651091617324},
    {"lat": -79.39970177723474, "lng": 43.77046066096583},
    {"lat": -79.39982154480901, "lng": 43.77043500133246},
    {"lat": -79.3998992207101, "lng": 43.770625433748776},
]

Collectives™ on Stack Overflow

Parsing JSON file with multiple arrays using Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related