Answers for "how to read the csv file using pandas in aws lambda"

how to read the csv file using pandas in aws lambda

import json
import os
import boto3
import csv
import sys
import pandas as pd
from io import BytesIO

s3_client = boto3.client('s3')

bucket_name ='bucket_name'
s3_file_name ='s3_file_name.csv'

def lambda_handler(event, context):
    print(event)
    try:
        #   bucket_name = event["Records"][0]["s3"]["bucket"]["name"]
        #   s3_file_name = event["Records"][0]["s3"]["object"]["key"]
        resp = s3_client.get_object(Bucket=bucket_name, Key=s3_file_name)
        df= pd.read_csv(resp['Body'], sep=',')

        print(df.head(2))
    except Exception as err:
        print(err)