import pandas as pd
import s3fs

fs = s3fs.S3FileSystem(profile_name='aws_profile')

with fs.open("s3://my-bucket/file.csv", "rb") as f:
  csv_df = pd.read_csv(f)

fs = s3fs.S3FileSystem(profile_name='other_aws_profile')
with fs.open("s3://another-bucket/file.csv", "wb") as f
  df.to_csv(f)