Download Edit And Upload A Csv To S3

December - 2021

TODO: scrub this to verify the includes are setup and pull it out of a function

import boto3
import csv

from io import StringIO


    def process_csv_files(self):
        print("-- Processing CSV Files")
        for attachment in self.attachments:
            print(attachment['name'])
            raw_string = s3.get_object(Bucket=self.bucket, Key=attachment['original_key'])['Body'].read().decode('utf-8')
            lines = raw_string.splitlines()
            csv_reader = csv.reader(lines)
            new_csv_data = StringIO()
            csv_writer = csv.writer(new_csv_data)
            for row in csv_reader:
                csv_writer.writerow(['asdf'])
            s3.put_object(Body=new_csv_data.getvalue(), Bucket=self.bucket, Key=attachment['finalized_key'])