Abstract:Big data techniques have been applied to power grid for the prediction and evaluation of grid conditions. However, the raw data quality can rarely meet the requirement of precise data analytics since raw data set usually contains samples with missing data to which the common data mining models are sensitive. Besides, the raw training data from a single monitoring system, e.g. dissolved gas analysis (DGA), are rarely sufficient for training in the form of valid instances since raw data set usually contains samples with noisy data. Though classic methods like neural network can be used to fill the gaps of missing data and classify the fault type, their models often fail to fit the rules of power grid conditions. This paper presents an integrated data preprocessing framework (DPF) based on Apache Spark to improve the prediction accuracy for data sets with missing data points and classification accuracy with noise data as well as to meet the big data requirement, which mainly combines missing data prediction, data fusion, data cleansing and fault type classification. First, the prediction model is trained based on the linear regression (LinR). Afterwards, we propose an optimized linear method (OLR) to improve the prediction accuracy. Then, to better utilize the strong correlation among different data sources, new data features extracted by persons correlation coefficient (PCC) are fused into a training data set. Next, principal component analysis (PCA) is taken to reduce the side effect brought by the new feature as well as retaining significant information for classification. Finally, the classification model based on logistic regression (LogR) and support vector machine (SVM) is trained to classify the fault type of electric equipment. We test the DPF framework on missing data prediction and fault type classification of power transformers in power grid system. The experimental results show that the predictors based on the proposed framework achieve lower mean square error and the classifiers obtain higher accuracy than traditional ones. Besides, the training time required for training large-scale data shows a decreasing trend. Therefore, the data preprocessing framework DPF would be a good candidate to predict the missing data and classify the fault type in power grid system.

Data Preprocessing and Quality Evaluation for Building the Power Grid Supervision Knowledge Graph

A Data Fusion and Data Cleaning System for Smart Grids Big Data.

Safety Monitoring of Power Industrial Control Terminals Based on Data Cleaning

A lattice LSTM-based framework for knowledge graph construction from power plants maintenance reports

Comprehensive Evaluation of Big Data Quality in Power Systems with Entropy Weight and Grey System Theory

Research on the construction and implementation of power grid fault handling knowledge graphs

Knowledge graph construction and Internet of Things optimisation for power grid data knowledge extraction

An Integrated Data Preprocessing Framework Based on Apache Spark for Fault Diagnosis of Power Grid Equipment

Application of knowledge graph in smart grid fault diagnosis

Study of Power Grid Development Diagnosis System Based on Multi-Source Data Analysis

Knowledge Graph Construction and Application of Power Grid Equipment

Data Cleaning for Power Quality Monitoring

Data quality assessment for on-line monitoring and measuring system of power quality based on big data and data provenance theory

Big Data Cleaning Model of Multi-Source Heterogeneous Power Grid Based On Machine Learning Classification Algorithm

Construction and intelligent analysis of power grid physical data knowledge graph based on Internet of Things for power system

Comprehensive Evaluation and Development Diagnosis System of the Municipal Power Grid

Construction and application of static stability intelligent evaluator for large power grid from the perspective of knowledge graph

A survey on the development status and application prospects of knowledge graph in smart grids

Multi-source Heterogeneous Information Fusion of Power Assets Based on Knowledge Graph

Knowledge Graph Construction For Intelligent Maintenance Of Power Plants

Power Grid Missing Data Filling Method Based on Historical Data Mining Assisted Multi-dimensional Scenario Analysis