In [9]:
import json

#загрузить из json
with open('data/json.json') as fh: #открываем файл на чтение
    data = json.load(fh) #загружаем из файла данные в словарь data
print(data)


[['ga', 'eventAction,ga', 'sessions'], ['Click,6', '', ''], ['Form,154', '', '']]

In [11]:
import json
import ast
import pandas as pd
mystr = """
{'ga': [{'Click,6': 'Form,154'}],
  'eventAction,ga': [{'':''}],
  'sessions': [{'': ''}]}
"""
val = ast.literal_eval(mystr)
val1 = json.loads(json.dumps(val))
val2 = val1['ga'][0]['eventAction,ga'][0]['sessions']
print pd.DataFrame(val2, columns=["ga", "eventAction,ga", "sessions"])


  File "<ipython-input-11-5befc85e7907>", line 12
    print pd.DataFrame(val2, columns=["ga", "eventAction,ga", "sessions"])
           ^
SyntaxError: invalid syntax

In [17]:
import pandas

d = pandas.read_json('data/json.json')
d


Out[17]:
0 1 2
0 ga eventAction,ga sessions
1 Click,6
2 Form,154

In [18]:
import pandas

d = pandas.read_json(https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A93735856&start-date=2017-04-04&end-date=2017-04-20&metrics=ga%3Asessions&dimensions=ga%3Adate&key)
d


  File "<ipython-input-18-41b29d2e7919>", line 3
    d = pandas.read_json(https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A93735856&start-date=2017-04-04&end-date=2017-04-20&metrics=ga%3Asessions&dimensions=ga%3Adate&key)
                              ^
SyntaxError: invalid syntax

In [ ]: