Based on DeepSeek and Python, "JOINN clinical testing" has developed the biological analysis data processing software "sample life cycle analyzer V3.0", which is used as the supplementary processing module after the data export of Watson LIMS system. For the actual storage time of biological samples and the freezing and thawing times of samples in testing institutions,Intelligent analysis, automatic calculation and one-click report generation are carried out to break through the traditional manual statistical mode and improve the report writing efficiency by more than 50%.

### **Core Features Highlights **

1️⃣ **Intelligent spatio-temporal computing engine **

The automatic recognition of 29-Jun-2024, 2025/3/20 and other 6 types of date formats (support Watson LIMS multiple historical date formats)

Accurately calculate the storage duration of the sample from receipt (Arrived) to the last issue (Given to analyze)

The number of full-cycle circulation of dynamic statistics samples

2️⃣ **Zero threshold interactive experience **

The visual operation interface, one-click selection of files to immediately generate analysis reports

Support Excel 97-2003 and other old format compatibility, put an end to the trouble of data migration

The result file automatically retains two decimal places and conforms to the laboratory record specification.

### **Use Value **

✔Reduce manual reconciliation time (average saving of 45 minutes in a single process)

✔Ensure that different operators generate reports in a uniform format.

✔Provide traceable intermediate processing results

### **Technical note **

This tool is developed based on the Python 3.8. The main technical features include:

The use of xlrd/xlsxwriter ensures accurate parsing of Excel format

Built-in date format fault tolerance mechanism (supports Watson LIMS multiple historical date formats)

The single-threaded design ensures low resource usage (CPU usage <15%)

**Notes **

※ This tool does not directly connect to LIMS database, you need to manually export the original data

※ It is recommended to archive the processing results together with LIMS original data

※ In case of abnormal data, please check the integrity of LIMS export file first. 

### **Access Method **

Email to info@joinnlaboratories.com

Future Expectations

Software developer, Dr. Li Kaiqing, chief scientific officer of JOINN clinical testing, said: "This is the first time to write software based on DeepSeek and Python. I was shocked by DeepSeek's powerful programming ability and its ability to optimize codes according to users' needs. From understanding the needs to writing codes using DeepSeek,Then to 2 code optimizations, less than 1 day. Subsequent clinical testing will be more integrated into DeepSeek and other AI tools to optimize the process and improve the level of intelligence. As a member of the Bioanalysis Committee of the Chinese Pharmaceutical Association, open source code and software sharing are also the due obligations to help the development of the industry.

Special Thanks:

Thanks to Liu Guoyou, head of JOINN's clinical testing thematic analysis, for providing data sources, Yang Wengen and Zhou Zonglei, head of JOINN's clinical testing thematic analysis, and Wu Feilin, head of the immune and biomarker platform, for providing logic optimization suggestions.