Machine tool configuration file data processing method and device

Abstract

The application provides a machine tool configuration file data processing method and device, and relates to the field of data processing.The method comprises the following steps: obtaining a machine tool configuration file, structurally expressing machine tool type information, and obtaining a machine tool type hierarchical expression structure diagram; the machine tool configuration file comprises the machine tool type information and machine tool attribute information; constructing at least two layers of multilevel data structure relationship tables according to the hierarchical relationship of the machine tool type hierarchical expression structure diagram; and using a data analysis processing tool to process the field corresponding data in each hierarchical data structure relationship table and the machine tool attribute information, so as to obtain data processing result information.The device executes the above method.The machine tool configuration file data processing method and device provided in the application can simplify machine tool configuration file data, help manage machine tool configuration files, and further facilitate machine tool maintenance and development and the like.

Description

Technical Field

[0001] This invention relates to the field of data processing, and more specifically to a method and apparatus for processing machine tool configuration file data. Background Technology

[0002] Machine tool configuration files, such as those for EDM machine tools, refer to a collection of configuration files containing the software and hardware environment required for the normal operation of an EDM machine tool. Because the definition of a configuration file is very broad, the configuration file mentioned in this invention refers specifically to the configuration file related to EDM attributes in an EDM machine tool, or simply the configuration file. A powerful machine tool will inevitably have a large and information-rich configuration file, which is a key element in ensuring the normal operation of the machine tool.

[0003] EDM machine tool configuration files can be broadly categorized into basic attribute configuration files and functional component attribute configuration files. Basic attribute configuration files contain fundamental machine tool information, such as the machine's travel distance. Functional component attribute configuration files refer to settings for various functional subsystems of the machine tool, such as the electrode wire settings in the wire feeding system of a wire EDM machine. Different EDM machine models have different configuration files. Therefore, given the large number of machine tool models, summarizing and uniformly managing machine tool configuration files greatly facilitates the maintenance and development of the machine tool system. Summary of the Invention

[0004] To address the problems in the prior art, embodiments of the present invention provide a machine tool configuration file data processing method and apparatus, which can at least partially solve the problems existing in the prior art.

[0005] On one hand, the present invention proposes a machine tool configuration file data processing method, including:

[0006] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0007] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0008] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0009] The process of using data analysis and processing tools to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain data processing result information includes:

[0010] Data analysis and processing tools are used to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables of each level and the attribute information of each machine tool to obtain data merging and processing information.

[0011] Based on the data merging and processing information, and according to the machine tool attribute information and the machine type identifier field of the first hierarchical data structure relationship table, data groups are obtained where the configuration data value and the machine type identifier field data are the same;

[0012] Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of each group of data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to deduplicate the merged data to obtain intermediate data processing results. The next-level data structure relation table executed for the first time is the last-level data structure relation table.

[0013] Based on the data corresponding to the symbolic field of machine type in the intermediate data processing result information, and the attribute information of each machine tool, the group data is regrouped;

[0014] Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of the regrouped data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to remove duplicate data after merging until all levels of data structure have been traversed, and the intermediate data processing result information is obtained.

[0015] Using the data analysis and processing tool, and based on the intermediate data processing results and machine tool attribute information, the data is grouped. The machine model identifier field of each group of data is deduplicated to obtain the data processing result information.

[0016] The process of using data analysis and processing tools to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables at each level, as well as the attribute information of each machine tool, to obtain data merging and processing information includes:

[0017] Each machine tool attribute information is treated as a separate column of data, and the symbolic field of machine type in the data structure relationship table at each level is treated as a separate column of data.

[0018] The data merging process, which involves considering the data relationship between the symbolic field data of the aircraft type in the next-level data structure relation table and the symbolic field data of the aircraft type in the previous-level data structure relation table, includes:

[0019] Merge the model type symbolic field of the next-level data structure relation table into the upper-level model type, and assign the model type symbolic field of the next-level data structure relation table a value of 0.

[0020] The regrouping of the group data based on the machine type symbolic field corresponding to the data in the intermediate data processing result information and the attribute information of each machine tool includes:

[0021] Select groups whose model type symbolic field value is 0 in the next-level data structure relation table of the intermediate data processing result information;

[0022] Based on the machine tool attribute information and the machine type symbolic field of the next-level data structure relationship table, the groups with a value of 0 are further grouped to obtain a set of machine type identifier fields for each group.

[0023] The data merging process, which involves considering the data relationship between the symbolic field data of the aircraft type in the next-level data structure relation table and the symbolic field data of the aircraft type in the previous-level data structure relation table, includes:

[0024] Merge the model type symbolic field of the next-level data structure relation table into the upper-level model type, and assign the model type symbolic field of the next-level data structure relation table a value of 0.

[0025] On one hand, the present invention proposes a machine tool configuration file data processing device, comprising:

[0026] The acquisition unit is used to acquire the machine tool configuration file, express the machine tool type information in a structured way, and obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0027] A construction unit is used to construct a multi-level data structure relationship table with at least two layers based on the layer-level relationship of the machine tool type hierarchical expression structure diagram; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0028] The processing unit is used to process the data corresponding to the fields in the data structure relationship tables at each level and the machine tool attribute information using data analysis and processing tools, and to obtain the data processing result information.

[0029] In another aspect, embodiments of the present invention provide a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it implements the following method:

[0030] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0031] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0032] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0033] This invention provides a computer-readable storage medium, comprising:

[0034] The computer-readable storage medium stores a computer program that, when executed by a processor, implements the following method:

[0035] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0036] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0037] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0038] This invention also provides a computer program product, which includes a computer program that, when executed by a processor, implements the following method:

[0039] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0040] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0041] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0042] The machine tool configuration file data processing method and apparatus provided in this invention obtains a machine tool configuration file, performs a structured expression of machine tool type information, and obtains a machine tool type hierarchical expression structure diagram. The machine tool configuration file includes machine tool type information and machine tool attribute information. Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, a multi-level data structure relationship table with at least two layers is constructed. Each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field. The next level of the multi-level data structure relationship table also includes the machine type identifier field from the previous level. Data analysis and processing tools are used to process the corresponding data in each level of the data structure relationship table, along with the machine tool attribute information, to obtain data processing results. This simplifies the machine tool configuration file data, facilitates its management, and thus enables convenient machine tool maintenance and development. Attached Figure Description

[0043] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. In the drawings:

[0044] Figure 1 This is a schematic flowchart of a machine tool configuration file data processing method provided in an embodiment of the present invention.

[0045] Figure 2 This is a schematic diagram of the configuration file structure of a machine tool configuration file data processing method provided in an embodiment of the present invention.

[0046] Figure 3 This is a schematic diagram of the tree structure representation of the machine tool type structure in the machine tool configuration file data processing method provided in an embodiment of the present invention.

[0047] Figure 4 This is a schematic diagram illustrating the relationship between Level 1 and Level 2 structures of a machine tool configuration file data processing method provided in an embodiment of the present invention.

[0048] Figure 5 This is a schematic diagram illustrating the relationship between Level 2 and Level 3 structures in a machine tool configuration file data processing method provided in an embodiment of the present invention.

[0049] Figure 6 This is a schematic diagram illustrating the method for processing machine tool configuration file data according to an embodiment of the present invention, in which all data is merged into a DataFrame-df_rawMerg.

[0050] Figure 7 This is a schematic diagram illustrating the merging and deduplication of machine tool configuration data from machine tool type Level 3 to Level 2 in a machine tool configuration data processing method provided by an embodiment of the present invention.

[0051] Figure 8 This is a schematic diagram illustrating the merging and deduplication of machine tool configuration data from machine tool type Level 2 to Level 1 in a machine tool configuration data processing method provided by an embodiment of the present invention.

[0052] Figure 9 This is an illustrative diagram illustrating how the same configuration data for different machine tool models is stored in a SubTypeID list format according to an embodiment of the machine tool configuration file data processing method provided by the present invention.

[0053] Figure 10 This is a schematic diagram of the structure of a machine tool configuration file data processing device provided in an embodiment of the present invention.

[0054] Figure 11 This is a schematic diagram of the physical structure of a computer device provided in an embodiment of the present invention. Detailed Implementation

[0055] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings. Here, the illustrative embodiments and descriptions of the present invention are used to explain the present invention, but are not intended to limit the present invention. It should be noted that, unless otherwise specified, the embodiments and features in the embodiments of this application can be arbitrarily combined with each other.

[0056] Figure 1 This is a flowchart illustrating a machine tool configuration file data processing method according to an embodiment of the present invention, as shown below. Figure 1 As shown, the machine tool configuration file data processing method provided in this embodiment of the invention includes:

[0057] Step S1: Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information.

[0058] Step S2: Construct a multi-level data structure relationship table with at least two layers based on the layer-level relationship of the machine tool type hierarchical expression structure diagram; each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next level of the multi-level data structure relationship table also includes the machine type identifier field of the previous level data structure relationship table.

[0059] Step S3: Use data analysis and processing tools to process the data corresponding to the fields in the data structure relationship tables at each level and the machine tool attribute information to obtain the data processing result information.

[0060] In step S1 above, the device acquires a machine tool configuration file, performs a structured representation of the machine tool type information, and obtains a hierarchical representation structure diagram of the machine tool type; the machine tool configuration file includes the machine tool type information and machine tool attribute information. The device can be a computer device, such as a server, that executes this method. The acquisition, storage, use, and processing of data in this application's technical solution all comply with relevant national laws and regulations. Figure 2 As shown, the configuration file structure for machine tool configuration files is explained below:

[0061] This method offers maximum compatibility with machine tool configuration file structures in XML and JSON formats. Other file types are also compatible if their content can be ultimately parsed into a two-dimensional array structure, i.e., the structure that a pandas DataFrame can represent.

[0062] The specific requirements for the format and content of the machine tool configuration file are as follows:

[0063] 1. The configuration file needs to include machine tool type information to distinguish which machine model the configuration file belongs to.

[0064] 2. If the machine tool attribute information units contained in the configuration file can be mapped to one-dimensional arrays and have the same structure, then the attribute information set can be mapped to a two-dimensional array.

[0065] exist Figure 2 In the example, the attribute information set named Parameters contains the machine tool type information corresponding to that attribute set. <machinetypeinfo1>and <machinetypeinfo2>In reality, due to the different classification methods for machine tool types, the number of labels and the way they are displayed for machine tool type information need to be designed according to specific circumstances. <parameters>It contains multiple names <parameter>The attribute information units, which have the same structure, each <parameter>The lower-level child nodes describe all the information about this attribute, and use... <id>The values ​​are used to distinguish them.

[0066] like Figure 3 As shown, the structured description of machine tool types is as follows:

[0067] Since this method aims to summarize and integrate similar configuration files for various types of machine tools, a structured representation of machine tool types is also essential.

[0068] The structured representation of machine tool types involves classifying, stratifying, and symbolizing all machine tool types, ultimately storing them in the form of tables or structured documents. For example, machine tool types can be classified as wire EDM and forming machines, further subdivided into different levels based on factors such as mechanical stroke and function. Wire EDM machines can be represented by the symbol CUT. Figure 3 The document describes the classification of EDM machine tools and the hierarchical structure under each classification. This structure can be expressed through relational tables or other structured data formats.

[0069] In step S2 above, the device constructs a multi-level data structure relationship table with at least two layers based on the layer-level relationships of the machine tool type hierarchical expression structure diagram. Each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field. The next layer of the multi-level data structure relationship table also includes the machine type identifier field from the previous layer. For example... Figure 3 Taking the three-level layer relationship shown as an example, a two-level data structure relationship table needs to be constructed, such as... Figure 4 The diagram shows the structural relationship between Level 1 and Level 2; as shown... Figure 5 The diagram illustrates the structural relationship between Level 2 and Level 3. Figure 4 The explanation is as follows:

[0070] Figure 4 Described Figure 3 The structural relationship between Level 1 machine tool types and Level 2 machine tool types. Figure 4 The TypeID in the field is used to uniquely identify each model (corresponding to the model identifier field).

[0071] Category describes the classification of various machine tool types.

[0072] Type Code is a symbolic representation of machine tool types in Level 1 and Level 2 (corresponding to the machine type symbolic field), where '0' represents the upper-level machine type in the hierarchy. Taking the machine tool type with Category CUT as an example, the machine type with Type ID 1 has a Type Code of 0, which is the parent type of this machine type. Other machine types with Category CUT (Type IDs 3, 4, and 5) are subtypes.

[0073] The Name and Description fields are used to describe the name and summary information of the machine tool type, respectively.

[0074] Figure 5 It describes Figure 3 The structural relationship between Level 2 and Level 3 is shown. SubTypeID is used not only to uniquely identify the models in Level 2 and Level 3, but also to identify the models in Level 1, so as to ensure that all models are identified uniformly in this diagram.

[0075] TypeID refers to the upper-level model. For a Level 3 model, its TypeID refers to the model in the Level 2 upper level.

[0076] SubTypeCode is a symbol for the device types in Level 2 and Level 3, where '0' represents the upper-level device type. Taking all devices corresponding to Type ID 4 (subTypeIDs 5, 6, and 7) as an example, the device with SubTypeID 5 has a SubTypeCode of 0, indicating that this device type is the parent type in this device type group, and the other devices (subTypeIDs 6 and 7) are its subtypes. Figure 5 The Type ID in the code is a foreign key, corresponding to... Figure 4 The primary key in the database.

[0077] The above describes the three-layer structure of the machine tool type. Figure 4 and Figure 5 If there are more than three levels of structure in reality, the number of tables and the description of relationships need to be increased accordingly.

[0078] In step S3 above, the device uses data analysis and processing tools to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results. This method can be implemented based on the ConfInte method, which is briefly explained below:

[0079] ConfInte maps data from configuration files into Pandas DataFrames, performing grouping, merging, and deduplication operations on similar machine tool configuration files, ultimately integrating the configuration information of all types of machine tools into a single DataFrame. Pandas is a data analysis and processing tool, and DataFrame is its data structure.

[0080] The process involves using data analysis and processing tools to process the data corresponding to fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain data processing results, including:

[0081] Data analysis and processing tools were used to merge the symbolic fields corresponding to machine type in the data structure relationship tables at each level, as well as the attribute information of each machine tool, to obtain data merging information. ConfInte first reads the configuration files of the same type for all machine tool types into a DataFrame, which includes configuration parameters and machine tool types. For ease of explanation later, this DataFrame is named df_rawMerg.

[0082] The process involves using data analysis and processing tools to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables at each level, as well as the attribute information of each machine tool, to obtain data merging and processing information, including:

[0083] Each machine tool attribute information is treated as a separate column of data, and the symbolic field of machine type in the data structure relationship table at each level is treated as a separate column of data.

[0084] by Figure 4 and Figure 5 Taking the described machine tool type structure as an example, such as Figure 6 The description states that ConfInte merges configuration file data named Config.xml for various machine tools, along with the corresponding machine tool type symbols SubTypeCode and TypeCode, into a dataframe named df_rawMerg (corresponding to data merging processing information). Each attribute of a data element in the configuration file is a column, with SubTypeCode and TypeCode each forming a separate column.

[0085] Based on the data merging and processing information, and according to the machine tool attribute information and the model identifier field of the first hierarchical data structure relationship table, data is grouped to obtain groups of data where the configuration data value and the model identifier field data are the same; df_rawMerg is grouped based on [ParamID,Name,Value...DefaultValue,TypeCode]. This will group all Series (in this article, Series refers to the row Series of a DataFrame) whose configuration data value and TypeCode are completely equal.

[0086] Based on the data relationship between the aircraft type symbolic field data of the next-level data structure relation table and the aircraft type symbolic field data of the previous-level data structure relation table, data merging is performed. Data analysis tools are then used to deduplicate the merged data, yielding intermediate processing results. The first next-level data structure relation table executed is the final-level data structure relation table. The data merging process, based on the data relationship between the aircraft type symbolic field data of the next-level data structure relation table and the aircraft type symbolic field data of the previous-level data structure relation table, includes:

[0087] Merge the machine type symbolic fields from the next-level data structure relation table into the upper-level machine type table, and assign the machine type symbolic fields from the next-level data structure relation table a value of 0. Check the SubTypeCode values ​​in the Series within each group, obtain the set of SubTypeCodes for each Series group, and merge and deduplicate them according to the relationships in the machine tool structure table.

[0088] like Figure 7 As shown, with Figure 5 Taking CUT-Type-B and its subtypes as an example, their corresponding SubTypeCode set is [0, 121, 122]. If the SubTypeCode set of Series in this group is [121, 122], it means that the configuration data value of this CUT-Type-B subtype in this group is the same. Therefore, the SubTypeCode of all Series in this group can be merged into its parent model, that is, represented by 0. Then, pandas is used to perform deduplication to generate a new DataFrame. For ease of reference, it is named df_lvl3Merg (corresponding to intermediate data processing result information).

[0089] Based on the data corresponding to the symbolic field of machine type in the intermediate data processing result information, and the attribute information of each machine tool, the group data is regrouped; the regrouping of the group data based on the data corresponding to the symbolic field of machine type in the intermediate data processing result information, and the attribute information of each machine tool, includes:

[0090] Select groups whose machine type symbolic field value is 0 in the next level data structure relation table of the intermediate data processing results information; df_lvl3Merg is the result of merging and deduplicating machine tool configuration data from machine tool type Level 3 to Level 2. Next, we need to merge and deduplicatize machine tool configuration data from machine tool type Level 2 to Level 1.

[0091] Select the Series in df_lvl3Merg where all SubTypeCode is 0, because when the SubTypeCode of a Series is 0, it means that the machine tool data in the Series corresponds to the machine type at the Level 2 level.

[0092] Based on the machine tool attribute information and the machine type symbolic field of the next-level data structure relationship table, groups with values ​​of 0 are further grouped to obtain a set of machine type identifier fields for each group. Series with SubTypeCode values ​​all of 0 are grouped based on [ParamID, Name, Value...DefaultValue, SubTypeCode] to obtain the TypeCode set for each Series. Then, based on the relationships in the machine tool structure table, merging and deduplication are performed.

[0093] Based on the data relationship between the symbolic field of aircraft type in the next-level data structure relation table of the regrouped data and the symbolic field of aircraft type in the previous-level data structure relation table, data merging is performed. Data analysis tools are then used to deduplicate the merged data until all levels of the data structure have been traversed, yielding the intermediate data processing result. The data merging process, based on the data relationship between the symbolic field of aircraft type in the next-level data structure relation table of the regrouped data and the symbolic field of aircraft type in the previous-level data structure relation table, includes:

[0094] Merge the model type symbolic field of the next-level data structure relation table into the upper-level model type, and assign the model type symbolic field of the next-level data structure relation table a value of 0.

[0095] like Figure 8 As shown, with Figure 3 Taking the CUT Category as an example, its TypeCode data set is [0, 11, 12, 13]. If the TypeCode set of a certain group of Series is [11, 12, 13], it means that the value of this configuration data is the same for all models in the group. Therefore, the TypeCode of all Series in the group can be merged into its upper-level model, that is, represented by only 0, and then deduplication is performed to obtain a further compressed and integrated DataFrame. For ease of reference below, it is named df_lvl2Merg (corresponding to the intermediate data processing result information).

[0096] Using the aforementioned data analysis and processing tool, and based on the intermediate data processing results and machine tool attribute information, data is grouped. The machine model identifier field of each group is deduplicated to obtain the data processing result information. The process of grouping the data using the aforementioned data analysis and processing tool, and based on the intermediate data processing results and machine tool attribute information, and deduplicating the machine model identifier field of each group, includes:

[0097] The machine model identifier field of each group of data is organized into a list, with only one record retained. As mentioned in the "Structured Machine Tool Types" section, due to... Figure 5 The SubTypeID is used to uniquely identify a machine tool type, so the final merged machine tool type is identified by the SubTypeID.

[0098] df_lvl2Merg is based on Figure 4 and Figure 5 The machine tool type structure in the code is used to process the data in df_rawMerg that can be merged to obtain a DataFrame. However, in reality, df_lvl2Merg also contains many data with the same configuration data values ​​but different machine tool models, and these machine models cannot be merged.

[0099] To compress this data, Pandas is used again to group df_lvl2Merg based on [ParamID, Name, Value, ... DefaultValue]. The SubTypeIDs of each Series are then organized into a list of SubTypeIDs, deduplicated, and stored in only one Series to further save space. The final generated DataFrame is named df_finalMerg (corresponding to the data processing result information).

[0100] like Figure 9 As shown in the example, CUT-Type-A-Sizeα (SubTypeID is 4) and CUT-Type-B-Sizeα (SubTypeID is 6) have the same configuration data value, but their configuration data values ​​are different from those of CUT-Type-B-Sizeβ. Therefore, CUT-Type-B-Sizeα cannot be merged with the configuration data of CUT-Type-B-Sizeβ into its upper-layer model CUT-Type-B. However, the configuration data of CUT-Type-A-Sizeα and CUT-Type-B-Sizeα can still be merged and stored in the form of a SubTypeID list {'4','6'} to save space.

[0101] After processing by ConfInte, the Config.xml configuration files for all machine tool types went through df_rawMerg->df_lvl3Merg->df_lvl2Merg->df_finalMerg. The final generated DataFrame, df_finalMerg, contains the data information from the Config.xml files of all machine tools, but without any duplicate entries and retains the corresponding machine tool type information, making it valuable data for preservation and analysis.

[0102] This invention proposes a Pandas-based method for integrating machine tool configuration files, ConfInte. This method can extract similar configuration files from different machine tool models, perform data cleaning operations such as classification and integration based on machine tool type, and thus obtain a dataset compatible with configuration files of all machine tool types.

[0103] This method utilizes the popular data analysis tool pandas, which is simple to program and highly efficient.

[0104] The method itself is ingeniously conceived, abandoning the traditional traversal method and proposing the idea of ​​splitting and mapping the configuration file into a Pandas DataFrame, and then processing the DataFrame.

[0105] From a data analysis perspective, the configuration information for different machine models in the configuration file is merged and deduplicated. The resulting data can be stored in a database and maintained as the original data for regenerating machine tool configuration files.

[0106] The generated data can also be stored in files such as CSV as intermediate data for analyzing machine tools with configuration errors, and its practical significance cannot be ignored.

[0107] The method for integrating machine tool configuration files based on Pandas in this application abstracts the machine tool configuration data into a DataFrame in Pandas. Based on the hierarchical structure of machine tool types and combined with the idea of ​​data cleaning, it integrates the same type of configuration files of all types of machine tools, removes duplicates, and obtains structured and clean data.

[0108] It leverages Pandas' powerful data analysis and processing capabilities to integrate complete machine tool configuration data and machine tool type information into a single DataFrame with concise code and high processing efficiency.

[0109] Since the data converted into a DataFrame is equivalent to cleaned structured data, it already has high analytical and storage value. Therefore, it is of great significance whether it is used for data analysis of machine tool attributes or stored in a database for reuse, which can help enterprises save time and improve efficiency.

[0110] The machine tool configuration file data processing method provided in this invention involves obtaining a machine tool configuration file, structurally representing machine tool type information to obtain a machine tool type hierarchical representation structure diagram; the machine tool configuration file includes machine tool type information and machine tool attribute information; constructing a multi-level data structure relationship table with at least two layers based on the layer-level relationship of the machine tool type hierarchical representation structure diagram; each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next level of the multi-level data structure relationship table also includes the machine type identifier field of the previous level data structure relationship table; using data analysis and processing tools to process the corresponding data of the fields in each level of the data structure relationship table and the machine tool attribute information to obtain data processing result information, which can simplify the machine tool configuration file data, help manage the machine tool configuration file, and thus facilitate machine tool maintenance and development.

[0111] Furthermore, the data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing result information, including:

[0112] Data analysis and processing tools are used to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables at each level, as well as the attribute information of each machine tool, to obtain the data merging and processing information; please refer to the above instructions, which will not be repeated here.

[0113] Based on the data merging and processing information, and according to the machine tool attribute information and the model identifier field of the first hierarchical data structure relationship table, data groups are obtained where the configuration data value and the model identifier field data are the same; please refer to the above description, which will not be repeated here.

[0114] Based on the data relationship between the symbolic field of the aircraft type in the next-level data structure relation table and the symbolic field of the aircraft type in the previous-level data structure relation table, data merging is performed. Then, data analysis and processing tools are used to deduplicate the merged data to obtain intermediate data processing results. The next-level data structure relation table executed for the first time is the last-level data structure relation table. Please refer to the above explanation, which will not be repeated here.

[0115] Based on the data corresponding to the symbolic field of machine type in the intermediate data processing results, and the attribute information of each machine tool, the group data is regrouped; please refer to the above description, which will not be repeated here.

[0116] Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of the regrouped data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to remove duplicate data after merging, until all levels of data structure have been traversed, and the intermediate data processing result information is obtained; please refer to the above explanation, which will not be repeated here.

[0117] Using the aforementioned data analysis and processing tool, and based on the intermediate data processing results and machine tool attribute information, the data is grouped. The machine model identifier field of each group is then deduplicated to obtain the data processing result information. This can be referred to the above description and will not be repeated here.

[0118] Furthermore, the data analysis and processing tools are used to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables at each level, as well as the attribute information of each machine tool, to obtain data merging and processing information, including:

[0119] Each machine tool's attribute information is treated as a separate column of data, and the symbolic field for machine type in the relationship tables with each level of data structure is also treated as a separate column of data. Refer to the above explanation; further details are omitted.

[0120] Furthermore, the data merging process, based on the data relationship between the symbolic field data of the aircraft type in the next-level data structure relation table and the symbolic field data of the aircraft type in the previous-level data structure relation table, includes:

[0121] The symbolic field for the model type in the next-level data structure relation table is merged into the model type field in the next-level data structure relation table, and the symbolic field for the model type in the next-level data structure relation table is assigned a value of 0. Refer to the above explanation; further details are omitted.

[0122] Furthermore, the regrouping of the group data based on the machine type symbolic field corresponding to the data in the intermediate data processing result information, and the attribute information of each machine tool, includes:

[0123] Select the group whose model type symbolic field value is 0 in the next level data structure relation table of the intermediate data processing result information; refer to the above description, and will not be repeated here.

[0124] Based on the machine tool attribute information and the machine type symbolic field of the next-level data structure relationship table, the groups with values ​​of 0 are further grouped to obtain a set of machine type identifier fields for each group. Refer to the above explanation; further details are omitted.

[0125] Furthermore, the data merging process based on the data relationship between the symbolic field data of the aircraft type in the next-level data structure relation table of the regrouped data and the symbolic field data of the aircraft type in the previous-level data structure relation table includes:

[0126] The symbolic field for the model type in the next-level data structure relation table is merged into the model type field in the next-level data structure relation table, and the symbolic field for the model type in the next-level data structure relation table is assigned a value of 0. Refer to the above explanation; further details are omitted.

[0127] Figure 10 This is a schematic diagram of the structure of a machine tool configuration file data processing device provided in an embodiment of the present invention, as shown below. Figure 10 As shown, the machine tool configuration file data processing device provided in this embodiment of the invention includes an acquisition unit 1001, a construction unit 1002, and a processing unit 1003, wherein:

[0128] The acquisition unit 1001 is used to acquire the machine tool configuration file, and to express the machine tool type information in a structured way to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information; the construction unit 1002 is used to construct at least two levels of multi-level data structure relationship tables according to the layer-level relationship of the machine tool type hierarchical expression structure diagram; each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next level of the multi-level data structure relationship table also includes the machine type identifier field of the previous level of the data structure relationship table; the processing unit 1003 is used to use data analysis and processing tools to process the data corresponding to the fields in each level of the data structure relationship table and the machine tool attribute information to obtain data processing result information.

