擅长:python、mysql、java
<p>根据文件大小,您可以使用<code>pysftp</code>获取CSV文件,添加一个标题行,然后简单地将其放回原处。我之所以说它取决于大小,是因为<code>paramiko</code>库中存在一些未解决的错误,导致它在大的>;1GB文件上失败。你知道吗</p>
<p>从文档中,您可以执行以下操作:</p>
<pre><code>import pysftp
remote_file = 'some_file_name.csv'
srv = pysftp.Connection(host="your_FTP_server", username="your_username",
password="your_password")
# Download the file from the remote server
srv.get(remote_file)
# Add the header
with open(local_path, 'rb') as csvfile:
rows = [r for r in csvfile]
rows = ['domain'] + rows
with open(local_path, 'wb') as csvfile:
for row in rows:
csvfile.write(row + '\n')
# To upload the file, simple replace get with put.
srv.put(local_path)
# Closes the connection
srv.close()
</code></pre>