CSV File MCQ Question Bank For Class 12
1. To open a file c:\scores.csv for reading, we use _______ command.
a) infile = open(“c:\scores.csv”, “r”)
b) infile = open(“c:\\scores.csv”, “r”)
c) infile = open(file = “c:\scores.csv”, “r”)
d) infile = open(file = “c:\\scores.csv”, “r”)
2. State True/False :
(i) The csv files are Binary Files:
a) True
b) False
3. Which of the following statement(s) are true for csv files?
a) When you open a file for reading, if the file does not exist, an error occurs
b) When you open a file for writing, if the file does not exist, a new file is created
c) When you open a file for writing, if the file exists, the existing file is overwritten with the new file
d) All the above
4. To read the entire content of the CSV file as a nested list from a file object infile, we use __________ command.
(a) infile.read()
(b) infile.reader()
(c) csv.reader(infile)
(d) infile.readlines()
5. State True/False :
The separator character of csv files is called delimiter.
a) True
b) False
6. The full form of CSV is
a) Comma Separated Values
b) Comma Separated Value
c) Comma Separated Variables
d) Comma Separate Values
7. State True/False:
The CSV files only take comma as delimiter.
a) True
b) False
8. EOL character used in windows operating system in CSV file is
a) \r
b) \n
c) \r\n
d) \0
9. The CSV files are popular because they are
a) capable of storing large amount of data
b) easier to create
c) preferred export and import format for databases and spread sheets
d) All the above
10. The default delimiter character of CSV file is____.
a) : (colon)
b)\t (tab)
c) , (comma)
d) ; (semi-colon)
11. State True/False:
A CSV file is open in the same way as text file.
a) True
b) False
12. Which of the following is not a valid mode to open CSV file?
a) a
b) w
c) ab
d) r
13. The file mode to open a CSV file for appending as well as reading is _____.
a) a+
b) w+
c) r+
d) All the above.
14. The file mode to open a CSV file for reading as well as writing is _____.
a) a+
b) w+
c) r+
d) All the above.
15. The CSV files are ____ files.
a) Text
b) Binary
c) Data
d) Python
CSV file: import csv module, open / close csv file, write into a csv file using csv.writerow() and read from a csv file using csv.reader( )
16. The character that separates values in csv files is called the ………
a) delimit
b) delimiter
c) delimited
d) delimits
17. The default delimiter of csv file is ……………
a) comma
b) colon
c) semicolon
d) hyphen
18. The file mode to open a csv file for reading as well writing is ………
a) r
b) rw
c) r+
d) rb
19. The file mode to open a csv file for appending as well reading is ……..
a) w
b) w+
c) a
d) a+
20. To specify a different delimiter while writing into csv file, ……. argument is used with csv.writer().
a) delimit
b) delimiter
c) delimited
d) delimits
21. To cancel the EOL translation in csv file while writing the data ………… argument is used with open().
a) newline
b) next
c) open
d) EOL
22. To add data to an existing csv file, the mode of the file should be ……..
a) w
b) w+
c) a
d) a+
23. CSV stands for …….
a) Cursor Separated Variables
b) Comma Separated Values
c) Cursor Separated Values
d) Cursor Separated Version
24. Which module is used for working with CSV files in Python?
a) random
b) statistics
c) csv
d) math
25. Every record in a CSV file is stored in reader object in the form of a list using which method?
a) writer()
b) append()
c) reader()
d) list()
CASE STUDY QUESTIONS (R)
26. Deepesh works as a programmer with Delta Technologies. He has been assigned the job of generating the salary of all employees using the file “employee.csv”. He has written a program to read the CSV file “employee.csv” which will contain details of all the employees. He has written the following code. As a programmer, help him to successfully execute the given task.
import______ # Line 1
def readCsvEmp( ): # to read data from the CSV file
with ______(’employees.csv’, newline=”) as f: # Line 2
reader = csv.______ (f) # Line 3
data_list = ______(reader) # Line 4
______ (data_list) # Line 5
(i) Name the module he should import in Line 1.
a) import csv
b) csv import
c) import
d) export csv
(ii) Write the method that he should use to open the file to read data from it.
a) read
b) open
c) close
d) append
(iii) Fill in the blank in Line 3 to read the data from a csv file.
a) read
b) readline
c) reader
d) writer
(iv) Fill in the blank in Line 4 with the method to convert the data read from the file into list.
a) list
b) sets
c) dictionary
d) tuple
27. Observe the following code and fill the blank in statement1
import csv
with _________ as f: #statement1
r = csv.______(f) #statement2
for row in ______: #statement3
print(_____) #statement4
a) open(“data.csv”)
b) f=open(“data.csv”)
c) Both A & B are Correct
d) Both A & B are incorrect
28. Observe the following code and fill the blank in statement2
import csv
with _________ as f: #statement1
r = csv.______(f) #statement2
for row in ______: #statement3
print(_____) #statement4
a) load
b) read()
c) reader()
d) readlines()
29. Observe the following code and fill the blank in statement3
import csv
with _________ as f: #statement1
r = csv.______(f) #statement2
for row in ______: #statement3
print(_____) #statement4
a) F
b) r
c) r,f
d) None of the above
30. Observe the following code and fill the blank in statement4
import csv
with _________ as f: #statement1
r = csv.______(f) #statement2
for row in ______: #statement3
print(_____) #statement4
a) r
b) row
c) f
d) csv
31. Legend sports wanted to store the number of prizes for each sport as a SPORTS.CSV file. As a programmer help them to complete the task successfully.
import _______________ #Line 1
fh=___________________ # Line 2
swriter = ______________(fh) #Line 3
ans=‟y‟
i=1
while ans==‟y‟:
print(“Record”,i)
sport=input(“Sport name”)
prizes=int(input(“Enter prizes won”))
__________ # Line 4
i=i+1
ans=input(“Want to enter records”)
fh._________________#Line 5
(i) Name the module to be imported in Line 1.
a) .tsv
b) .csv
c) .py
d) .bin
(ii) Fill in line 2 to open the CSV file.
a) fh = open(“sports.csv”,”w”)
b) fh=read(“sports.csv”,”w”)
c) fh = file(“sports.csv”,”w”)
d) fh = append(“sports.csv”,”w”)
(iii) Write the correct statement to write the data into file in line 3.
a) writerows( )
b) writerow( )
c) writer( )
d) swriter = csv.csvwriter(fh)
(iv) Write the statement to write the records given as input from user in line 4.
a) swriter([sport,prizes])
b) swriter.writrrow([sport,prizes])
c) swriter_writrrow([sport,prizes])
d) swriterwritrrow([sport,prizes])
32. Krishna of class 12 is writing a program to read the details of Sports performance and store in the csv file “Sports.csv” delimited with a tab character. As a programmer, help him to achieve the task.
import ___________ # Line 1
f = open(“Sports.csv”,”a”)
wobj = csv.______________ (f, delimiter = „\t‟) # Line 2
wobj.writerow( [„Sport‟, „Competitions‟, „Prizes Won‟] )
ans = „y‟
i = 1
while ans == „y‟:
print(“Record :”, i)
sport = input(“Sport Name :”)
comp = int(input(“No. of competitions participated :”))
prize = int(input(“Prizes won:”))
record = ____________________ # Line 3
wobj.______________ (rec) # Line 4
i += 1
ans = input(“Do u want to continue ? (y/n) :”)
f.___________ # Line 5
(i) Name the module he should import in Line 1
a) .tcs
b) .tmp
c) .bin
d) .csv
(ii) To create an object to enable to write in the csv file in Line 2
a) open
b) writer
c) file
d) read
(iii) To create a sequence of user data in Line 3
a) [prize,comp,sport]
b) [comp,prize,sport]
c) [sport, comp, prize]
d) none of the above
(iv) To write a record onto the writer object in Line 4
a) write
b) writerow
c) writeline
d) writelines
33. Kumar is writing a program to create a CSV file “student.csv” which will contain rollno, name and age of some students. He has written the following code. As a programmer, help him to successfully execute the given task
import ________________ # Line 1
f=open(‘student.csv’,’w’,newline=””)
p=csv._________(f) # Line 2
ch=’y’
while ch==’y’:
l=[]
rollno=int(input(‘enter rollno’))
name=input(‘enter name’)
age=int(input(‘enter age’))
l.append(rollno)
l.append(name)
l.append(age)
p.___________(l) # Line 3
ch = input (‘want to continue y/n?’)
if ch==’y’:
continue
else:
break
f.__________()
f=open(‘student.csv’,’r+’)
c=list(csv.reader(f))
for i in c:
k=i[2]
if int(k)>15:
print(i)
f.close()
(i) Name the module he should import in Line 1
a) import csv
b) csv import
c) import
d) export csv
(ii) which function is used in Line 2 to create a writer object
a) p=tsv.writer(f)
b) p=psv.writer(f)
c) p=csv.writer(f)
d) p=dsv.writer(f)
(iii) The method which is to be used in line 3 to writes a row of data into the specified file
a) p.writerow(l)
b) p.writerows(l)
c) p.writer()
d) p.writerow(l)
(iv) Fill in the blank in Line 4 to close the file.
a) f.close()
b) f.open()
c) close.f()
d) f.read()
34. Puneeta is storing the data of her gift store in a csv file named gift.csv which will store Gift_code and Gift_name of items of her gift store. She has written the following code .As a programmer help her to successfully execute her program in python:
import ___________ # Line 1
def writeFile(Gift_code,Gift_name):
F=open(“gift.csv”,‟___‟) #Line 2
FW=csv.________(F) #Line 3
FW.writerow([Gift_code,Gift_name)
F.close()
#CSV file for reading
def readFile():
with ________(„gift.csv‟,‟r‟) as newF #Line 4
FR=csv.reader(newF)
for row in FR:
if row[0]==101:
print(row)
newF.close()
writeFile(101,”Photoframe”)
writeFile(102,”Soft Toys”)
writeFile(103,”Flower Pot”)
readFile() #Line 5
(i) Name the module she should import in line 1.
a) .tmp
b) .bin
c) .tsc
d) .csv
(ii) In which mode Puneeta should open the file to add data in it?
a) “a”
b) “ab”
c) “r”
d) “w”
(iii) Fill in the blanks in Line 3 to write data to csv file gift.csv
a) close()
b) open()
c) writer()
d) append()
(iv) Fill in the blank in Line 4 to open the csv file from the disk
a) close
b) open
c) write
d) read
35. What is the output of the following program?
import csv
d=csv.reader(open(‘c:\PYPRG\ch13\city.csv’))
next(d)
for row in d:
print(row)
if the file called “city.csv” contain the following details chennai,mylapore mumbai,andheri
a) Chennai,mylapore
b) mumbai,andheri
c) chennai,mumba
d) chennai,mylapore mumbai,andheri
| #TRENDING | |
Text File MCQs for Class 12 Term 1Binary File MCQs for Class 12 Term 1 |
|
CSV Case Study Based Questions
36. Sonal, a student of class 12th, is learning CSV File Module in Python. During examination, she has been assigned an incomplete python code (shown below) to create a CSV file ‘Customer.csv’ (content shown below). Help her in completing the code which creates the desired CSV file.
| Cus_No | Name | Address | Ph_No |
| 11 | Rohit | Mumbai | 8567843243 |
| 12 | Sonal | Delhi | 9645342345 |
Incomplete Code
______ csv #Statement 1
def Create_CSV():
fw=open("Customer.csv","w")
_______=csv.writer(fw) #Statement 2
Cuswriter.writerow(["Cus_No","Name","Address","Ph_No"])
n=int(input("Enter total number of Customer"))
for i in range(n):
Cusno=int(input("Enter Customer no."))
Name=input("Enter Name")
Add=input("Enter Address")
Ph_No=int(input("Enter Phone No."))
Rec=[Cusno,Name,Add,Ph_No]
Cuswriter.writerow(____) #Statement 3
fw.close()
def Display_CSV():
fr=open("__________","r") #Statement 4
Cusreader=csv.reader(fr)
i=0
for ____ in Cusreader: #Statement 5
if i%2==0:
print(rec[0],'\t',rec[1],'\t',rec[2],'\t',rec[3])
else:
pass
i+=1
fr.close()
Create_CSV()
Display_CSV()
(i) Identify suitable code for the blank space in line marked as Statement-1.
a) include
b) add
c) Import
d) import
(ii) Identify the missing code for the blank space in line marked as Statement-2.
a) Customer
b) reader
c) Cuswriter
d) writer
(iii) Identify the argument name for the blank space in line marked as Statement-3?
a) Row
b) Rec
c) row
d) rec
(iv) Identify the missing file name for the blank space in line marked as Statement-4?
a) Customer
b) Customer.csv
c) Customer.txt
d) Customer.dat
(v) Identify the object name for the blank space in line marked as Statement-5?
a) i
b) Rec
c) row
d) rec
37. Mohan has written following program to create a CSV file “File_extent.csv” which will contain file types and file extensions for some records. As a programmer, help him to successfully execute the given task:
import ______ # Statement 1
def adddata(filetype,extension): # To write /add data into the file
f=open(______,_____,newline='') # Statement 2
newFileWriter = csv.writer(f)
newFileWriter.writerow([filetype,extension])
f.close()
#Csv file reading code
def readdata(filename): # To read data
with open(filename,'r') as f:
filereader = csv.______(f) # Statement 3
for row in filereader:
print (row[0],row[1])
f._______ # Statement 4
adddata("Notepad","txt")
adddata("Word","docx")
adddata("Excel","xlsx")
adddata("PowerPoint","pptx")
readdata("________") #Statement 5
(i) Identify the module he should import for Statement 1.
a) math
b) csv
c) pickle
d) random
(ii) Choose the correct option for Statement 2 to open file name and mode. (Suresh should open the file to add data into the file)
a) “File_extent.csv”,”r”
b) “File_extent.csv”,”w”
c) “File_extent.csv”,”a”
d) “File_extent.csv”,”w+”
(iii) Choose the correct option for Statement 3 to read the data from a csv file.
a) read()
b) readline()
c) load()
d) reader
(iv) Choose the correct option for Statement 4 to close the file.
a) end()
b) close()
c) close
d) from
(v) Choose the correct option for Statement 5 to send the file name as parameter.
a) “File_extent.csv”
b) File_extent.csv
c) File_extent
d) .csv
38. Ashok Kumar of class 12 is writing a program to create a CSV file “empdata.csv” with empid, name & mobile number. Also to search a particular empid and display its record details. He has written the following code. As a programmer, help him to successfully execute the given task.
import ______ #Line1
fields=['empid','name','mobile_no']
rows=[['101','Rohit','8982345659'],['102','Shaurya','8974564589'],['103','Deep','8753695421'],['104','Prerna','9889984567'],['105','Lakshya','7698459876']]
filename="empdata.csv"
f=open(filename,'w',newline='')
csv_w=csv.writer(f)
csv_w._________ #Line2
for row in rows:
csv_w.______ #Line3
f.close()
f=open(filename,'r')
csv_r=________ #Line4
ans='y'
while ans=='y':
found=False
emplid=input("Enter employee id to search=")
for row in csv_r:
if len(row)!=0:
if _______==emplid: #Line5
print("Name : ",row[1])
print("Mobile No : ",row[2])
found=True
break
if not found:
print("Employee id not found")
ans=input("Do you want to search more? (y)")
(i) Choose the module he should import in Line 1.
a) math
b) pickle
c) csv
d) random
(ii) Choose a code to write the fields (column heading) from fields list in Line2.
a) writerows(fields)
b) writerow(field)
c) writerow(fields)
d) writerows(fields)
(iii) Choose a code to write the row from rows list in Line3.
a) writerows(row)
b) writerow(row)
c) writerow(rows)
d) write_row(row)
(iv) Choose a code for line 4 to read the data from a csv file.
a) csv.reader(f)
b) csv.read(f)
d) pickle.load(f)
e) f.read()
(v) Choose the correct variable (list value) to check “emplid” in Line5.
a) Row[0]
b) Rec[0]
c) row[0]
d) rec[0]
39. Sumit is making a software on “Countries and their Capitals” in which various records are to be stored/retrieved in “CAPITAL.CSV” data file. It consists of few records of Countries and their Capitals. He has written the following code in python. As a programmer, you have to help him to successfully execute the program.
import csv
# Fn. to add a new record in CSV file
def _________(Country,Capital): # Statement-1
f=open("CAPITAL.CSV","__") # Statement-2
fwriter=csv.writer(f)
fwriter.writerow([_____]) # Statement-3
f.close()
def ShowRec(): # Fn. to display all records from CSV file
with open("CAPITAL.CSV","r") as NF:
NewReader=csv._____ (NF) # Statement-4
for rec in NewReader:
if len(rec)!=0:
print(rec[0],rec[1])
AddNewRec("INDIA","NEW DELHI")
AddNewRec("CHINA","BEIJING")
ShowRec() # Statement-5
(i) Choose the Name of the function in Statement-1.
a) AddNewRec
b) Addnew
c) Addrec
d) AddNewRec()
(ii) Choose the file mode to be passed to add new records in Statement-2.
a) w
b) r
c) w+
d) a
(iii) Identify the correct variables in Statement-3 to store data to the file.
a) country,capital
b) Country,Capital
c) Coun,Cap
d) [Country,Capital]
(iv) Choose the correct option for Statement-4 to read the data from a csv file.
a) Reader()
b) reader()
c) read
d) reader
(v) Choose the output which will come after executing Statement-5.
a) ‘INDIA NEW DELHI’
‘CHINA BEIJING’
b) ‘INDIA’ ‘NEW DELHI’
‘CHINA’ ‘BEIJING’
c) INDIA NEW DELHI
CHINA BEIJING
d) All the above
40. Choose the possible output from the following code:
import csv
def addFile(Name,Phno):
f=open("Diary.csv","a",newline='')
newFileWriter = csv.writer(f)
newFileWriter.writerow([Name,Phno])
f.close()
def readFile():
with open("Diary.csv",'r') as f:
filereader = csv.reader(f)
for row in filereader:
print (row[0],row[1])
f.close()
addFile("SOMU","9867564534")
addFile("KRISH","9678564534")
readFile()
a) KRISH 9678564534
SOMU 9867564534
b) SOMU 9867564534
KRISH 9678564534
c) somu 9867564534
krish 9678564534
d) ‘SOMU’ 9867564534
‘KRISH’ 9678564534
| #TRENDING | |
Text File MCQs for Class 12 Term 1Binary File MCQs for Class 12 Term 1 |
|