Automatic data analysis system, data analysis method and electronic equipment

Through the design of an automated data analysis system, the time-consuming and labor-intensive problem of manual operation in chemical experimental data analysis is solved, the data is automatically processed and sorted, the analysis efficiency is improved, and the log configuration is provided to find bugs and improve operation proficiency.

CN118897968APending Publication Date: 2024-11-05AICHEMECO TECHNOLOGY CORP LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411026489.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-30
Publication Date
2024-11-05

AI Technical Summary

Technical Problem

In the prior art, chemical experimental data analysis requires manual input and interpretation, which is time-consuming and labor-intensive, and lacks automated processing, resulting in inefficiency.

Method used

An automated data analysis system is designed, including a central control module, method editing module, points module and data processing module. It is connected to the analysis software through screen automation operations, automatically process and organize the data in the points file to generate analysis results.

Benefits of technology

It realizes the automated analysis and processing of chemical experimental data, reduces manual operation time, improves data analysis efficiency, and provides reference for bug search and operation steps through log configuration.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118897968A_ABST
    Figure CN118897968A_ABST
Patent Text Reader

Abstract

The invention discloses an automatic data analysis system, a data analysis method and electronic equipment. The automatic data analysis system comprises a central control module, a method editing module, an integral module and a data processing module, the central control module is connected with the method editing module, the integral module and the data processing module. According to the data analysis method provided by the invention, after the automatic data analysis system is connected with the existing analysis software, the automatic analysis processing of the data in the integral file is realized through the combination of the central control module, the method editing module, the integral module and the data processing module in the system.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of chemical reaction condition screening, and in particular to an automated data analysis system, a data analysis method and electronic equipment. Background Art

[0002] Chemical experiment data analysis is a key step in chemical research. This process usually includes the collection, organization, interpretation and reporting of chemical experiment data.

[0003] Accurate data analysis not only helps to verify experimental hypotheses, but also reveals the principles and mechanisms behind chemical phenomena. In addition, data analysis helps to evaluate the reliability and validity of experimental results and provide guidance for further experimental design and research. Therefore, chemical experimental data analysis is of great significance to promoting the development of chemical science. In current data analysis, chemists are often required to manually input data and combine professional knowledge to identify trends, patterns and outliers in the data, which is very time-consuming and laborious.

[0004] In summary, the present application provides an automated data analysis system, a data analysis method and an electronic device to solve the above problems. Summary of the invention

[0005] In order to solve the time-consuming and labor-intensive problems of manual operation in the related art, the present invention discloses an automated data analysis system, including a central control module, a method editing module, an integration module and a data processing module;

[0006] The central control module is connected to the method editing module, the integration module and the data processing module respectively;

[0007] The central control module is used for connecting with the analysis software, inputting the timeout time and the number of files, and collecting and storing information on the file path of the integral file and the corresponding integral range;

[0008] The method editing module is used to open and edit the method file of the analysis software through screen automation operation and fill in the mass number data;

[0009] Integration module: perform integration operations on the integration files in the analysis software and save the integration results to the clipboard;

[0010] Data processing module: processes and organizes the integration results generated by the integration module, saves and outputs the organized integration results.

[0011] Preferably, the central control module is also used to set log configuration and create logs.

[0012] Preferably, the screen automation operation includes:

[0013] Pre-capture and store the target image;

[0014] Match images in the area to be identified that are similar or identical to the target image;

[0015] Move the mouse over the image and double-click.

[0016] Preferably, the calling process of the method editing module includes:

[0017] Initialize and set image path;

[0018] Open the method editing window through screen automation;

[0019] Maximize the method editing window;

[0020] Select the UPLC method file;

[0021] Fill in the mass number data line by line;

[0022] Save the edited UPLC method file and close the method editing window.

[0023] Preferably, the calling process of the integration module includes:

[0024] Initialize and select the integration file, open a new sample list and upload the integration file;

[0025] Locate and select the target folder and subfolders;

[0026] Select the specified integration file rows and columns;

[0027] Select the UPLC method file and perform integration;

[0028] Save the integration result to the clipboard and close the integration window.

[0029] Preferably, the calling process of the data processing module includes:

[0030] 1) Data processing:

[0031] Create or open the specified Excel file;

