Table data processing method and device, computer equipment and readable storage medium

A technology for tabular data and processing methods, applied in the field of data processing, can solve the problems of long reading and operation time, and achieve the effect of reducing complexity, improving running speed, and shortening reading time

Pending Publication Date: 2020-09-18
TAIKANG LIFE INSURANCE CO LTD +1
View PDF3 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present invention provides a table data processing method to solve the technical problem of long system reading and operation time in table data processing in the prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Table data processing method and device, computer equipment and readable storage medium
  • Table data processing method and device, computer equipment and readable storage medium
  • Table data processing method and device, computer equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below in conjunction with the embodiments and accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0029] In an embodiment of the present invention, a tabular data processing method is provided, such as figure 2 As shown, the method includes:

[0030] Step 202: read the data of each row or column in the table;

[0031] Step 204: converting the data of each row or column into an ordered dictionary format;

[0032] Step 206: Convert the data in ordered dictionary format into a multidimensional array according to the order of rows and columns in the table;

[0033] Step 208: Call the multi-dimensional array to obtain data to be processed according to different data processing requests, wher...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The embodiment of the invention provides a table data processing method and device, computer equipment and a readable storage medium, and the method comprises the steps: reading the data of each row or each column in a table; converting the data of each row or each column into an ordered dictionary format; converting the data in the ordered dictionary format into a multi-dimensional array according to the sequence of rows and columns in the table; calling the multi-dimensional array according to different data processing requests to obtain to-be-processed data, the data processing requests comprising processing types and related information of the to-be-processed data; and performing data processing of a corresponding type on the to-be-processed data. According to the scheme, the code writing number can be reduced in the data processing process, so that the system reading time is shortened, the running speed is increased, the complexity of the data processing process is reduced, the code robustness is improved, and the maintenance is easier.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a table data processing method, device, computer equipment and readable storage medium. Background technique [0002] The Taikang RPA (Robotic Process Automation, software process automation) project scenario involves a lot of data processing on EXCEL tables, including the realization of data pivoting, data sorting, addition, deletion, modification and query in the tables. In order to realize these requirements, existing methods need to write codes, set instructions for the system, and write different codes according to different instructions until the data processing requirements of EXCEL tables are realized. [0003] For example, taking data sorting processing requirements as an example, such as figure 1 As shown, the code needs to be written according to the data processing steps. The text uses the EXCEL table as an example. The code required for sorting is as...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F40/103G06F40/177G06F40/242
CPCG06F40/103G06F40/177G06F40/242
Inventor 李静
Owner TAIKANG LIFE INSURANCE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap