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 [ ]: