CSV Files Quiz

What does CSV stand for?

• Column Separated Values

• Character Separated Values

• Comma Separated Values

• Comma Standard Values

Which of the following is a reason to use a CSV file?

• To store images

• To create a web page

• To store data in a tabular format

• To execute Python code

What is the correct way to open a CSV file for writing in Python?

• file = open('file.csv', 'a')

• file = open('file.csv', 'x')

• file = open('file.csv', 'r')

• file = open('file.csv', 'w')

What error occurs when trying to write an integer directly to a CSV file?

• IndexError: list index out of range

• FileNotFoundError: No such file or directory

• ValueError: invalid literal for int()

• TypeError: write() argument must be str, not int

How should data be formatted before writing to a CSV file?

• As a list of integers

• As a string with commas

• As a dictionary

• As a JSON object

What does the join() method do?

• Removes an item from a list

• Splits a string into a list

• Joins a list into a string

• Appends an item to a list

What is the purpose of the newline character '\n' in a CSV file?

• To separate items in a row

• To indicate a new row

• To create a comment

• To format the text

What must be done to a list of integers before writing it to a CSV file?

• Convert each integer to a string

• Convert the list to a dictionary

• Remove duplicates

• Sort the list

Which of the following is NOT a valid way to write to a CSV file?

• file.write(','.join(str_numbers))

• file.write('3,4,5')

• file.write(numbers)

• file.write(data)

What is the correct way to write a 2D list to a CSV file?

• Write each row followed by a newline

• Write the list as a JSON string

• Flatten the list and write it as a single line

• Write each item without any separators