title: How to read a csv file from an s3 bucket using Pandas in Python
body: <p>I am trying to read a CSV file located in an AWS S3 bucket into memory as a pandas dataframe using the following code:</p>
  
  <pre><code>import pandas as pd
  import boto
  
  data = pd.read_csv('s3:/example_bucket.s3-website-ap-southeast-2.amazonaws.com/data_1.csv')
  </code></pre>
  
  <p>In order to give complete access I have set the bucket policy on the S3 bucket as follows:</p>
  
  <pre><code>{
  "Version": "2012-10-17",
  "Id": "statement1",
  "Statement": [
      {
          "Sid": "statement1",
          "Effect": "Allow",
          "Principal": "*",
          "Action": "s3:*",
          "Resource": "arn:aws:s3:::example_bucket"
      }
  ]
  </code></pre>
  
  <p>}</p>
  
  <p>Unfortunately I still get the following error in python:</p>
  
  <pre><code>boto.exception.S3ResponseError: S3ResponseError: 405 Method Not Allowed
  </code></pre>
  
  <p>Wondering if someone could help explain how to either correctly set the permissions in AWS S3 or configure pandas correctly to import the file. Thanks!</p>