Data analysis method and device, computer equipment and readable storage medium

A data analysis and data recording technology, applied in the field of data processing, can solve the problems of stay, high manpower and time costs, low technical means, etc., and achieve the effect of improving accuracy

Pending Publication Date: 2020-12-04
GLODON CO LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In order to realize the unified aggregation, storage and processing of data, it is necessary to unify various forms of tabular data into electronic data. At present, when realizing the unification of electronic data, the technical means are relatively low, and most of the operation methods are still manual. The input mode leads to high manpower and time costs for this work

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
  • Data analysis method and device, computer equipment and readable storage medium
  • Data analysis method and device, computer equipment and readable storage medium
  • Data analysis method and device, computer equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] An embodiment of the present invention provides a data parsing method, through which automatic parsing of non-editable data can be realized, specifically, figure 1 The flow chart of the data parsing method provided by Embodiment 1 of the present invention, such as figure 1 As shown, the data parsing method provided in this embodiment includes the following steps S101 to S106.

[0028] Step S101: Obtain the picture of the table to be parsed.

[0029] In some scenarios, the materials that need to be unified into spreadsheet data include various forms, such as paper, web pages, PDF, etc. In this embodiment, the above material forms can be unified into pictures by taking pictures or screenshots first Format, convert the table into a picture, and get the picture of the table to be parsed.

[0030] Step S102: Identify the form image to be analyzed as a form file to obtain an initial form file.

[0031] Text recognition technology modules such as OCR can be called to perform ...

Embodiment 2

[0060] The second embodiment is a preferred embodiment provided on the basis of the first embodiment above. figure 2 It is a flow chart of the data parsing method provided by Embodiment 2 of the present invention.

[0061] In this embodiment, the table to be parsed is a data table of information prices. For the update of information prices, each region basically modifies content on the basis of the previous period. Through this embodiment, templates can be dynamically configured , to parse the complex xls data file (that is, the initial form file) and convert it into a formatted data file (that is, the standard form file). The parsed data is matched with the existing information price database of the previous period to determine the newly added data records and modified data records without manual proofreading. The entire program uses an automated process to replace the existing manual entry process. Specifically, the processing stage mainly includes identifying the image (...

Embodiment 3

[0079] Corresponding to Embodiment 1 above, Embodiment 3 of the present invention provides a data parsing device. Details of corresponding technical features and corresponding technical effects may refer to the description of Embodiment 1 above, which will not be repeated here. image 3 The block diagram of the data parsing device provided for Embodiment 3 of the present invention, such as image 3 As shown, the data analysis device includes: an acquisition module 201 , an identification module 202 , an analysis template 203 and an update module 204 .

[0080] Obtaining module 201 is used for obtaining the form picture to be analyzed; Recognition module 202 is used for identifying form file to be analyzed form picture, obtains initial form file; Parsing template 203 is used for parsing initial form file according to pre-configured parsing template, to obtain several data record, and write the data record into the standard form file; and the update module 204 matches the standa...

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 invention provides a data analysis method and device, computer equipment and a readable storage medium. The method comprises the steps of obtaining a to-be-analyzed form picture; identifying the to-be-analyzed table picture as a table file to obtain an initial table file; analyzing the initial table file according to a pre-configured analysis template to obtain a plurality of data records; writing the data record into a standard table file; matching the standard table file with a historical record library to determine a newly added data record or a modified data record; and updating the historical record library according to the newly added data record or the modified data record to obtain a data record library corresponding to the to-be-analyzed table picture. According to the invention, automatic analysis of the table data can be achieved.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a data analysis method, device, computer equipment and readable storage medium. Background technique [0002] In the field of building material information, every province, city, and region in the country needs to publish a form of material information data every month, involving information prices in more than 30 provinces and more than 600 regions across the country, and the release methods are various, including PDF, web pages, paper, Electronic forms and other forms, among which, publishing in paper form accounts for as high as 48%. In order to realize the unified aggregation, storage and processing of data, it is necessary to unify various forms of tabular data into electronic data. At present, when realizing the unification of electronic data, the technical means are relatively low, and most of the operation methods are still manual. The input mode leads to...

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/18G06F40/174G06F40/186G06K9/00G06K9/62G06F16/23
CPCG06F40/18G06F40/174G06F40/186G06F16/2358G06V30/413G06V30/10G06F18/22
Inventor 张彬李果成应洪峰
Owner GLODON 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