Pandas to read JSON

[desaiyang]

import pandas as pd

data = pd.read_json('path/input.json')
print (data)

[desaiyang]

save this as input.json

{ 
   "ID":["1","2","3","4","5","6","7","8" ],
   "Name":["Guna1","Sekar2","Guna3","Guna4","Guna5","Sekar6","Guna8","Guna9" ],
   "Salary":["623.3","515.2","611","729","843.25","578","632.8","722.5" ],   
   "StartDate":[ "1/1/2057","9/23/2074","11/15/2087","5/11/2094","3/27/3015","5/21/6013",
      "7/30/2013","6/17/2014"],
   "Dept":[ "DevOps","Finance","IT","HR","Finance","IT","Operations","HR"]
}

[desaiyang]

save this as read-json.py

import pandas as pd

data = pd.read_json('c:\devops\python\simple\input.json')
print (data)