Skip to main content

Python : reading json data in python


The below program shows how to read a json file and pull the data element for it in python. We make use json library for this.
#!/usr/bin/python

import json

def get_id():
  file = open("/home/python/json/js.json","r")
  json_file = file.read()
  parse_json = json.loads(json_file)
  a = parse_json['purchase'][0]['order_id']
  print a

get_id()

#output : 1234

Sample json file

{
   "store" : "New York",
 
   "purchase" :
   [
   {
      "order_id" : "1234",
      "customer" : "regular",  
      "amount" : "$123.45"
   }
   ]
}

Comments

Popular posts from this blog

UNIX : How to get record count from zipped file

Sometimes we may need to get records count from file . For that we can use wc -l , command with file name. In some situation the file will be in compressed format . wc -l will not directly work with zipped files . In this case we can do zcat the file and pipe the word count command with it. Example : Let say we have a file cricketData.dat.gz To get word count from the file use : zcat cricketData.dat.gz | wc -l This will give the record count.

Excel : How to pad zeros

Today I got a requirement to format the number in excel cell - to left pad number with zeros.i find the following function very useful to do it. In case one to make the number left padded with "0" s give the formula =TEXT(A1,"0000") In case two even more enhanced form to make it left padded with "0" and add two decimal places give the formula as =TEXT(A2,"0000.00")

Scala

Scala is a object oriented functional type programing language. All variables declared in scala is considered as objects.