Parse output from json python

If you are willing to use pandas, you could just use pd.json_normalize, which is actually quite fast:

import pandas as pd
 
abc = {'everything': {'A': {'1': {'tree': {'value': 'good'}}}, 

'B': {'5': {'tree1': {'value': 'bad'}}},

'C': {'30': {'tree2': {'value': 'good'}}}}}

df = pd.json_normalize(abc)
print(df.values[0])

['good' 'bad' 'good']

Without any extra libraries, you will have to iterate through your nested dictionary:

values = [abc['everything'][e][k][k1]['value'] for e in abc['everything'] for k in abc['everything'][e] for k1 in abc['everything'][e][k]]
print(values)

['good', 'bad', 'good']

Provided your keys and dictionaries have a value somewhere, you can try this:

• Create a function (or reuse the code) that gets the first element of the dictionary until the value key exists, then return that. Note that there are other ways of doing this.
• Iterate through, getting the result under each value key and return.

# Define function
def get(d):
    while not "value" in d:
        d = list(d.values())[0]
    return d["value"]

# Get the results from your example
results = [get(v) for v in list(abc["everything"].values())]

['good', 'bad', 'good']

Firstly, the syntax you are using is incorrect.

If you are using pandas, you can code like

import pandas as pd

df4 = pd.DataFrame({"TreeType": ["Tree1", "Tree2", "Tree3"], "Values": ["Good", "Bad","Good"]})

df4.index = ["A","B","C"]

next just run the code df4, you would get the correct output.

output:

TreeType    Values

A Tree1 Good B Tree2 Bad C Tree3 Good