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)