Method and system for extracting, cleaning and integrating power data of power supply company
A technology of power data and power supply companies, applied in the direction of electric digital data processing, data processing applications, special data processing applications, etc., can solve the differences in the format and statistical dimension of production and operation monthly reports, and the inaccurate grasp of power data of county-level power supply companies , Insufficient mastery and accuracy, etc., to achieve the effect of convenient labeling, easy identification, and improved accuracy
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0040] The method for extracting, cleaning and integrating power data of a power supply company includes the following steps in sequence:
[0041] S1: Data extraction, extracting the power data of the monthly production and operation reports of county-level power supply companies;
[0042] S2: Data cleaning, check the data quality of the extracted power data, and clean up the abnormal data of the extracted power data;
[0043] S3: Data integration. On the basis of the data cleaned up, the power data of each month is integrated into a complete data set to form a complete internal data set of the power supply company.
[0044] Through the above steps, the provincial power supply company extracts the power data of the monthly production and operation reports of the county-level power supply companies, then cleans up the abnormal data, and then integrates them, effectively avoiding the format and statistical dimensions of the monthly production and operation reports of the county-...
Embodiment 2
[0048] In order to better demonstrate the present invention, as a further optimization of Embodiment 1, this embodiment includes all the technical features of Embodiment 1, the difference being that this embodiment also includes the following technical features:
[0049] Preferably, the data structure combing includes: data crawling object confirmation, file format conversion.
[0050] The object of data crawling is the data in the table in the appendix of the production and operation monthly report of each county-level power supply company, which is conducive to determining the source of power data according to the extraction requirements; and other file formats) to convert all files in batches to a unified file format to prepare for file data extraction and mining.
[0051] Preferably, the data crawling objects include "Industrial Power Consumption Classification Table", "Detailed Statistical Table of Electricity Sales", "Line Loss Rate Statistical Table", "10kv Heavy Loss, ...
Embodiment 3
[0060] Power data extraction, cleaning and integration system of power supply company, including data extraction module, data cleaning module and data integration module;
[0061] The data extraction module is used to extract the power data of the county-level power supply company's production and operation monthly report;
[0062] The data cleaning module is used to check the data quality of the extracted power data, and clean up the abnormal data of the extracted power data;
[0063] The data integration module is used to integrate the power data of each month into a complete data set on the basis of the data cleaned up to form a complete internal data set of the power supply company.
[0064] Through the above modules, the provincial power supply company extracts the power data of the county-level power supply company's monthly production and operation report, then cleans up the abnormal data, and then integrates it, effectively avoiding the format and statistical dimension...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More