title: Converting Json to Excel or CSV in Python
body: <p>I habe a JSon Document, which i would like to convert to Excel or CSV. My JSON File looks like this: </p>
  
  <pre><code>df = pd.DataFrame(columns=[Store,Address,User,Rating], dtype='unicode')
  </code></pre>
  
  <p>With following data: </p>
  
  <pre><code> Store  |   Address  |  User   | Rating  
  |:----------------------------------------:|
   Store X| Adresse X  | User 1  | 3
          |            | User 2  | 5
          |            | User 3  | 2
   Store Y| Adresse Y  | User 1  | 2
          |            | User 2  | 1
          |            | User 3  | 4
          |            | User 4  | 5
  </code></pre>
  
  <p>I tried following Code to convert the Json Doc to Excel:</p>
  
  <pre><code>jsonDoc = pd.read_json(df.to_json())
  ExcelDoc = jsonDoc.to_excel("C:\Users\output.xlsx")
  </code></pre>
  
  <p>But i get following output:  </p>
  
  <pre><code> Store  |   Address  |  User                    | Rating  
  |:-------------------------------------------------------:|
   Store X| Adresse X  | User 1,User2,User3       | 3,5,2
   Store Y| Adresse Y  | User 1,User2,User3,User4 | 2,1,4,5
  </code></pre>
  
  <p>But I would like to have my excel file like this:</p>
  
  <pre><code> Store  |   Address  |  User   | Rating  
  |:----------------------------------------:|
   Store X| Adresse X  | User 1  | 3
   Store X| Adresse X  | User 2  | 5
   Store X| Adresse X  | User 3  | 2
   Store Y| Adresse Y  | User 1  | 2
   Store Y| Adresse Y  | User 2  | 1
   Store Y| Adresse Y  | User 3  | 4
   Store Y| Adresse Y  | User 4  | 5
  </code></pre>
  
  <p>Can somebody help me? how I can implement this? Is there a library that can handle it?</p>