Pandas read_json - Stop convert index to datetime

Question

I have the below data in a a.json file.

{
  "1000000000": {
    "TEST": 2
  }
}

import pandas as pd
df = pd.read_json(r"a.json", dtype= str, orient='index', convert_dates=False)
print(df)

Getting output as :

                TEST
2001-09-09 01:46:40    2

Expected :

                TEST
1000000000         2

Abhik Sarkar · Accepted Answer · 2020-07-17 05:24:53Z

9

You need parameter convert_axes=False in read_json:

You can use it like this

import pandas as pd
df = pd.read_json("a.json", dtype= str, orient='index',convert_axes=False ,convert_dates=False)
print(df)

answered Jul 17, 2020 at 5:24

Abhik Sarkar

9754 gold badges13 silver badges33 bronze badges

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

1 Answer 1