Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 143 of 145

File Handling — Question 23

Back to all questions
23
Question

Question 23

Write a function that reads a csv file and creates another csv file with the same content, but with a different delimiter.

Answer

Let "original.csv" file contain the following data:

Product,Price,Quantity
Apple,1.99,100
Banana,0.99,150
Orange,2.49,80

import csv

def change_delimiter(input_file, output_file, input_delimiter, output_delimiter):
    with open(input_file, 'r', newline='') as f_in:
        reader = csv.reader(f_in, delimiter = input_delimiter)
        data = list(reader)

    with open(output_file, 'w', newline='') as f_out:
        writer = csv.writer(f_out, delimiter = output_delimiter)
        writer.writerows(data)

change_delimiter('original.csv', 'modified.csv', ',', '|')

Contents of "modified.csv":

Product|Price|Quantity
Apple|1.99|100
Banana|0.99|150
Orange|2.49|80