title: How to import the google map timeline Json data into a DataFrame
body: <p>I got my commuting report from google map timeline and it is in json format. I use these codes:</p>
  
  <pre><code>with open('Location History.json', encoding='utf-8') as data_file:
    data = json.loads(data_file.read())
    pd.DataFrame(data)
  </code></pre>
  
  <p>the dataframe has only one 'location' column.</p>
  
  <pre><code>{"locations" : [ {
  "timestampMs" : "1501812184856",
  "latitudeE7" : 390632197,
  "longitudeE7" : -771227158,
  "accuracy" : 10,
  "velocity" : 1,
  "heading" : 226,
  "altitude" : 146,
  "verticalAccuracy" : 12
   }, {
  "timestampMs" : "1501813902831",
  "latitudeE7" : 390624516,
  "longitudeE7" : -771212199,
  "accuracy" : 10,
  "velocity" : 5,
  "heading" : 316,
  "altitude" : 126,
  "verticalAccuracy" : 16
   },
  </code></pre>
  
  <p>any advice how I can read the file into multiple columns and one row for each member of dict.</p>