Parsing Firebase JSON with Python

Question

I'm working with the following JSON structures

{
    "-L6Tr0Wl5fuG3tDgUPCa": {
        "List": "{'x': [0.02245, 0.02196], 'y': [0.96941, 0.97014], 'z': [0.05344, 0.05368]}",
        "Index": "17361"
    },
    "-L6Tr4j05NV6BJKcaRSe": {
        "List": "{'x': [0.03196, 0.01537], 'y': [0.96795, 0.96966], 'z': [0.05051, 0.04929]}",
        "Index": "17362"
    }
}

The name of each entry is random (e.g. L6Tr0Wl5fuG3tDgUPCa) that is generated by firebase whenever we push a new entry. What is the best way to parse and iterate through each entry of such a JSON file in python?

The file is huge with a couple of thousands of such entries.

did you search for python parse json on SO? did you do any other reasearch? — Patrick Artner
– Patrick Artner, Commented Mar 4, 2018 at 12:43
Yes, I found quite a lot of examples and they all assumed known tags to parse. For example: data["known_tag"][0]. — Mobashyr Mohammad
– Mobashyr Mohammad, Commented Mar 4, 2018 at 12:44
So you know how to get from a json string to a dict aready? whats the problem then? You can for key in dictName: and then use dictName[key] to access its content. There is also .items() and .keys() on the dict. What is the exact problem you have? show some code, an error message, expected output and whats not correct with your approach. — Patrick Artner
– Patrick Artner, Commented Mar 4, 2018 at 13:01
Firebase has different structure and I am facing issues with same on python — Baljeetsingh Sucharia
– Baljeetsingh Sucharia, Commented Apr 11, 2019 at 4:49

Frank van Puffelen · Accepted Answer · 2018-03-04 15:27:32Z

2

I've never done Python before, but this seems to work in https://www.python.org/shell/:

import json
data = {
    "-L6Tr0Wl5fuG3tDgUPCa": {
        "List": "{'x': [0.02245, 0.02196], 'y': [0.96941, 0.97014], 'z': [0.05344, 0.05368]}",
        "Index": "17361"
    },
    "-L6Tr4j05NV6BJKcaRSe": {
        "List": "{'x': [0.03196, 0.01537], 'y': [0.96795, 0.96966], 'z': [0.05051, 0.04929]}",
        "Index": "17362"
    }
}

for key in data:
  print(key, data[key])

Also see:

How can I loop over entries in JSON?

answered Mar 4, 2018 at 15:27

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

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

1 Comment

Baljeetsingh Sucharia Over a year ago

if you see the JSON of firebase - we have less control on where [ bracket is available. the structure is as is and we want to deserialize - I have done it in C# but python am trying to crack.

Collectives™ on Stack Overflow

Parsing Firebase JSON with Python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related