[0129] Specifically, the acquisition unit 1001 in the device is used to acquire the machine tool configuration file, perform structured expression of the machine tool type information, and obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information; the construction unit 1002 is used to construct at least two levels of multi-level data structure relationship tables according to the layer-level relationship of the machine tool type hierarchical expression structure diagram; each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next level of the multi-level data structure relationship table also includes the machine type identifier field of the previous level of the data structure relationship table; the processing unit 1003 is used to use data analysis and processing tools to process the data corresponding to the fields in each level of the data structure relationship table and the machine tool attribute information to obtain data processing result information.

[0130] The machine tool configuration file data processing device provided in this embodiment of the invention acquires a machine tool configuration file, performs a structured expression of machine tool type information, and obtains a machine tool type hierarchical expression structure diagram. The machine tool configuration file includes machine tool type information and machine tool attribute information. Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, a multi-level data structure relationship table with at least two layers is constructed. Each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field. The next layer of the multi-level data structure relationship table also includes the machine type identifier field from the previous layer. Data analysis and processing tools are used to process the corresponding data in each layer of the data structure relationship table, along with the machine tool attribute information, to obtain data processing results. This simplifies the machine tool configuration file data, facilitates the management of machine tool configuration files, and thus facilitates machine tool maintenance and development.

[0131] The embodiments of the present invention provide a machine tool configuration file data processing device that can be used to execute the processing flow of the above-described method embodiments. Its functions will not be repeated here, but can be referred to the detailed description of the above-described method embodiments.

[0132] Figure 11 This is a schematic diagram of the physical structure of a computer device provided in an embodiment of the present invention, such as... Figure 11 As shown, the computer device includes: a memory 1101, a processor 1102, and a computer program stored in the memory 1101 and executable on the processor 1102. When the processor 1102 executes the computer program, it implements the following method:

[0133] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0134] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0135] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0136] This embodiment discloses a computer program product, which includes a computer program that, when executed by a processor, implements the following method:

[0137] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0138] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0139] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0140] This embodiment provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the following method:

[0141] Obtain the machine tool configuration file, and express the machine tool type information in a structured manner to obtain a machine tool type hierarchical expression structure diagram; the machine tool configuration file includes the machine tool type information and machine tool attribute information;

[0142] Based on the layer-level relationships of the machine tool type hierarchical expression structure diagram, construct at least two layers of multi-level data structure relationship tables; each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next layer of the multi-level data structure relationship table also includes the machine type identifier field of the previous layer of the data structure relationship table;

[0143] Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain the data processing results.

[0144] Compared with existing technologies, this invention obtains a machine tool configuration file, structures the machine tool type information to obtain a hierarchical representation diagram of the machine tool type; the machine tool configuration file includes the machine tool type information and machine tool attribute information; a multi-level data structure relationship table with at least two layers is constructed based on the layer-level relationship of the machine tool type hierarchical representation diagram; each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field, and the next level of the multi-level data structure relationship table also includes the machine type identifier field of the previous level data structure relationship table; data analysis and processing tools are used to process the data corresponding to the fields in each level of the data structure relationship table and the machine tool attribute information to obtain data processing results, which can simplify the machine tool configuration file data, facilitate the management of the machine tool configuration file, and thus facilitate machine tool maintenance and development.

[0145] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0146] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0147] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0148] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0149] In the description of this specification, references to terms such as "an embodiment," "a specific embodiment," "some embodiments," "for example," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the invention. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0150] The specific embodiments described above further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above descriptions are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.< / id> < / parameter> < / parameter> < / parameters>

Claims

1. A method for processing machine tool configuration file data, characterized in that, include: Obtain the machine tool configuration file, express the machine tool type information in a structured way, and obtain the machine tool type hierarchical expression structure diagram; The machine tool configuration file includes the machine tool type information and machine tool attribute information; Based on the layer-level relationships of the machine tool type hierarchy diagram, a multi-level data structure relationship table with at least two layers is constructed. Each layer of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbol field. The next layer of the multi-level data structure relationship table also includes the machine type identifier field from the previous layer. The machine type symbol field of the next layer can reflect the inheritance relationship between the parent type and the child type in the machine type group of the machine type symbol field of the previous layer. Data analysis and processing tools are used to process the data corresponding to the fields in the data structure relationship tables at each level and the machine tool attribute information to obtain the data processing result information. The process involves using data analysis and processing tools to process the data corresponding to fields in the data structure relationship tables at each level, as well as the machine tool attribute information, to obtain data processing results, including: Data analysis and processing tools are used to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables of each level and the attribute information of each machine tool to obtain data merging and processing information. Based on the data merging and processing information, and according to the machine tool attribute information and the machine type identifier field of the first hierarchical data structure relationship table, data groups are obtained where the configuration data value and the machine type identifier field data are the same; Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of each group of data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to deduplicate the merged data to obtain intermediate data processing results. The next-level data structure relation table executed for the first time is the last-level data structure relation table. Based on the data corresponding to the symbolic field of machine type in the intermediate data processing result information, and the attribute information of each machine tool, the group data is regrouped; Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of the regrouped data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to remove duplicate data after merging until all levels of data structure have been traversed, and the intermediate data processing result information is obtained. Using the data analysis and processing tool, and based on the intermediate data processing results and machine tool attribute information, the data is grouped. The machine model identifier field of each group of data is deduplicated to obtain the data processing result information.

