Revision - CSV File Handling

Rashil is working on a project that involves analyzing sales data stored in a CSV file. Which Python module should he primarily use for handling these CSV files?

• csv

• txt

• xml

• json

Reyansh is working on a project where he needs to save the results of his experiments in a structured format. He decides to use a CSV file for this purpose. What does the csv.writer() function do?

• It reads data from a CSV file.

• It converts CSV data to JSON format.

• It writes data to a CSV file.

• It deletes data from a CSV file.

During a class project, Shaurya needs to write a single row of data to a CSV file using the csv.writer method. Which method should he use?

• writerow()

• insert_row()

• addrow()

• writerows()

Taran is working on a project that involves reading and writing CSV files. He comes across the newline='' argument in the open() function. What does this argument do when working with CSV files?

• It determines the delimiter used in the CSV file.

• It prevents the addition of extra newline characters when reading or writing CSV files.

• It adds extra newline characters when reading CSV files.

• It specifies the encoding type for the CSV file.

What happens if the CSV file being read by Reyansh contains inconsistent row lengths?

• All rows will be padded with empty values to match the longest row.

• The CSV file will be ignored entirely if row lengths are inconsistent.

• Inconsistent row lengths are automatically corrected during the read process.

• Inconsistent row lengths can cause errors or misalignment in data when reading a CSV file.

During a class project, Reyansh and Tanisha were discussing how to handle data files. They wondered what the default delimiter is when using the csv module in Python.

• ;

• ,

• |

• tab

During a school project, Reyansh, Taran, and Tanisha need to save their data into a CSV file. Which method should they use to write multiple rows in one call?

• writeall()

• bulkInsert()

• addRows()

• writerows()

Abhishek and Adivya are working on a project that involves reading data from a CSV file. They need to skip the header row to process the data correctly. How can they achieve this?

• Set skip_header=True in csv.reader()

• Use next() before iterating over rows

• Both a and b

• Use csv.Sniffer() to detect headers

When Adivya was trying to analyze the sales data, she opened a CSV file using the ________ mode to read the file.

During a group project, Abhishek and Tanisha decided to create a CSV file to organize their data. They realized that a CSV file can use characters other than commas, such as ; or |, as delimiters, which can be specified using the ________ parameter in both csv.reader and csv.writer.