How to pass a JSON or DICT into a dataframe with pandas?

Question

I have this JSON/DICT in Python and I need to pass it to a datframe:

{
    "filters": [
        {
            "field": "example1",
            "operation": "like",
            "values": [
                "Completed"
            ]
        },
        {
            "field": "example2",
            "operation": "like",
            "values": [
                "value1",
                "value2",
                "value3",
            ]
        }
    ]
}

DF that i need:

example1	example2
Completed	["value1","value2","value3"]

Answer 1

Try:

dct = {
    "filters": [
        {"field": "example1", "operation": "like", "values": ["Completed"]},
        {
            "field": "example2",
            "operation": "like",
            "values": [
                "value1",
                "value2",
                "value3",
            ],
        },
    ]
}

df = pd.DataFrame(
    [
        {
            f["field"]: f["values"][0] if len(f["values"]) == 1 else f["values"]
            for f in dct["filters"]
        }
    ]
)
print(df)

Prints:

    example1                  example2
0  Completed  [value1, value2, value3]