title: How to Create Multiple Data Frames in For Loop
body: <p>I have a list of names (I changed them to letters) that correspond with values in a data frame column.</p>
  <pre><code>names = ['A','B','C','D','E','F','G','H']
  
  </code></pre>
  <p>I am trying to create a separate data frame for each name containing that name's associated QTY grouped by part number.</p>
  <pre><code>for x in names:
      name_data = data[data['Name']== x]
      name_dict = name_data.groupby(['Part No.']).Quantity.sum().to_dict()
      df1= pd.DataFrame.from_dict(name_dict, orient = 'index',columns = ['QTY'])
  </code></pre>
  <p>As you can see from the code each time it loops it writes the new loop data over the previous loop's data in df1. How to I iterate a new data frame name each time it loops, so that I end of with 8 separate data frames?</p>