Pandas DataFrame Combine Certain Columns in Nested JSON

Question

Let's say you have a pandas DataFrame that looks like this:

A1a  A1b   A2a    A2b   …   B1a …
0.25 0.75  0.10   0.5       1   
…    …     …      …         …

And you want to output a JSON list of objects (one object for each row) that looks like this:

What's the best way to do this?

There are obviously a lot of pandas/nested JSON questions on here, but I think this is different because I'm trying to nest specific columns within the same row, rather than grouping rows that have the same values in columns (like in this example).

BENY · Accepted Answer · 2018-06-15 14:14:16Z

2

Since you link the page , I will borrow the recur_dictify function from the accepted answer in that link

#make your df columns become multiple index 
df.columns=pd.MultiIndex.from_tuples(df.columns.map(list).map(tuple))

      A
      1          2
      a     b    a    b
0  0.25  0.75  0.1  0.5

#Then we apply the function
recur_dictify(df.T.reset_index())

{'A': {'1': {'a': 0.25, 'b': 0.75}, '2': {'a': 0.1, 'b': 0.5}}}

answered Jun 15, 2018 at 14:14

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

user3483203 Over a year ago

This is really clean, very nice!

Collectives™ on Stack Overflow

Pandas DataFrame Combine Certain Columns in Nested JSON

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related