Code Samples for Processing CSV Files

csv_files_python.py

#Read a CSV file

import csv

with open('data.csv', 'r') as f: reader = csv.reader(f) for row in reader: print(row)

#Write a CSV file

import csv

data = [[1, 2, 3], [4, 5, 6]]

with open('data.csv', 'w') as f: writer = csv.writer(f) writer.writerows(data)

#Manipulate CSV data using pandas

import pandas as pd

df = pd.read_csv('data.csv')

#Print the first 5 rows of the DataFrame

print(df.head())

#Print the average value of the 'Age' column

print(df['Age'].mean())

#Write the DataFrame to a new CSV file

df.to_csv('new_data.csv')