Processing

Please wait...

Settings

Settings

Goto Application

1. CN109783788 - Data table filling method and device, computer device and storage medium

Office
China
Application Number 201910001784.2
Application Date 02.01.2019
Publication Number 109783788
Publication Date 21.05.2019
Publication Kind A
IPC
G06F 17/24
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
17Digital computing or data processing equipment or methods, specially adapted for specific functions
20Handling natural language data
21Text processing
24Editing, e.g. insert/delete
G06F 16/2458
GPHYSICS
06COMPUTING; CALCULATING OR COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
CPC
G06F 16/2458
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
16Information retrieval; Database structures therefor; File system structures therefor
20of structured data, e.g. relational data
24Querying
245Query processing
2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
G06F 17/00
GPHYSICS
06COMPUTING; CALCULATING; COUNTING
FELECTRIC DIGITAL DATA PROCESSING
17Digital computing or data processing equipment or methods, specially adapted for specific functions
Applicants SHENZHEN ONECONNECT TECHNOLOGY CO., LTD.
深圳壹账通智能科技有限公司
Inventors CAI JIAN
蔡健
YANG LEI
杨镭
HUANG BEICHEN
黄北辰
GUO LINGFENG
郭凌峰
FU XIAO
付晓
Agents 广州华进联合专利商标代理有限公司 44224
Title
(EN) Data table filling method and device, computer device and storage medium
(ZH) 数据表填补方法、装置、计算机设备和存储介质
Abstract
(EN)
The invention relates to a data table filling method and device, a computer device and a storage medium. The data table filling method relates to the technical field of data processing, and comprisesthe following steps: obtaining a data table uploaded by a user; determining incomplete field names in the data table, wherein the incomplete field names are lack of data values; determining the missing type of the incomplete field names according to the relevancy between the incomplete field names and other field names in the data table; calculating a missing value according to an existing data value in the data table and a filling mode corresponding to the missing type; and filling the incomplete field name missing data value according to the missing value. By adopting the scheme, the missingdata value of each incomplete field name in the data table can be filled, and the data table can be effectively filled, so that the accuracy of data analysis performed based on the filled data tablecan be remarkably improved.

(ZH)
本申请涉及一种数据表填补方法、装置、计算机设备和存储介质。该数据表填补方法涉及数据处理技术领域,所述方法包括:获取用户上传的数据表;确定数据表中的非完全字段名,非完全字段名缺少数据值;根据非完全字段名与数据表中其它字段名之间的相关度确定非完全字段名的缺失类型;根据数据表中已有的数据值,根据缺失类型对应的填补方式计算缺失值;根据缺失值填补非完全字段名缺失的数据值。采用本方案可以填补数据表中各个非完全字段名缺失的数据值,能够有效填补数据表,这样,基于填补后的数据表所进行的数据分析的准确度也会显著提高。

Related patent documents