[0032] Open the workspace of the analysis software and navigate to the specified Excel file;

[0033] 2) Save data:

[0034] Save the integration results to the specified location of the Excel file;

[0035] 3) Data cleaning and organization:

[0036] Read Excel files and fill missing values;

[0037] Filter specific data rows and save them into different subtables.

[0038] Preferably, the reading of the Excel file and filling the missing values ​​is to insert the None character into the cells with missing data in the Excel file.

[0039] Preferably, the analysis software includes MassLynx software, MassHunter software, Empower software, chromeleon software or openlab software.

[0040] The present invention also provides a data analysis method, using the above-mentioned automated data analysis system, comprising:

[0041] Input the timeout time and the number of files into the automated data analysis system, and collect and store the file path of each integral file and the corresponding integral range information;

[0042] Connect the automated data analysis system to the analysis software, and pin and maximize the running interface of the analysis software;

[0043] Traverse each integral file, read the mass number data, and save them separately through multiple sublists;

[0044] For each integral file and corresponding sublist, the automated data analysis system is called to output the analysis results.

[0045] The present invention also provides an electronic device, comprising:

[0046] Memory for storing computer programs;

[0047] A processor is used to implement the above-mentioned data analysis method when executing the computer program.

[0048] The beneficial effects of the present invention compared with the prior art are:

[0049] (1) Through the technical solution of the present invention, an automated data analysis system is provided. By connecting the system with existing analysis software, the automated analysis and processing of the data in the integration file can be achieved through the combination of the central control module, method editing module, integration module and data processing module in the system.

[0050] (2) Through the technical solution of the present invention, the log configuration can be set and the log can be created through the central control module. The functions of the log are as follows: on the one hand, it is used by developers to find bugs; on the other hand, if users are interested in mastering relevant knowledge or improving their proficiency, they can also read the log document to clarify steps or find problems. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0052] Figure 1 A schematic diagram of the connection between the automated data analysis system and the analysis software of an embodiment of the present application;

[0053] Figure 2 This is a diagram of the operation interface of the central control module of the automated data analysis system of an embodiment of the present application;

[0054] Figure 3 This is a diagram of the filling interface of the mass number of the method editing module of the automated data analysis system of the embodiment of the present application;

[0055] Figure 4 This is a diagram of an upload interface for an integral file of an integral module of an automated data analysis system according to an embodiment of the present application;

[0056] Figure 5 This is an integration process interface diagram of an integration module of an automated data analysis system according to an embodiment of the present application;

[0057] Figure 6 This is a diagram of the integration result interface of the integration module of the automated data analysis system of an embodiment of the present application;

[0058] Figure 7 This is a sub-table content diagram output by the data processing module of the automated data analysis system of an embodiment of the present application. DETAILED DESCRIPTION

[0059] The following will be combined with the accompanying drawings in the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work belong to the protection scope of the present invention.

[0060] Some technical terms in this application are explained as follows:

[0061] Timeout: This is the timeout for each operation. When the set time is exceeded, the automated data analysis system will be shut down.

[0062] Integration: The process of identifying peaks on a chromatogram and calculating their areas.

[0063] UPLC: ultra-performance liquid chromatography.

[0064] UPLC method file: The configuration file that stores retention time (RT) and relative molecular mass (QuantificationTrace) in the analysis software. By comparing the chromatographic peak areas corresponding to the molecular weights of different products, the relative content of the products can be analyzed.

[0065] Mass number data: relative molecular mass data of different products

[0066] Integration file: raw data file of ultra-high performance liquid chromatogram.

[0067] like Figure 1 As shown, an automated data analysis system includes a central control module, a method editing module, an integration module and a data processing module;

[0068] The central control module is connected to the method editing module, the integration module and the data processing module respectively;

[0069] The central control module is used to connect to the analysis software (using pywinauto to connect to the analysis software), input the timeout time and the number of files, and collect and store the file path of the integral file (i.e., the storage location) and the corresponding integral range information;

[0070] The method editing module is used to open and edit the method file of the analysis software through screen automation operation and fill in the mass number data;

[0071] Integration module: perform integration operations on the integration files in the analysis software and save the integration results to the clipboard;

[0072] Data processing module: processes and organizes the integration results generated by the integration module, saves and outputs the organized integration results.

