Iterating list to create df

Question

I have a variable <class 'list'> that comes from a post request API in GraphQL that looks like this:

  [
    {'duration': 0, 
     'phase': 
        {
            'name': 'Start form'
        }
    }, 
    {'duration': 441, 
     'phase': 
        {
            'name': 'Análise do SAC - Mesas'
        }
    }, 
    {'duration': 126057, 
     'phase': 
        {
            'name': 'Análise do SAC - Industrial'
        }
    }
 ]

How can I iterate thru this list and create a dataframe that looks like this:

Start form	Análise do SAC - Mesas	Análise do SAC - Industrial
0	441	126057

I need to create the df like this because I will merge with another df

Also, I'm curious, what's the need of this list organization? Like a list of lists? List of dict?

Thanks in advance!!

"what's the need"? Do you mean "what's the name"? It's a list of dictionaries. — Barmar
– Barmar, Commented Dec 31, 2021 at 4:14

Tyler Liu · Accepted Answer · 2021-12-31 04:15:10Z

2

Consider the following code which will produce the output you want:

import pandas as pd

response =  [
    {'duration': 0, 
     'phase': 
        {
            'name': 'Start form'
        }
    }, 
    {'duration': 441, 
     'phase': 
        {
            'name': 'Análise do SAC - Mesas'
        }
    }, 
    {'duration': 126057, 
     'phase': 
        {
            'name': 'Análise do SAC - Industrial'
        }
    }
 ]
 
data = {}
for obj in response:
    data[obj["phase"]["name"]] = [obj["duration"]]
     
df = pd.DataFrame(data)
print(df.to_string(index=False))

answered Dec 31, 2021 at 4:15

Tyler Liu

1,0791 gold badge7 silver badges7 bronze badges

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

Comments

Muhammad Hassan · Accepted Answer · 2021-12-31 04:21:15Z

1

Use:

df = pd.json_normalize(l)
df = df.set_index('phase.name').T.reset_index(drop=True)

OUTPUT

phase.name  Start form  Análise do SAC - Mesas  Análise do SAC - Industrial
0                    0                     441                       126057

If want to rename axis you can then use:

df.rename_axis(None, axis=1, inplace=True)

OUTPUT

   Start form  Análise do SAC - Mesas  Análise do SAC - Industrial
0           0                     441                       126057

edited Dec 31, 2021 at 4:21

answered Dec 31, 2021 at 4:15

Muhammad Hassan

4,2492 gold badges17 silver badges30 bronze badges

Collectives™ on Stack Overflow

Iterating list to create df

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related