title: How to read csv from ftp using pandas?
body: <p>I connected to a sftp and got a list of files successfully:</p>
  <pre><code>ssh = paramiko.SSHClient()
  ssh.set_missing_host_key_policy( paramiko.AutoAddPolicy() )
  
  ssh.connect(Hostname, username=Username, password=Password)
  
  ftp = ssh.open_sftp()
  files = ftp.listdir()
  
  dir_oi = &quot;blah&quot;
  foi = ftp.listdir(dir_oi)
  foi = [i for i in foi if '.csv' in i]
  foi = [i for i in foi if not '.test.' in i]
  len(foi)
  </code></pre>
  <p>and I get a list of 500+ csvs. I would like to read them to process, but am hitting a block.</p>
  <pre><code>remote_file = ( dir_oi +&quot;/&quot; + foi[0])
  </code></pre>
  <p>I tried <code>pd.read_csv(remote_file)</code> and other parimiko suggestions from SO to no avail.</p>
  <p>Any suggestions?</p>