CN111353286A - Table file processing method and device, computer equipment and storage medium - Google Patents
Table file processing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111353286A CN111353286A CN202010151591.8A CN202010151591A CN111353286A CN 111353286 A CN111353286 A CN 111353286A CN 202010151591 A CN202010151591 A CN 202010151591A CN 111353286 A CN111353286 A CN 111353286A
- Authority
- CN
- China
- Prior art keywords
- data
- file
- instruction sequence
- user operation
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Stored Programmes (AREA)
Abstract
The application relates to a table file processing method, a table file processing device, computer equipment and a storage medium. The method comprises the following steps: acquiring a to-be-processed form file and a current user operation instruction of the to-be-processed form file; inputting a table file to be processed and a current user operation instruction into a table processing model to obtain a target table file; the table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence. By adopting the method, the working efficiency and the accuracy of processing the form file can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method and an apparatus for processing a table file, a computer device, and a storage medium.
Background
At present, Excel office work in the financial field mostly adopts manual Excel calculation processing on collected data. A business person uses a series of Excel operations such as formula operation, labeling and the like to calculate and process data according to a data logic rule to form a required standard Excel template, and enterprises need to distribute a large amount of manpower and time every day to do similar repetitive work, so that the time consumption is long, and the efficiency is low; moreover, due to subjective factors such as human errors and the like, data calculation errors are easy to occur, and even economic losses are brought to enterprises. Therefore, the traditional table file processing method has the problem of low efficiency.
Disclosure of Invention
In view of the above, it is necessary to provide a table file processing method, an apparatus, a computer device, and a storage medium capable of efficiently and accurately processing a table file in view of the above technical problems.
A method of processing a tabular document, the method comprising:
and acquiring the to-be-processed form file and a current user operation instruction of the to-be-processed form file.
And inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file.
The table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
In one embodiment, the generating of the table processing model comprises:
and acquiring a standard form file.
And analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file.
And acquiring a user operation instruction sequence.
And obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence.
And obtaining a table processing model according to the target instruction sequence and the programming language component library.
In an embodiment, the step of obtaining the user operation instruction sequence includes:
and acquiring a plurality of user operation instructions.
And sequencing the user operation instructions according to the acquisition time sequence of the user operation instructions to obtain a user operation instruction sequence.
In an embodiment, the parsing result further includes data information in the standard form file, the data information includes cell attribute information in the standard form file, and the step of obtaining the plurality of user operation instructions includes:
and carrying out statistical analysis on the cell attribute information according to the rows and the columns to obtain the cell attribute proportion of the rows and the columns.
And acquiring a cell attribute setting instruction fed back by a user according to the cell attribute proportion, and setting the cell attribute setting instruction as a user operation instruction.
And/or calculating the information entropy of each column in the standard table file according to the cell attribute proportion of each column in the standard table file.
And when the information entropy is higher than a preset threshold value, generating a data missing item notification.
And acquiring a missing item completion instruction fed back by the user according to the data missing item notification.
And setting the missing item completion instruction as a user operation instruction.
In one embodiment, the step of obtaining the target instruction sequence according to the data association relationship and the user operation instruction sequence includes:
and generating a table data processing instruction sequence according to the data association relation.
And carrying out duplication removal and integration on the form data processing instruction sequence and the user operation instruction sequence to obtain a target instruction sequence.
In one embodiment, the step of obtaining the table processing model according to the target instruction sequence and the programming language component library includes:
and carrying out relational mapping on the target instruction sequence and the programming language component library to obtain a target programming language script.
And compiling the target programming language script and configuring the environment to obtain a form processing model.
In the specific implementation process, the form file is an Excel file, and the target programming language script is a Python script.
In one embodiment, the step of parsing the standard form file to obtain a parsing result includes: and extracting various data information in the standard table file.
And establishing a data matrix object according to the data information.
And analyzing the data matrix object, and distinguishing data entity information and data attribute information in each item of data information.
Obtaining a data association relation between data information according to the data entity information and the data attribute information, wherein the data association relation is an association relation between at least two data entity information or an association relation between the data entity information and the data attribute information; the analysis result comprises various data information in the standard table file and data association relation among the various data information.
A method of generating a form processing model, the method comprising:
and acquiring a standard form file.
And analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file.
And acquiring a user operation instruction sequence.
And obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence.
And obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing the form file to be processed according to the current user operation instruction so as to obtain the target form file.
A form file processing apparatus, the apparatus comprising:
and the to-be-processed data acquisition module is used for acquiring the to-be-processed form file and the current user operation instruction of the to-be-processed form file.
And the form processing module is used for inputting the form file to be processed and the current user operation instruction into the form processing model to obtain the target form file.
The table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
and acquiring the to-be-processed form file and a current user operation instruction of the to-be-processed form file.
And inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file.
The table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
Alternatively, a standard form file is obtained.
And analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file.
And acquiring a user operation instruction sequence.
And obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence.
And obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing the form file to be processed according to the current user operation instruction so as to obtain the target form file.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
and acquiring the to-be-processed form file and a current user operation instruction of the to-be-processed form file.
And inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file.
The table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
Alternatively, a standard form file is obtained.
And analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file.
And acquiring a user operation instruction sequence.
And obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence.
And obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing the form file to be processed according to the current user operation instruction so as to obtain the target form file.
The table file processing method, the table file processing device, the computer equipment and the storage medium can obtain the target table file required by the user by inputting the table file to be processed and the current user operation instruction of the table file to be processed into the table processing model for processing, the table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence, namely, the user can generate the target form file only by sending the form file to be processed and the current user operation instruction to the form processing model for processing, thereby effectively improving the working efficiency, while the labor cost is reduced, the calculation error rate caused by subjective factors such as personnel errors can be reduced, and the processing result of the form file is more accurate.
Drawings
FIG. 1 is a diagram of an application environment of a method for processing a form file in one embodiment;
FIG. 2 is a flowchart illustrating a method for processing a table file according to an embodiment;
FIG. 3 is a flow diagram that illustrates the generation of a form processing model, according to one embodiment;
FIG. 4 is a flowchart illustrating a method for processing a form file according to another embodiment;
FIG. 5 is a flowchart illustrating a method of generating a form processing model according to one embodiment;
FIG. 6 is a block diagram showing the structure of a table file processing apparatus according to an embodiment;
FIG. 7 is a block diagram that illustrates the structure of a table processing model generation module in one embodiment;
FIG. 8 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The form file processing method and the form processing model generation method provided by the application can be applied to the application environment shown in fig. 1. When the method is implemented specifically, the terminal 102 receives a standard form file input by the user 106, the terminal 102 can directly analyze the standard form file and feed back an analysis result of the standard form file to the user on the display for viewing, or the terminal 102 can also send the standard form file to the server 104 for analysis, obtain an analysis result of the standard form file returned by the server 104, and feed back the analysis result to the user 106 through the display of the terminal 102. The user 106 may also input some user operation instructions to the terminal 102 according to the operation sequence, where the user operation instructions may be operation instructions defined by the user or operation instructions given by the user according to the analysis result fed back by the terminal 102. The table file processing process and the table processing model generation process may be executed in the terminal 102 or the server 106. The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, and tablet computers, and the server 106 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In an embodiment, as shown in fig. 2, a method for processing a table file is provided, which is described by taking the method as an example applied to the terminal in fig. 1, and includes the following steps:
The table file to be processed may be one or more Excel files, and the current user operation instruction of the table file to be processed is an operation instruction to be executed on the table file to be processed by a current user.
And 204, inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file.
The table processing model is a data processing model generated by performing relational mapping according to a target instruction sequence and a preset programming language component library, the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence, namely, the target instruction sequence comprises an instruction which is required to be executed for converting a table file to be processed into a table file meeting the requirement of the standard table file, and the target table file is the table file meeting the requirement of the standard table file.
Specifically, the form file to be processed is input into the form processing model, and the form processing model performs corresponding processing on the form file to be processed according to the current user operation instruction, for example, a user generates a plurality of Excel files to the form processing model as a tax payment report to be processed, the current user operation instruction is a combined tax payment report summary table, and the form processing model can automatically process the tax payment report to be processed and output the tax payment report summary table, which is the target form file.
In the form file processing method, the target form file required by the user can be obtained by inputting the form file to be processed and the current user operation instruction of the form file to be processed into the form processing model for processing, the table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence, namely, the user can generate the target form file only by sending the form file to be processed and the current user operation instruction to the form processing model for processing, thereby effectively improving the working efficiency, while the labor cost is reduced, the calculation error rate caused by subjective factors such as personnel errors can be reduced, and the processing result of the form file is more accurate.
In one embodiment, as shown in fig. 3, there is provided a table file processing method, wherein the generating process of the table processing model includes:
the standard form file can be one or more Excel files and is used for training and generating a form processing model, and each attribute of a target form file output by the form processing model generated by the standard form file training is consistent with each attribute of the standard form file.
Specifically, the user uploads the standard form file to the terminal, and the terminal stores the received standard form file. The standard table file can have color labels for cells or association formulas between data information.
For example, the value of the tax rate (column J) field is derived from the values of two fields, invoice tax (column G) and invoice amount (column F), and the association formula is "═ ROUND (G1715/F1715, 2)".
And step 304, analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises data association relations among various data information in the standard table file.
The data attribute information may include row attribute information, column attribute information, and cell attribute information, the row attribute information has a row spacing and the like, the column attribute information includes a column name and a column calculation formula, and the cell attribute information has a cell position and a cell color. The data association relationship may be an association relationship between data entity information, or an association relationship between data entity information and data attribute information.
As a specific embodiment, the terminal scans the attribute of each cell in the standard table file, and performs statistical analysis on the attribute of each row and each column, for example, the color of a certain column of cells can be obtained, where the mark red accounts for 30%, the mark yellow accounts for 60%, and the mark blue accounts for 10%. The terminal can also analyze data attribute information such as a calculation formula of a worksheet in a standard spreadsheet file, a name of the worksheet and the like, for example, the standard spreadsheet file is an Excel file, and data of a column D in a sheet1 of the Excel file is calculated and obtained from a column N in a sheet2 and a column M in a sheet3 according to a vlookup formula in the Excel. The calculation formula of the column D can be obtained; in addition, the terminal can also analyze Excel file attribute information, such as data information of Excel file names, sheet pages and the like.
Specifically, the terminal acquires user operation instructions input by a user, and the acquired user operation instructions are sequentially arranged from first to last according to the sequence of the acquisition time to obtain a user operation instruction sequence.
308, obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence;
specifically, the terminal processes the data association relationship to obtain a table data processing instruction sequence. And when the data association relation is a calculation formula of any cell numerical value information in the standard report file, generating a report data processing instruction according to the calculation formula.
Carrying out duplication removal and integration on the form data processing instruction sequence and the user operation instruction sequence to obtain a target instruction sequence;
for example, if the table data processing instruction sequence includes instruction a, instruction B, instruction C, and instruction D, and the user operation instruction sequence includes instruction B, instruction C, and instruction E, the target instruction sequences obtained after deduplication and integration of the above instructions are instruction a, instruction B, instruction C, instruction D, and instruction E.
In particular, the target instruction sequence may include:
open Sheet1 page of the form file;
removing duplicate screens of the table file D column;
marking the data of the invoice amount less than 0 in the F column of the table file with red;
date formatting is performed on table file H column, formatting% Y-% m-% d;
save and exit the form file.
Specifically, a target instruction sequence and a programming language component library are subjected to relational mapping to obtain a target programming language script;
and compiling the target programming language script and configuring the environment to obtain a form processing model.
The form file may be an Excel file, and the target programming language script may be a Python script.
In this embodiment, a table processing model is generated, where a corresponding target instruction sequence is generated by parsing according to a standard table file and a user operation instruction sequence, and then the target instruction sequence is mapped with a preset programming language component library to generate a reusable table processing model, where the table processing model may be used to process a table file according to a current user operation instruction to obtain a required target table file, so as to effectively improve the efficiency and accuracy of processing the table file.
In one embodiment, as shown in fig. 4, there is provided a table file processing method, including the steps of:
extracting various data information in the standard table file;
establishing a data matrix object according to various data information;
analyzing the data matrix object, and distinguishing data entity information and data attribute information in each item of data information;
and obtaining a data association relation between the data information according to the data entity information and the data attribute information, wherein the data association relation is an association relation between at least two data entity information or an association relation between the data entity information and the data attribute information.
The analysis result comprises various data information in the standard table file and data association relation among the various data information.
And step 414, inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file.
In this embodiment, a form file processing method is provided, where a corresponding target instruction sequence is generated by parsing according to a standard form file and a user operation instruction sequence, and then a reusable form processing model is generated by mapping the target instruction sequence with a preset programming language component library, and a user can generate a target form file only by inputting a form file to be processed and a current user operation instruction into a form processing model for processing, so as to effectively improve work efficiency and reduce a calculation error rate caused by subjective factors such as human errors.
In an embodiment, the parsing result further includes data information in the standard form file, the data information includes cell attribute information in the standard form file, and the step of obtaining the plurality of user operation instructions includes:
and carrying out statistical analysis on the cell attribute information according to the rows and the columns to obtain the cell attribute proportion of the rows and the columns. And acquiring a cell attribute setting instruction fed back by a user according to the cell attribute proportion, and setting the cell attribute setting instruction as a user operation instruction.
For example, the cell attribute information may be color marking information of the cell, a certain column of color marking statistical proportion is obtained through statistical analysis, and the statistical proportion is fed back to a user for confirmation, so that interaction with the user is realized, and a rule for marking the color by the user is obtained.
In this embodiment, the method can feed back the cell attribute ratio to the user by performing statistical analysis on the cell attribute information of each row/column in the standard form file, obtain the user operation instruction fed back by the user according to the cell attribute ratio, and interact with the user, thereby implementing effective supplement of the data association relationship in the labeled form file, and ensuring the accuracy of the form processing model.
The step of obtaining a plurality of user operation instructions further includes:
calculating the information entropy of each column in the standard table file according to the cell attribute proportion of each column in the standard table file;
an information entropy calculation formula:
when the information entropy is higher than a preset threshold value, generating a data missing item notification;
acquiring a missing item completion instruction fed back by a user according to the data missing item notification;
and setting the missing item completion instruction as a user operation instruction.
The information entropy is a concept for measuring information quantity in the information theory, and the more ordered a system is, the lower the information entropy is; conversely, the more chaotic a system is, the higher the information entropy is, in this embodiment, that is, the higher the information entropy of a certain column in the table is, the greater the uncertainty of the cell attribute in the column is, and when the information entropy is higher than a certain threshold, a situation may occur in which the cell attribute information of the column cannot be determined. Therefore, in a specific implementation process, the embodiment may screen out a column whose information entropy is higher than a preset threshold, generate a data missing item notification corresponding to the column, where the data missing item notification includes content that needs to be completed by a user, receive interaction information fed back by the user according to the data missing item notification after the data missing item notification occurs to the user, analyze the interaction information, obtain a missing item completion instruction, and complete a missing item in a target instruction sequence by setting the missing item completion instruction as a user operation instruction.
For example, assuming that 80% of the values in column A retain 2-bit decimal values, the remaining 20% retain 1-bit decimal values,
the information entropy of column A is: h (x) ═ - (0.8 × log (0.8) +0.2 × log (0.2)) ═ 0.72.
Assuming that the preset threshold is 0.5, the information entropy of the a column is higher than the preset threshold, and a data missing item notification needs to be generated to confirm the retention mode of the numerical decimal place of the a column data with the user. Specifically, the notification of the missing data item may be a numerical value reservation mode for asking for a column a data of a sheet page in a certain table, obtain the interaction information fed back by the user, analyze the interaction information, and make up for the missing item.
In this embodiment, the method can judge whether each column in the standard table file has a data missing item according to the information entropy of each column in the standard table file, and implement timely completion of the data missing item by interacting with the user, thereby further ensuring the accuracy of the table processing model.
In one embodiment, as shown in fig. 5, there is provided a method of generating a form processing model, the method including:
and 510, obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing the form file to be processed according to the current user operation instruction to obtain the target form file.
The specific limitations of steps 502-510 can be referred to the limitations of steps 302-310, and are not described herein again.
In the embodiment, a table processing model generation method is provided, which is used for generating a reusable table processing model by parsing a corresponding target instruction sequence according to a standard table file and a user operation instruction sequence and mapping the target instruction sequence with a preset programming language component library, and the table processing model can be used for processing the table file according to a current user operation instruction to obtain a required target table file, so that the table file processing efficiency and accuracy are effectively improved.
It should be understood that although the various steps in the flow charts of fig. 2-5 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-5 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternating with other steps or at least some of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 6, there is provided a form file processing apparatus including: a pending data obtaining module 602 and a table processing module 604, wherein:
a to-be-processed data obtaining module 602, configured to obtain a to-be-processed form file and a current user operation instruction of the to-be-processed form file;
the form processing module 604 is configured to input the form file to be processed and the current user operation instruction into a form processing model to obtain a target form file;
the table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
In one embodiment, as shown in fig. 7, the apparatus further includes a table processing model generating module, which includes:
the standard form obtaining sub-module 702 is configured to obtain a standard form file.
And the standard table analyzing submodule 704 is used for analyzing the standard table file to obtain an analysis result, and the analysis result comprises a data association relation among various data information in the standard table file.
And the user operation instruction sequence obtaining sub-module 706 is configured to obtain a user operation instruction sequence.
And the target instruction sequence obtaining sub-module 708 is configured to obtain a target instruction sequence according to the data association relationship and the user operation instruction sequence.
And the model generation submodule 710 is used for obtaining a table processing model according to the target instruction sequence and the programming language component library.
In an embodiment, the sub-module for obtaining the user operation instruction sequence includes:
and the user operation instruction acquisition unit is used for acquiring a plurality of user operation instructions.
And the user operation instruction sequence unit is used for sequencing the user operation instructions according to the acquisition time sequence of the user operation instructions to obtain a user operation instruction sequence.
In one embodiment, the analysis result further includes various data information in the standard table file, the data information includes cell attribute information in the standard table file, and the user operation instruction obtaining unit is configured to perform statistical analysis on the cell attribute information according to rows/columns to obtain a row/column cell attribute ratio; and acquiring a cell attribute setting instruction fed back by a user according to the cell attribute proportion, and setting the cell attribute setting instruction as a user operation instruction.
And/or the user operation instruction obtaining unit is further configured to calculate an information entropy of each column in the standard table file according to a cell attribute ratio of each column in the standard table file; when the information entropy is higher than a preset threshold value, generating a data missing item notification; acquiring a missing item completion instruction fed back by a user according to the data missing item notification; and setting the missing item completion instruction as a user operation instruction.
In one embodiment, the target instruction sequence fetch submodule includes:
and the table data processing instruction sequence unit is used for generating a table data processing instruction sequence according to the data association relation.
And the target instruction sequence unit is used for carrying out duplication removal and integration on the form data processing instruction sequence and the user operation instruction sequence to obtain a target instruction sequence.
In one embodiment, the model generation submodule includes:
and the programming language script unit is used for carrying out relational mapping on the target instruction sequence and the programming language component library to obtain a target programming language script.
And the compiling and configuring unit is used for compiling the target programming language script and configuring the environment to obtain the form processing model. In the specific implementation process, the form file is an Excel file, and the target programming language script is a Python script.
In one embodiment, the standard table parsing submodule includes:
and the data information extraction unit is used for extracting various data information in the standard form file.
And the data matrix object unit is used for establishing a data matrix object according to each item of data information.
And the analysis unit is used for analyzing the data matrix object and distinguishing data entity information and data attribute information in each item of data information.
And the incidence relation unit is used for obtaining a data incidence relation between the data information according to the data entity information and the data attribute information, wherein the data incidence relation is the incidence relation between at least two data entity information or the incidence relation between the data entity information and the data attribute information.
For the specific limitation of the table file processing apparatus, reference may be made to the above limitation on the table file processing method, which is not described herein again. The various modules in the above table file processing device can be wholly or partially implemented by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 8. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a table file processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: and acquiring the to-be-processed form file and a current user operation instruction of the to-be-processed form file. And inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file. The table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
In one embodiment, the processor, when executing the computer program, further performs the steps of: the generation process of the table processing model comprises the following steps: acquiring a standard form file; analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file; acquiring a user operation instruction sequence; and obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence. And obtaining a table processing model according to the target instruction sequence and the programming language component library.
In one embodiment, the processor, when executing the computer program, further performs the steps of: the step of obtaining the user operation instruction sequence includes: acquiring a plurality of user operation instructions; and sequencing the user operation instructions according to the acquisition time sequence of the user operation instructions to obtain a user operation instruction sequence.
In one embodiment, the parsing result further includes various items of data information in the standard table file, the data information includes cell attribute information in the standard table file, and the processor, when executing the computer program, further implements the following steps: the step of obtaining a plurality of user operation instructions includes: carrying out statistical analysis on the cell attribute information according to the rows/columns to obtain the cell attribute proportion of the rows/columns; and acquiring a cell attribute setting instruction fed back by a user according to the cell attribute proportion, and setting the cell attribute setting instruction as a user operation instruction. And/or calculating the information entropy of each column in the standard table file according to the cell attribute proportion of each column in the standard table file; when the information entropy is higher than a preset threshold value, generating a data missing item notification; acquiring a missing item completion instruction fed back by a user according to the data missing item notification; and setting the missing item completion instruction as a user operation instruction.
In one embodiment, the processor, when executing the computer program, further performs the steps of: the step of obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence comprises the following steps: generating a table data processing instruction sequence according to the data association relation; and carrying out duplication removal and integration on the form data processing instruction sequence and the user operation instruction sequence to obtain a target instruction sequence.
In one embodiment, the processor, when executing the computer program, further performs the steps of: obtaining a table processing model according to the target instruction sequence and the programming language component library, wherein the table processing model comprises the following steps: and carrying out relational mapping on the target instruction sequence and the programming language component library to obtain a target programming language script. And compiling the target programming language script and configuring the environment to obtain a form processing model. In the specific implementation process, the form file is an Excel file, and the target programming language script is a Python script.
In one embodiment, the processor, when executing the computer program, further performs the steps of: analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises the following steps: and extracting various data information in the standard table file. And establishing a data matrix object according to the data information. Analyzing the data matrix object, and distinguishing data entity information and data attribute information in each item of data information; and obtaining a data association relation between the data information according to the data entity information and the data attribute information, wherein the data association relation is an association relation between at least two data entity information or an association relation between the data entity information and the data attribute information.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program: acquiring a standard form file; analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file; acquiring a user operation instruction sequence; obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence; and obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing the form file to be processed according to the current user operation instruction so as to obtain the target form file.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: and acquiring the to-be-processed form file and a current user operation instruction of the to-be-processed form file. And inputting the table file to be processed and the current user operation instruction into the table processing model to obtain a target table file. The table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
In one embodiment, the computer program when executed by the processor further performs the steps of: the generation process of the table processing model comprises the following steps: acquiring a standard form file; analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file; acquiring a user operation instruction sequence; and obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence. And obtaining a table processing model according to the target instruction sequence and the programming language component library.
In one embodiment, the computer program when executed by the processor further performs the steps of: the step of obtaining the user operation instruction sequence includes: acquiring a plurality of user operation instructions; and sequencing the user operation instructions according to the acquisition time sequence of the user operation instructions to obtain a user operation instruction sequence.
In one embodiment, the parsing result further comprises items of data information in the standard form file, the data information comprising cell attribute information in the standard form file, and the computer program when executed by the processor further implements the following steps: the step of obtaining a plurality of user operation instructions includes: carrying out statistical analysis on the cell attribute information according to the rows/columns to obtain the cell attribute proportion of the rows/columns; and acquiring a cell attribute setting instruction fed back by a user according to the cell attribute proportion, and setting the cell attribute setting instruction as a user operation instruction. And/or calculating the information entropy of each column in the standard table file according to the cell attribute proportion of each column in the standard table file; when the information entropy is higher than a preset threshold value, generating a data missing item notification; acquiring a missing item completion instruction fed back by a user according to the data missing item notification; and setting the missing item completion instruction as a user operation instruction.
In one embodiment, the computer program when executed by the processor further performs the steps of: the step of obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence comprises the following steps: generating a table data processing instruction sequence according to the data association relation; and carrying out duplication removal and integration on the form data processing instruction sequence and the user operation instruction sequence to obtain a target instruction sequence.
In one embodiment, the computer program when executed by the processor further performs the steps of: obtaining a table processing model according to the target instruction sequence and the programming language component library, wherein the table processing model comprises the following steps: and carrying out relational mapping on the target instruction sequence and the programming language component library to obtain a target programming language script. And compiling the target programming language script and configuring the environment to obtain a form processing model. In the specific implementation process, the form file is an Excel file, and the target programming language script is a Python script.
In one embodiment, the computer program when executed by the processor further performs the steps of: analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises the following steps: and extracting various data information in the standard table file. And establishing a data matrix object according to the data information. Analyzing the data matrix object, and distinguishing data entity information and data attribute information in each item of data information; and obtaining a data association relation between the data information according to the data entity information and the data attribute information, wherein the data association relation is an association relation between at least two data entity information or an association relation between the data entity information and the data attribute information.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring a standard form file; analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file; acquiring a user operation instruction sequence; obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence; and obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing the form file to be processed according to the current user operation instruction so as to obtain the target form file.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method of tabular file processing, the method comprising:
acquiring a to-be-processed form file and a current user operation instruction of the to-be-processed form file;
inputting the table file to be processed and the current user operation instruction into a table processing model to obtain a target table file;
the table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
2. The method of claim 1, wherein the generating of the form processing model comprises:
acquiring the standard form file;
analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file;
acquiring the user operation instruction sequence;
obtaining the target instruction sequence according to the data association relation and the user operation instruction sequence;
and obtaining the table processing model according to the target instruction sequence and the programming language component library.
3. The method according to claim 2, wherein the obtaining the sequence of user operation instructions comprises:
acquiring a plurality of user operation instructions;
and sequencing the user operation instructions according to the acquisition time sequence of the user operation instructions to obtain the user operation instruction sequence.
4. The method according to claim 3, wherein the parsing result further includes items of data information in the standard form file, the data information includes cell attribute information in the standard form file, and the obtaining a plurality of user operation instructions includes:
carrying out statistical analysis on the cell attribute information according to the rows/columns to obtain the cell attribute proportion of the rows/columns;
acquiring a cell attribute setting instruction fed back by a user according to the cell attribute proportion, and setting the cell attribute setting instruction as a user operation instruction;
and/or calculating the information entropy of each column in the standard table file according to the cell attribute proportion of each column in the standard table file;
when the information entropy is higher than a preset threshold value, generating a data missing item notification;
acquiring a missing item completion instruction fed back by the user according to the data missing item notification;
and setting the missing item completion instruction as a user operation instruction.
5. The method according to any one of claims 2 to 4, wherein the obtaining the target instruction sequence according to the data association relation and the user operation instruction sequence comprises:
generating a table data processing instruction sequence according to the data association relation;
carrying out duplication removal and integration on the table data processing instruction sequence and the user operation instruction sequence to obtain the target instruction sequence;
preferably, the obtaining a table processing model according to the target instruction sequence and the programming language component library includes:
performing relational mapping on the target instruction sequence and the programming language component library to obtain a target programming language script;
compiling and environment configuring the target programming language script to obtain the form processing model;
preferably, the form file is an Excel file, and the target programming language script is a Python script.
6. The method of claim 5, wherein parsing the standard form file to obtain a parsing result comprises:
extracting various data information in the standard table file;
establishing a data matrix object according to each item of data information;
analyzing the data matrix object, and distinguishing data entity information and data attribute information in each item of data information;
and obtaining a data association relation between each item of data information according to the data entity information and the data attribute information, wherein the data association relation is an association relation between at least two items of data entity information or an association relation between the data entity information and the data attribute information.
7. A method of generating a form processing model, the method comprising:
acquiring a standard form file;
analyzing the standard table file to obtain an analysis result, wherein the analysis result comprises a data association relation among various data information in the standard table file;
acquiring a user operation instruction sequence;
obtaining a target instruction sequence according to the data association relation and the user operation instruction sequence;
and obtaining a form processing model according to the target instruction sequence and a preset programming language component library, wherein the form processing model is used for processing a form file to be processed according to a current user operation instruction to obtain a target form file.
8. A form file processing apparatus, characterized in that the apparatus comprises:
the system comprises a to-be-processed data acquisition module, a to-be-processed data acquisition module and a processing module, wherein the to-be-processed data acquisition module is used for acquiring a to-be-processed form file and a current user operation instruction of the to-be-processed form file;
the form processing module is used for inputting the form file to be processed and the current user operation instruction into a form processing model to obtain a target form file;
the table processing model is a data processing model generated by carrying out relational mapping on a target instruction sequence and a preset programming language component library, and the target instruction sequence is an instruction sequence obtained according to a standard table file and a user operation instruction sequence.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010151591.8A CN111353286A (en) | 2020-03-06 | 2020-03-06 | Table file processing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010151591.8A CN111353286A (en) | 2020-03-06 | 2020-03-06 | Table file processing method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111353286A true CN111353286A (en) | 2020-06-30 |
Family
ID=71197483
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010151591.8A Pending CN111353286A (en) | 2020-03-06 | 2020-03-06 | Table file processing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111353286A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112560415A (en) * | 2020-12-18 | 2021-03-26 | 深圳市元征科技股份有限公司 | Data processing method, device, equipment and medium |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN113378532A (en) * | 2021-06-04 | 2021-09-10 | 远光软件股份有限公司 | Processing method of table file, processing device and storage medium thereof |
| CN113435701A (en) * | 2021-05-28 | 2021-09-24 | 消费者报道杂志社有限公司 | Method and device for processing consumption quality information |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110008446A (en) * | 2019-02-27 | 2019-07-12 | 深圳点猫科技有限公司 | The method and electronic equipment that a kind of language based on programming converts form document |
| CN110046334A (en) * | 2019-03-21 | 2019-07-23 | 平安国际智慧城市科技股份有限公司 | Data lead-in method, device, computer equipment and storage medium |
-
2020
- 2020-03-06 CN CN202010151591.8A patent/CN111353286A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110008446A (en) * | 2019-02-27 | 2019-07-12 | 深圳点猫科技有限公司 | The method and electronic equipment that a kind of language based on programming converts form document |
| CN110046334A (en) * | 2019-03-21 | 2019-07-23 | 平安国际智慧城市科技股份有限公司 | Data lead-in method, device, computer equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 廖致君: "用Python完成Excel的常用操作" * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112560415A (en) * | 2020-12-18 | 2021-03-26 | 深圳市元征科技股份有限公司 | Data processing method, device, equipment and medium |
| CN112862449A (en) * | 2021-03-02 | 2021-05-28 | 岭东核电有限公司 | Structural chemical industry bill generation method and device, computer equipment and storage medium |
| CN113435701A (en) * | 2021-05-28 | 2021-09-24 | 消费者报道杂志社有限公司 | Method and device for processing consumption quality information |
| CN113378532A (en) * | 2021-06-04 | 2021-09-10 | 远光软件股份有限公司 | Processing method of table file, processing device and storage medium thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111353286A (en) | Table file processing method and device, computer equipment and storage medium | |
| CN108874926B (en) | Mass data query method, device, computer equipment and storage medium | |
| WO2020258650A1 (en) | Page information display method and apparatus, computer device, and storage medium | |
| CN111176767B (en) | Table data processing method, apparatus, computer device and storage medium | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN110955418A (en) | Code generation method and device, computer equipment and storage medium | |
| CN112286934A (en) | Database table importing method, device, equipment and medium | |
| CN111208998A (en) | Method and device for automatically laying out data visualization large screen and storage medium | |
| CN111309991B (en) | Query statement generation method and device and data query method and system | |
| CN109063155B (en) | Language model parameter determination method and device and computer equipment | |
| CN113780673A (en) | Training method and device of job leaving prediction model and job leaving prediction method and device | |
| CN113901768A (en) | Standard file generation method, device, equipment and storage medium | |
| CN114201511A (en) | Project management and control method and device, computer equipment and storage medium | |
| CN110555082B (en) | Data processing method, device, computer equipment and storage medium | |
| CN110795475A (en) | Report generation method and device, computer equipment and storage medium | |
| CN112001615A (en) | Process creation method, system, computer device, and storage medium | |
| CN112884435A (en) | Service data processing method, device, system, computer equipment and storage medium | |
| CN110287459B (en) | Form batch processing method, system, device and storage medium | |
| CN115905397A (en) | Visual display method, device, system and medium for business data | |
| CN115393128A (en) | Panoramic analysis method and device for intellectual property, computer equipment and medium | |
| CN111667214B (en) | Goods information acquisition method and device based on two-dimensional code and electronic equipment | |
| CN109871214B (en) | Program code generation method, program code generation device, computer device, and storage medium | |
| CN113095047A (en) | Experiment report generation method and device, computer equipment and storage medium | |
| CN109783877B (en) | Time sequence model establishment method, device, computer equipment and storage medium | |
| CN112463791A (en) | Nuclear power station document data acquisition method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |