使用Python通过ftp上传csv文件

import ftplib

def upload_csv_via_ftp(hostname, username, password, csv_file_path, remote_directory):
    try:
        # 连接FTP服务器
        ftp = ftplib.FTP(hostname)
        ftp.login(username, password)

        # 切换到指定的远程目录
        ftp.cwd(remote_directory)

        # 打开本地CSV文件
        with open(csv_file_path, 'rb') as file:
            # 上传文件到FTP服务器
            ftp.storbinary('STOR ' + csv_file_path, file)

        # 关闭FTP连接
        ftp.quit()
        print("CSV文件上传成功！")
    except Exception as e:
        print("上传失败:", str(e))

# 示例用法
hostname = 'ftp.example.com'
username = 'your_username'
password = 'your_password'
csv_file_path = 'path/to/your/csv/file.csv'
remote_directory = '/path/on/remote/server'

upload_csv_via_ftp(hostname, username, password, csv_file_path, remote_directory)