用python实现多嵌套json数据存入excel表格——以美食数据为例

JSON至Excel：解析与转换实践

最新推荐文章于 2022-10-28 21:26:57 发布

原创

最新推荐文章于 2022-10-28 21:26:57 发布 · 置顶 · 4.9k 阅读

20 ·

CC 4.0 BY-SA版权

json嵌套格式如下：

主要为
[区位[商家{菜单}]，区位[商家{菜单}],…,区位[商家{菜单}]}的数据格式

{
	"id": 13779,
	"code": "xa",
	"pinyin": "xian",
	"addr": "西安",
	"areaId": 113,
	"areaName": "碑林区",
	"level": 2,
	"parentId": 2131,
	"eshopList": [
		{
			"id": 2106,
			"addrId": 5897,
			"shopId": "E9347828247610564279",
			"name": "极速披萨外卖",
			"brand": null,
			"recentOrderNum": 1335,
			"imagePath": "078a1ff5a967e578bee6614d93adf9fajpeg",
			"rating": "4.7",
			"ratingCount": "376",
			"address": "西安市碑林区东关南街29号2号楼101室",
			"phone": "13759967293 13619256197",
			"latitude": "34.25375",
			"longitude": "108.97534",
			"description": null,
			"areaName": "碑林区",
			"city": null,
			"limitNum": null,
			"menuList": [省略，其中包含多个字典]
			"eaddr": null
		},
		{
			"id": 5450,
			"addrId": 5906,
			"shopId": "E8089558816195246680",
			"name": "麻辣诱惑小龙虾(南稍门店)",
			"brand": null,
			"recentOrderNum": 893,
			"imagePath": "7b257dc4ca9f48179834f09de8400c0djpeg",
			"rating": "4