This is OCR results of 5 methods for a strcutured lab report. The methods name is 450i,…
- User
This is OCR results of 5 methods for a strcutured lab report. The methods name is 450i, QVL_72b_O, LLama31_70B, QVL_7b_O, and QVL_7b_R. The 450i contains metadata and test and value results. Other methods contains 5 section in csv like format and seperated by `
. The first section is contains test, value, unit, reference range. the second section contains category of test, test, value, unit, and reference range. The third section contains 4 answer to this 4 question in each line: 1- It is medical report or not 2- Type of medical report 3- Category of medical report 4- Is it medical laboratory report category or not The fourth section contains metadata about lab center and patient in each line in this order: 1- patient name 2- patient age 3- date of lab report 4- lab center name 5- lab center phone number 6- lab center city The fifth section is answer to this questions: 1- This page is which page of a multi page report? 2- There is any attachment? Please compare them in case of test and resutls and category and metadata in sperate tables strictly with csv format and no extra explanation and` between tables. Frist output table should have all mention test names in rows and each ocr methods in columns and the contents should be the value of tests. Second output table should have all mention test names in rows and each ocr methods in columns and the contents should be the unit of tests. Third output table should have all mention test names in rows and each ocr methods in columns and the contents should be the reference ranges of tests. Fourth output table should have 4 question of is medical test or not, type of medical test, category of medical report, and lab test or not in rows and each ocr methods in columns and the contents should be the ocr method prediction of that question. Fifth output table should have 6 mentioned metadata that are patient name, patient age,date of lab report, lab center name, lab center phone number, lab center city in order in rows and ocr test names in columns. Sixth output table should have 2 rows for page information and availability of attachment in each row and the ocr methods in columns. Use Quotatin for each element of output csvs. If one of the OCR results is empty keep them in the compraison tables. Seperate output csv tables by 2 nelines. keep the format with no intro and title in sake of machine readablity:
450i method result:"Type of Test","Yes/No" "Medical Lab Test","Yes"
"Metadata" "Patient ID","14302/26" "Phone Number - Patient","Not available" "Lab Center ID","14302/29" "Phone Number - Lab Center","Not available" "Page Number","3"
"Test","Result","Unit","Risk","Reference" "FBS","119","mg/dL","H","74-106" "BUN","11","mg/dL","-","6-21.5" "Cr","0.9","mg/dL","-","0.6-1.2" "Cholesterol","258","mg/dL","H","<200 : D, 200-239 : BH, >240 : H" "Triglyceride","142","mg/dL","-","<150 : N, 150-199 : BH, >200 : H" "HDL Cholesterol","46","mg/dL","-","<35 : HR, >50 : LR" "LDL Cholesterol","196","mg/dL","H","Optimal : <130, AO : 130-160, HR : >160" "AST(SGOT)","8","U/L","-","<34" "ALT(SGPT)","5","U/L","-","<34" "Alk P","146","U/L","-","<240" "Ca","9.4","mg/dL","-","8.6-10.0" "P","2.9","mg/dL","-","2.4-4.5" "Mg","1.9","mg/dL","-","1.9-2.5" "CRP","2.5","mg/L","-","0-10" "RF","2.9","IU/mL","-","0-24" "TSH(CL)","0.41","mlU/L","L","2-12 (P) : 0.64 - 6.27, 12-18 (A) : 0.51 - 4.94, >12 (A) : 0.55 - 4.78" "Vitamin B12","32","pmol/L","-","21-123" "ANA","Negative","-","-","Negative" "Anti Ds DNA","9.5","IU/mL","-","Negative <20, Borderline 20-25, Positive >25"
QVL_72b_O method result:
LLama31_70B method result:
"Test Name","Result Value","Unit","Reference Range" "Age","32","-","-" "Biochemistry","1.5","-","-" "FBS","119","mg/dL","74-106" "BUN","0.9","mg/dL","0.6-1.2" "Cr","0.6-1.2","mg/dL","0.6-1.2" "Cholesterol","258","mg/dL","Normal <150, 201-239 Borderline High, =>240 High" "Triglyceride","142","mg/dL","150-199 Borderline High, >200 High" "HDL Cholesterol","46","mg/dL","35 High risk, >=50 Low risk" "LDL Cholesterol","196","mg/dL","H Optimal<130, 130-160 Above Optimal, >160 High Risk" "AST(SGOT)","8","U/L","Up to 40" "ALT(SGPT)","5","U/L","<34" "Alk P","146","U/L","<240" "Ca","9.9","mg/dL","8.6-10.0" "P","2.9","mg/dL","2.4-4.4" "Mg","2.0","mg/dL","1.9-2.5" "CRP","2.5","mg/L","0-10" "RF","2.9","IU/mL","0-24" "TSH(CL)","0.41","mIU/L","L2-<12 Pediatrics, 0.64-6.27, 12 to<18 (Adolescents) 0.55-4.78, >12 Adults" "Vitamin B12","32","pmol/L","21-123" "ANA","Negative","-","Negative" "Anti Ds DNA","9.5","IU/mL","Negative 20, Borderline 20-25, Positive >25"
"Test Category","Test Name","Test Value","Test Unit","Reference Range" "Demographics","Age","32","-","-" "Demographics","Biochemistry","-","-","-" "Biochemistry","Biochemistry (bv Mindray BS-800)","1.5","-","-" "Hormones","TSH(CL)","0.41","mIU/L","0.55-4.78, 0.51-4.94 ( >12Adults:, 0.64-6.27 (12 to<18 (Adolescents)" "Vitamins","Vitamin B12","32","pmol/L","21-123" "Autoimmune","ANA","Negative","-","Negative" "Autoimmune","Anti Ds DNA","9.5","IU/mL","Negative 20, Borderline 20-25, Positive >25" "Autoimmune","RF","2.9","IU/mL","0-24" "Immune Response","CRP","2.5","mg/L","0-10" "Lipids","Cholesterol","258","mg/dL","Normal <150, 201-239 Borderline High, =>240 High" "Lipids","Triglyceride","142","mg/dL","150-199 Borderline High, >200 High" "Lipids","HDL Cholesterol","46","mg/dL","35 High risk, >=50 Low risk" "Lipids","LDL Cholesterol","196","mg/dL","H Optimal<130, 130-160 Above Optimal, >160 High Risk" "Kidney Functions","BUN","0.9","mg/dL","0.6-1.2" "Kidney Functions","Cr","0.6-1.2","mg/dL","0.6-1.2" "Electrolytes","Ca","9.9","mg/dL","8.6-10.0" "Electrolytes","P","2.9","mg/dL","2.4-4.4" "Electrolytes","Mg","2.0","mg/dL","1.9-2.5" "Blood Sugar","FBS","119","mg/dL","74-106" "Liver Functions","AST(SGOT)","8","U/L","Up to 40" "Liver Functions","ALT(SGPT)","5","U/L","<34" "Liver Functions","Alk P","146","U/L","<240"
- Is this a medical report? Yes
- If yes what type of medical test is this? Biochemistry
- The current report is which of them and mention the category? Comprehensive Metabolic Panel (CMP) Report, Category 5: Laboratory Report
- Is this one of the laboratory report category? Yes
patient name,patient age,report date,lab center name,lab center phone number,lab center city No data,No data,1403/02/26,No data,No data,No data
Page,Attachment ?,No
QVL_7b_O method result:
Sure, here is the refined table in CSV format:
Test Name,Result Value,Unit,Risk,Normal Ranges FBS,119,mg/dL,Desirable,6-21.5 BUN,11,mg/dL,Normal,0.6-1.2 Cr,0.9,mg/dL,Normal,>=240: High Cholesterol,258,mg/dL,High,<=150: Normal Triglyceride,142,mg/dL,High,<=35: High risk HDL Cholesterol,46,mg/dL,Low risk,<=50: Low risk LDL Cholesterol,196,mg/dL,High Risk,>160 AST(SGOT),8,U/L,Up to 40,<=34 ALT(SGPT),5,U/L,<=240,<=240 Alk P,146,U/L,Normal,8.6-10.0 Ca,9.9,mg/dL,Normal,2.4-4.4 P,2.9,mg/dL,Normal,1.9-2.5 Mg,2.0,mg/dL,Normal,0-10 CRP,2.5,mg/L,Normal,0-24 RF,2.9,mg/L,Normal,0-24 TSH(CL),0.41,mIU/L,Adults: 0.55 - 4.78,>12 (Adults): 0.55 - 4.78 Vitamin B12,32,pmol/L,Negative,21 - 123 ANA,Negative,Positive,>25 Anti Ds DNA,9.5,Positive,>25
Note: The "Risk" column has been added based on the provided normal ranges.
Test Category,Test Name,Test Value,Test Unit,Reference Range Biochemistry,FBS,119,mg/dL,6-21.5 Biochemistry,BUN,11,mg/dL,0.6-1.2 Biochemistry,Cr,0.9,mg/dL,>=240: High Biochemistry,Cholesterol,258,mg/dL,<=150: Normal Biochemistry,Triglyceride,142,mg/dL,<=35: High risk Biochemistry,HDL Cholesterol,46,mg/dL,<=50: Low risk Biochemistry,LDL Cholesterol,196,mg/dL,Up to 40 Biochemistry,AST(SGOT),8,U/L,<=34 Biochemistry,ALT(SGPT),5,U/L,<=240 Biochemistry,Alk P,146,U/L,8.6-10.0 Biochemistry,Ca,9.9,mg/dL,2.4-4.4 Biochemistry,P,2.9,mg/dL,1.9-2.5 Biochemistry,Mg,2.0,mg/dL,0 - 10 Biochemistry,CRP,2.5,IU/mL,0-24 Biochemistry,RF,2.9,-,- CL,TSH(CL),0.41,mIU/L,0.64 - 6.27 CL,Vitamin B12,32,pmol/L,21 - 123 CL,ANA,Negative,-,Negative CL,Anti Ds DNA,9.5, IU/mL,Positive >25
Yes Biochemistry Biochemistry Yes
1- افراز 2- 29 سال 3- 1403/02/29 4- مختبر میترای 5- مختبر میترای 6- تهران
1,2 No
QVL_7b_R method result:
Sure, here is the merged and refined table in CSV format:
Test,Result,Unit,Risk,Normal Ranges FBS,119,mg/dL,High,6-21.5 BUN,11,mg/dL,Normal,0.6-1.2 Cr,0.9,mg/dL,Normal,0.6-1.2 Cholesterol,258,mg/dL,High,<=200 Triglyceride,142,mg/dL,Normal,<=150 HDL Cholesterol,46,mg/dL,Normal,<=150 LDL Cholesterol,196,mg/dL,Normal,<=199 AST(SGOT),8,U/L,Normal,<=34 ALT(SGPT),5,U/L,Normal,<=240 Alk P,146,mg/dL,Normal,8.6-10.0 Ca,9.9,mg/dL,Normal,2.4-4.4 P,2.9,mg/dL,Normal,1.9-2.5 Mg,2.0,mg/dL,Normal,1.9-2.5 CRP,2.5,mg/L,Normal,0-10 RF,2.9,mg/L,Normal,0-24 TSH(CL),0.41,mIU/L,Normal,2 to <12 (Pediatrics): 0.64 - 6.27 Vitamin B12,32,pmol/L,Normal,21 - 123 ANA,Negative,Positive,Negative Anti Ds DNA,9.5,Positive,Positive
Note: The "Risk" column is not included in the CSV format as it is not a standard unit of measurement.
Sure, here is the requested information in CSV format:
Test Category,Test Name,Test Value,Test Unit,Reference Range Biochemistry,FBS,119,mg/dL,6-21.5 Biochemistry,BUN,11,mg/dL,0.6-1.2 Biochemistry,Cr,0.9,mg/dL,0.6-1.2 Biochemistry,Cholesterol,258,mg/dL,74-106 Biochemistry,Triglyceride,142,mg/dL,<150 Biochemistry,HDL Cholesterol,46,mg/dL,Optimal:<130 Biochemistry,LDL Cholesterol,196,mg/dL,Up to 40 Biochemistry,AST(SGOT),8,U/L,<34 Biochemistry,ALT(SGPT),5,U/L,<240 Biochemistry,Alk P,146,mg/dL,8.6-10.0 Biochemistry,Ca,9.9,mg/dL,2.4-4.4 Biochemistry,P,2.9,mg/dL,1.9-2.5 Biochemistry,Mg,2.0,mg/dL,1.9-2.5 Biochemistry,CRP,2.5,mg/L,0-10 Biochemistry,RF,2.9,mg/L,0-24 CL,TSH(CL),0.41,mIU/L,2 to <12 (Pediatrics): 0.64 - 6.27 CL,TSH(CL),0.41,mIU/L,12 to <18 (Adolescents): 0.51 - 4.94 CL,TSH(CL),0.41,mIU/L,>12 (Adults): 0.55 - 4.78 CL,Vitamin B12,32,pmol/L,21 - 123 CL,ANA,Negative,Negative CL,Anti Ds DNA,9.5,mg/L,Borderline 20-25
Yes Biochemistry Yes Laboratory Report
1- نام بیمار 2- سن بیمار 3- تاریخ گزارش 4- نام مرکز آزمایش 5- شماره تلفن مرکز آزمایش 6- شهر مرکز آزمایش
2, No
- Assistant
"Test","450i","QVL_72b_O","LLama31_70B","QVL_7b_O","QVL_7b_R" "Age","","","32","","" "Biochemistry","","","1.5","","" "FBS","119","","119","119","119" "BUN","11","","0.9","11","11" "Cr","0.9","","0.6-1.2","0.9","0.9" "Cholesterol","258","","258","258","258" "Triglyceride","142","","142","142","142" "HDL Cholesterol","46","","46","46","46" "LDL Cholesterol","196","","196","196","196" "AST(SGOT)","8","","8","8","8" "ALT(SGPT)","5","","5","5","5" "Alk P","146","","146","146","146" "Ca","9.4","","9.9","9.9","9.9" "P","2.9","","2.9","2.9","2.9" "Mg","1.9","","2.0","2.0","2.0" "CRP","2.5","","2.5","2.5","2.5" "RF","2.9","","2.9","2.9","2.9" "TSH(CL)","0.41","","0.41","0.41","0.41" "Vitamin B12","32","","32","32","32" "ANA","Negative","","Negative","Negative","Negative" "Anti Ds DNA","9.5","","9.5","9.5","9.5"
"Test","450i","QVL_72b_O","LLama31_70B","QVL_7b_O","QVL_7b_R" "Age","","","-","","" "Biochemistry","","","-","","" "FBS","mg/dL","","mg/dL","mg/dL","mg/dL" "BUN","mg/dL","","mg/dL","mg/dL","mg/dL" "Cr","mg/dL","","mg/dL","mg/dL","mg/dL" "Cholesterol","mg/dL","","mg/dL","mg/dL","mg/dL" "Triglyceride","mg/dL","","mg/dL","mg/dL","mg/dL" "HDL Cholesterol","mg/dL","","mg/dL","mg/dL","mg/dL" "LDL Cholesterol","mg/dL","","mg/dL","mg/dL","mg/dL" "AST(SGOT)","U/L","","U/L","U/L","U/L" "ALT(SGPT)","U/L","","U/L","U/L","U/L" "Alk P","U/L","","U/L","U/L","U/L" "Ca","mg/dL","","mg/dL","mg/dL","mg/dL" "P","mg/dL","","mg/dL","mg/dL","mg/dL" "Mg","mg/dL","","mg/dL","mg/dL","mg/dL" "CRP","mg/L","","mg/L","mg/L","mg/L" "RF","IU/mL","","IU/mL","IU/mL","IU/mL" "TSH(CL)","mIU/L","","mIU/L","mIU/L","mIU/L" "Vitamin B12","pmol/L","","pmol/L","pmol/L","pmol/L" "ANA","-","","-","-","-" "Anti Ds DNA","IU/mL","","IU/mL","IU/mL","IU/mL"
"Test","450i","QVL_72b_O","LLama31_70B","QVL_7b_O","QVL_7b_R" "Age","","","-","","" "Biochemistry","","","-","","" "FBS","74-106","","74-106","6-21.5","6-21.5" "BUN","6-21.5","","0.6-1.2","0.6-1.2","0.6-1.2" "Cr","0.6-1.2","","0.6-1.2",">=240: High","0.6-1.2" "Cholesterol","<200 : D, 200-239 : BH, >240 : H","","Normal <150, 201-239 Borderline High, =>240 High","<=150: Normal","<=200" "Triglyceride","<150 : N, 150-199 : BH, >200 : H","","150-199 Borderline High, >200 High","<=35: High risk","<=150" "HDL Cholesterol","<35 : HR, >50 : LR","","<35: High risk, >=50: Low risk","<=50: Low risk","<=150" "LDL Cholesterol","Optimal : <130, AO : 130-160, HR : >160","","Optimal <130, 130-160 Above Optimal, >160 High Risk",">160","<=199" "AST(SGOT)","<34","","Up to 40","<=34","<=34" "ALT(SGPT)","<34","","<34","<=240","<=240" "Alk P","<240","","<240","8.6-10.0","8.6-10.0" "Ca","8.6-10.0","","8.6-10.0","2.4-4.4","2.4-4.4" "P","2.4-4.5","","2.4-4.4","1.9-2.5","1.9-2.5" "Mg","1.9-2.5","","1.9-2.5","0-10","1.9-2.5" "CRP","0-10","","0-10","0-24","0-10" "RF","0-24","","0-24","0-24","0-24" "TSH(CL)","2-12 (P): 0.64-6.27, 12-18 (A): 0.51-4.94, >12 (A): 0.55-4.78","","L2-<12 Pediatrics, 0.64-6.27, 12 to <18 (Adolescents) 0.51-4.94, >12 Adults"," >12 (Adults): 0.55 - 4.78","2 to <12 (Pediatrics): 0.64 - 6.27" "Vitamin B12","21-123","","21-123","21-123","21-123" "ANA","Negative","","Negative",">25","Negative" "Anti Ds DNA","Negative <20, Borderline 20-25, Positive >25","","Negative <20, Borderline 20-25, Positive >25","Positive >25","Positive"
"Question","450i","QVL_72b_O","LLama31_70B","QVL_7b_O","QVL_7b_R" "Is this a medical report?","Yes","","Yes","Yes","Yes" "What type of medical test is this?","Medical Lab Test","","Biochemistry","Biochemistry","Biochemistry" "Category of medical report","","","Comprehensive Metabolic Panel (CMP) Report, Category 5: Laboratory Report","Biochemistry","Laboratory Report" "Is this one of the laboratory report category?","","","Yes","Yes","Yes"
"Metadata","450i","QVL_72b_O","LLama31_70B","QVL_7b_O","QVL_7b_R" "Patient Name","","","","افراز","نام بیمار" "Patient Age","","","","29 سال","سن بیمار" "Date of Lab Report","14302/26","","1403/02/26","1403/02/29","تاریخ گزارش" "Lab Center Name","","","","مختبر میترای","نام مرکز آزمایش" "Lab Center Phone Number","Not available","","No data","مختبر میترای","شماره تلفن مرکز آزمایش" "Lab Center City","","","","تهران","شهر مرکز آزمایش"
"Information","450i","QVL_72b_O","LLama31_70B","QVL_7b_O","QVL_7b_R" "Page Number","3","","?","1","2" "Attachment","","","No","No","No"