title: Downloading zip files with more than 1 csv and append them all to a dataframe
body: <p>I am trying to read <code>csv files</code> from a <code>.zip</code> file.  The code works fine when the <code>zip file</code> <strong>has only one file</strong> but fails when there's <strong>more than one file.</strong></p>
  <pre><code>DATE = ['2010','2011']
  x=[]
  for i in range(len(DATE)):
      file_i='http://url_of_file/file_' + DATE[i] +'.zip'
      x.append(file_i)
      
  xi=[]
  for filename in x:
      dfi = pd.read_csv(filename, index_col=None, header=0, sep=';')
      xi.append(dfi)
  
  dfi = pd.concat(xi, axis=0, ignore_index=True)
  </code></pre>
  <p>What's the best way to deal with <strong>zip files</strong> with more than one <strong>csv file</strong></p>
  <p>I Know I can manually unzip the zip file and read from there, but there's a lot of zip files so I want to avoid to manually unzip them. But I can unzip them locally to read from there if needed but doing that through code not manually.</p>
  <p>What's the best way here?</p>