title: Split Pandas Dataframe into Multiple Excel Sheets Based on Index Value in Dataframe
body: <p>I have this dataset:</p>
  
  <p><a href="https://i.stack.imgur.com/JufSZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JufSZ.jpg" alt="Dataset"></a></p>
  
  <p>That has the column 'Product' with values 'Gas', 'Oil', and 'Water'. I want to write this dataframe to a single excel workbook with three worksheets with the 'Gas', 'Oil', and 'Water' data in those three worksheets. </p>
  
  <p>I have tried:</p>
  
  <p><a href="https://i.stack.imgur.com/F8qUM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F8qUM.png" alt="I have tried variations of:"></a></p>
  
  <p>and keep getting a type error. Any assistance is appreciated.</p>
  
  <p><a href="https://i.stack.imgur.com/1K24c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1K24c.png" alt="enter image description here"></a></p>