记录一次字符串转字典

本文记录了一段使用Python将字符串转换为字典,并遍历数据展示支付记录的过程,特别是提取了购买状态、金额和时间信息。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

import json

a="{'total':'27','rows':[{'trade_no':'2023072322362160827','out_trade_no':'2023072322362160827','api_trade_no':'2023072322360187078','uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'3.00','realmoney':'3.24','getmoney':'3.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072322362160827','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072322362160827','param':null,'addtime':'2023-07-23 22:36:21','endtime':'2023-07-23 22:37:16','date':'2023-07-23',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072315351316383','out_trade_no':'2023072315351316383','api_trade_no':'2023072315345463604','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'2.12','realmoney':'2.29','getmoney':'2.12','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072315351316383','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072315351316383','param':null,'addtime':'2023-07-23 15:35:13','endtime':'2023-07-23 15:35:45','date':'2023-07-23',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072315340831992','out_trade_no':'2023072315340831992','api_trade_no':null,'uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'2.12','realmoney':'2.29','getmoney':'2.12','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072315340831992','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072315340831992','param':null,'addtime':'2023-07-23 15:34:08','endtime':null,'date':null,domain2':null,,'buyer':'','status':'0','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072309361292160','out_trade_no':'2023072309361292160','api_trade_no':'2023072309360233764','uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.96','getmoney':'12.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309361292160','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309361292160','param':null,'addtime':'2023-07-23 09:36:12','endtime':'2023-07-23 09:36:44','date':'2023-07-23',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072309354553572','out_trade_no':'2023072309354553572','api_trade_no':null,'uid':'1069','tid':'3','type':'0','channel':'0','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.66','realmoney':null,'getmoney':null,'notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309354553572','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309354553572','param':null,'addtime':'2023-07-23 09:35:45','endtime':null,'date':null,domain2':null,,'buyer':'','status':'0','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':null,'typename':null,'typeshowname':null},{'trade_no':'2023072309323034090','out_trade_no':'2023072309323034090','api_trade_no':null,'uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.96','getmoney':'12.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309323034090','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309323034090','param':null,'addtime':'2023-07-23 09:32:30','endtime':null,'date':null,domain2':null,,'buyer':'','status':'0','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072309315079812','out_trade_no':'2023072309315079812','api_trade_no':null,'uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.96','getmoney':'12.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309315079812','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072309315079812','param':null,'addtime':'2023-07-23 09:31:50','endtime':null,'date':null,domain2':null,,'buyer':'','status':'0','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072218203389726','out_trade_no':'2023072218203389726','api_trade_no':'2023072218201870628','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'2.00','realmoney':'2.16','getmoney':'2.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072218203389726','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072218203389726','param':null,'addtime':'2023-07-22 18:20:33','endtime':'2023-07-22 18:22:22','date':'2023-07-22',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072218152914618','out_trade_no':'2023072218152914618','api_trade_no':'2023072218151899964','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.96','getmoney':'12.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072218152914618','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072218152914618','param':null,'addtime':'2023-07-22 18:15:29','endtime':'2023-07-22 18:16:53','date':'2023-07-22',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072215362123121','out_trade_no':'2023072215362123121','api_trade_no':'2023072215360621201','uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'11.00','realmoney':'11.88','getmoney':'11.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072215362123121','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072215362123121','param':null,'addtime':'2023-07-22 15:36:21','endtime':'2023-07-22 15:38:10','date':'2023-07-22',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072215341449795','out_trade_no':'2023072215341449795','api_trade_no':null,'uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.96','getmoney':'12.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072215341449795','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072215341449795','param':null,'addtime':'2023-07-22 15:34:14','endtime':null,'date':null,domain2':null,,'buyer':'','status':'0','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072211554059279','out_trade_no':'2023072211554059279','api_trade_no':'2023072211553369122','uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'35.00','realmoney':'37.80','getmoney':'35.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072211554059279','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072211554059279','param':null,'addtime':'2023-07-22 11:55:40','endtime':'2023-07-22 11:56:06','date':'2023-07-22',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072122093227563','out_trade_no':'2023072122093227563','api_trade_no':'2023072122093251323','uid':'1069','tid':'3','type':'1','channel':'1','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.00','getmoney':'11.04','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072122093227563','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072122093227563','param':null,'addtime':'2023-07-21 22:09:32','endtime':'2023-07-21 22:10:05','date':'2023-07-21',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'alipay','typeshowname':'\u652f\u4ed8\u5b9d'},{'trade_no':'2023072120460881478','out_trade_no':'2023072120460881478','api_trade_no':'2023072120455742928','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'50.00','realmoney':'50.00','getmoney':'46.00','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072120460881478','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072120460881478','param':null,'addtime':'2023-07-21 20:46:08','endtime':'2023-07-21 20:46:32','date':'2023-07-21',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072020152479347','out_trade_no':'2023072020152479347','api_trade_no':'2023072020164284028','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'60.00','realmoney':'60.00','getmoney':'55.20','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072020152479347','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072020152479347','param':null,'addtime':'2023-07-20 20:15:24','endtime':'2023-07-20 20:17:33','date':'2023-07-20',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072020095880330','out_trade_no':'2023072020095880330','api_trade_no':'2023072020094883319','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'61.00','realmoney':'61.00','getmoney':'56.12','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072020095880330','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072020095880330','param':null,'addtime':'2023-07-20 20:09:58','endtime':'2023-07-20 20:10:17','date':'2023-07-20',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072014233651180','out_trade_no':'2023072014233651180','api_trade_no':'2023072014232731888','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'11.00','realmoney':'11.00','getmoney':'10.12','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072014233651180','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072014233651180','param':null,'addtime':'2023-07-20 14:23:36','endtime':'2023-07-20 14:24:45','date':'2023-07-20',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023072010495177423','out_trade_no':'2023072010495177423','api_trade_no':'2023072010494190892','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'12.00','realmoney':'12.00','getmoney':'11.04','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023072010495177423','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023072010495177423','param':null,'addtime':'2023-07-20 10:49:51','endtime':'2023-07-20 10:50:10','date':'2023-07-20',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023071912250798690','out_trade_no':'2023071912250798690','api_trade_no':'2023071912250152516','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'60.00','realmoney':'60.00','getmoney':'55.20','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023071912250798690','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023071912250798690','param':null,'addtime':'2023-07-19 12:25:07','endtime':'2023-07-19 12:25:33','date':'2023-07-19',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'},{'trade_no':'2023071910135632956','out_trade_no':'2023071910135632956','api_trade_no':'2023071910134957148','uid':'1069','tid':'3','type':'2','channel':'2','name':'\u5728\u7ebf\u6536\u6b3e','money':'60.00','realmoney':'60.00','getmoney':'55.20','notify_url':'http:\/\/\/paypage\/success.php?trade_no=2023071910135632956','return_url':'http:\/\/\/paypage\/success.php?trade_no=2023071910135632956','param':null,'addtime':'2023-07-19 10:13:56','endtime':'2023-07-19 10:14:18','date':'2023-07-19',domain2':null,,'buyer':'','status':'1','notify':'0','notifytime':null,'invite':'0','invitemoney':null,'plugin':'epay','typename':'wxpay','typeshowname':'\u5fae\u4fe1\u652f\u4ed8'}]}"

a = a.replace("'", '"')
data = json.loads(a)
# 转成json数据
# print(data)

zi=""
# 遍历data中的rows 并输出前三行的数据
for row in data['rows'][:3]:
    addtime = row['addtime']
    money = row['money']
    status = row['status']

    if status=="1":
        zt="已购买"
    else:
        zt="未购买"

    zi+=f'时间: {addtime}, 金额: {money}, status: {zt}'+"\n"
print(zi)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

qq_58758353

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值