aws s3 python_Python：如何从AWS S3读取和加载Excel文件？

I have uploaded an excel file to AWS S3 bucket and now I want to read it in python. Any help would be appreciated. Here is what I have achieved so far,

import boto3

import os

aws_id = 'aws_id'

aws_secret = 'aws_secret_key'

client = boto3.client('s3', aws_access_key_id=aws_id, aws_secret_access_key=aws_secret)

bucket_name = 'my_bucket'

object_key = 'my_excel_file.xlsm'

object_file = client.get_object(Bucket=bucket_name, Key=object_key)

body = object_file['Body']

data = body.read()

What do I need to do next in order to read this data and work on it?

解决方案

Spent quite some time on it and here's how I got it working,

import boto3

import io

import pandas as pd

import json

aws_id = ''

aws_secret = ''

bucket_name = ''

object_key = ''

s3 = boto3.client('s3', aws_access_key_id=aws_id, aws_secret_access_key=aws_secret)

obj = s3.get_object(Bucket=bucket_name, Key=object_key)

data = obj['Body'].read()

df = pd.read_excel(io.BytesIO(data), encoding='utf-8')