Python代码如何识别json文件中这种一个相同格式下的不同内容？并且转录在Excel

2024-12-26 20:30:49 309 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Python自动化：3分钟搞定微信收藏链接批量导出到TXT（附完整代码）本文介绍如何使用Python自动化工具在3分钟内将微信收藏链接批量导出到TXT文件。通过模拟人类操作和OCR技术，脚本高效处理大量链接，显著提升工作效率，并附有完整代码和实战避坑指南。阅读详情

"item": [
{
"itemName": {
"raw": "丙氨酸氨基转移酶",
"pos": [
81,
284,
236,
309
],
"value": "丙氨酸氨基转移酶",
"score": 0.9
},
"consequence": {
"raw": "31",
"pos": [
255,
279,
292,
313
],
"value": "31",
"score": 0.9
},
"reference": {
"raw": "7--40IU/L",
"pos": [
400,
280,
491,
310
],
"value": "7~40IU/L",
"score": 0.9
}
},
{
"itemName": {
"raw": "天门冬氨酸氨基转移",
"pos": [
78,
314,
254,
337
],
"value": "天门冬氨酸氨基转移",
"score": 0.9
},
"consequence": {
"raw": "28",
"pos": [
256,
311,
291,
340
],
"value": "28",
"score": 0.9
},
"reference": {
"raw": "13--35IU/L",
"pos": [
400,
307,
500,
338
],
"value": "13~35IU/L",
"score": 0.9
}
},
{
"itemName": {
"raw": "酶",
"pos": [
73,
339,
108,
372
],
"value": "酶",
"score": 0.9
},
"consequence": {},
"reference": {}
},
{
"itemName": {
"raw": "碱性磷酸酶",
"pos": [
72,
369,
178,
397
],
"value": "碱性磷酸酶",
"score": 0.9
},
"consequence": {
"raw": "98",
"pos": [
253,
365,
291,
398
],
"value": "98",
"score": 0.9
},
"reference": {
"raw": "50--1351U/L",
"pos": [
400,
367,
509,
394
],
"value": "50~1351U/L",
"score": 0.9
}
},
{
"itemName": {
"raw": "y-谷氨酰基转移酶",
"pos": [
72,
401,
234,
425
],
"value": "y-谷氨酰基转移酶",
"score": 0.9
},
"consequence": {
"raw": "22",
"pos": [
251,
395,
289,
429
],
"value": "22",
"score": 0.9
},
"reference": {
"raw": "7--451U/L",
"pos": [
399,
394,
489,
425
],
"value": "7~451U/L",
"score": 0.9
}
},
{
"itemName": {
"raw": "尿素",
"pos": [
68,
426,
122,
462
],
"value": "尿素",
"score": 0.9
},
"consequence": {
"raw": "4.7",
"pos": [
249,
425,
292,
459
],
"value": "4.7",
"score": 0.9
},
"reference": {
"raw": "2.5--7.1mmol/L",
"pos": [
400,
429,
535,
450
],
"value": "2.5~7.1mmol/L",
"score": 0.9
}
},
{
"itemName": {
"raw": "肌酐",
"pos": [
68,
456,
121,
492
],
"value": "肌酐",
"score": 0.9
},
"consequence": {
"raw": "55",
"pos": [
249,
455,
286,
488
],
"value": "55",
"score": 0.9
},
"reference": {
"raw": "53--97umol/L",
"pos": [
399,
457,
523,
481
],
"value": "53~97umol/L",
"score": 0.9
}
},