title: Read multiple csv files zipped in one file
body: <p>I have several csv files in several zip files in on folder, so for example:</p>
  
  <ul>
  <li>A.zip (contains csv1,csv2,csv3)</li>
  <li>B.zip (contains csv4, csv5, csv6)</li>
  </ul>
  
  <p>which are in the folder path <code>C:/Folder/</code>, when I load normal csv files in a folder I use the following code:</p>
  
  <pre><code>import glob
  import pandas as pd
  files = glob.glob("C/folder/*.csv")
  dfs = [pd.read_csv(f, header=None, sep=";") for f in files]
  
  df = pd.concat(dfs,ignore_index=True)
  </code></pre>
  
  <p>followed by this post: <a href="https://stackoverflow.com/questions/26942476/reading-csv-zipped-files-in-python">Reading csv zipped files in python</a></p>
  
  <p>One csv in zip works like this:</p>
  
  <pre><code>import pandas as pd
  import zipfile
  
  zf = zipfile.ZipFile('C:/Users/Desktop/THEZIPFILE.zip') 
  df = pd.read_csv(zf.open('intfile.csv'))
  </code></pre>
  
  <p>Any idea how to optimize this loop for me?</p>