将字典解析为多个值并用python生成表

import requests import json url = "http://api.elsevier.com/content/search/author" querystring = {"apiKey":"xxxxxxxxxxxxx","query":["AUTHLASTNAME(Volaire)","AUTHFIRST(F)"]} headers = { 'cache-control': "no-cache", 'postman-token': "5c0df5ad-2645-8e88-0f8a-10795757b4ec" } response = requests.request("GET", url, headers=headers, params=querystring) results = response.json()

{ "search-results": { "opensearch:totalResults": "3", "opensearch:startIndex": "0", "opensearch:itemsPerPage": "3", "opensearch:Query": { "@role": "request", "@searchTerms": "AUTHLASTNAME(Volaire)", "@startPage": "0" }, "link": [ { "@_fa": "true", "@href": "http://api.elsevier.com/content/search/author?start=0&count=25&query=AUTHLASTNAME%28Volaire%29&apiKey=4275854a6db51fb373ef69fb1337ccf9", "@ref": "self", "@type": "application/json" }, { "@_fa": "true", "@href": "http://api.elsevier.com/content/search/author?start=0&count=25&query=AUTHLASTNAME%28Volaire%29&apiKey=4275854a6db51fb373ef69fb1337ccf9", "@ref": "first", "@type": "application/json" } ], "entry": [ { "@_fa": "true", "link": [ { "@_fa": "true", "@href": "http://api.elsevier.com/content/author/author_id/55910750900", "@ref": "self" }, { "@_fa": "true", "@href": "http://api.elsevier.com/content/search/author?query=au-id%2855910750900%29", "@ref": "search" }, { "@_fa": "true", "@href": "https://www.scopus.com/author/citedby.uri?partnerID=HzOxMe3b&citedAuthorId=55910750900&origin=inward", "@ref": "scopus-citedby" }, { "@_fa": "true", "@href": "https://www.scopus.com/authid/detail.uri?partnerID=HzOxMe3b&authorId=55910750900&origin=inward", "@ref": "scopus-author" } ], "prism:url": "http://api.elsevier.com/content/author/author_id/55910750900", "dc:identifier": "AUTHOR_ID:55910750900", "eid": "9-s2.0-55910750900", "preferred-name": { "surname": "Volaire", "given-name": "Florence A.", "initials": "F.A." }, "name-variant": [ { "@_fa": "true", "surname": "Volaire", "given-name": "F.", "initials": "F." }, { "@_fa": "true", "surname": "Volaire", "given-name": "Florence", "initials": "F." } ], "document-count": "41", "subject-area": [ { "@abbrev": "ENVI", "@frequency": "7", "$": "Environmental Science (all)" }, { "@abbrev": "AGRI", "@frequency": "50", "$": "Agricultural and Biological Sciences (all)" }, { "@abbrev": "ENGI", "@frequency": "4", "$": "Engineering (all)" } ], "affiliation-current": { "affiliation-url": "http://api.elsevier.com/content/affiliation/affiliation_id/60020315", "affiliation-id": "60020315", "affiliation-name": "INRA Institut National de La Recherche Agronomique", "affiliation-city": "Paris", "affiliation-country": "France" } }, { "@_fa": "true", "link": [ { "@_fa": "true", "@href": "http://api.elsevier.com/content/author/author_id/6603570012", "@ref": "self" }, { "@_fa": "true", "@href": "http://api.elsevier.com/content/search/author?query=au-id%286603570012%29", "@ref": "search" }, { "@_fa": "true", "@href": "https://www.scopus.com/author/citedby.uri?partnerID=HzOxMe3b&citedAuthorId=6603570012&origin=inward", "@ref": "scopus-citedby" }, { "@_fa": "true", "@href": "https://www.scopus.com/authid/detail.uri?partnerID=HzOxMe3b&authorId=6603570012&origin=inward", "@ref": "scopus-author" } ], "prism:url": "http://api.elsevier.com/content/author/author_id/6603570012", "dc:identifier": "AUTHOR_ID:6603570012", "eid": "9-s2.0-6603570012", "preferred-name": { "surname": "Volaire", "given-name": "Florence", "initials": "F." }, "name-variant": [ { "@_fa": "true", "surname": "Volaire", "given-name": "F.", "initials": "F." } ], "document-count": "8", "subject-area": [ { "@abbrev": "AGRI", "@frequency": "13", "$": "Agricultural and Biological Sciences (all)" }, { "@abbrev": "BIOC", "@frequency": "1", "$": "Biochemistry, Genetics and Molecular Biology (all)" } ], "affiliation-current": { "affiliation-url": "http://api.elsevier.com/content/affiliation/affiliation_id/60020315", "affiliation-id": "60020315", "affiliation-name": "INRA Institut National de La Recherche Agronomique", "affiliation-city": "Paris", "affiliation-country": "France" } }, { "@_fa": "true", "link": [ { "@_fa": "true", "@href": "http://api.elsevier.com/content/author/author_id/24571987100", "@ref": "self" }, { "@_fa": "true", "@href": "http://api.elsevier.com/content/search/author?query=au-id%2824571987100%29", "@ref": "search" }, { "@_fa": "true", "@href": "https://www.scopus.com/author/citedby.uri?partnerID=HzOxMe3b&citedAuthorId=24571987100&origin=inward", "@ref": "scopus-citedby" }, { "@_fa": "true", "@href": "https://www.scopus.com/authid/detail.uri?partnerID=HzOxMe3b&authorId=24571987100&origin=inward", "@ref": "scopus-author" } ], "prism:url": "http://api.elsevier.com/content/author/author_id/24571987100", "dc:identifier": "AUTHOR_ID:24571987100", "eid": "9-s2.0-24571987100", "preferred-name": { "surname": "Volaire", "given-name": "M.", "initials": "M." }, "name-variant": [ { "@_fa": "true", "surname": "Volaire", "given-name": null, "initials": "M." } ], "document-count": "1", "subject-area": [ { "@abbrev": "CHEM", "@frequency": "2", "$": "Chemistry (all)" }, { "@abbrev": "BIOC", "@frequency": "1", "$": "Biochemistry, Genetics and Molecular Biology (all)" }, { "@abbrev": "ENVI", "@frequency": "1", "$": "Environmental Science (all)" }

2条回答

网友

1楼 · 编辑于 2024-04-25 22:36:12

也许是这样的？你在这里所拥有的一切都已步入正轨：）

print(results['search-results']['link']['entry']['dc:identifier'])

试试这个。它应该可以工作，因为您想要的值在json列表中的对象中。你知道吗

some_dict = [
    { 
        "dc:identifiers": r['dc:identifier'], 
        "AUTHLASTNAME":  r['preferred-name']['surname'],
        "AUTHFIRST":  r['preferred-name']['given-name'],
    } for r in results['search-results']['entry']
]

显然，这是假设您的json保持这种格式。还要检查我输入的结果['search-results']['entry']是否正确。我没有仔细检查

网友

2楼 · 编辑于 2024-04-25 22:36:12

这将获得第1部分的信息：

print( [e["dc:identifier"] for e in results['search-results']['entry']] )

您可以对每个entry中的其他信息使用类似的内容。你知道吗

至于第2部分：python没有表。你知道吗

相关问题更多 >

编程相关推荐

热门问题

热门文章