title: Trying to read csv with special characters from AWS S3
body: <p>Im trying to read a csv from my bucket on S3 using AWS Lambda, but the csv have special characters from brazillian portuguese alphabet.</p>
  <pre><code>def rentabilidade_sintetica():
  
  s3_client = boto3.client('s3')
  
  bucket_name = &quot;bucket-my&quot;
  s3_file_name = &quot;historico/Rentabilidade Sintetica1.csv&quot;
  resp = s3_client.get_object(Bucket=bucket_name, Key=s3_file_name)
  df_s3_data = pd.read_csv(resp['Body'], sep=';')
  </code></pre>
  <p>Because of that, i get the following error:</p>
  <p>&quot;errorMessage&quot;: &quot;'utf-8' codec can't decode byte 0xf3 in position 4: unexpected end of data&quot;,</p>
  <p>&quot;errorType&quot;: &quot;UnicodeDecodeError&quot;,</p>
  <p>When I changed the special characters in the csv files, the code worked.</p>
  <p>So I tried to specify the encoding parameter at read_csv:</p>
  <pre><code>df_s3_data = pd.read_csv(resp['Body'], sep=';', encoding='cp860')
  </code></pre>
  <p>but it gave me the same error.</p>
  <p>Do you have any other method to read this?</p>