title: Save Dataframe to csv directly to s3 Python
body: <p>I have a pandas DataFrame that I want to upload to a new CSV file. The problem is that I don't want to save the file locally before transferring it to s3. Is there any method like to_csv for writing the dataframe to s3 directly? I am using boto3.<br>
  Here is what I have so far:</p>
  
  <pre><code>import boto3
  s3 = boto3.client('s3', aws_access_key_id='key', aws_secret_access_key='secret_key')
  read_file = s3.get_object(Bucket, Key)
  df = pd.read_csv(read_file['Body'])
  
  # Make alterations to DataFrame
  
  # Then export DataFrame to CSV through direct transfer to s3
  </code></pre>