title: Nested Dictionary to excel with color formatting
body: <p>My dictionary looks like this :</p>
  <pre><code>dict1 = { '2020-10-11' : { 
                             'group1':{ 
                                       1 : 2356,
                                       21 : 10001,
                                       34 :  234 
                                     },
                              'group2':{
                                       11 : 999,
                                       2  : 101,
                                       13 : 1234 
                                       } 
                           },
           '2020-10-12' : { 
                             'group1':{ 
                                       11 : 236,
                                       21 : 100,
                                       34 :  34 
                                     },
                              'group2':{
                                       1 : 99,
                                       3 : 121,
                                       2 : 12 
                                       } 
                           }
  
  
  }
  </code></pre>
  <h2>I wanted my output to look something like this :</h2>
  <p><a href="https://i.stack.imgur.com/64SPQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/64SPQ.png" alt="enter image description here" /></a></p>
  <h1>The requirement is : for every date, the color should be different.</h1>
  <p>I have tried this using this method:</p>
  <pre><code>reform = {(level1_key, level2_key, level3_key): values
            for level1_key, level2_dict in dict1.items()
            for level2_key, level3_dict in level2_dict.items()
            for level3_key, values      in level3_dict.items()}
  
  out = pd.DataFrame(reform,index = ['amount']).T
  names=['date', 'group', 'id']
  out.index.set_names(names, inplace=True)
  </code></pre>
  <h3>out in xls :</h3>
  <p><a href="https://i.stack.imgur.com/hocyh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hocyh.png" alt="enter image description here" /></a></p>
  <h2>After this how am I supposed to proceed for the color formatting in excel using python?</h2>