Crystal component design feedback extraction method and system, electronic equipment and storage medium

Abstract

The invention discloses a crystal component design feedback extraction method and system, electronic equipment and a storage medium, relates to the field of data processing of crystal components, and aims to solve the problems that data are scattered, only one batch can be checked each time, time is consumed, and the data cannot be compared with other batches of products directly. The method comprises the steps of obtaining a target address of a production management system; a design feedback module of the production management system is accessed by using a request module; the data information of the design feedback module is correspondingly placed at the corresponding position of the data dictionary; reading the data information of the design feedback module in the data dictionary by using a built-in function of the request module; and storing the read data information of the design feedback module as data information in a csv format. According to the method, a large amount of data information is quickly crawled from design feedback text information in a production management system in a code mode and is automatically summarized into the same csv file, so that the design feedback is conveniently screened and checked according to various parameters, the time is saved, and the working efficiency is improved.

Description

Technical Field

[0001] This document relates to the field of data processing of crystal components, and in particular to a method, system, electronic device and storage medium for extracting design feedback of crystal components. Background Art

[0002] In the current situation where the traditional manufacturing industry has not yet been fully digitized, all kinds of data generated in the production process are scattered and complex. Design feedback is the designer's text evaluation of each batch of products after the production is completed, which has great guiding significance for future production. As more and more products are produced, the amount of design feedback is also increasing, but the data feedback is stored in the system and is not fully utilized except for normal inquiries. At present, the design feedback of crystal components is entered into the production system, which is relatively sporadic and scattered, and only one batch of design feedback information can be retrieved each time, which is very time-consuming and cannot be directly compared with other batches of products.

[0003] Therefore, a method, system, electronic device and storage medium for extracting crystal component design feedback are proposed. Summary of the invention

[0004] This specification provides a method, system, electronic device and storage medium for extracting design feedback of crystal components, which is used to solve the problem that as more and more products are produced, the number of design feedbacks is also increasing, but the data feedback is stored in the system, which is relatively scattered, and only one batch of design feedback information can be retrieved each time, which is very time-consuming and cannot be directly compared with other batches of products. In addition to normal inquiries, it has not been fully utilized. The extraction method includes:

[0005] Get the target address of the production management system;

[0006] Use the requests module in the Python programming language to access the design feedback module of the production management system;

[0007] Create a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary;

[0008] Use the built-in function of the requests module to read the data information of the design feedback module in the data dictionary;

[0009] The data information of the read design feedback module is saved as data information in csv format.

[0010] In a preferred embodiment, the data information includes: product model, product frequency, product batch, product specification and design feedback.

[0011] In a preferred embodiment, the data information also includes:

[0012] The product model, product frequency, product batch, and product specifications are all part of the product description.

[0013] In a preferred embodiment, the data information also includes:

[0014] The design feedback of the product can be located based on the product model, product frequency, product batch and product specification; the design feedback of the product uniquely corresponds to the product.

[0015] In a preferred embodiment, the data dictionary is in the form of key-value pairs.

[0016] In a preferred embodiment, the data information in csv format is separated by characters csv.

[0017] In a preferred embodiment, the data information in csv format is stored in plain text.

[0018] In a preferred embodiment, the data information in csv format further includes: classifying the data information in csv format into an Excel worksheet, each list is the data information of a product, and a column of data for each product is: i (i=1, 2, 3, 4, 5);

[0019] Among them, D represents the current product, D1 represents the product model of the current product; D2 represents the product frequency of the current product; D3 represents the product batch of the current product; D4 represents the product batch of the current product; and D5 represents the design feedback of the current product.

[0020] A second aspect of the present invention provides a system for extracting crystal component design feedback, the system comprising:

[0021] An address acquisition module is used to obtain the target address of the production management system;

[0022] A data access module for accessing the design feedback module of the production management system using the requests module in the Python programming language;

[0023] The dictionary building module is used to build a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary;

[0024] The data reading module is used to read the data information of the design feedback module in the data dictionary using the built-in functions of the requests module;

[0025] The data saving module is used to save the data information read from the design feedback module into data information in csv format.

[0026] The third aspect of the present invention proposes an electronic device, comprising: at least one processor; and a memory communicatively connected to at least one of the processors; wherein the memory stores instructions executable by the processor, the instructions being used by the processor to execute the above-mentioned method for extracting crystal component design feedback.

[0027] A fourth aspect of the present invention is a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to be executed by the computer to implement the above-mentioned method for extracting crystal component design feedback.

[0028] At least one of the above technical solutions adopted in the embodiments of this specification can achieve the following beneficial effects:

[0029] The present invention aims to use code to quickly crawl a large amount of data information from the design feedback text information in the production management system, and then automatically summarize it into the same csv file, so that designers can directly filter and view the design feedback according to various parameters, save time and improve work efficiency, summarize the difference level between products more quickly, facilitate the later control of production, and make optimization suggestions. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0031] Figure 1 A flowchart of a method for extracting crystal component design feedback provided in one embodiment of this specification. DETAILED DESCRIPTION

[0032] In order to make the purpose, technical solution and advantages of the present application clearer, the technical solution of the present application will be clearly and completely described below in combination with the specific embodiments of the present application and the corresponding drawings. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without making creative work are within the scope of protection of the present application.

[0033] The technical solutions provided by various embodiments of the present application are described in detail below in conjunction with the accompanying drawings.

[0034] Figure 1 A method for extracting crystal component design feedback provided in an embodiment of this specification is shown in Figure 1 , the method may specifically include the following steps:

[0035] Get the target address of the production management system;

[0036] Use the requests module in the Python programming language to access the design feedback module of the production management system;

[0037] Create a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary;

[0038] Use the built-in function of the requests module to read the data information of the design feedback module in the data dictionary;

[0039] The data information of the read design feedback module is saved as data information in csv format.

[0040] In order to specifically illustrate a method for extracting crystal component design feedback of the present application, the content of the present application is described in detail below:

[0041] Crawler technology is currently widely used in the Internet field, but it has not yet been widely used in traditional manufacturing. The field of crystal components is a very niche traditional manufacturing field. If it can be combined with emerging Internet technologies, it will greatly improve work efficiency and facilitate the analysis and resolution of related technical problems.

[0042] Crystal components need to go through various stages of inspection from production to delivery to users to ensure that products with excellent performance and various indicators that meet the requirements are delivered to users. The first stage of inspection is to provide design feedback after each batch of products is produced.

[0043] Design feedback is a text description of the basic indicators of this batch of products by the designer after production is completed. Each batch of products has corresponding model, frequency, batch, and specification information, and these four pieces of information can accurately locate a specific batch of products.

[0044] Production is the process of product manufacturing. The quality of the product depends entirely on the production level. Therefore, the design feedback information after production is completed is very important for designers. The design feedback can be used to improve the process level and improve the performance quality of the device after optimization.

[0045] Therefore, a method for extracting crystal component design feedback is proposed, which specifically includes:

[0046] Get the target address of the production management system;

[0047] Use the requests module in the Python programming language to access the design feedback module of the production management system;

[0048] Create a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary;

[0049] Use the built-in function of the requests module to read the data information of the design feedback module in the data dictionary;

[0050] In this embodiment, the data dictionary is in the form of key-value pairs.

[0051] The data information of the read design feedback module is saved as data information in csv format.

[0052] In this embodiment, the crawler technology is implemented based on Python code.

[0053] In this embodiment, the data information includes: product model, product frequency, product batch, product specification and design feedback. The product model, product frequency, product batch and product specification are all descriptions of the product; the design feedback of the product can be located based on the product model, product frequency, product batch and product specification; the design feedback of the product uniquely corresponds to the product.

