Data processing method and device, equipment and storage medium
By displaying two data files on the display screen and asking users to formulate selection rules, and combining the data in the two data files, the problem of inability to effectively combine data in the prior art is solved, and a user-customized data combination and simplified operation process is realized.
Patent Information
- Application Number
- CN202411625056.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-14
- Publication Date
- 2025-03-07
AI Technical Summary
In the functional and performance testing scenarios, it is difficult for the existing technology to effectively handle the constraint relationship between two data files, resulting in the inability to directly combine them in full. The existing methods are time-consuming, labor-intensive, error-prone, and complex in operations, which cannot meet the user's flexible combination needs.
By displaying two data files on the display screen, users can flexibly formulate data selection rules according to their needs, generate corresponding data selection rules, and combine the data in the two data files according to the rules to generate test data.
It realizes user-customized data combination, meets users' flexible combination needs for two data files, simplifies the operation process, and avoids manual processing errors and complexity.
Smart Images
Figure CN119577013A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a data processing method, device, equipment and storage medium. Background Art
[0002] In the scenario of function and performance testing, it is usually necessary to select and combine data from two data files to form test data. In actual processing, there will be constraints between the data in the two data files, and they cannot be directly combined in full.
[0003] At present, manual processing or semi-automatic processing is usually adopted. The semi-automatic processing is to first perform full Cartesian product combination and then manually remove non-conforming items. However, the manual processing is not only time-consuming and labor-intensive, but also prone to errors; the full Cartesian product combination method can only meet the needs of a small number of users and the operation is relatively complicated. It cannot meet the needs of users to flexibly formulate selection rules for two data files and combine the two data files on demand. Summary of the invention
[0004] The embodiments of the present application provide a data processing method, apparatus, device and storage medium for meeting the customized data combination requirements of users.
[0005] In a first aspect, the present application provides a data processing method. The method comprises: obtaining a first data file and a second data file, and displaying the first data file and the second data file on a display screen, wherein the first data file comprises M lines of data, and the second data file comprises N lines of data; determining a first part of a first rule according to data selected by a user in the first data file, and determining a second part of the first rule according to data selected by the user in the second data file; wherein the first part is used to indicate M1 lines of data selected by the user in the first data file, and the second part is used to indicate N1 lines of data selected by the user in the second data file; obtaining a third data file according to the first rule, wherein the third data file comprises the Cartesian product of the M1 lines of data and the N1 lines of data, and the third data file is test data; wherein M, M1, N, and N1 are integers greater than or equal to 1.
[0006] The above scheme, by displaying the first data file and the second data file on the display screen, allows the user to flexibly formulate data selection rules according to needs, and selects and combines the data in the first data file and the second data file according to the determined first rule to obtain the third data file, which can not only meet the user's flexible customization needs but also is simple to operate.
[0007] In a possible embodiment, when M1 is an integer greater than 1, the M1 row data is continuous M1 row data, or discontinuous M1 row data; and / or, when N1 is an integer greater than 1, the N1 row data is continuous N1 row data, or discontinuous N1 row data.
[0008] In the above scheme, the data selected by the user can be continuous rows or non-continuous rows. When M1 and N1 are integers greater than 1, the first part of the first rule can be continuous rows or non-continuous rows, and the second part of the first rule can be continuous rows or non-continuous rows. Various different types of combination rules for continuous rows and non-continuous rows can be implemented for the first data file and the second data file.
[0009] In a possible embodiment, when the M1 row data is continuous M1 row data, the first part includes a first symbol, a row number of a starting row and a row number of an ending row of the M1 row data, and the row number of the starting row and the row number of the ending row are located on both sides of the first symbol; when the M1 row data is non-continuous M1 row data, the first part includes at least one second symbol and the row number of the M1 row data, and different row numbers in the row numbers of the M1 row data are separated by the second symbol.
[0010] In a possible embodiment, according to the first rule, obtaining a third data file includes: according to the first rule and the second rule, obtaining the third data file; wherein the second rule includes a third part and a fourth part, the third part is used to indicate the M2 rows of data selected by the user in the first data file, and the fourth part is used to indicate the N2 rows of data selected by the user in the second data file; the third data file also includes the Cartesian product of the M2 rows of data and the N2 rows of data. When M2 is an integer greater than 1, the M2 rows of data are continuous M2 rows of data, or non-continuous M2 rows of data; and / or, when N2 is an integer greater than 1, the N2 rows of data are continuous N2 rows of data, or non-continuous N2 rows of data.
[0011] In a possible embodiment, the method further includes: if the Cartesian product of the M1 row of data and the N1 row of data overlaps with the Cartesian product of the M2 row of data and the N2 row of data, deduplication processing is performed on the third data file.
[0012] In the above scheme, according to the first rule, a third data file is obtained, and the third data file includes the Cartesian product of M1 row data and N1 row data. According to the second rule, a third data file is obtained, and the third data file includes the Cartesian product of M2 row data and the N2 row data. By deduplicating the content in the third data file, the duplication of the combined data of the third data file can be effectively avoided.
[0013] In a possible embodiment, the method further includes: establishing and saving a correspondence between the first data file, the second data file and the first rule.
[0014] The above scheme establishes and saves the correspondence between the first data file, the second data file and the first rule to form a rule set. In subsequent operations, the user can query the maintained rule set based on the first data file and the second data file, and supports operations such as modification and deletion of the maintained rule set.
[0015] In a second aspect, the present application provides a data processing device, comprising: an acquisition module, used to acquire a first data file and a second data file, and display the first data file and the second data file on a display screen, wherein the first data file includes M lines of data and the second data file includes N lines of data; a determination module, used to determine a first part of a first rule based on data selected by a user in the first data file, and to determine a second part of the first rule based on data selected by the user in the second data file; wherein the first part is used to indicate M1 lines of data selected by the user in the first data file, and the second part is used to indicate N1 lines of data selected by the user in the second data file; a processing module, used to obtain a third data file according to the first rule, wherein the third data file includes the Cartesian product of the M1 lines of data and the N1 lines of data, and the third data file is test data.
[0016] In a possible embodiment, in the determination module, when M1 is an integer greater than 1, the M1 row data is continuous M1 row data, or discontinuous M1 row data; and / or, when N1 is an integer greater than 1, the N1 row data is continuous N1 row data, or discontinuous N1 row data.
[0017] In a possible embodiment, when the M1 row data is continuous M1 row data, the first part includes a first symbol, a row number of a starting row and a row number of an ending row of the M1 row data, and the row number of the starting row and the row number of the ending row are located on both sides of the first symbol; when the M1 row data is non-continuous M1 row data, the first part includes at least one second symbol and the row number of the M1 row data, and different row numbers in the row numbers of the M1 row data are separated by the second symbol.
[0018] In a possible embodiment, obtaining a third data file according to the first rule includes: obtaining the third data file according to the first rule and the second rule; wherein the second rule includes a third part and a fourth part, the third part is used to indicate the M2 rows of data selected by the user in the first data file, and the fourth part is used to indicate the N2 rows of data selected by the user in the second data file; the third data file also includes the Cartesian product of the M2 rows of data and the N2 rows of data; when M2 is an integer greater than 1, the M2 rows of data are continuous M2 rows of data, or non-continuous M2 rows of data; and / or, when N2 is an integer greater than 1, the N2 rows of data are continuous N2 rows of data, or non-continuous N2 rows of data.
[0019] In a possible embodiment, the device further includes: if the Cartesian product of the M1 row of data and the N1 row of data overlaps with the Cartesian product of the M2 row of data and the N2 row of data, deduplication processing is performed on the third data file.
[0020] In a possible embodiment, the device further includes: establishing and saving a correspondence between the first data file, the second data file and the first rule.
[0021] In a third aspect, the present application provides an electronic device, including:
[0022] A memory for storing program instructions;
[0023] The processor is used to call the program instructions stored in the memory, and execute the steps included in any one of the methods in the first aspect according to the obtained program instructions.
[0024] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and when the program instructions are executed by a computer, the computer executes any one of the methods described in the first aspect.
[0025] In a fifth aspect, the present application provides a computer program product, comprising: a computer program code, when the computer program code is run on a computer, the computer executes any one of the methods described in the first aspect. BRIEF DESCRIPTION OF THE DRAWINGS
[0026] Figure 1 A flowchart corresponding to a data processing method provided in an embodiment of the present application;
[0027] Figure 2 A schematic diagram of a visual interface provided in an embodiment of the present application;
[0028] Figure 3 A flowchart corresponding to a data processing method provided in an embodiment of the present application;
[0029] Figure 4 A schematic diagram of the structure of a data processing device provided in an embodiment of the present application;
[0030] Figure 5 A schematic diagram of the structure of a data processing device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0031] In order to make the purpose, technical scheme and advantages of the present application clearer, the technical scheme in the embodiment of the present application will be clearly and completely described below in conjunction with the drawings in the embodiment of the present application. Obviously, the described embodiment is only a part of the embodiment of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. In the absence of conflict, the embodiments in the present application and the features in the embodiments can be arbitrarily combined with each other. In addition, although the logical order is shown in the flow chart, in some cases, the steps shown or described can be performed in an order different from that here.
[0032] The terms "first" and "second" in the specification and claims of the present application and the above-mentioned drawings are used to distinguish different objects, rather than to describe a specific order. In addition, the term "comprising" and any of their variations are intended to cover non-exclusive protection. For example, a process, method, system, product or device comprising a series of steps or units is not limited to the listed steps or units, but optionally also includes steps or units that are not listed, or optionally also includes other steps or units inherent to these processes, methods, products or devices. "Multiple" in the present application can mean at least two, for example, two, three or more, and the embodiments of the present application are not limited.
[0033] The following is a description of exemplary embodiments of the present application in conjunction with the accompanying drawings, including various details of the embodiments of the present application to facilitate understanding, which should be considered as merely exemplary. Therefore, those of ordinary skill in the art should recognize that various changes and modifications can be made to the embodiments described herein without departing from the scope of the present application. Similarly, for the sake of clarity and conciseness, the description of well-known functions and structures is omitted in the following description. It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, which should be considered as exemplary, and their purpose is only to illustrate the feasibility of the implementation of the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.
[0034] In the technical solution of this application, the acquisition, transmission, storage, and use of data are in compliance with the requirements of relevant national laws and regulations.
[0035] It should be noted that in the embodiments of the present application, certain software, components, models and other existing solutions in the industry may be mentioned, and they should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the solution.
[0036] To facilitate understanding, the technical background of the following embodiments of the present application is first introduced in detail.
[0037] Cartesian product: Cartesian product is a concept in set theory, which represents the set of all possible ordered pairs of two sets. In mathematics, the Cartesian product of set X and set Y means that the first object is a member of X and the second object is a member of all possible ordered pairs of Y. For example, set A = {a, b}, set B = {1, 2, 3}, then the Cartesian product of set A and set B is {(a, 1), (a, 2), (a, 3), (b, 1), (b, 2), (b, 3)}.
[0038] In the prior art, tools based on Cartesian product processing can only cross-combine all data, so they can only meet the needs of a few users and are complex to operate. In actual applications, users usually want to flexibly formulate selection rules and combine data on demand.
[0039] Based on this, an embodiment of the present application provides a data processing method, which displays two data files on a display screen, generates corresponding data selection rules based on the parts that need to be combined selected by the user in the two data files, and performs an on-demand Cartesian product on the data in the two data files according to the generated data selection rules, thereby meeting the user's needs for flexible customization and simplifying the complexity of the operation.
[0040] Figure 1 This is a flowchart corresponding to a data processing method provided in an embodiment of the present application. The method can be executed by a data processing device, which can be an electronic device with a display screen, and is not specifically limited. Figure 1 As shown, the method comprises the following steps:
[0041] Step 101: A data processing device obtains a first data file and a second data file, and displays the first data file and the second data file on a display screen.
[0042] Here, the data processing device can send a prompt message to the user to prompt the user to import the first data file and the second data file on the interface. After the user imports the first data file and the second data file on the interface according to the prompt message, the data processing device can obtain the first data file and the second data file, and display the first data file and the second data file on the display screen.
[0043] Optionally, the data processing device may check the first data file and the second data file, and if the first data file and the second data file are not empty, the first data file and the second data file are displayed on the display screen. Figure 2 As shown, the first data file includes M lines of data, and the second data file includes N lines of data. The left half of the display screen displays the M lines of data of the first data file, and the right half of the display screen displays the N lines of data of the second data file. There is a corresponding check box on the left side of each line of data in the M lines of data of the first data file and the N lines of data of the second data file, providing users with flexible data selection rules, where M and N are integers greater than or equal to 1.
[0044] If the first data file and / or the second data file is found to be empty, an error message is displayed on the interface to prompt the user to check the first data file and / or the second data file.
[0045] Step 102: The data processing device determines a first part of a first rule according to data selected by a user in the first data file, and determines a second part of the first rule according to data selected by the user in the second data file.
[0046] Here, the first rule includes a first part, a separator symbol and a second part, the first part and the second part are located on both sides of the separator symbol, the user checks the check box in front of the data row presented in the left half of the display screen as needed, selects data in the first data file, and determines the first part of the first rule, and the user checks the check box in front of the data row presented in the right half of the display screen as needed to determine the second part of the first rule, wherein the first part is used to indicate the M1 row of data selected in the first data file, and the second part is used to indicate the N1 row of data selected in the second data file.
[0047] When M1 is an integer greater than 1, the M1 row data is continuous M1 row data, or non-continuous M1 row data; and / or, when N1 is an integer greater than 1, the N1 row data is continuous N1 row data, or non-continuous N1 row data. Taking the first part of the first rule determined by M1 row data as an example (the second part of the first rule determined by N1 row data can be referred to), when the M1 row data is continuous M1 row data, the first part includes a first symbol, the row number of the starting row of the M1 row data, and the row number of the ending row, and the row number of the starting row and the row number of the ending row are located on both sides of the first symbol; when the M1 row data is non-continuous M1 row data, the first part includes at least one second symbol and the row number of the M1 row data, and different row numbers in the row number of the M1 row data are separated by the second symbol.
[0048] For example, the contents of the first data file and the second data file below are only examples. Assuming that the data in the first data file is precious metal varieties, the data in the first data file and the corresponding row numbers are shown in Table 1:
[0049] Table 1: Example of data and corresponding line numbers in the first data file
[0050] Line Number Precious metals 1 gold 2 silver 3 Platinum 4 Palladium
[0051] The data in the second data file are rental products. The data in the second data file and the corresponding row numbers are shown in Table 2:
[0052] Table 2: Example of data and corresponding line numbers in the second data file
[0053]
[0054]
[0055] If the M1 rows of data selected by the user in the first data file are continuous rows (such as rows 1 to 4 in the first data file), where 1 is the starting row of the M1 rows of data, 4 is the ending row of the M1 rows of data, and the first symbol can be a punctuation mark colon ":", which is not limited here, then the first part of the first rule is 1:4;
[0056] If the M1 row data selected by the user in the first data file is a non-continuous row (such as the 1st and 3rd rows in the first data file), the second symbol here can be a punctuation mark comma "," , which is not limited here. At this time, the first part of the first rule is 1,3.
[0057] If the N1 rows of data selected by the user in the second data file are continuous rows (such as rows 3 to 5 in the second data file), where 3 is the starting row of the N1 rows of data and 5 is the ending row of the N1 rows of data, then the second part of the first rule is 3:5;
[0058] If the N1 rows of data selected by the user in the first data file are non-consecutive rows (such as the 1st row and the 4th row in the second data file), then the second part of the first rule is 1,4.
[0059] Step 103: The data processing device obtains a third data file according to the first rule.
[0060] Here, the data processing device processes the first data file and the second data file according to the first rule to obtain a third data file, and the third data file is test data. Figure 3 A flowchart corresponding to a data processing method provided in an embodiment of the present application, such as Figure 3 As shown:
[0061] According to the first rule separation symbol, the first rule is divided into a first part and a second part; if the first part of the first rule and the second part of the first rule are pure numbers (that is, M1 and N1 are equal to 1), then according to the line number in the first part of the first rule, the data with the corresponding line number is selected in the first data file, and according to the line number in the second part of the first rule, the data with the corresponding line number selected in the first data file and the data with the corresponding line number selected in the second data file are combined and spliced to generate a third data file.
[0062] If the first part of the first rule and the second part of the first rule are not pure numbers, obtain the separator symbol of the first part of the first rule and the separator symbol of the second part of the first rule; process the first data file and the second data file according to the line number separated by the separator symbol of the first part and the line number separated by the separator symbol of the second part to obtain a third data file.
[0063] If the delimiter symbol of the first part and the delimiter symbol of the second part are the first symbol (that is, the M1 row data and the N1 row data are consecutive rows), obtain the starting row number and the ending row number of the first part separated by the first symbol and the starting row number and the ending row number of the second part separated by the first symbol, use a nested double loop to select data from the first data file and the second data file, combine and splice the selected data to obtain a third data file, the third data file includes the Cartesian product of the M1 row data and the N1 row data, wherein the outer loop of the nested double loop uses the row number range of the starting row number and the ending row number of the first part separated by the first symbol to select data from the first data file, and the inner loop uses the row number range of the starting row number and the ending row number of the second part separated by the first symbol to select data from the second data file.
[0064] If the separator symbol of the first part and the separator symbol of the second part are the second symbol (that is, the M1 row data and the N1 row data are non-continuous rows), obtain the row number of the M1 row data of the first part separated by the second symbol and the row number of the N1 row data of the second part separated by the second symbol, use a nested double loop to select data from the first data file and the second data file, combine and splice the selected data to obtain a third data file, the third data file includes the Cartesian product of the M1 row data and the N1 row data, wherein the outer loop of the nested double loop uses the row number corresponding to the M1 row of the first part separated by the second symbol to select data from the first data file, and the inner loop uses the row number corresponding to the N1 row of the second part separated by the second symbol to select data from the second data file.
[0065] If the delimiter of the first part is the first symbol and the delimiter of the second part is the second symbol (i.e., M1 rows of data are continuous rows and N1 rows of data are non-continuous rows), obtain the starting row number and the ending row number of the first part separated by the first symbol and the row number of N1 rows of data of the second part separated by the second symbol, use a nested double loop to select data from the first data file and the second data file, combine and splice the selected data to obtain a third data file, the third data file includes the Cartesian product of M1 rows of data and N1 rows of data, wherein the outer loop of the nested double loop uses the row number range of the starting row number and the ending row number of the first part separated by the first symbol to select data from the first data file, and the inner loop uses the row number corresponding to the N1 rows of the second part separated by the second symbol to select data from the second data file.
[0066] If the delimiter symbol of the first part is the second symbol and the delimiter symbol of the second part is the first symbol (i.e., the M1 row data is a non-continuous row and the N1 row data is a continuous row), obtain the row number of the M1 row data of the first part separated by the second symbol and the starting row number and the ending row number of the second part separated by the first symbol, use a nested double loop to select data from the first data file and the second data file, combine and splice the selected data to obtain a third data file, the third data file includes the Cartesian product of the M1 row data and the N1 row data, wherein the outer loop of the nested double loop uses the row number corresponding to the M1 row of the first part separated by the second symbol to select data from the first data file, and the inner loop uses the row number range of the starting row number and the ending row number of the second part separated by the first symbol to select data from the second data file.
[0067] Optionally, the data processing device can generate multiple data selection rules according to user needs. For example, in addition to the first rule, the data processing device can also generate a second rule according to user operations. Furthermore, the data processing device obtains a third data file according to the first rule and the second rule, and processes the second rule in the same way as the first rule; wherein the second rule includes a third part and a fourth part, the third part is used to indicate the M2 rows of data selected by the user in the first data file, and the fourth part is used to indicate the N2 rows of data selected by the user in the second data file; the third data file also includes the Cartesian product of the M2 rows of data and the N2 rows of data; wherein M2 and N2 are integers greater than or equal to 1;
[0068] When M2 is an integer greater than 1, the M2 row data is continuous M2 row data, or non-continuous M2 row data; and / or, when N2 is an integer greater than 1, the N2 row data is continuous N2 row data, or non-continuous N2 row data.
[0069] Optionally, when the third data file is obtained according to the first rule and the second rule, the third data file includes the Cartesian product of M1 row data and N1 row data and the Cartesian product of M2 row data and N2 row data. If the Cartesian product of M1 row data and N1 row data and the Cartesian product of M2 row data and N2 row data overlap, the third data file is deduplicated.
[0070] Optionally, the data processing device establishes and saves a correspondence between the first data file and the second data file and the data selection rule. The data selection rule may include the first rule and the second rule. When the user needs to perform operations on the first data file and the second data file later, the corresponding first rule and the second rule can be called out according to the correspondence between the first data file and the second data file and the data selection rule. The user can choose to use the existing first rule or second rule, or modify the existing first rule or second rule to generate a new rule.
[0071] By adopting the above method, by displaying the first data file and the second data file on the display screen, the user can flexibly formulate data selection rules according to needs, and select and combine the data in the first data file and the second data file according to the determined first rule to obtain the third data file, which can not only meet the needs of users but also is simple to operate.
[0072] Based on the same concept, the embodiment of the present application further provides a data processing device, which can be used to implement the functions in the above method embodiment. Figure 4 A structural diagram of a data processing device 4000 provided in an embodiment of the present application is shown in FIG. Figure 4 As shown, the device 4000 includes:
[0073] An acquisition module 401 is used to acquire a first data file and a second data file, and display the first data file and the second data file on a display screen, wherein the first data file includes M lines of data and the second data file includes N lines of data;
[0074] The determination module 402 is used to determine the first part of the first rule according to the data selected by the user in the first data file, and to determine the second part of the first rule according to the data selected by the user in the second data file; wherein the first part is used to indicate the M1 row of data selected by the user in the first data file, and the second part is used to indicate the N1 row of data selected by the user in the second data file;
[0075] The processing module 403 is used to obtain a third data file according to the first rule, wherein the third data file includes the Cartesian product of the M1 row of data and the N1 row of data, and the third data file is test data.
[0076] In one possible design, in the determination module 402, when M1 is an integer greater than 1, the M1 row data is continuous M1 row data, or discontinuous M1 row data; and / or, when N1 is an integer greater than 1, the N1 row data is continuous N1 row data, or discontinuous N1 row data.
[0077] In one possible design, when the M1 row data is continuous M1 row data, the first part includes a first symbol, a row number of a starting row and a row number of an ending row of the M1 row data, and the row number of the starting row and the row number of the ending row are located on both sides of the first symbol; when the M1 row data is non-continuous M1 row data, the first part includes at least one second symbol and the row number of the M1 row data, and different row numbers in the row numbers of the M1 row data are separated by the second symbol.
[0078] In a possible design, the processing module 403 is also used to obtain a third data file according to the first rule, including: obtaining the third data file according to the first rule and the second rule; wherein the second rule includes a third part and a fourth part, the third part is used to indicate the M2 rows of data selected by the user in the first data file, and the fourth part is used to indicate the N2 rows of data selected by the user in the second data file; the third data file also includes the Cartesian product of the M2 rows of data and the N2 rows of data; when M2 is an integer greater than 1, the M2 rows of data are continuous M2 rows of data, or non-continuous M2 rows of data; and / or, when N2 is an integer greater than 1, the N2 rows of data are continuous N2 rows of data, or non-continuous N2 rows of data.
[0079] In a possible design, the processing module 403 is further used to deduplicate the third data file if the Cartesian product of the M1 row of data and the N1 row of data overlaps with the Cartesian product of the M2 row of data and the N2 row of data.
[0080] In a possible design, the determination module 402 is further used to establish and save a correspondence between the first data file and the second data file and the first rule.
[0081] Based on the same concept, the present application embodiment also provides a structural diagram of a data processing device 5000, such as Figure 5 As shown, the device 5000 includes at least one processor 501 and a memory 502 connected to the at least one processor 501. The specific connection medium between the processor 501 and the memory 502 is not limited in the embodiment of the present application. Figure 5 For example, the processor 501 and the memory 502 are connected via a bus. The bus can be divided into an address bus, a data bus, a control bus, etc. In the embodiment of the present application, the memory 502 stores instructions that can be executed by at least one processor 501, and the at least one processor 501 can implement the steps of the above data processing method by executing the instructions stored in the memory 502.
[0082] The processor 501 is the control center of the computer device, and can use various interfaces and lines to connect various parts of the computer device, and perform resource settings by running or executing instructions stored in the memory 502 and calling data stored in the memory 502. Optionally, the processor 501 may include one or more processing units, and the processor 501 may integrate an application processor and a modem processor, wherein the application processor mainly processes the operating system, user interface, and application programs, and the modem processor mainly processes wireless communications. It is understandable that the above-mentioned modem processor may not be integrated into the processor 501. In some embodiments, the processor 501 and the memory 502 may be implemented on the same chip, and in some embodiments, they may also be implemented separately on independent chips.
[0083] Processor 501 can be a general-purpose processor, such as a central processing unit (CPU), a digital signal processor, an application specific integrated circuit (ASIC), a field programmable gate array or other programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, and can implement or execute the various methods, steps and logic block diagrams disclosed in the embodiments of the present application. A general-purpose processor can be a microprocessor or any conventional processor, etc. The steps of the method disclosed in the embodiments of the present application can be directly embodied as a hardware processor for execution, or can be executed by a combination of hardware and software modules in the processor.
[0084] The memory 502 is a non-volatile computer-readable storage medium that can be used to store non-volatile software programs, non-volatile computer executable programs and modules. The memory 502 may include at least one type of storage medium, such as flash memory, hard disk, multimedia card, card-type memory, random access memory (RAM), static random access memory (SRAM), programmable read only memory (PROM), read only memory (ROM), electrically erasable programmable read-only memory (EEPROM), magnetic memory, disk, optical disk, etc. The memory 502 is any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited thereto. The memory 502 in the embodiment of the present application can also be a circuit or any other device that can realize a storage function, for storing program instructions and / or data.
[0085] Based on the same inventive concept, the embodiment of the present application provides a computer-readable storage medium, and the computer program product includes: computer program code, when the computer program code is run on a computer, the computer executes any of the data processing methods discussed above. Since the principle of solving the problem by the above-mentioned computer-readable storage medium is similar to that of the data processing method, the implementation of the above-mentioned computer-readable storage medium can refer to the implementation of the method, and the repeated parts will not be repeated.
[0086] Based on the same inventive concept, the embodiment of the present application also provides a computer program product, which includes: computer program code, when the computer program code is run on a computer, the computer executes any of the data processing methods discussed above. Since the principle of solving the problem by the above computer program product is similar to that of the data processing method, the implementation of the above computer program product can refer to the implementation of the method, and the repeated parts will not be repeated.
[0087] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.
[0088] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0089] These computer program instructions may also be stored in a computer readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0090] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 A step that specifies a function in one or more boxes.
[0091] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.
Claims
1. A data processing method, characterized in that: The method comprises: Acquire a first data file and a second data file, and display the first data file and the second data file on a display screen, wherein the first data file includes M lines of data and the second data file includes N lines of data; Determine a first part of the first rule according to data selected by the user in the first data file, and determine a second part of the first rule according to data selected by the user in the second data file; wherein the first part is used to indicate M1 rows of data selected by the user in the first data file, and the second part is used to indicate N1 rows of data selected by the user in the second data file; According to the first rule, a third data file is obtained, wherein the third data file includes the Cartesian product of the M1 row data and the N1 row data, and the third data file is test data; Among them, M, M1, N, and N1 are integers greater than or equal to 1.
2. The method according to claim 1, characterized in that When M1 is an integer greater than 1, the M1 row data is continuous M1 row data, or discontinuous M1 row data; and / or, when N1 is an integer greater than 1, the N1 row data is continuous N1 row data, or discontinuous N1 row data.
3. The method according to claim 2, characterized in that When the M1 row data is continuous M1 row data, the first part includes a first symbol, a row number of a starting row and a row number of an ending row of the M1 row data, and the row number of the starting row and the row number of the ending row are located on both sides of the first symbol; When the M1 line data is non-continuous M1 line data, the first part includes at least one second symbol and a line number of the M1 line data, and different line numbers in the line numbers of the M1 line data are separated by the second symbol.
4. The method according to claim 2 or 3, characterized in that According to the first rule, a third data file is obtained, including: According to the first rule and the second rule, obtaining the third data file; The second rule includes a third part and a fourth part, the third part is used to indicate the M2 rows of data selected by the user in the first data file, and the fourth part is used to indicate the N2 rows of data selected by the user in the second data file; the third data file also includes the Cartesian product of the M2 rows of data and the N2 rows of data; M2 and N2 are integers greater than or equal to 1; When M2 is an integer greater than 1, the M2 row data is continuous M2 row data, or non-continuous M2 row data; and / or, when N2 is an integer greater than 1, the N2 row data is continuous N2 row data, or non-continuous N2 row data.
5. The method according to claim 4, characterized in that The method further comprises: If the Cartesian product of the M1 row of data and the N1 row of data overlaps with the Cartesian product of the M2 row of data and the N2 row of data, deduplication processing is performed on the third data file.
6. The method according to any one of claims 1 to 5, characterized in that The method further comprises: A correspondence between the first data file, the second data file and the first rule is established and saved.
7. A data processing device, characterized in that: The device comprises: an acquisition module, used for acquiring a first data file and a second data file, and displaying the first data file and the second data file on a display screen, wherein the first data file includes M lines of data and the second data file includes N lines of data; a determination module, configured to determine a first part of a first rule according to data selected by a user in the first data file, and to determine a second part of the first rule according to data selected by the user in the second data file; wherein the first part is used to indicate M1 rows of data selected by the user in the first data file, and the second part is used to indicate N1 rows of data selected by the user in the second data file; A processing module is used to obtain a third data file according to the first rule, wherein the third data file includes the Cartesian product of the M1 row data and the N1 row data, and the third data file is test data.
8. An electronic device, characterized in that: The device comprises: A memory for storing program instructions; A processor is used to call the program instructions stored in the memory, and execute the steps included in any one of claims 1-6 according to the obtained program instructions.
9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, wherein the computer program includes program instructions. When the program instructions are executed by a computer, the method according to any one of claims 1 to 6 is executed.
10. A computer program product, characterized in that The computer program product comprises a computer program code, which causes any one of claims 1 to 6 to be performed when the computer program code is run on a computer.