Using pandas with json normalize

Question

I am trying to normalize a very simple JSON structure.

data = [{"pedido": {"situacao": "OK", ....}}, {"pedido": {"situacao": "NOK", ...}}]
rs = json_normalize(data, 'pedido', [['pedido', 'situacao']])

I would like to get just the index and another column called pedido.situacao. There is a bunch of other field on json but I want to get only situacao:

0 pedido.situacao
0  situacao              OK
1  situacao             NOK

It seens there is a extra column with "0"as label.

BENY · Accepted Answer · 2020-06-21 01:15:07Z

1

We can do

df=pd.concat(pd.DataFrame(x) for x in data)
         pedido
situacao     OK
situacao    NOK

Update

df=pd.concat([pd.DataFrame(x) for x in data],keys=range(len(data))).unstack(level=1)
df.columns=df.columns.map('.'.join)
df
  pedido.situacao
0              OK
1             NOK

edited Jun 21, 2020 at 1:15

answered Jun 21, 2020 at 1:11

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

p.magalhaes Over a year ago

I want only a single column called pedido.situacao

NYC Coder · Accepted Answer · 2020-06-21 02:53:38Z

0

You can just do this:

rs = pd.json_normalize(data)
print(rs[['pedido.situacao']])

  pedido.situacao
0              OK
1             NOK

answered Jun 21, 2020 at 2:53

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges

Collectives™ on Stack Overflow

Using pandas with json normalize

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related