想要处理用python抓取的数据，并且要导出到excel？ 10

这是我抓取的网页代码然后网站的显示是这样的我想要处理成excel请问怎样处理，怎样导出？谢谢啦... 这是我抓取的网页代码然后网站的显示是这样的我想要处理成excel请问怎样处理，怎样导出？谢谢啦展开





 我来答

2个回答

#合辑# 面试问优缺点怎么回答最加分？

玩转数据处理
2017-01-17 · 数据处理,Python,dotnet

玩转数据处理

采纳数：1613 获赞数：3794

向TA提问私信TA

关注

展开全部

import json

data = {"data":[
{"id":"1","price_data":"2017-01-06","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-02","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-03","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-05","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-07","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"}
]}

json_str = json.dumps(data)
jsonData = json.loads(json_str)
all_data = jsonData["data"]
for item in all_data:
        #导出代码在这里实现
	print item['price_data'],item['nav'],item['cumulativate_nav_withdrawa1']

本回答被网友采纳