title: Reading csv file from S3 and converting it to xlsx using Python
body: <p>I have a big csv file in S3 and i cam concatenating it with another csv file in S3. I am using pandas dataframe in python to do this in AWS lambda. I also have to save the concatenated data frame to xlsx format in S3 using the same lambda. Is there a way to do this?</p>
  
  <pre><code>import pandas as pd
  import os
  import boto3
  
  df1 =pd.read_csv("file1.csv",header=None,lineterminator='\n',sep='\t', error_bad_lines=False, encoding='ISO-8859-1') # file is in s3.
  
  df2 = pd.read_csv("file2.csv",sep='\t',header=None)
  
  df3 = pd.concat([df2,df1]) 
  </code></pre>
  
  <p>I want to save the result in df3 object as excel file in s3. </p>
  
  <p>Note: I have already tried df.to_excel(). But since i need to save it directly to s3 it is not working.</p>