title: Create Columns Percentage of Total Based on Referenced Strings In List Python DataFrame
body: <p>I have a dataframe that is essentially some indexes with a pivot table of columns with values in the rows of 1's and 0's. One column 'Total' is the total of the 1's across a given row. Each column name is the first index of items in a list that I referenced. What I would like to do is create columns for percent of the total column referencing these columns and pulling the third index which is a string which represents a region in the world such as 'United States', 'Germany', etc. </p>
  
  <p>Dataframe below:</p>
  
  <pre><code>Name     Total  Option1  Option2  Option3  Option4  Option5  Option6  Option7
  Michael   4       1        0        0        1        0        1        1
  Gerry     2       1        0        0        0        0        0        1
  </code></pre>
  
  <p>List that is referenced for pivot table dataframe</p>
  
  <pre><code>ids = [('Option1', '37i9dQZF1DX0XUsuxWHRQd', 'United States'), 
  ('Option2', '37i9dQZF1DX2RxBh64BHjQ', 'Germany'), 
  ('Option3', '37i9dQZF1DX5hR0J49CmXC', 'Denmark'), 
  ('Option4', '37i9dQZF1DX8f6LHxMjnzD', 'Australia'), 
  ('Option5', '37i9dQZF1DWSOkubnsDCSS', 'United Kingdom'), 
  ('Option6', '37i9dQZF1DX0QKpU3cGsyb', 'United States'), 
  ('Option7', '37i9dQZF1DX60OAKjsWlA2', 'United States')]
  </code></pre>
  
  <p>Expected Output</p>
  
  <pre><code>Name     Total  %United States  %Germany   %Denmark   %Australia  %United Kingdom  Option1  Option2  Option3  Option4  Option5  Option6  Option7
  Michael   4         .75             0          0          .25            0            1        0        0        1        0        1        1
  Gerry     2          1              0          0           0             0            1        0        0        0        0        0        1
  </code></pre>