[0054] In this embodiment, the data information in csv format is separated by csv as a character. The data information in csv format is stored in plain text. The data information in csv format also includes: classifying the data information in csv format into an Excel worksheet, each list is the data information of a product, and a column of data for each product is: D i (i=1, 2, 3, 4, 5);

[0055] Among them, D represents the current product, D1 represents the product model of the current product; D2 represents the product frequency of the current product; D3 represents the product batch of the current product; D4 represents the product batch of the current product; and D5 represents the design feedback of the current product.

[0056] Finally, the information in the Excel worksheet is used as a data set to facilitate designers to filter and query design feedback information and analyze or predict product conditions.

[0057] A second embodiment of the present invention provides a system for extracting crystal component design feedback, the system comprising:

[0058] An address acquisition module is used to obtain the target address of the production management system;

[0059] A data access module for accessing the design feedback module of the production management system using the requests module in the Python programming language;

[0060] The dictionary building module is used to build a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary;

[0061] The data reading module is used to read the data information of the design feedback module in the data dictionary using the built-in functions of the requests module;

[0062] The data saving module is used to save the data information read from the design feedback module into data information in csv format.

[0063] The third embodiment of the present invention provides an electronic device, comprising: at least one processor; and a memory communicatively connected to at least one of the processors; wherein the memory stores instructions executable by the processor, and the instructions are used to be executed by the processor to implement the above-mentioned method for extracting crystal component design feedback.

[0064] A fourth embodiment of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to be executed by the computer to implement the above-mentioned method for extracting crystal component design feedback.

[0065] The above is only an embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A method for extracting crystal component design feedback, characterized in that: The method comprises: Get the target address of the production management system; Use the requests module in the Python programming language to access the design feedback module of the production management system; Create a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary; Use the built-in function of the requests module to read the data information of the design feedback module in the data dictionary; The data information of the read design feedback module is saved as data information in csv format.

2. The method for extracting crystal component design feedback according to claim 1, characterized in that: The data information includes: product model, product frequency, product batch, product specification and design feedback.

3. The method for extracting crystal component design feedback according to claim 2, characterized in that: The data information specifically includes: The product model, product frequency, product batch, and product specifications are all descriptive information of the product; based on the descriptive information of the product, the design feedback of the product can be located; the design feedback of the product uniquely corresponds to the product.

4. The method for extracting crystal component design feedback according to claim 3, characterized in that: The data dictionary contains key-value pairs.

5. The method for extracting crystal component design feedback according to claim 4, characterized in that: The data information in the csv format uses csv as the character separation value.

6. The method for extracting crystal component design feedback according to claim 5, characterized in that: The data information in the csv format is stored in plain text.

7. The method for extracting crystal component design feedback according to claim 6, characterized in that: The data information in csv format also includes: classifying the data information in csv format into an Excel table, each table is the data information of a product, and a column of data for each product is: i (i=1, 2, 3, 4, 5); Among them, D represents the current product, D1 represents the product model of the current product; D2 represents the product frequency of the current product; D3 represents the product batch of the current product; D4 represents the product batch of the current product; and D5 represents the design feedback of the current product.

8. A system for extracting crystal component design feedback, characterized in that: The system comprises: An address acquisition module is used to obtain the target address of the production management system; A data access module for accessing the design feedback module of the production management system using the requests module in the Python programming language; The dictionary building module is used to build a data dictionary and put the data information of the design feedback module into the corresponding position of the data dictionary; The data reading module is used to read the data information of the design feedback module in the data dictionary using the built-in functions of the requests module; The data saving module is used to save the data information read from the design feedback module into data information in csv format.

9. An electronic device, characterized in that: include: at least one processor; as well as A memory communicatively connected to at least one of the processors; wherein the memory stores instructions executable by the processor, the instructions being used to be executed by the processor to implement the method for extracting crystal component design feedback as described in any one of claims 1-7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer instructions, and the computer instructions are used to be executed by the computer to implement the method for extracting crystal component design feedback according to any one of claims 1 to 7.

Images