如何从pysftp下载csv文件到本地？无法将其保存到本地路径，或将其加载到df

import pysftp
import pandas as pd

cnopts = pysftp.CnOpts()
cnopts.hostkeys = None  # 可选，用于忽略主机密钥验证
sftp = pysftp.Connection('hostname', username='username', password='password', cnopts=cnopts)

remote_path = '/path/to/remote/csv/file.csv'  # 远程CSV文件路径
local_path = '/path/to/local/save/file.csv'  # 本地保存路径
sftp.get(remote_path, local_path)

df = pd.read_csv(local_path)