title: converting json to csv using python pandas
body: <p>I have referred this:
  <a href="https://stackoverflow.com/questions/34341974/nested-json-to-pandas-dataframe-with-specific-format">Nested Json to pandas DataFrame with specific format</a></p>
  
  <p>and this: <a href="https://stackoverflow.com/questions/32291437/json-normalize-produces-confusing-keyerror">json_normalize produces confusing KeyError</a></p>
  
  <p>to try and normalize my json snippet using json_normalize in pandas.
  However, the output isn't getting normalized fully. Here's a snippet of my code</p>
  
  <pre><code>x =[{'fb_metrics': [{'period': 'lifetime', 'values': [{'value': {'share': 2, 'like': 10}}], 'title': 'Lifetime Post Stories by action type', 'name': 'post_stories_by_action_type', '_id': '222530618111374_403476513350116/insights/post_stories_by_action_type/lifetime', 'description': 'Lifetime: The number of stories created about your Page post, by action type. (Total Count)'}]}]
  
  df = pd.io.json.json_normalize(x[0]['fb_metrics'])
  </code></pre>
  
  <p>The output for values column is </p>
  
  <pre><code>values
  [{'value': {'share': 2, 'like': 10}}] 
  </code></pre>
  
  <p>I would've liked to have two column outputs instead like</p>
  
  <pre><code>value.share   value.like
  2                10
  </code></pre>
  
  <p>How should I achieve this? </p>