[0073] In this embodiment, the central control module is also used to set log configuration and create logs.

[0074] Configure loguru to log to the console and log file (Loguru is an alternative library for Python logging, which aims to provide a simple way to record the operation of the application while keeping the code concise and readable. Compared with Python's built-in logging standard library, Loguru has a simpler configuration process, can achieve similar functions, and can ensure the thread and process safety of logging. In addition, it also supports color output of logs, making the log content more intuitive and friendly);

[0075] Create a log directory and a timestamped log file.

[0076] At the same time, an initial prompt will be given, indicating the file location where the log is saved and information about the status of the analysis software.

[0077] In this embodiment, the screen automation operation includes:

[0078] Pre-capture and store the target image;

[0079] Match images in the area to be identified that are similar or identical to the target image;

[0080] Move the mouse over the image and double-click.

[0081] In this embodiment, the calling process of the method editing module includes:

[0082] Initialize and set the image path (the image path is the location where the pre-captured target image is stored);

[0083] Open the method editing window through screen automation;

[0084] Maximize the method editing window;

[0085] Select the UPLC method file;

[0086] Fill in the mass number data line by line;

[0087] Save the edited UPLC method file and close the method editing window.

[0088] In this embodiment, the calling process of the integration module includes:

[0089] Initialize and select the integration file, open a new sample list and upload the integration file;

[0090] Locate and select the target folder and subfolders;

[0091] Select the specified integration file rows and columns;

[0092] Select the UPLC method file and perform integration;

[0093] Save the integration result to the clipboard and close the integration window.

[0094] In this embodiment, the calling process of the data processing module includes:

[0095] Create or open the specified Excel file;

[0096] Open the workspace of the analysis software and navigate to the specified Excel file;

[0097] Save the integration results to the specified location of the Excel file;

[0098] Read Excel files and fill missing values;

[0099] Filter specific data rows and save them into different sub-tables (select the filtering conditions based on work requirements, for example, filter all data except rows with missing values).

[0100] In this embodiment, the reading of the Excel file and filling the missing values ​​means inserting the None character into the cells with missing data in the Excel file, so as to avoid the system error problem that may occur due to missing data.

[0101] In this embodiment, the analysis software includes MassLynx software, MassHunter software, Empower software, chromeleon software or openlab software.

[0102] The present invention also provides a data analysis method, using the above-mentioned automated data analysis system, comprising:

[0103] Input the timeout time and the number of files into the automated data analysis system, and collect and store the file path of each integral file and the corresponding integral range information;

[0104] Connect the automated data analysis system to the analysis software, and pin and maximize the running interface of the analysis software;

[0105] Traverse each integral file, read the mass number data, and save them separately through multiple sublists;

[0106] The automatic data analysis system is called for each integral file and the corresponding sublist to output the analysis result. The present invention also provides an electronic device, comprising:

[0107] Memory for storing computer programs;

[0108] A processor is used to implement the above-mentioned data analysis method when executing the computer program.

[0109] Example 1 (In this example, the analysis software uses MassLynx software, and the product chromatogram data of a 96-well plate are automatically analyzed):

[0110] Central control module:

[0111] See also Figure 2 , set log configuration, create log

[0112] Configure loguru to log to the console and log file.

[0113] Create a log directory and a timestamped log file.

[0114] Outputs an initial prompt, indicating the file location where the log is saved and the application status of the MassLynx software (analysis software);

[0115] Enter the timeout of 60s (timel, i.e. the timeout of a single operation) and the number of files 3 (file_nums)

[0116] Collect and store the file path of each integration file and the corresponding integration range information.

[0117] Create a new UPLC method file (.mdb) named MS-96 and save it in the UPLC Method folder of the built-in workspace (M:) for subsequent editing and use.

[0118] Method editing module:

[0119] Initialize and set image path;

[0120] Pre-capture and store the target image (the icon of the MassLynx software in this embodiment);

[0121] Match images in the area to be identified that are similar or identical to the target image;

[0122] Move the mouse to the image and double-click to open the method editing window (MassLynx software method editing window);

[0123] Maximize the method editing window;

[0124] Select the UPLC method file (i.e. the UPLC method file named MS-96);

[0125] Fill in the mass data line by line (see Figure 3 , you can prepare an Excel file with the corresponding mass number data in advance, for example Figure 2 The Excel file containing the corresponding mass number data is stored in the built-in workspace disk of the UPLC method file (UPLC Method (.xlsx)), and the storage path is input into the automated data analysis system, and the system automatically fills in the mass number data line by line according to the content of the Excel file);

[0126] Save the edited UPLC method file and close the method editing window.

[0127] Integration module:

[0128] See also Figure 4 , initialize and select the integration file, open a new sample list and upload the integration file;

[0129] Locate and select the target folder and subfolders;

[0130] Select the specified integration file rows and columns;

[0131] See also Figure 5 , select the UPLC method file and perform integration (i.e. click the "Process Samples" button to pop up the interface, and select the UPLC method file in this interface);

[0132] See also Figure 6 , save the integration result to the clipboard and close the integration window.

[0133] Data processing module:

[0134] Create an Excel file;

[0135] Open the workspace of the analysis software and navigate to the specified Excel file;

[0136] Save the integration results to the specified location of the Excel file;

[0137] Read Excel files and fill missing values;

[0138] See also Figure 7 , filter specific data rows and save them into different subtables.

[0139] The present invention is further described above with the aid of specific embodiments. However, it should be understood that the specific description here should not be construed as limiting the essence and scope of the present invention. Various modifications made to the above embodiments by ordinary technicians in the field after reading this specification are all within the scope of protection of the present invention.

Claims

1. An automated data analysis system, characterized in that: It includes central control module, method editing module, integration module and data processing module; The central control module is connected to the method editing module, the integration module and the data processing module respectively; The central control module is used for connecting with the analysis software, inputting the timeout time and the number of files, and collecting and storing information on the file path of the integral file and the corresponding integral range; The method editing module is used to open and edit the method file of the analysis software through screen automation operation and fill in the mass number data; Integration module: perform integration operations on the integration files in the analysis software and save the integration results to the clipboard; Data processing module: processes and organizes the integration results generated by the integration module, saves and outputs the organized integration results.

2. The automated data analysis system according to claim 1, characterized in that: The central control module is also used to set log configuration and create logs.

3. The automated data analysis system according to claim 1, characterized in that: The screen automation operation includes: Pre-capture and store the target image; Match images in the area to be identified that are similar or identical to the target image; Move the mouse over the image and double-click.

4. The automated data analysis system according to claim 3, characterized in that: The calling process of the method editing module includes: Initialize and set image path; Open the method editing window through screen automation; Maximize the method editing window; Select the UPLC method file; Fill in the mass number data line by line; Save the edited UPLC method file and close the method editing window.

5. The automated data analysis system according to claim 1, characterized in that: The calling process of the integration module includes: Initialize and select the integration file, open a new sample list and upload the integration file; Locate and select the target folder and subfolders; Select the specified integration file rows and columns; Select the UPLC method file and perform integration; Save the integration result to the clipboard and close the integration window.

6. The automated data analysis system according to claim 1, characterized in that: The calling process of the data processing module includes: Create or open the specified Excel file; Open the workspace of the analysis software and navigate to the specified Excel file; Save the integration results to the specified location of the Excel file; Read Excel files and fill missing values; Filter specific data rows and save them into different subtables.

7. The automated data analysis system according to claim 6, characterized in that: The reading of the Excel file and filling the missing values ​​means inserting the None character into the cells with missing data in the Excel file.

8. The automated data analysis system according to claim 1, characterized in that: The analysis software includes MassLynx software, MassHunter software, Empower software, chromeleon software or openlab software.

9. A data analysis method, characterized in that: Use of the automated data analysis system according to any one of claims 1 to 8, comprising: Input the timeout time and the number of files into the automated data analysis system, and collect and store the file path of each integral file and the corresponding integral range information; Connect the automated data analysis system to the analysis software, and pin and maximize the running interface of the analysis software; Traverse each integral file, read the mass number data, and save them separately through multiple sublists; For each integral file and corresponding sublist, the automated data analysis system is called to output the analysis results.

10. An electronic device, characterized in that: include: Memory for storing computer programs; A processor, configured to implement the data analysis method as claimed in claim 9 when executing the computer program.