Using JSON Data in Python

Breaking string data into dictionary object and viceversa using json library

data='{"bookno":"1234","title":"C Programming","author":"Dr B P Sharma","price":"340"}'
import json
# converting string to dictionary object
b=json.loads(data)
print(b['bookno'])

# converting a dictionary in string
json.dumps(b)

Working with Single JSON Record 

Create a JSON file as book.json and place the following record into that file

{"bookno":"1234","title":"C Programming","author":"Dr B P Sharma","price":"340"}

Create Python File to read the data as readbook.py

import json
f=open("book.json")
data=f.read()
d=json.loads(data)
for k,v in d.items():
    print(k,"=",v)

Output

bookno = 1234
title = C Programming
author = Dr B P Sharma
price = 340

Working with Multiple JSON Records of single category

Create a JSON file as books.json and place the following records in that file

{
"books": [{
"bookno": "1234",
"title": "Java",
"author": "Gosling",
"price": "900"
},
{
"bookno": "1235",
"title": "PHP",
"author": "Rohit",
"price": "300"
},
{
"bookno": "1236",
"title": "Oracle",
"author": "Sanjay",
"price": "400"
}
]
}


import json
f=open("books.json")
data=f.read()
d=json.loads(data)
i=1
for k in d.keys():
    records=d[k]
    print("Record of",k.upper());
    for r in records:
        print("Record #{}".format(i))
        for k,v in r.items():
            print(k,"=",v)
        i=i+1
Output

Record of BOOKS
Record #1
bookno = 1234
title = Java
author = Gosling
price = 900
Record #2
bookno = 1235
title = PHP
author = Rohit
price = 300
Record #3
bookno = 1236
title = Oracle
author = Sanjay
price = 400         

Another Case

import json
f=open("books.json")
data=f.read()
d=json.loads(data)
books=d["books"]
for b in books:
    print(b["bookno"],b["title"],b["author"],b["price"])


Output
1234 Java Gosling 900
1235 PHP Rohit 300
1236 Oracle Sanjay 400

Working with Multiple JSON Records of Multiple categories

Create a JSON file as library.json and place the following records in that file

{
"books": [{
"bookno": "1234",
"title": "Java",
"author": "Gosling",
"price": "900"
},
{
"bookno": "1235",
"title": "PHP",
"author": "Rohit",
"price": "300"
},
{
"bookno": "1236",
"title": "Oracle",
"author": "Sanjay",
"price": "400"
}
],
"students": [{
"rollno": "1001",
"name": "Rohit",
"course": "MCA"
},
{
"rollno": "1002",
"name": "Karan",
"course": "MBA"
}
],
"faculties": [{
"empid": "A001",
"name": "Sanjay Kumar"
},
{
"empid": "A002",
"name": "Ruchi Verma"
},
{
"empid": "A003",
"name": "Kanchan"
},
{
"empid": "A004",
"name": "Garima"
}
]
}

Create Python File to read the data as readlibrary.py
    
import json
f=open("library.json")
data=f.read()
d=json.loads(data)
for k in d.keys():
    records=d[k]
    i=1
    print("Record of",k.upper());
    for r in records:
        print("Record #{}".format(i))
        for k,v in r.items():
            print(k,"=",v)
        i=i+1
            
Output

Record of BOOKS
Record #1
bookno = 1234
title = Java
author = Gosling
price = 900
Record #2
bookno = 1235
title = PHP
author = Rohit
price = 300
Record #3
bookno = 1236
title = Oracle
author = Sanjay
price = 400
Record of STUDENTS
Record #1
rollno = 1001
name = Rohit
course = MCA
Record #2
rollno = 1002
name = Karan
course = MBA
Record of FACULTIES
Record #1
empid = A001
name = Sanjay Kumar
Record #2
empid = A002
name = Ruchi Verma
Record #3
empid = A003
name = Kanchan
Record #4
empid = A004
name = Garima

Comments

Post a Comment

Popular posts from this blog

Converting Excel File to JSON File using xlrd module

from xlrd import open_workbook import json import os os.chdir("d:/2018/mayank") book = open_workbook('demo.xlsx') sheet = book.sheet_by_index(0) # read header values into the list keys = [sheet.cell(0, col_index).value for col_index in range(sheet.ncols)] print ("keys are", keys) dict_list = [] for row_index in range(1, sheet.nrows):     d = {keys[col_index]: sheet.cell(row_index, col_index).value          for col_index in range(sheet.ncols)}     dict_list.append(d) j = json.dumps(dict_list) with open('data.json', 'w') as f:     f.write(j)
Read more

Using Oracle with Python

Install the module     pip install cx_Oracle Import the module     import cx_Oracle Establish the connection     cn = cx_Oracle.connect('userid/password@servername') #rest commands are same as MySQL
Read more

Using time module

The time module provides the current date and time using time() function The time.time() returns the number of second elapsed from 1/1/1970 12:00 am till current date and time called as ticks >>> import time >>> time.time() 1522211915.914467 We can also convert these ticks into actual date and time using function time.localtime() >>> time.localtime(time.time()) time.struct_time(tm_year=2018, tm_mon=3, tm_mday=28, tm_hour=10, tm_min=10, tm_sec=0, tm_wday=2, tm_yday=87, tm_isdst=0) It returns a structure having different fields for date and time which we can convert into date or time format >>> t=time.localtime(time.time()) >>> currentdate='%02d-%02d-%d' % (t.tm_mday,t.tm_mon,t.tm_year) >>> currentdate '28-03-2018' >>> currenttime='%02d-%02d-%02d' % (t.tm_hour,t.tm_min,t.tm_sec) >>> currenttime '10-12-05' We can also use this structure inside the functions and ...
Read more