title: Read specific csv file from zip using pandas
body: <p>Here is a data I am interested in.</p>
  <p><a href="http://fenixservices.fao.org/faostat/static/bulkdownloads/Production_Crops_E_All_Data.zip" rel="nofollow noreferrer">http://fenixservices.fao.org/faostat/static/bulkdownloads/Production_Crops_E_All_Data.zip</a></p>
  <p>It consists of 3 files:</p>
  <p><a href="https://i.stack.imgur.com/FzM6p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FzM6p.png" alt="enter image description here" /></a></p>
  <p>I want to download zip with pandas and create DataFrame from 1 file called Production_Crops_E_All_Data.csv</p>
  <pre><code>import pandas as pd
  url=&quot;http://fenixservices.fao.org/faostat/static/bulkdownloads/Production_Crops_E_All_Data.zip&quot;
  df=pd.read_csv(url)
  </code></pre>
  <p>Pandas can download files, it can work with zips and of course it can work with csv files. But how can I work with 1 specific file in archive with many files?</p>
  <p>Now I get error</p>
  <p>ValueError: ('Multiple files found in compressed zip file %s)</p>
  <p>This post doesn't answer my question bcause I have multiple files in 1 zip
  <a href="https://stackoverflow.com/questions/18885175/read-a-zipped-file-as-a-pandas-dataframe">Read a zipped file as a pandas DataFrame</a></p>