title: dictionary values to excel columns
body: <p>I would like to convert a dictionary of key-value pairs to an excel file with column names that match the values to the corresponding columns. </p>
  
  <p>For example :</p>
  
  <p>I have an excel file with column names as:</p>
  
  <pre><code>a,b,c,d,e,f,g and h.
  </code></pre>
  
  <p>I have a dictionary like: 
      {<code>1:['c','d'],2:['a','h'],3:['a','b','b','f']}</code>. </p>
  
  <p>I need the output to be:</p>
  
  <pre><code>       a  b  c  d  e  f  g  h
  
  1            1  1                
  
  2      1                    1
  
  3      1  2           1  
  </code></pre>
  
  <p>the <code>1,2,3</code> are the keys from the dictionary.
  The rest of the columns could be either <code>0</code> or <code>null</code>.</p>
  
  <p>I have tried splitting the dictionary and am getting </p>
  
  <pre><code>1 = ['c','d']
  2 = ['a','h']
  3 = ['a','b','b','f']
  </code></pre>
  
  <p>but, I don't know how to pass this to match with the excel file. </p>