Question

Rohit, a student of class 12^th, is learning CSV File Module in Python. During examination, he has been assigned an incomplete python code (shown below) to create a CSV File 'Student.csv' (content shown below). Help him in completing the code which creates the desired CSV File. 

CSV File 

1,AKSHAY,XII,A 

2,ABHISHEK,XII,A 

3,ARVIND,XII,A 

4,RAVI,XII,A 

5,ASHISH,XII,A

Incomplete Code 

import_____ #Statement-1 

fh = open(_____, _____, newline='') #Statement-2 

stuwriter = csv._____ #Statement-3 

data = [] 

header = ['ROLL_NO', 'NAME', 'CLASS', 'SECTION'] 

data.append(header) for i in range(5):

roll_no = int(input("Enter Roll Number : ")) 

name = input("Enter Name : ") 

Class = input("Enter Class : ") 

section = input("Enter Section : ") 

rec = [_____]      #Statement-4 

data.append(rec) stuwriter. _____ (data)      #Statement-5

fh.close()

i. Identify the suitable code for blank space in line marked as Statement-1. 

a) csv file 

b) CSV 

c) csv 

d) Csv 

ii. Identify the missing code for blank space in line marked as Statement-2? 

a) "School.csv","w" 

b) "Student.csv","w" 

c) "Student.csv","r" 

d) "School.csv","r" 

"Student.csv","w" 

iii. Choose the function name (with argument) that should be used in the blank space of line marked as Statement-3 

a) reader(fh) 

b) reader(MyFile) 

c) writer(fh) 

d) writer(MyFile)

iv. Identify the suitable code for blank space in line marked as Statement-4. 

a) 'ROLL_NO', 'NAME', 'CLASS', 'SECTION' 

b) ROLL_NO, NAME, CLASS, SECTION 

c) 'roll_no','name','Class','section' 

d) roll_no,name,Class,sectionc) co.connect()

v. Choose the function name that should be used in the blank space of line marked as Statement-5 to create the desired CSV File? 

a) dump() 

b) load() 

c) writerows() 

d) writerow()

Answer 1

1. Correct Answer : c) csv

2. Correct Answer : b) "Student.csv","w"

3. Correct Answer : c) writer(fh)

4. Correct Answer : d) roll_no,name,Class,section

5. Correct Answer : c) writerows()