我正在尝试从JSON我的json格式如下
{
eventId: "9668383e-ec96-4d6a-b873-2312dd008e7b",
eventType: "PlannedCustomerChoiceWasUpdated",
publishedDate: "2016-05-31T18:52:29.219Z",
payload: {
plannedCustomerChoiceId: "e9301a6e-7ccf-4c89-bd05-19c1b9067a61"
},
_links: {
self: {
href: "http://gbp-router.gapinc.dev:8080/planning-service/_feeds/planning.planning-service.planned-customer-choice-events/entries/d2de62a6-1e0f-430a-bf3f-2df711f64beb"
},
source: {
href: "http://gbp-router.gapinc.dev:8080/planning-service/planning/buy-plan/planned-customer-choices/e9301a6e-7ccf-4c89-bd05-19c1b9067a61"
}
}
}
我需要列作为单个记录。你知道吗
这就是我到现在为止所做的。你知道吗
from pandas.io.json import json_normalize
a = { "eventId": "9668383e-ec96-4d6a-b873-2312dd008e7b", "eventType": "PlannedCustomerChoiceWasUpdated", "publishedDate": "2016-05-31T18:52:29.219Z", "payload": { "plannedCustomerChoiceId": "e9301a6e-7ccf-4c89-bd05-19c1b9067a61" }, "_links": { "self": { "href": "http://gbp-router.gapinc.dev:8080/planning-service/_feeds/planning.planning-service.planned-customer-choice-events/entries/d2de62a6-1e0f-430a-bf3f-2df711f64beb" }, "source": { "href": "http://gbp-router.gapinc.dev:8080/planning-service/planning/buy-plan/planned-customer-choices/e9301a6e-7ccf-4c89-bd05-19c1b9067a61" } } }
b = json_normalize(a)
print b
我无法达到预期的格式。有人能帮我吗。你知道吗
使用b=pd.数据帧(a) 数据帧的格式如下。你知道吗
\单位
links \
plannedCustomerChoiceId NaN
self {u'href': u'http://gbp-router.gapinc.dev:8080/...
source {u'href': u'http://gbp-router.gapinc.dev:8080/...
eventId \
plannedCustomerChoiceId 9668383e-ec96-4d6a-b873-2312dd008e7b
self 9668383e-ec96-4d6a-b873-2312dd008e7b
source 9668383e-ec96-4d6a-b873-2312dd008e7b
eventType \
plannedCustomerChoiceId PlannedCustomerChoiceWasUpdated
self PlannedCustomerChoiceWasUpdated
source PlannedCustomerChoiceWasUpdated
payload \
plannedCustomerChoiceId e9301a6e-7ccf-4c89-bd05-19c1b9067a61
self NaN
source NaN
publishedDate
plannedCustomerChoiceId 2016-05-31T18:52:29.219Z
self 2016-05-31T18:52:29.219Z
source 2016-05-31T18:52:29.219Z
我要找的是
9668383e-ec96-4d6a-b873-2312dd008e7b,PlannedCustomerChoiceWasUpdated,2016-05-31T18:52:29.219Z,e9301a6e-7ccf-4c89-bd05-19c1b9067a61,http://gbp-router.gapinc.dev:8080/planning-service/planning/buy-plan/planned-customer-choices/e9301a6e-7ccf-4c89-bd05-19c1b9067a61
我认为可以先更改列的顺序,然后^{} :
如果需要更改列名:
相关问题 更多 >
编程相关推荐