擅长:python、mysql、java
<p>您可以取消嵌套数据,然后构造数据帧。下面是如何取消嵌套。在</p>
<pre><code>df = {'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,
}
sub_df1 = df.pop('custom')
sub_df2 = df.pop('customer_ids')
df.update(sub_df1)
df.update(sub_df2)
# you can define a function to do this
def un_nest(df):
sub_df1 = df.pop('custom')
sub_df2 = df.pop('customer_ids')
df.update(sub_df1)
df.update(sub_df2)
return df
</code></pre>
<p>这样可以得到如下输出</p>
^{pr2}$