title: How do I create several DataFrames for each sheet in an Excel file?
body: <p>I have an Excel file with several sheets. I would like to iterate over each sheet of the Excel file and create a DataFrame for each sheet in the file. Also, I would like the DataFrames to be named "hfi_(name of the sheet)". This is the for loop I wrote so far, but it is not running due to a syntax error. Would you help me solve this?</p>
  
  <pre><code>for sheet in hfi_file:    
    hfi_file=pd.read_excel("/Users/glosophy/Desktop/hfi/hfi_2016.xlsx",sheet_name=sheet)
  return str("hfi"+sheet)=pd.DataFrame(hfi_file)
  </code></pre>