CSV File handling in Python

CSV stands for

• Comma Separated Values

• Comma Spaced Values

• Completely Separated VAlues

• Comma Segregated Values

Delimeter for CSV file is

• Comma

• Tab

• Space

• Semi-colon

Which character can work as delimiter for CSV files:

• Comma only

• Tab only

• Space only

• Any character

We can manage (create/read/update)CSV files using

• A text editor

• A Python program

• A Spreadsheet application

• All of the above

File opening modes for CSV files are:

• Same as those for text files

• same as those for binary files

• different from text files and binary files

• mix of text files and binary files

Which module in Python is used to process csv file

• pickle

• random

• CSV

• csv.reader()

CSV module allows writing multiple records in a CSV file using

• writerows()

• writerow()

• writerec()

• writelines

The content of a file "sample.txt" are shown below:

1,2,3,4

'a', 'b', 'c'

5, 23, 'me', 'peace'

'to', 'be', 'or' 'not'

• It can be treated as a csv file

• It can not be treated as CSV file as it is a text file

• It can not be treated as CSV file as it contains mixed data

• It can not be treated as CSV file as it contains different number of elements in different lines.

The contents of a csv file "sample.csv" are shown below:

sno, name, age

1, Amit, 12

2, Harsh, 13

3, Vivek, 21

• It can be treated as a text file

• It cannot be treated as a text file as it is a CSV file

• It cannot be opened in a text editor a sit is a CSV file

• An error will be raised in Python

The contents of a text file"sample.txt", and a script to read the file contents are shown

Pick the correct statement w.r.t the given contents and code:

• rec will be list in 1 element

• rec will be list in 3 element

• rec will be a nested list of 1 element

• rec will be a nested list of 3 elements