Supercharge Your Innovation With Domain-Expert AI Agents!

Data cleaning tool

A technology of data cleaning and tools, applied in the field of data processing, can solve problems such as cumbersome process and long time-consuming, and achieve the effect of shortening time and improving efficiency

Pending Publication Date: 2019-10-22
北京聚通达科技股份有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to solve the above-mentioned problems of long time spent in data cleaning, cumbersome process and excessive professionalism of staff, the present invention proposes a cleaning process using graphical editing, which can be called repeatedly and is simple to operate without requiring too much effort. Expertise in data cleaning tools

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] A data cleaning tool, comprising: a running monitoring module, an import execution module, an import configuration module, and a data definition module; the import configuration module includes a basic configuration unit, a cleaning rule definition unit, and a cleaning process definition unit.

[0014] The cleaning rule definition unit includes: control node, character string processing node, date processing node, number processing node, data processing node and data storage node.

[0015] The control node includes: a start component, an end component, a judgment component and a branch component. The string processing node includes: a string length acquisition component, a search substring component, a substring interception component, a string connection component and a string replacement component.

[0016] The date processing node includes: obtaining current component, time calculation component and formatting component. The digital processing node includes: a digit...

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 belongs to the field of data processing, and particularly relates to a data cleaning tool. In order to solve the problems of long time consumption, tedious process and too strong professional skill of workers during data cleaning, the invention provides a data cleaning tool which uses a graphical editing cleaning process, can be repeatedly called. The data cleaning tool is simple tooperate and does not need too strong professional skill. In order to achieve the purpose, the technical scheme adopted by the invention is as follows: the data cleaning tool comprises an operation monitoring module, an import execution module, an import configuration module and a data definition module, and the import configuration module comprises a basic configuration unit, a cleaning rule definition unit and a cleaning process definition unit. The cleaning rule definition unit comprises a control node, a character string processing node, a date processing node, a digital processing node, adata processing node and a data storage node.

Description

technical field [0001] The invention belongs to the field of data processing, and in particular relates to a data cleaning tool. Background technique [0002] Data cleaning is the process of converting data from different sources and different formats into data in the same format and then saving them in the database. However, most data cleaning is done manually at present. There are also some software that can realize data cleaning, but its function The performance is very weak, requiring staff to have extremely high computer expertise, and the data processing method is fixed and single. Every time data processing needs to be reprogrammed, it takes a long time. Contents of the invention [0003] In order to solve the above-mentioned problems of long time spent in data cleaning, cumbersome process, and excessive professionalism of staff, the present invention proposes a cleaning process using graphical editing, which can be called repeatedly and is simple to operate without...

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): G06F8/34G06F16/25
CPCG06F8/34G06F16/258
Inventor 侯战斌
Owner 北京聚通达科技股份有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More