Quiz

CSV Files Quiz

Quiz

 

1. _________ is a file format which stores records separated by comma.
   1.   .tsv
   2.   .csv
   3.   .py
   4.   .bin
2. The CSV files can be operated by _______softwares.
   1.   Spreedsheet
   2.   Notepad
   3.   MS Excel
   4.   All of the above
3. When you read csv file using csv.reader() function it returns the values in _______ object.
   1.   dictionary
   2.   tuple
   3.   nested list
   4.   sets
4. CSV module allows to write multiple rows using ____________ function.
   1.   writerows()
   2.   writerow()
   3.   writer()
   4.   None of the above
5. Which of the following parameter needs to be added with open function to avoid blank row followed file each row in CSV file?
   1.   delimiter
   2.   newline
   3.   writer, delimiter
   4.   file object
6. which is the correct way to import a csv module?
   1.   import csv
   2.   from csv import *
   3.   None of the above
   4.   Both A & B
7. 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
   1.   open("data.csv")
   2.   f=open("data.csv")
   3.   Both A & B are Correct
   4.   Both A & B are incorrect
8. 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
   1.   load
   2.   read()
   3.   reader()
   4.   readlines()
9. 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
   1.   f
   2.   r
   3.   r,f
   4.   None of the above
10. 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
    
    1.   r
    2.   row
    3.   f
    4.   csv