我只需要提取字符串中的特定元素值。下面是我使用 Facebook AdsInsight API 獲取 AdsInsight 數(shù)據(jù)的代碼。class LibFacebook: def __init__(self, app_id, app_secret, access_token, ad_account_id): FacebookAdsApi.init(app_id, app_secret, access_token) self.account = AdAccount(ad_account_id) #get ads insight insights = self.account.get_insights(fields=[ AdsInsights.Field.campaign_id, AdsInsights.Field.actions,], params={ 'level': AdsInsights.Level.campaign, }) print(insights)輸出<AdsInsights> { "campaign_id": "23843294609751234", "actions": [ { "action_type": "post_reaction", "value": "1" }, { "action_type": "landing_page_view", "value": "78" }, { "action_type": "link_click", "value": "163" } ]問題：與campaign_id 值（23843294609751234）一起，我只需要landing_page_view的值，即78（而不是其他操作項(xiàng)）并將其放入df 中。我如何訪問它們？更多信息：AdsInsights.Field.actions 是字符串類型。type(AdsInsights.Field.actions)str
1 回答
慕蓋茨4494581
TA貢獻(xiàn)1850條經(jīng)驗(yàn) 獲得超11個(gè)贊
希望這會(huì)起作用，讓您的數(shù)據(jù)是AdsInsights對象列表
obj = [{
"campaign_id": "23843294609751234",
"actions" : [
{
"action_type": "post_reaction",
"value": "1"
},
{
"action_type": "landing_page_view",
"value": "78"
},
{
"action_type": "link_click",
"value": "163"
}
]
},
{
"campaign_id": "112233",
"actions" : [
{
"action_type": "post_reaction",
"value": "1"
},
{
"action_type": "landing_page_view",
"value": "100"
},
{
"action_type": "link_click",
"value": "163"
}
]
}]
你可以得到這樣的結(jié)果
result_arr = []
for i in obj:
datadict = {}
datadict["campaign_id"] = i.get("campaign_id")
for action in i.get("actions"):
if action.get("action_type") == "landing_page_view":
datadict["value"]= action.get("value")
result_arr.append(datadict)
result_arr將會(huì)
[{'campaign_id': '23843294609751234', 'value': '78'},
{'campaign_id': '112233', 'value': '100'}]
接下來將字典列表轉(zhuǎn)換為數(shù)據(jù)框
df=pd.DataFrame(result_arr)
添加回答
舉報(bào)
0/150
提交
取消