Python | Sort JSON by value

# Python code to demonstrate JSON sorting.

import json

data = & # 39; & # 39; & # 39; {

& quot; Student & quot;: [

{

& quot; Enrollment_no & quot ;: & quot; 9915103000 & quot ;,

& quot; Title & quot ;: & quot; JIIT & quot ;,

& quot; subject & quot;: [

{

  "Code": "DBMS",

& quot; Class & quot ;: & quot; C & quot;

  }

]

< code class = "comments">},

{

& quot; Enrollment_no & quot ;: & quot; 8815103057 & quot ;,

  & quot; Title & quot ;: & quot; JSS & quot ;,

  & quot; subject & quot;: [

{

& quot; Code & quot ;: & quot; COA & quot ;,

& quot; excellent grade & quot;

},

{

& quot; Code & quot ;: & quot; CN & quot ;,

& quot; Class & quot ;: & quot; A + & quot;

}

]

}

  ]

} & # 39; & # 39;"

 
# Parse the Json object

json_parse = json.loads (data)

 
# repeat

for it in json_parse [ ’Student’ ]:

< code class = "undefined spaces">  for y in it [ ’subject’ ]:

print (y [ ’code’ ], y [ ’ grade’ ], it [ ’enrollment_no’ ], it [ ’ name’ ])

 from pandas.io.json import json_normalize

df = json_normalize (json_parse [ ’Student’ ],

’subject’ , 

[ ’enrollment_no’ , ’name’ ])

df.sort_values ​​([ ’code’ , ’grade’ , ’ enrollment_no’ ]). .reset_index (drop = True )