title: How to convert json to dataframe
body: <p>This is what my json file looks like:</p>
  
  <pre><code>d = {
      "Success" : 
       {
         "Schema1.Table1" : [
           file1, file2
         ],
         "Schema1.Table2" : [
           file3, file4, file5
         ]
      },
     "Fail" :
       {
         "Schema1.Table1" : [
           file7, file8
         ],
         "Schema1.Table2" : [
           file10, file11, file12
         ]
       }
     }
  </code></pre>
  
  <p>I would like to convert it to a dataframe that looks like this:</p>
  
  <pre><code>Success
  Schema1.Table1.file1
  Schema1.Table1.file2
  
  ...
  
  Fail
  Schema1.Table1.file7
  Schema1.Table1.file8
  ...
  </code></pre>
  
  <p>Any advice on how to do so?</p>