I’m a complete beginner at python, and I’m trying to convert a json payload into a dataframe.

So I’ve got data that looks like this:

data = {
    "results": [
        {"values": [{"name": "firstname","value": "Fname1"},{"name": "lastname","value": "Lname1"}]},
        {"values": [{"name": "firstname","value": "Fname2"},{"name": "lastname","value": "Lname2"}]},
        {"values": [{"name": "firstname","value": "Fname3"},{"name": "lastname","value": "Lname3"}]}
    ]
}

I want a dataframe that looks like this:

I’m trying to figure out how to do this without doing something like a for loop or manually assigning column names. Thanks!

Kinda tried something like this:

df = pd.DataFrame(data["results"])

df[['values'][0]].apply(lambda x: x[0]['value'])

which result in:

But I’m kinda stuck on what to do next.