2. The machine tool configuration file data processing method according to claim 1, characterized in that, The process involves using data analysis and processing tools to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables at each level, as well as the attribute information of each machine tool, to obtain data merging and processing information, including: Each machine tool attribute information is treated as a separate column of data, and the symbolic field of machine type in the data structure relationship table at each level is treated as a separate column of data.

3. The machine tool configuration file data processing method according to claim 1, characterized in that, The data merging process, based on the data relationship between the symbolic field data of the aircraft type in the next-level data structure relation table and the symbolic field data of the aircraft type in the next-level data structure relation table, includes: Merge the model type symbolic field of the next-level data structure relation table into the upper-level model type, and assign the model type symbolic field of the next-level data structure relation table a value of 0.

4. The machine tool configuration file data processing method according to claim 3, characterized in that, The regrouping of the group data based on the symbolic field corresponding to the machine type in the intermediate data processing result information and the attribute information of each machine tool includes: Select groups whose model type symbolic field value is 0 in the next-level data structure relation table of the intermediate data processing result information; Based on the machine tool attribute information and the machine type symbolic field of the next-level data structure relationship table, the groups with a value of 0 are further grouped to obtain a set of machine type identifier fields for each group.

5. The machine tool configuration file data processing method according to claim 1, characterized in that, The data merging process, based on the data relationship between the symbolic field data of the aircraft type in the next-level data structure relation table of the regrouped data and the symbolic field data of the aircraft type in the next-level data structure relation table, includes: Merge the model type symbolic field of the next-level data structure relation table into the upper-level model type, and assign the model type symbolic field of the next-level data structure relation table a value of 0.

6. A machine tool configuration file data processing device, characterized in that, include: The acquisition unit is used to acquire the machine tool configuration file, express the machine tool type information in a structured way, and obtain the machine tool type hierarchical expression structure diagram; The machine tool configuration file includes the machine tool type information and machine tool attribute information; A construction unit is used to construct at least two levels of multi-level data structure relationship tables based on the layer-level relationships of the machine tool type hierarchical expression structure diagram. Each level of the multi-level data structure relationship table includes at least a machine type identifier field and a machine type symbolization field. The next level of the multi-level data structure relationship table also includes the machine type identifier field of the previous level data structure relationship table. The machine type symbolization field of the next level can reflect the inheritance relationship between the parent type and the child type in the machine type group of the machine type symbolization field of the previous level. The processing unit is used to process the data corresponding to the fields in the data structure relationship table of each level and the machine tool attribute information using data analysis and processing tools to obtain the data processing result information. The processing unit is specifically used for: Data analysis and processing tools are used to merge the data corresponding to the symbolic fields of machine type in the data structure relationship tables of each level and the attribute information of each machine tool to obtain data merging and processing information. Based on the data merging and processing information, and according to the machine tool attribute information and the machine type identifier field of the first hierarchical data structure relationship table, data groups are obtained where the configuration data value and the machine type identifier field data are the same; Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of each group of data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to deduplicate the merged data to obtain intermediate data processing results. The next-level data structure relation table executed for the first time is the last-level data structure relation table. Based on the data corresponding to the symbolic field of machine type in the intermediate data processing result information, and the attribute information of each machine tool, the group data is regrouped; Based on the data relationship between the symbolic field of the model type in the next-level data structure relation table of the regrouped data and the symbolic field of the model type in the previous-level data structure relation table, data merging is performed, and data analysis and processing tools are used to remove duplicate data after merging until all levels of data structure have been traversed, and the intermediate data processing result information is obtained. Using the data analysis and processing tool, and based on the intermediate data processing results and machine tool attribute information, the data is grouped. The machine model identifier field of each group of data is deduplicated to obtain the data processing result information.

7. A computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method of any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the method of any one of claims 1 to 5.

9. A computer program product, characterized in that, The computer program product includes a computer program that, when executed by a processor, implements the method of any one of claims 1 to 5.

Images