Microbiological detection analysis report generation method, device, equipment, medium and product
Through automated microbial detection and analysis methods, the microbial detection situation is statistically and visualized, and the problems of low efficiency and poor accuracy of manual analysis are solved, achieving improvements in report generation efficiency and data analysis accuracy.
Patent Information
- Application Number
- CN202510055925.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-01-14
- Publication Date
- 2025-05-13
AI Technical Summary
In the prior art, relying on manual analysis of microbial detection results, it is inefficient and prone to errors, making it difficult to meet the complexity and diversity of targeted second-generation sequencing detection results.
By automatically counting the detection status of microorganisms in the selected time interval, a report is generated, including obtaining the detection result data of the target time interval and the detection item, counting the detection status of microorganisms, generating data visualization charts, and performing data analysis based on the template fill items to generate a final report.
Improve report generation efficiency and data analysis accuracy, reduce manual errors, and enable faster and accurate processing of microbial test results.
Smart Images

Figure CN119993287A_ABST
Abstract
Description
Technical Field
[0001] Embodiments of the present invention relate to the field of computer technology, and in particular, to a method, device, equipment, medium and product for generating a microbial detection and analysis report. Background Art
[0002] Infectious diseases refer to a series of pathological and physiological processes caused by the body being infected by pathogenic microorganisms such as bacteria, fungi, and viruses. They are one of the diseases with the highest mortality and morbidity rates worldwide.
[0003] Currently, the demand for analysis of the results of targeted second-generation sequencing detection of pathogenic microorganisms is gradually increasing. However, there are many types of microorganisms, the result descriptions are diverse, and the data analysis methods are complex. Relying solely on manual analysis to complete the report is time-consuming and prone to errors. Summary of the invention
[0004] The embodiments of the present invention provide a method, device, equipment, medium and product for generating a microbial detection and analysis report, which can generate a report by automatically counting the detection conditions of microorganisms in a selected time interval, thereby improving report generation efficiency and data analysis accuracy.
[0005] In a first aspect, an embodiment of the present invention provides a method for generating a microbial detection analysis report, the method comprising:
[0006] In response to a microbial detection and analysis report generation instruction, obtaining a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction;
[0007] Obtain a detection result data set corresponding to the target detection project, and select target detection result data within a target time interval from the detection result data set;
[0008] Count the microbial detection conditions in the target test result data, and generate data visualization charts corresponding to the microbial detection conditions based on the microbial detection conditions;
[0009] According to the data filling items in the target template corresponding to the target detection items, data analysis is performed on the microorganism detection situation to obtain the target template filling content corresponding to the data filling items;
[0010] Fill the target template based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
[0011] In a second aspect, an embodiment of the present invention provides a device for generating a microbial detection and analysis report, the device comprising:
[0012] An instruction processing module, for responding to a microbial detection and analysis report generation instruction, and obtaining a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction;
[0013] The detection result acquisition module is used to obtain the detection result data set corresponding to the target detection project, and select the target detection result data within the target time interval from the detection result data set;
[0014] A chart generation module is used to count the microbial detection conditions in the target detection result data, and generate a data visualization chart corresponding to the microbial detection conditions based on the microbial detection conditions;
[0015] A template filling content generation module is used to perform data analysis on the microorganism detection situation according to the data filling items in the target template corresponding to the target detection item, and obtain the target template filling content corresponding to the data filling items;
[0016] The report generation module is used to fill the target template based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
[0017] In a third aspect, an embodiment of the present invention further provides a computer device, the computer device comprising:
[0018] one or more processors;
[0019] A memory for storing one or more programs;
[0020] When the one or more programs are executed by one or more processors, the one or more processors implement the method for generating a microbial detection and analysis report as provided in any embodiment of the present invention.
[0021] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a method for generating a microbial detection and analysis report as provided in any embodiment of the present invention.
[0022] In a fifth aspect, an embodiment of the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements a method for generating a microbial detection and analysis report as provided in any embodiment of the present invention.
[0023] The embodiments of the above invention have the following advantages or beneficial effects:
[0024] The embodiment of the present invention obtains the target time interval and target detection item associated with the microbial detection analysis report generation instruction by responding to the microbial detection analysis report generation instruction; obtains the detection result data set corresponding to the target detection item, and selects the target detection result data within the target time interval in the detection result data set; counts the microbial detection situation in the target detection result data, and generates a data visualization chart corresponding to the microbial detection situation based on the microbial detection situation; performs data analysis on the microbial detection situation based on the data filling items in the target template corresponding to the target detection project, and obtains the target template filling content corresponding to the data filling items; fills the target template based on the data visualization chart and the target template filling content, and generates a target microbial detection report. The technical solution of the embodiment of the present invention solves the problem of low efficiency in writing reports that currently rely on manual statistics of microbial detection-related content, and can generate reports by automatically counting the detection situation of microorganisms in the selected time interval, thereby improving report generation efficiency and data analysis accuracy. BRIEF DESCRIPTION OF THE DRAWINGS
[0025] Figure 1 It is a flow chart of a method for generating a microbial detection and analysis report provided by an embodiment of the present invention;
[0026] Figure 2 It is a flow chart of a method for generating a microbial detection and analysis report provided by an embodiment of the present invention;
[0027] Figure 3 It is a flow chart of a method for generating a microbial detection and analysis report provided by an embodiment of the present invention;
[0028] Figure 4 It is a structural schematic diagram of a microorganism detection and analysis report generating device provided by an embodiment of the present invention;
[0029] Figure 5 It is a structural schematic diagram of a computer device provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0030] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.
[0031] Figure 1 This is a flowchart of a method for generating a microbial detection and analysis report provided in an embodiment of the present invention. This embodiment is applicable to scenarios where a microbial detection and analysis report is generated. The method can be executed by a microbial detection and analysis report generating device, which can be implemented by software and / or hardware and integrated into a computer device with application development capabilities.
[0032] like Figure 1 As shown, the method for generating a microbial detection analysis report in this embodiment includes the following steps:
[0033] S110. In response to a microbial detection and analysis report generation instruction, obtain a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction.
[0034] The microbial detection and analysis report can be a report of microbial detection and analysis using pathogen-targeted next-generation sequencing technology (tNGS). The detected pathogenic microorganism result data plays an important role in disease prevention and scientific research. Therefore, this embodiment automatically generates a detection and analysis report to give full play to the research value and significance of the microbial detection result data.
[0035] For example, the user can operate preset interface controls, such as input boxes, buttons, and forms, in the preset detection and analysis report generation interface to select or fill in the target time interval and target detection items of the target analysis detection data, and issue a microbial detection and analysis report generation instruction.
[0036] In response to the microbial detection and analysis report generation instruction, the server obtains the target time interval and target detection items associated with the microbial detection and analysis report generation instruction.
[0037] The target time interval may be any time interval detected in the past, such as the time interval from May 2024 to June 2024. The target detection items may be detection items of tNGS, such as respiratory detection items and upper respiratory tract infection detection items.
[0038] This embodiment acquires data independently for different time intervals and detection items to facilitate the subsequent generation of reports corresponding to target time intervals and target detection items, making report generation clearer and more targeted. At the same time, compared with manual data acquisition, automatic data acquisition is more efficient.
[0039] S120 , obtaining a detection result data set corresponding to the target detection item, and selecting target detection result data within a target time interval from the detection result data set.
[0040] The detection result data set may be a dataframe data set of the pandas library of Python. The detection result data set includes the detection result data of all time intervals corresponding to the target detection project. The target detection result data within the target time interval may be selected from the detection result data set through the groupby+contact function.
[0041] S130, counting the microbial detection conditions in the target detection result data, and generating a data visualization chart corresponding to the microbial detection conditions based on the microbial detection conditions.
[0042] From the target detection result data, the microorganism name field can be extracted through a preset character segmentation function, and the number of entries in each microorganism name field can be counted as the number of detections. According to the name field of the microorganism and the number of detections, a data visualization chart corresponding to the microorganism detection situation can be automatically generated through a preset data visualization library. The preset character segmentation function can be a split function, and the preset data visualization library can be a matplotlib library.
[0043] S140, performing data analysis on the microorganism detection situation according to the data filling items in the target template corresponding to the target detection item, and obtaining the target template filling content corresponding to the data filling items.
[0044] It is understandable that the report needs to provide a text description of the data analysis of the microbial detection situation. The text description content is composed of the template text content and the target template filling content. In this embodiment, by performing data analysis on the microbial detection situation, the target template filling content corresponding to the data filling item is obtained. The data filling item can be the detection index and analysis index related to the microbial detection situation.
[0045] S150, filling the target template based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
[0046] For example, the target template is automatically rendered through the render+write function of Python's jinja2 library and the hypertext language html, the target template is filled with content, and a data visualization chart is embedded to obtain a target microorganism detection report.
[0047] The technical solution of this embodiment, by responding to the microbial detection analysis report generation instruction, obtains the target time interval and target detection items associated with the microbial detection analysis report generation instruction; obtains the detection result data set corresponding to the target detection item, and selects the target detection result data within the target time interval in the detection result data set; counts the microbial detection situation in the target detection result data, and generates a data visualization chart corresponding to the microbial detection situation based on the microbial detection situation; performs data analysis on the microbial detection situation based on the data filling items in the target template corresponding to the target detection project, and obtains the target template filling content corresponding to the data filling items; fills the target template based on the data visualization chart and the target template filling content, and generates a target microbial detection report. The technical solution of the embodiment of the present invention solves the problem of low efficiency in writing reports that currently rely on manual statistics of microbial detection-related content, and can generate reports by automatically counting the detection situation of microorganisms in the selected time interval, thereby improving report generation efficiency and data analysis accuracy.
[0048] Figure 2 This is a flowchart of a method for generating a microbial detection and analysis report provided in an embodiment of the present invention. This embodiment and the method for generating a microbial detection and analysis report in the above embodiment belong to the same inventive concept, and further describes the process of statistically analyzing microbial detection conditions and determining the target template filling content. The method can be executed by a microbial detection and analysis report generating device, which can be implemented by software and / or hardware and integrated into a computer device with application development functions.
[0049] like Figure 2 As shown, the method for generating a microbial detection analysis report in this embodiment includes the following steps:
[0050] S210. In response to a microbial detection and analysis report generation instruction, obtain a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction.
[0051] S220 , obtaining a detection result data set corresponding to the target detection item, and selecting target detection result data within a target time interval from the detection result data set.
[0052] S230, identifying and extracting the microorganism name field in the target detection result data.
[0053] Through Python's split function, the target detection result data is content-divided according to the preset first special character to obtain a first content division list, each content division item in the first content division list includes a microorganism name field, a preset second special character and other detection result data, each content division item is content-divided according to the preset second special character to obtain a second content division list, and the content division result of the preset position corresponding to the microorganism name field is extracted from the second content division list, for example, the microorganism name field is obtained according to the index value corresponding to the microorganism name field.
[0054] For example, the target detection result data is divided using the special character ";". The target detection result data is, for example: "Human respiratory syncytial virus type A: 27156:>1.0E+6; Stenotrophomonas maltophilia: 354:1.8E+4; Candida glabrata: 95:<1.0E+3; Pseudomonas aeruginosa: 25:<1.0E+3. The split function is used to divide according to the ";", and each item of the result array formed by the division is looped through, and each single item is divided again using the split function on the ":" and the first item in the list is selected to be retained. For example, "Stenotrophomonas maltophilia: 354:1.8E+4" is divided and extracted to obtain Stenotrophomonas maltophilia.
[0055] You can also use the strip function to delete the spaces on both sides of the microorganism name field to facilitate subsequent matching of microorganism types.
[0056] S240 . Establish a classification data set corresponding to the target detection item according to the type of the target detection item, and divide the microorganism name field into the classification data set corresponding to the microorganism type.
[0057] The types of target detection projects may include different classification data sets. For example, the preset classification files of pathogens for respiratory detection projects and upper respiratory tract detection projects are imported. The preset classification files define the mapping relationship between microorganisms and microorganism types. According to the preset classification files, the microorganism name field is looped through. The respiratory detection project can set 4 dictionaries, namely 4 classification data sets, namely virus type classification data set, bacteria type classification data set, fungus type classification data set and mycoplasma type classification data set. The upper respiratory tract detection project sets 3 dictionaries, namely virus type classification data set, bacteria type classification data set and mycoplasma type classification data set. After the microorganism name field is traversed, it is divided into the classification data set of the corresponding microorganism type.
[0058] S250. Count the number of each microorganism name field in the classified data set, use the microorganism name field and the number of microorganism name fields as the microorganism detection situation, and generate a data visualization chart corresponding to the microorganism detection situation based on the microorganism detection situation.
[0059] The detection times of different microorganisms in the classified data set are counted, and a data visualization chart is automatically generated through Python's matplotlib library, with the microorganism field name as the horizontal axis and the number of times as the vertical axis. The chart type is, for example, a histogram.
[0060] S260. According to the data filling items in the target template corresponding to the target detection item, the microorganism name fields are sorted in descending order according to the number of microorganism name fields to obtain a sorting result, and a preset number of microorganism name fields are determined as target microorganism name fields in the sorting result.
[0061] The preset number can be determined according to the specific content of the data filling item. For example, when the data filling item is the target bacteria name field, the preset number can be 5, that is, the top 5 bacteria name fields are obtained as the target microorganism name field. For mycoplasma, the top 1 can be obtained as the target microorganism name field.
[0062] S270, using the target microorganism name field as the target template filling content of the target microorganism filling item, and using the number of the target microorganism name field as the target template filling content of the target microorganism detection number filling item.
[0063] For example, the target microorganism name field is Mycoplasma pneumoniae, the number of Mycoplasma pneumoniae is 76, and the template content is "Mycoplasma: [target microorganism filling item] is detected more frequently, the number of detections: [the number of target microorganism name field] times". After filling, the text content of the final report is: Mycoplasma: Mycoplasma pneumoniae is detected more frequently, the number of detections: 76 times.
[0064] S280, filling the target template based on the data visualization chart and the target template filling content, and generating a target microorganism detection report.
[0065] The technical solution of this embodiment is to obtain the target time interval and target detection item associated with the microbial detection analysis report generation instruction by responding to the microbial detection analysis report generation instruction; obtain the detection result data set corresponding to the target detection item, and select the target detection result data within the target time interval in the detection result data set; identify and extract the microbial name field in the target detection result data; establish a classification data set corresponding to the target detection item according to the type of the target detection item, and divide the microbial name field into the classification data set corresponding to the microbial type; count the number of each microbial name field in the classification data set, and use the microbial name field and the number of microbial name fields as the microbial detection situation; generate a data visualization chart corresponding to the microbial detection situation according to the microbial detection situation; according to the data filling items in the target template corresponding to the target detection item, sort the microbial name fields in descending order according to the number of microbial name fields to obtain a sorting result, and determine a preset number of microbial name fields as the target microbial name fields in the sorting result; use the target microbial name field as the target template filling content of the target microbial filling item, and use the number of the target microbial name field as the target template filling content of the target microbial detection number filling item; fill the target template based on the data visualization chart and the target template filling content to generate a target microbial detection report. The technical solution of the embodiment of the present invention solves the problem of low efficiency in writing reports that currently rely on manual statistics of microbial detection related content. It can determine the detection status of microorganisms in a selected time period through field extraction and quantity statistics to generate a chart, and can determine the template filling content to generate a text description through data intelligent analysis. Reports are generated based on text descriptions and charts to improve report generation efficiency and data analysis accuracy.
[0066] Figure 3 This is a flowchart of a method for generating a microbial detection and analysis report provided in an embodiment of the present invention. This embodiment and the method for generating a microbial detection and analysis report in the above embodiment belong to the same inventive concept, and further describes the process of determining the detection result data set. The method can be executed by a microbial detection and analysis report generating device, which can be implemented by software and / or hardware and integrated into a computer device with application development function.
[0067] like Figure 3 As shown, the method for generating a microbial detection analysis report in this embodiment includes the following steps:
[0068] S310, obtaining microbial detection list data, and filtering the microbial detection list data for preset data items to obtain a microbial detection data set.
[0069] The microbial test list data can be a list of original laboratory results. The original laboratory result list is imported, and the preset data items such as test items, test results, sample type, department, hospital name and project time are screened to obtain the dataframe data set of key information, namely the microbial test data set.
[0070] S320, dividing the microbial detection data set into a plurality of detection result data sets corresponding to each detection item.
[0071] The preset data items include test items and test results. The microbial test data set is traversed and divided according to different test items to obtain multiple test result data sets corresponding to each test item, such as a test result data set for a respiratory test item and a test result data set for an upper respiratory tract infection 102 test item.
[0072] S330. In response to the microbial detection and analysis report generation instruction, obtain the target time interval and target detection items associated with the microbial detection and analysis report generation instruction.
[0073] S340: Obtain a detection result data set corresponding to the target detection item, and select target detection result data within a target time interval from the detection result data set.
[0074] S350, counting the microbial detection conditions in the target detection result data, and generating a data visualization chart corresponding to the microbial detection conditions based on the microbial detection conditions.
[0075] S360: Perform data analysis on the microorganism detection situation according to the data filling items in the target template corresponding to the target detection item, and obtain the target template filling content corresponding to the data filling items.
[0076] In an optional embodiment, the target template filling content also includes supplementary microbial detection data analysis content within a preset time interval associated with the target time interval. The process of determining the supplementary microbial detection data analysis content can be to determine the preset time interval including the target time interval, and establish a microbial list corresponding to each preset unit time interval based on the number of preset unit time intervals included in the preset time interval, wherein the microbial list includes microbial detection conditions, and the key microorganisms of each microbial type are screened by arranging the detection number of each microorganism in the microbial detection conditions in descending order; and the positive rate of the key microorganisms is calculated based on the total sample size and the detection number of the key microorganisms.
[0077] The preset time interval associated with the target time interval can be the time interval within the year, the whole year, or half a year in which the target time interval is located. The preset unit time interval can be a month, and a microorganism list corresponding to each month is established. For example, the microorganisms of the whole year are divided into 12 microorganism lists according to 12 months. The number of detections of each microorganism in the microbial detection situation is arranged in descending order, and the key microorganisms of each microbial type are screened. The key microorganisms can be understood as the key analyzed microorganisms in the target microbial monitoring and analysis report.
[0078] For example, for bacterial type microorganisms and fungal type microorganisms, the top 8 microorganisms with the largest number of detections are obtained as key bacterial type microorganisms and key fungal type microorganisms, respectively, and the microorganisms of each microorganism type are traversed through 12 microorganism lists to obtain a list of monthly detection conditions of key microorganisms corresponding to each microorganism type. The formula LV (positive rate) = S (current number of microorganisms detected) / S (current number of specimens submitted for inspection) * 100% can be used to calculate the positive rate of key microorganisms corresponding to each microorganism type in each unit time interval.
[0079] In an optional embodiment, the total number of samples in a preset time interval can also be obtained, the entire test result data set can be obtained and traversed, the number of positive samples in the preset time interval can be obtained, and the total positive rate of the preset time interval can be calculated based on the total number of samples and the number of positive samples in the preset time interval.
[0080] If the test item does not detect a positive pathogen, the test result is empty. Based on this, the dataframe dataset is traversed to obtain the number of non-empty positive items. The shape[0] method is used to obtain the total number of items, that is, the total number of samples. The total positive rate is obtained according to the positive rate formula.
[0081] Data visualization charts can also be generated based on the key microbial positivity rate corresponding to each microbial type in each unit time interval to visualize the microbial detection situation in each unit time interval.
[0082] The target template filling content also includes the analysis results of the non-detection result data. In an optional implementation, statistical analysis can be performed on preset data items of non-detection results in the detection result data set to obtain the analysis results of the non-detection result data.
[0083] For example, traverse the sample types in the test result data set, use the judgment statement to put the sample types into the dictionary and sort them in descending order. Get the first one as the main sample type data filling item. Traverse the departments in the test result data set, and if the department is not filled in a standardized way on the test application form, collect the department names in a unified and centralized way, and count the first two departments with the most tests as the main departments data filling items.
[0084] S370, filling the target template based on the data visualization chart and the target template filling content, and generating a target microorganism detection report.
[0085] The technical solution of this embodiment is to obtain the microbial detection list data, filter the microbial detection list data by preset data items to obtain the microbial detection data set; divide the microbial detection data set into multiple detection result data sets corresponding to each detection item; wherein the preset data items include detection items and detection results; in response to the microbial detection analysis report generation instruction, obtain the target time interval and target detection items associated with the microbial detection analysis report generation instruction; obtain the detection result data set corresponding to the target detection item, and select the target detection result data within the target time interval in the detection result data set; count the microbial detection situation in the target detection result data, and generate a data visualization chart corresponding to the microbial detection situation according to the microbial detection situation; according to the data filling items in the target template corresponding to the target detection item, perform data analysis on the microbial detection situation to obtain the target template filling content corresponding to the data filling item; fill the target template based on the data visualization chart and the target template filling content to generate a target microbial detection report. The technical solution of the embodiment of the present invention solves the problem of low efficiency in writing reports currently relying on manual statistics of microbial detection related content, and can obtain key data by filtering and dividing the original data, so as to automatically count the detection situation of microorganisms in the selected time interval according to the key data to generate a report, thereby improving the report generation efficiency and data analysis accuracy.
[0086] Figure 4 The present invention provides a schematic diagram of a microbial detection and analysis report generation device, which can be applied to scenarios where microbial detection and analysis reports are generated. The microbial detection and analysis report generation device can be implemented by software and / or hardware and integrated into a computer terminal device with application development functions.
[0087] like Figure 4 As shown, the microbial detection and analysis report generating device includes: an instruction processing module 410, a detection result acquisition module 420, a chart generating module 430, a template filling content generating module 440 and a report generating module 450.
[0088] Among them, the instruction processing module 410 is used to respond to the microbial detection and analysis report generation instruction, and obtain the target time interval and target detection item associated with the microbial detection and analysis report generation instruction; the detection result acquisition module 420 is used to obtain the detection result data set corresponding to the target detection item, and select the target detection result data within the target time interval in the detection result data set; the chart generation module 430 is used to count the microbial detection conditions in the target detection result data, and generate a data visualization chart corresponding to the microbial detection conditions based on the microbial detection conditions; the template filling content generation module 440 is used to perform data analysis on the microbial detection conditions based on the data filling items in the target template corresponding to the target detection items, and obtain the target template filling content corresponding to the data filling items; the report generation module 450 is used to fill the target template based on the data visualization chart and the target template filling content to generate a target microbial detection report.
[0089] The technical solution of this embodiment, by responding to the microbial detection analysis report generation instruction, obtains the target time interval and target detection items associated with the microbial detection analysis report generation instruction; obtains the detection result data set corresponding to the target detection item, and selects the target detection result data within the target time interval in the detection result data set; counts the microbial detection situation in the target detection result data, and generates a data visualization chart corresponding to the microbial detection situation based on the microbial detection situation; performs data analysis on the microbial detection situation based on the data filling items in the target template corresponding to the target detection project, and obtains the target template filling content corresponding to the data filling items; fills the target template based on the data visualization chart and the target template filling content, and generates a target microbial detection report. The technical solution of the embodiment of the present invention solves the problem of low efficiency in writing reports that currently rely on manual statistics of microbial detection-related content, and can generate reports by automatically counting the detection situation of microorganisms in the selected time interval, thereby improving report generation efficiency and data analysis accuracy.
[0090] In an optional implementation, the chart generation module 430 is specifically used for:
[0091] Identify and extract the microorganism name field in the target detection result data; establish a classification data set corresponding to the target detection project according to the type of the target detection project, and divide the microorganism name field into the classification data set corresponding to the microorganism type; count the number of each microorganism name field in the classification data set, and use the microorganism name field and the number of microorganism name fields as the microorganism detection situation.
[0092] In an optional implementation, the template filling content generation module 440 is specifically used for:
[0093] The microorganism name fields are arranged in descending order according to the number of microorganism name fields to obtain a sorting result, and a preset number of microorganism name fields are determined in the sorting result as target microorganism name fields; the target microorganism name fields are used as target template filling content for the target microorganism filling item, and the number of target microorganism name fields is used as target template filling content for the target microorganism detection number filling item.
[0094] In an optional embodiment, the device further comprises:
[0095] The test result data set determination module is used to obtain the microbial test list data, filter the microbial test list data by preset data items to obtain the microbial test data set; divide the microbial test data set into multiple test result data sets corresponding to each test item; wherein the preset data items include the test items and the test results.
[0096] In an optional embodiment, the target template filling content also includes supplementary microbial detection data analysis content within a preset time interval associated with the target time interval, and the device also includes:
[0097] The supplementary analysis content determination module is used to determine a preset time interval that includes a target time interval; establish a microorganism list corresponding to each preset unit time interval according to the number of preset unit time intervals included in the preset time interval, wherein the microorganism list includes microorganism detection conditions; screen key microorganisms of each microorganism type by arranging the detection quantity of each microorganism in the microorganism detection conditions in descending order; and calculate the positive rate of key microorganisms based on the total sample size and the detection quantity of key microorganisms.
[0098] In an optional implementation, the supplementary analysis content determination module is further used to:
[0099] Obtain the total number of samples in a preset time interval; obtain and traverse all test result data sets to obtain the number of positive samples in the preset time interval; calculate the total positive rate of the preset time interval based on the total number of samples and the number of positive samples in the preset time interval.
[0100] The microbial detection and analysis report generating device provided in the embodiment of the present invention can execute the microbial detection and analysis report generating method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
[0101] Figure 5 A schematic diagram of the structure of a computer device provided in an embodiment of the present invention. Figure 5 A block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention is shown. Figure 5The computer device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention. The computer device 12 can be any terminal device with computing capabilities, such as an intelligent controller and server, a mobile phone and other terminal devices.
[0102] like Figure 5 As shown, the computer device 12 is in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that connects various system components (including the system memory 28 and the processing unit 16).
[0103] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.
[0104] The computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer device 12, including volatile and non-volatile media, removable and non-removable media.
[0105] The system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 5 not shown, usually called a "hard drive"). Although Figure 5 Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The system memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.
[0106] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. Program modules 42 generally perform the functions and / or methods of the embodiments described herein.
[0107] The computer device 12 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), one or more devices that enable a user to interact with the computer device 12, and / or any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed via an input / output (I / O) interface 22. Furthermore, the computer device 12 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 20. As shown, the network adapter 20 communicates with the other modules of the computer device 12 via the bus 18. It should be understood that although Figure 5 Not shown, other hardware and / or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RFID systems, tape drives, and data backup storage systems.
[0108] The processing unit 16 executes various functional applications and data processing by running the program stored in the system memory 28, for example, implementing the method for generating a microbial detection analysis report provided in the embodiment of the present invention, which includes:
[0109] In response to a microbial detection and analysis report generation instruction, obtaining a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction;
[0110] Obtain a detection result data set corresponding to the target detection project, and select target detection result data within a target time interval from the detection result data set;
[0111] Count the microbial detection conditions in the target test result data, and generate data visualization charts corresponding to the microbial detection conditions based on the microbial detection conditions;
[0112] According to the data filling items in the target template corresponding to the target detection items, data analysis is performed on the microorganism detection situation to obtain the target template filling content corresponding to the data filling items;
[0113] Fill the target template based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
[0114] An embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon. When the program is executed by a processor, the method for generating a microbial detection and analysis report provided in any embodiment of the present invention is implemented. The method includes:
[0115] In response to a microbial detection and analysis report generation instruction, obtaining a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction;
[0116] Obtain a detection result data set corresponding to the target detection project, and select target detection result data within a target time interval from the detection result data set;
[0117] Count the microbial detection conditions in the target test result data, and generate data visualization charts corresponding to the microbial detection conditions based on the microbial detection conditions;
[0118] According to the data filling items in the target template corresponding to the target detection items, data analysis is performed on the microorganism detection situation to obtain the target template filling content corresponding to the data filling items;
[0119] Fill the target template based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
[0120] The computer storage medium of the embodiment of the present invention can adopt any combination of one or more computer-readable media. The computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to: an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program, which can be used by an instruction execution system, device or device or used in combination with it.
[0121] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.
[0122] The program code embodied on the computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
[0123] Computer program code for performing the operation of the present invention may be written in one or more programming languages or a combination thereof, including object-oriented programming languages such as Java, Smalltalk, Python, C++, and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).
[0124] An embodiment of the present invention also provides a computer program product, including a computer program, which, when executed by a processor, implements the method for generating a microbial detection and analysis report as provided in any embodiment of the present application.
[0125] In the process of implementation, the computer program product can be written in one or more programming languages or a combination thereof to perform the computer program code of the present invention, including object-oriented programming languages, such as Java, Smalltalk, Python, C++, and conventional procedural programming languages, such as "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (for example, using an Internet service provider to connect through the Internet).
[0126] It should be understood by those skilled in the art that the modules or steps of the present invention described above can be implemented by a general-purpose computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, optionally, they can be implemented by a program code executable by a computer device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. Thus, the present invention is not limited to any specific combination of hardware and software.
[0127] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims
1. A method for generating a microbial detection and analysis report, characterized in that: include: In response to a microbial detection and analysis report generation instruction, obtaining a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction; Acquire a detection result data set corresponding to the target detection item, and select target detection result data within the target time interval from the detection result data set; Counting the microbial detection conditions in the target detection result data, and generating a data visualization chart corresponding to the microbial detection conditions based on the microbial detection conditions; According to the data filling items in the target template corresponding to the target detection item, data analysis is performed on the microorganism detection situation to obtain the target template filling content corresponding to the data filling items; The target template is filled based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
2. The method according to claim 1, characterized in that The counting of microbial detection conditions in the target detection result data includes: Identify and extract the microorganism name field in the target detection result data; Establishing a classification data set corresponding to the target detection item according to the type of the target detection item, and dividing the microorganism name field into the classification data set corresponding to the microorganism type; The number of each microorganism name field in the classification data set is counted, and the microorganism name field and the number of the microorganism name field are used as the microorganism detection situation.
3. The method according to claim 2, characterized in that The data analysis of the microorganism detection situation to obtain the target template filling content corresponding to the data filling item includes: Arrange the microorganism name fields in descending order according to the number of the microorganism name fields to obtain a sorting result, and determine a preset number of the microorganism name fields in the sorting result as target microorganism name fields; The target microorganism name field is used as the target template filling content of the target microorganism filling item, and the number of the target microorganism name field is used as the target template filling content of the target microorganism detection number filling item.
4. The method according to claim 1, characterized in that: Before obtaining the detection result data set corresponding to the target detection project, the method further includes: Acquire microbial detection list data, and filter the microbial detection list data by preset data items to obtain a microbial detection data set; Dividing the microorganism detection data set into a plurality of detection result data sets corresponding to each of the detection items; Wherein, the preset data items include detection items and detection results.
5. The method according to claim 1, characterized in that The target template filling content also includes supplementary microbial detection data analysis content within a preset time interval associated with the target time interval, and the determination process of the supplementary microbial detection data analysis content includes: Determining a preset time interval that includes the target time interval; According to the number of preset unit time intervals contained in the preset time interval, a microorganism list corresponding to each preset unit time interval is established, wherein the microorganism list includes microorganism detection conditions; Screening key microorganisms of each microorganism type by arranging the detected quantity of each microorganism in the microorganism detection situation in descending order; The positive rate of the key microorganisms is calculated based on the total sample size and the detected number of the key microorganisms.
6. The method according to claim 5, characterized in that The process of determining the content of the supplementary microbial detection data analysis also includes: Obtaining the total number of samples in the preset time interval; Obtain and traverse all the test result data sets to obtain the number of positive samples in the preset time interval; The total positive rate of the preset time interval is calculated according to the total number of samples and the number of positive samples in the preset time interval.
7. A device for generating a microbial detection and analysis report, characterized in that: include: An instruction processing module, for responding to a microbial detection and analysis report generation instruction, obtaining a target time interval and a target detection item associated with the microbial detection and analysis report generation instruction; A detection result acquisition module, used to acquire a detection result data set corresponding to the target detection item, and select target detection result data within the target time interval from the detection result data set; A chart generation module, used to count the microbial detection conditions in the target detection result data, and generate a data visualization chart corresponding to the microbial detection conditions according to the microbial detection conditions; A template filling content generating module is used to perform data analysis on the microorganism detection situation according to the data filling items in the target template corresponding to the target detection item, and obtain the target template filling content corresponding to the data filling items; A report generation module is used to fill the target template based on the data visualization chart and the target template filling content to generate a target microorganism detection report.
8. A computer device, characterized in that: The computer device comprises: one or more processors; A memory for storing one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the method for generating a microbial detection and analysis report as described in any one of claims 1-6.
9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method for generating a microbial detection and analysis report as described in any one of claims 1 to 6 is implemented.
10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the computer program implements the method for generating a microbial detection and analysis report as described in any one of claims 1 to 6.