How do I read and write CSV files in Python?

Python provides a built-in module called `csv` that makes it easy to read from and write to CSV files. The `csv` module can handle both reading and writing in various dialects and formats.

Reading CSV Files

To read a CSV file, you can use the `csv.reader()` function, which returns an object that can iterate over lines in the specified CSV file.

Example Code:

import csv with open('example.csv', mode ='r')as file: csvFile = csv.reader(file) for lines in csvFile: print(lines)

Writing CSV Files

You can write to a CSV file using the `csv.writer()` function. This function allows you to write rows of data to your CSV file.

Example Code:

import csv with open('example.csv', mode ='w', newline='') as file: csvWriter = csv.writer(file) csvWriter.writerow(['Name', 'Age', 'City']) csvWriter.writerow(['Alice', '30', 'New York']) csvWriter.writerow(['Bob', '25', 'Los Angeles'])

Python CSV read CSV write CSV csv module data handling