unable to convert groupby dataset to json in pandas

Question

I have group by data set but I'm unable to convert it to json. It throws out json with a bad format. TO_excel works fine.

Country Sub amount        
        3   source4      
UK      1   source3      
        1   source1      
US      2   source2

How can I export groupby dataset to_json?

Would you mind describing your expected output? Also, print `df.head(5).to_dict()` here please. — cs95, Apr 20 '18 at 11:19
@jezrael PLease type this- **df = df.reset_index()** as the answer. I'll accept it now! — jason, Apr 20 '18 at 11:19

score 2 · Accepted Answer · answered Apr 20 '18 at 11:20

2

There is problem you have MultiIndex in DataFrame, so need reset_index:

j = df.reset_index().to_json()
print (j)
{"Country":{"0":"UK","1":"UK","2":"US"},
 "Sub":{"0":1,"1":1,"2":2},
 "amount":{"0":"source3","1":"source1","2":"source2"}}

answered Apr 20 '18 at 11:20

jezrael

822,522
95
1,334
1,252

1

Awesome! THanks J :) – jason Apr 20 '18 at 11:39

unable to convert groupby dataset to json in pandas

1 Answers1