How Can I delete a column from csv file in an s3 amazon bucket?

Question

I have an s3 bucket that contains many CSV files. I want to apply some modifications to these files like removing specific columns from a specific file using aws CLI.

question from:https://stackoverflow.com/questions/65853308/how-can-i-delete-a-column-from-csv-file-in-an-s3-amazon-bucket

Answer 1

The Amazon S3 API does not have any methods that let you modify the content located in objects. You must get the object, then you can use code to modify the object and put the object back. If you needed to do this to many objects, you can look at using a workflow by using AWS Step functions.