A CSV file is also known as a ….

(a)

Flat File

(b)

3D File

(c)

String File

(d)

Random File

The command used to skip a row in a CSV file is

(a)

next()

(b)

skip()

(c)

omit()

(d)

bounce()

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

What will be written inside the file test.csv using the following program
import csv
D = [['Exam'],['Quarterly'],['Halfyearly']]
csv.register_dialect('M',lineterminator = '\n')
with open('c:\pyprg\ch13\line2.csv', 'w') as f:
wr = csv.writer(f,dialect='M')
wr.writerows(D)
f.close()

(a)

Exam Quarterly Halfyearly

(b)

Exam Quarterly Halfyearly

(c)

E, Q, H

(d)

Exam, Quarterly, Halfyearly

Which of the following is a human readable text file where each line has fields?

(a)

CSV file

(b)

CSV module

(c)

CSV sheet

(d)

CSV text

In CSV file, each record is to be located on a separate line, delimited by a line break by pressing

(a)

Enter key

(b)

ESV key

(c)

Tab key

(d)

Shift key

Which of the following built-in function Python has to open a file?

(a)

read ()

(b)

open ()

(c)

reader ()

(d)

openfile ()

Python function open () returns a file object called

(a)

read

(b)

write

(c)

handle

(d)

process

Which python file mode open a file for exclusive creation?

(a)

'x'

(b)

'w'

(c)

't'

(d)

'a'

The CSV file contents can be read with the help of the method

(a)

read ( )

(b)

open ( )

(c)

with open ( )

(d)

reader ( )

The function used to add elements to CSV file is 

(a)

add ( )

(b)

write ( )

(c)

append ( )

(d)

addition ( )

List literals are enclosed with

(a)

{ }

(b)

( )

(c)

< >

(d)

[ ]

Which of the following works with list / tupledict?

(a)

read ( )

(b)

dictreader ( )

(c)

reader ( )

(d)

diet ( )

How many ways are there to write a new or modify the existing CSV file?

(a)

8

(b)

6

(c)

4

(d)

2

Which option allows to write the double quote or all the values in CSV file?

(a)

csv.Quote ( )

(b)

csv.ALL_QUOTE( )

(c)

csv.QUOTE_ALL ( )

(d)

csv.QUOTEALL ( )

What is CSV File?

Mention the default modes of the File.

How will you sort more than one column from a csv file?Give an example statement.

Why CSV file is known as flat file?

How the CSV file operation takes place in python?

What take the three models in which CSV file can be opened?

Differentiate text mode and binary mode.

What is use of sort ( ) method?

How will you read CSV file into a dictionary?

What is called modification?

Write a note on open() function of python. What is the difference between the two methods?

Write a Python program to read a CSV file with default delimiter comma (,).

What is the difference between the write mode and append mode.

What is the difference between reader() and DictReader() function?

How will you create CSV normal file?

How will you save the CSV file in MS-Excel?

Write the syntax of reader( ).

Write a program to read a file with default delimiter comma.

What are the different ways of reading a CSV file using reader ( ) method?

Write a program to create a new normal CSV file to store data.

Differentiate Excel file and CSV file.

Tabulate the different mode with its meaning.

Write a Python program to write a CSV File with custom quotes.

Write the rules to be followed to format the data in a CSV file.

Write a program to read the CSV file through python using reader ( ) method.

Write a program to read the CSV file and store it in a list.

How will you write the CSV file with custom denote characters? Explain with an example.