edit csv files in a folder in python

main.py
import csv
import os

# Define the folder path where the CSV files are located
folder_path = '/path/to/folder'

# Iterate over each file in the folder
for filename in os.listdir(folder_path):
    if filename.endswith('.csv'):
        # Construct the full path of the file
        file_path = os.path.join(folder_path, filename)
        
        # Open the CSV file in read mode
        with open(file_path, 'r') as file:
            # Read the CSV file into a list of dictionaries
            csv_data = list(csv.DictReader(file))
        
        # Modify the data as needed
        for row in csv_data:
            row['column_name'] = 'new value'
        
        # Open the CSV file in write mode
        with open(file_path, 'w', newline='') as file:
            # Write the modified data back to the file
            writer = csv.DictWriter(file, fieldnames=csv_data[0].keys())
            writer.writeheader()
            writer.writerows(csv_data)
        
        print(f'File {filename} updated successfully.')
1021 chars
30 lines