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.

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

Robust and Automatic Data Cleansing Method for Short-Term Load Forecasting of Distribution Feeders

Diverse Grouping-Based Aggregation Protocol With Error Detection for Smart Grid Communications

Distributed storage and processing of real-time data in smart grid dispatching and control systems

A Decision Support System Using Two-Level Classifier for Smart Grid

Safety Monitoring of Power Industrial Control Terminals Based on Data Cleaning

Complex Power System Status Monitoring and Evaluation Using Big Data Platform and Machine Learning Algorithms: A Review and a Case Study

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

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

Application Research of Big Data Real-time Processing Technology in Smart Grid

Concept, Technology and Challengs of Big Data in Smart Grids

Data Quality Management Framework for Smart Grid Systems

Smart Grid Time Series Big Data Processing System

Research on Big Data Risk Assessment of Major Transformer Defects and Faults Fusing Power Grid, Equipment and Environment Based on SVM

Grid data asset relationship and intelligent classification integrating knowledge graph and Internet of Things

A Fusion Framework Using Integrated Neural Network Model for Non-Intrusive Load Monitoring

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

Build Smart Grids on Artificial Intelligence -- A Real-world Example

Design and Implementation of Power Big Data Platform

Big data cleaning model of smart grid based on Tensor Tucker decomposition

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