擅长:python、mysql、java
<p>Pandas有一个实用函数<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.io.json.json_normalize.html" rel="nofollow noreferrer">^{<cd1>}</a>,用于执行以下操作:</p>
<pre><code>import pandas as pd
df = pd.io.json.json_normalize({'android_id': 'ds cgethcvwrzvbjezrzve',
'app': 'hndbfhjdfhf bnmhjknuihklmmkbghjbtfgjnkluilnkkfbnjtkjzn',
'app_ver': '10.0.1_0',
'at': '2016-02-02 23:59:47',
'birth_date': 1447896843,
'browser': 'Android 4',
'carrier': 'Comcast Cable',
'city_name': 'Jacksonville',
'country': 'us',
'custom': {'Action': 'Click',
'Campaign ID': '167713',
'Creative ID': '113961',
'Creative Type': 'Alert',
'Schema Version - Client': '3',
'Schema Version - Server': '1'},
'customer_ids': {'customer_id': '1234587612545464525441540341414'},
'data_conn': 'android_network_type_3',
'device_new': False,
})
df.columns
</code></pre>
<p>输出是</p>
^{pr2}$
<p>请注意函数是如何创建所需的嵌套列的。例如:<code>custom.Action</code>和<code>custom.Campaign ID</code>。在</p>