-1

Suppose that you work in an e-commerce company, which keeps records of multiple products (more than a thousand) in the S3 bucket ‘records’. The files have the following structure for filename: ‘category-productid.csv’.

Now, you have to analyse the records associated with the ‘Electronics’ category only. You are expected to download the specific category reports and then perform the analysis over your local machine.

Provide the command that helps you perform this task.

i am trying on s3 help page , but i can download the csv file , but how to analyze particular category in csv ?

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
  • You can't perform any analysis with s3; it's just a storage service. You will need to use some program (eg: Excel or a custom script) to run analytics on the files once they're on your local machine. – chamal Dec 16 '22 at 07:02
  • Please provide enough code so others can better understand or reproduce the problem. – Community Dec 16 '22 at 09:09
  • It says "You are expected to download the specific category reports" -- you have done this. It then says "perform the analysis over your local machine", which probably means that you should do it ON your own machine. This doesn't involve any AWS service. You'll need to figure out how to analyse the CSV files yourself, because this looks like an assignment you have been given. – John Rotenstein Dec 16 '22 at 09:22

1 Answers1

0

aws s3 cp s3://records “local_path” --recursive --exclude “” --include “electronics

  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Dec 23 '22 at 20:16