擅长:python、mysql、java
<p>JSON解析在这个例子中起作用。你可以随意修改它。你知道吗</p>
<pre><code>output = """{
"reportRequests": [
{
"viewId": "VIEW_ID",
"dateRanges": [{"startDate": "today", "endDate": "today"}],
"metrics": [{"expression": "ga:sessions"}],
"dimensions": [{"name": "ga:country"}, {"name": "ga:hostname"}]
}]
}"""
output = json.loads(output)
output = output['reportRequests'][0]
data = {}
for i in output:
if i == 'metrics':
data['ga:session'] = output[i][0]['expression']
if i == 'dimensions':
data['ga:country'] = output[i][0]['name']
if i == 'dimensions':
data['ga:hostname'] = output[i][1]['name']
df = pd.DataFrame([data])
</code></pre>