Storing data to S3

In this recipe, you will explore writing to AWS S3 using pandas and another approach using the AWS Python SDK. The pandas approach can be used to write files to other cloud storage locations, such as Azure or Google Cloud.

Getting ready

In the Reading data from a URL recipe in Chapter 2, Reading Time Series Data from Files, you were instructed to install boto3 and s3fs in order to read from AWS S3 buckets. In this recipe, you will be leveraging the same libraries.

To install using pip, you can use this:

>>> pip install boto3 s3fs

To install using conda, you can use this:

>>> conda install boto3 s3fs -y

You will be working with the boxoffice_by_month.xlsx file that we created in the previous recipe, Writing data to an Excel file. The file is provided in the GitHub repository for this book, which you can find here: https://github.com/PacktPublishing/Time-Series-Analysis-with-Python-Cookbook.

How to do it…

Several...