【求助】Python爬虫-把[dict,dict,dict]保存到excel
python吧
全部回复
仅看楼主
level 1
网页每页是表格,返回内容是列表,列表中是字典,如何保存到Excel中呢,整个列表相当于一个表格,每个字典的值是表格的一行。
2020年01月10日 00点01分 1
level 1
好比说,第一页内容是
[{"name":"风向(act.)","id":"WD","device":"weather","timestamp":
15537838259
03,"scanDateStr":"2019-03-28 14:37:05","value":111.1,"interval":10}]
[{"name":"风向(act.)","id":"WD","device":"weather","timestamp":
15537838360
97,"scanDateStr":"2019-03-28 14:37:16","value":107.4,"interval":10}]
第二页内容是
[{"name":"风向(act.)","id":"WD","device":"weather","timestamp":
15537838259
01,"scanDateStr":"2019-03-28 14:37:05","value":111.1,"interval":10}]
[{"name":"风向(act.)","id":"WD","device":"weather","timestamp":
15537838360
902,"scanDateStr":"2019-03-28 14:37:16","value":107.4,"interval":10}]
第三页是
[{"name":"风向(act.)","id":"WD","device":"weather","timestamp":
15537838259
04,"scanDateStr":"2019-03-28 14:37:05","value":111.1,"interval":10}]
[{"name":"风向(act.)","id":"WD","device":"weather","timestamp":
15537838360
95,"scanDateStr":"2019-03-28 14:37:16","value":107.4,"interval":10}]
共3217页。
2020年01月10日 00点01分 2
1