背景:读取json字符串相以列表的形式输出,这样方便json字符串和csv文件数据进行比较,以便验证导入数据是否正确
json字符串
{
"total":527,
"items":[
{
"id":8,
"appName":"百度",
"packageName":"com.baidu.searchbox",
"categoryId":9,
"createTime":"2021-07-20 15:50:25",
"updateTime":"2021-07-20 15:50:25",
"appAttr":1,
"categoryName":"软件/生活",
"appChannelInfos":[
{
"id":13,
"appId":8,
"marketShortName":"hailiang",
"md5":"0ef6e1def688faf2913c0236e8cf00ed",
"channelPackageName":"com.baidu.searchbox",
"cpChannel":"12",
"settlementMode":"",
"minAmount":0,
"maxAmount":0,
"price":0.36,
"startExpiryDate":"1970-01-01 08:00:00",
"endExpiryDate":"1970-01-01 08:00:00",
"versionDesc":"",
"permissionType":1,
"apk64Info":{
"versionName":"12.21.0.12",
"versionCode":106169856,
"apkUrl":"http://imtt.dd.qq.com/16891/apk/0EF6E1DEF688FAF2913C0236E8CF00ED.apk?fsname=com.baidu.searchbox_12.21.0.12_106169856.apk\u0026csr=a24f\u0026c=store360",
"fileSize":129587333,
"md5":"0ef6e1def688faf2913c0236e8cf00ed"
},
"apk32Info":"",
"marketName":"嗨量"
}
],
"parentCategoryId":0
},
{
"id":9,
"appName":"兼职侠",
"packageName":"com.jianzhiman.customer",
"categoryId":9,
"createTime":"2021-07-20 15:50:25",
"updateTime":"2021-07-20 15:50:25",
"appAttr":1,
"categoryName":"软件/生活",
"appChannelInfos":[
{
"id":14,
"appId":9,
"marketShortName":"hailiang",
"md5":"c75fd082842529e462130f2bedeff5fd",
"channelPackageName":"com.jianzhiman.customer",
"cpChannel":"12",
"apkType":1,
"icon":"http://img-
"downloadCount":0,
"rating":"",
"privacyAggreement":"",
"arch":0,
"isAd":1,
"state":1,
"createTime":"2021-07-20 15:50:25",
"updateTime":"2021-08-13 16:23:14",
"smallIcon":"",
"vedio":"",
"screenSize":"全部",
"permissionType":1,
"apk64Info":{
"versionName":"1.9.14",
"versionCode":10914,
"apkUrl":"http://imtt.dd.qq.com/16891/apk/C75FD082842529E462130F2BEDEFF5FD.apk?fsname=com.jianzhiman.customer_1.9.14_10914.apk\u0026csr=a24f\u0026c=store360",
"fileSize":30650376,
"md5":"c75fd082842529e462130f2bedeff5fd"
},
"apk32Info":"",
"marketName":"嗨量"
}
],
"parentCategoryId":0
}
]
}
代码实现:
"""
import json
#读取json字符串并把字典的value值转化为列表
def file():
with open('test', "r", encoding="utf-8") as n:
#读取文件
readtest=json.load(n)
#取出item对应的value值
data_boby=readtest["items"]
#可有可无,只要是删除total对应的key和value
del readtest['total']
for item in data_boby:
#开心心---把字典中value值取出来,以列表的形式展示
row=[str(item["id"]),item["appName"] , item["packageName"],item["categoryId"],item["createTime"],item["updateTime"],item["appAttr"],item["categoryName"],item["appChannelInfos"]]
print(row)
#print(item)
if __name__ == "__main__":
file();
结果: