我想从一个给定的网址获取JSON数据而那个JSON数据我必须转换成XML形式(I want to fetch json data from a given url And that json data i have to convert into xml form)
我想从给定的URL获取JSON数据
http://www.deanclatworthy.com/imdb/?=The+Green+Mile并将JSON数据转换为XML。 我用urllib和json将JSON对象转换成python字典。
这是我的代码:
import json json_string = '{"imdbid":"tt0120689","imdburl":"http:\/\/www.imdb.com\/title\/tt0120689\/","genres":"Crime,Drama,Fantasy,Mystery","languages":"English ,French","country":"USA","votes":"281023","stv":0,"series":0,"rating":"8.4","title":"The Green Mile","year":"1999","usascreens":2875,"ukscreens":340}' new_python_object = json.loads(json_string) print(json_string) print() print (new_python_object)结果是:
{"imdbid":"tt0120689","imdburl":"http:\/\/www.imdb.com\/title\/tt0120689\/","genres":"Crime,Drama,Fantasy,Mystery","languages":"English ,French","country":"USA","votes":"281023","stv":0,"series":0,"rating":"8.4","title":"The Green Mile","year":"1999","usascreens":2875,"ukscreens":340} {'ukscreens': 340, 'rating': '8.4', 'genres': 'Crime,Drama,Fantasy,Mystery', 'title': 'The Green Mile', 'series': 0, 'imdbid': 'tt0120689', 'year': '1999', 'votes': '281023', 'languages': 'English ,French', 'stv': 0, 'country': 'USA', 'usascreens': 2875, 'imdburl': 'http://www.imdb.com/title/tt0120689/'}I want to fetch JSON data from a given url
http://www.deanclatworthy.com/imdb/?=The+Green+Mileand convert the JSON data into XML. I have used urllib and json to convert JSON objects into python dictionary.
Here is my code:
import json json_string = '{"imdbid":"tt0120689","imdburl":"http:\/\/www.imdb.com\/title\/tt0120689\/","genres":"Crime,Drama,Fantasy,Mystery","languages":"English ,French","country":"USA","votes":"281023","stv":0,"series":0,"rating":"8.4","title":"The Green Mile","year":"1999","usascreens":2875,"ukscreens":340}' new_python_object = json.loads(json_string) print(json_string) print() print (new_python_object)And the result:
{"imdbid":"tt0120689","imdburl":"http:\/\/www.imdb.com\/title\/tt0120689\/","genres":"Crime,Drama,Fantasy,Mystery","languages":"English ,French","country":"USA","votes":"281023","stv":0,"series":0,"rating":"8.4","title":"The Green Mile","year":"1999","usascreens":2875,"ukscreens":340} {'ukscreens': 340, 'rating': '8.4', 'genres': 'Crime,Drama,Fantasy,Mystery', 'title': 'The Green Mile', 'series': 0, 'imdbid': 'tt0120689', 'year': '1999', 'votes': '281023', 'languages': 'English ,French', 'stv': 0, 'country': 'USA', 'usascreens': 2875, 'imdburl': 'http://www.imdb.com/title/tt0120689/'}最满意答案
使用请求和dict2xml库:
>>> import requests >>> r = requests.get("http://www.deanclatworthy.com/imdb/?q=The+Green+Mile") >>> import dict2xml >>> xml = dict2xml.dict2xml(r.json) >>> print xml <country>USA</country> <genres>Crime,Drama,Fantasy,Mystery</genres> <imdbid>tt0120689</imdbid> <imdburl>http://www.imdb.com/title/tt0120689/</imdburl> <languages>English,French</languages> <rating>8.5</rating> <runtime>189min</runtime> <series>0</series> <stv>0</stv> <title>The Green Mile</title> <ukscreens>340</ukscreens> <usascreens>2875</usascreens> <votes>344054</votes> <year>1999</year>Using the requests and dict2xml libraries:
>>> import requests >>> r = requests.get("http://www.deanclatworthy.com/imdb/?q=The+Green+Mile") >>> import dict2xml >>> xml = dict2xml.dict2xml(r.json) >>> print xml <country>USA</country> <genres>Crime,Drama,Fantasy,Mystery</genres> <imdbid>tt0120689</imdbid> <imdburl>http://www.imdb.com/title/tt0120689/</imdburl> <languages>English,French</languages> <rating>8.5</rating> <runtime>189min</runtime> <series>0</series> <stv>0</stv> <title>The Green Mile</title> <ukscreens>340</ukscreens> <usascreens>2875</usascreens> <votes>344054</votes> <year>1999</year>
更多推荐
发布评论