Python Pandas How to read json without sorting by the index?

Question

If i have a json file like this, and import it to dataframe, the column order is always sort -0.8, -0.9. i want the order maintain as it is defined in the json which is -0.9, -0.8

{
    "-0.90": {
        "A": 1.0,
        "B": 0.4935585804
    },
    "-0.80": {
        "A": 1.0,
        "B": 0.4935585804
    }
}

maxymoo · Accepted Answer · 2016-10-24 03:14:21Z

2

You can load load your json data as an OrderedDict to preserve the order of the keys, and then use the DataFrame.from_dict constructor:

import json
from collections import OrderedDict

s = """{
    "-0.90": {
        "A": 1.0,
        "B": 0.4935585804
    },
    "-0.80": {
        "A": 1.0,
        "B": 0.4935585804
    }
}"""

data = json.loads(s, object_pairs_hook=OrderedDict)
pd.DataFrame.from_dict(data)

      -0.90     -0.80
A  1.000000  1.000000
B  0.493559  0.493559

answered Oct 24, 2016 at 3:14

maxymoo

36.7k12 gold badges97 silver badges121 bronze badges

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

Collectives™ on Stack Overflow

Python Pandas How to read json without sorting by the index?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related