In [9]:
import json
#загрузить из json
with open('data/json.json') as fh: #открываем файл на чтение
data = json.load(fh) #загружаем из файла данные в словарь data
print(data)
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"])
In [17]:
import pandas
d = pandas.read_json('data/json.json')
d
Out[17]:
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
In [ ]: