1 Letter is prefixed to store string in binary form

Ans b
2 Write a Python statement to open a text file “DATA.TXT” in binary mode so
that new contents can be written on it.
Ans f = open('DATA.TXT','wb')
3 Write a Python statement to open a text file “DATA.TXT” in binary mode so that
new content can be added to the end of file
Ans f = open('DATA.TXT','ab')
4 Write a Python statement to open a text file “DATA.TXT” in binary mode so
that existing contents can be read from file.
Ans f = open('DATA.TXT','rb')
5 function is used to convert string in binary form.
Ans encode()
6 Consider the following Python code, and fill in the blank to complete the
program
f=open("India.txt","wb")
str="India is my country"
f. (str.encode()) # statement to store the str in
file f.close()

Ans f.write(str.encode())
7 function is used to fetch binary data from binary file
Ans
8 function is used to convert binary string to string
Ans read() and load()
9 function is used in binary mode to send the read pointer to desired
position
Ans seek()
Note: seek() function of file object is used to reposition the cursor Syntax :
seek(number of bytes to read, seek_direction)
Seek_direction can be 0 – beginning, 1 – current position , 2- from last (can be in
negative also for backward traversing)

10 Consider a binary file which stores Name of employee, where each name
occupies 20 bytes (length of each name) in file irrespective of actual characters.
Now you have to write code to access the first name, 5th name and last name.

f = open("Emp.txt","rb")
s = #code to get first record print(s.decode())
# code to position at 5th record s = f.read(size)
print(s.decode())
# code to position at last record s = f.read(20)
print(s.decode()) f.close()
Ans f.read(20) f.seek((5-1)*20)
f.read(((os.path.getsize(„Emp.txt‟)/20)-1)
11 Write a Python statement to reposition the read pointer to 20 bytes back from
the current position.
f = open("Emp.txt","rb") f.read(20)
f.read(20) f.read(20)
 f. # reposition read pointer to previous record
f.close()
Ans f.seek(-20,1)
12 Write a function RECCOUNT() to read the content of binary file „NAMES.DAT‟
and display number of records ( each name occupies 20 bytes in file ) in it.
For. e.g. if the content of file is: SACHIN
AMIT AMAN SUSHIL DEEPAK
HARI SHANKER
Function should display
Total Records are 6
Ans import os
def RECCOUNT():
size_of_rec = 20 #Each name will occupy 20 bytes file_len =
os.path.getsize('Names.dat')
num_record = file_len/size_of_rec print("Total Records are :",num_record)
13 Write a function SCOUNT() to read the content of binary file „NAMES.DAT‟ and
display number of records (each name occupies 20 bytes in file ) where name
begins from „S‟ in it.
For. e.g. if the content of file is: SACHIN
AMIT AMAN SUSHIL DEEPAK
HARI SHANKER
Function should display
Total Names beginning from „S‟ are 2
Ans def SCOUNT(): s=' '
count=0
with open('Names.dat','rb') as f: while(s):
s = f.read(20) s=s.decode() if len(s)!=0:
if s[0].lower()=='s':
count+=1
print('Total names beginning from "S" are ',count)
14 To read and write collections like LIST, DICTIONARIES Python provides a
module
called
Ans pickle
15 is the process of converting structures to byte stream before writing to
file.
Ans Pickling
16 is the process of converting byte stream to original structure.
Ans Unpickling
17 Pickling is done by the function
Ans dump()
18 Unpickling is done by the function
Ans load()
19 Consider the following Python code and complete the missing statement:

import pickle
myfile = open("test.dat","wb") d={1:100,2:200,3:300}
#statement to store dictionary d in file
myfile.close()
Ans pickle.dump(d,myfile)
20 Consider the following Python code and complete the missing statement:
import pickle
 myfile = open("test.dat","rb")
d= #statement to load dictionary data from file to „d‟ print(d)
myfile.close()
Ans pickle.load(myfile)
21 Python‟s standard streams are , ,
Ans stdin, stdout, stderr
22 Python‟s standard streams are available in module
Ans sys
23 From the given path identify the type of each:
(i) C:\mydata\web\resources\img.jpg
(ii) ..\web\data.conf
Ans (i) Absolute
(ii) Relative
24 Consider the following Binary file „Emp.txt‟, Write a function RECSHOW() to
display only those records who are earning more than 7000

Ans import pickle def RECSHOW():

emp=[]
f = open('employee.dat','rb') while True:
try:
emp = pickle.load(f) # loading data in emp list except EOFError:
break
print("%10s"%"EMP NO ","%20s"%"EMP NAME ","%10s"%"EMP SALARY")
print("*****************************************************") for e in emp:
if (e[2]>7000):
print("%10s"%e[0],"%20s"%e[1],"%10s"%e[2])
found=True

if found==False:
print("## SORRY EMPLOYEE NUMBER NOT FOUND ##")
f.close()
24 CSV stands for
Ans Comma Separate Value
25 object is used to read data from csv file?
Ans reader
26 object is used to perform write operation on csv file.
Ans writer
27 function of writer object is used to send data to csv file to store.
Ans writerow()
28 Consider the following CSV file (emp.csv):
1,Peter,3500 2,Scott,4000 3,Harry,5000 4,Michael,2500 5,Sam,4200

Write Python function DISPEMP() to read the content of file emp.csv and display
only those records where salary is 4000 or above
Ans import csv
def DISPEMP():
with open('emp.csv') as csvfile:
myreader = csv.reader(csvfile,delimiter=',')
print("%10s"%"EMPNO","%20s"%"EMP NAME","%10s"%"SALARY")
print("=============================================
=====")
 for row in myreader:
if int(row[2])>4000:
print("%10s"%row[0],"%20s"%row[1],"%10s"%row[2])
29 Consider the following CSV file (emp.csv):
1,Peter,3500 2,Scott,4000 3,Harry,5000 4,Michael,2500 5,Sam,4200

Write a Python function DISPEMP() to read the content of file emp.csv and count
how many employee are earning less than 5000
Ans import csv
def DISPEMP():
with open('emp.csv') as csvfile:
myreader = csv.reader(csvfile,delimiter=',') count=0
print("%10s"%"EMPNO","%20s"%"EMP NAME","%10s"%"SALARY")
print("=============================================
=====")
for row in myreader:
if int(row[2])<5000:
count+=1
print("=============================================
=====") print("%40s"%"#EMPLOYEE GETTING SALARY <5000 :",count)
print("=============================================
=====")
30 Consider the following CSV file (emp.csv):
1,Peter,3500 2,Scott,4000 3,Harry,5000 4,Michael,2500 5,Sam,4200

Write a Python function SNAMES() to read the content of file emp.csv and
display the employee record whose name begins from „S‟ also show no. of
employee with first letter „S‟ out of total record.
Output should be: 2,Scott,4000 5,Sam,4200
Number of „S‟ names are 2/5
Ans import csv
def SNAMES():
with open('emp.csv') as csvfile:
myreader = csv.reader(csvfile,delimiter=',') count_rec=0
count_s=0
for row in myreader:
if row[1][0].lower()=='s': print(row[0],',',row[1],',',row[2]) count_s+=1
count_rec+=1
print("Number of 'S' names are ",count_s,"/",count_rec)
31 Write a python function CSVCOPY() to take sourcefile, targetfile as parameter
and create a targetfile and copy the contents of sourcefile to targetfile
Ans import csv
def CSVCOPY(sourcefile,targetfile): with open(sourcefile) as csvfile:
f2 = open(targetfile,'w') mywriter=csv.writer(f2,delimiter=',') myreader =
csv.reader(csvfile,delimiter=',') for row in myreader:
mywriter.writerow([row[0],row[1],row[2]])
f2.close()