Power data exception reason screening method and device, electronic equipment and storage medium

Abstract

The embodiment of the invention discloses a power data exception reason screening method and device, electronic equipment and a storage medium. Obtaining a screening task of the power data, and obtaining to-be-screened data corresponding to the screening task from the corresponding page through the crawler script; the screening condition in the screening task comprises an exception type; uploading the to-be-screened data to a to-be-screened table in a screening database, and determining a target screening script from candidate screening scripts based on a structured query language according to the exception type; and according to the target screening script, abnormal reason screening is automatically carried out on the to-be-screened data in the to-be-screened table to determine an abnormal reason. According to the embodiment of the invention, the efficiency and accuracy of screening the abnormal reasons of the power data are improved.

Description

Technical Field

[0001] The embodiments of the present application relate to power system automation technology, and in particular to a method, device, electronic device and storage medium for screening causes of abnormal power data. Background Art

[0002] With the reform of electricity market trading, it is necessary to calculate the daily electricity consumption of market trading users. For users with abnormal daily electricity consumption calculation, it is necessary to determine the cause of the abnormality and send it to the responsible personnel of each department.

[0003] In actual operations, business personnel are required to query the global market trading household data for the past month on a daily and branch basis, manually determine the causes of abnormalities, and send them to the responsible personnel of each department.

[0004] However, manual screening is labor-intensive and cannot guarantee the efficiency and accuracy of screening. Summary of the invention

[0005] The present application provides a method, device, electronic device and storage medium for screening causes of power data anomalies to improve the efficiency and accuracy of screening causes of power data anomalies.

[0006] In a first aspect, an embodiment of the present application provides a method for screening causes of abnormal power data, the method for screening causes of abnormal power data comprising:

[0007] Obtain a screening task for power data, and obtain the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include the abnormality type;

[0008] Upload the data to be screened into the table to be screened in the screening database, and determine the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type;

[0009] According to the target screening script, the data to be screened in the screening table are automatically screened for abnormal causes to determine the abnormal causes.

[0010] In a second aspect, an embodiment of the present application further provides a device for screening causes of abnormal power data, the device for screening causes of abnormal power data comprising:

[0011] The module for obtaining data to be screened is used to obtain the screening task of power data, and obtain the data to be screened corresponding to the screening task from the corresponding page through the crawler script; the screening conditions in the screening task include the abnormal type;

[0012] A target screening script determination module is used to upload the data to be screened to the to-be-screened table in the screening database, and determine the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type;

[0013] The abnormal cause screening module is used to automatically screen the abnormal causes of the data to be screened in the screening table according to the target screening script to determine the abnormal causes.

[0014] In a third aspect, an embodiment of the present application further provides an electronic device, the electronic device comprising:

[0015] one or more processors;

[0016] A storage device for storing one or more programs;

[0017] When one or more programs are executed by one or more processors, the one or more processors implement any one of the methods for screening causes of power data anomalies provided in the embodiments of the present application.

[0018] In a fourth aspect, an embodiment of the present application further provides a storage medium comprising computer executable instructions, which, when executed by a computer processor, are used to execute any one of the methods for screening causes of power data anomalies as provided in the embodiments of the present application.

[0019] The present application obtains the screening task of power data, and obtains the data to be screened corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include the abnormality type; the data to be screened is automatically obtained, and there is no need to manually query and export the data one by one, thereby improving the efficiency of the entire abnormal cause screening, reducing export errors, and improving the accuracy of data export; the data to be screened is uploaded to the to-be-screened table in the screening database, and according to the abnormality type, the target screening script is determined from the candidate screening scripts based on the structured query language. By importing the data to be screened into the screening database, a script file can be written based on the structured query language to realize automatic screening of abnormal causes, and by determining the target screening script according to the abnormality type, there is no need to screen the abnormal causes one by one through the candidate screening scripts, thereby narrowing the scope of abnormal cause screening and improving the efficiency of abnormal cause screening; the data to be screened in the to-be-screened table is automatically screened for abnormal causes according to the target screening script to determine the abnormal cause, and the target screening script can be used to perform targeted abnormal cause screening on the to-be-screened data of the corresponding abnormal type, thereby improving the accuracy of the abnormal cause. Therefore, the technical solution of the present application solves the problem that manual screening has a large workload and cannot guarantee the efficiency and accuracy of screening, thereby achieving the effect of improving the efficiency and accuracy of screening of abnormal causes of power data. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] Figure 1 It is a flow chart of a method for screening causes of abnormal power data in Embodiment 1 of the present application;

[0021] Figure 2This is a flow chart of a method for screening causes of abnormal power data in Embodiment 2 of the present application;

[0022] Figure 3 This is a flow chart of a method for screening causes of abnormal power data in Embodiment 3 of the present application;

[0023] Figure 4 It is a flow chart of a method for screening causes of abnormal power data in Embodiment 4 of the present application;

[0024] Figure 5 It is a structural schematic diagram of a device for screening causes of abnormal power data in Embodiment 5 of the present application;

[0025] Figure 6 It is a structural diagram of an electronic device in Example 6 of the present application. DETAILED DESCRIPTION

[0026] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0027] It should be noted that the terms "first" and "second" etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0028] Embodiment 1

[0029] Figure 1 A flowchart of a method for screening causes of abnormal power data provided in Example 1 of the present application. This embodiment can be applied to the situation of screening causes of abnormal data in a power system. The method can be executed by a device for screening causes of abnormal power data, which can be implemented in software and / or hardware and is specifically in a power system.

[0030] See also Figure 1The method for screening the causes of abnormal power data shown in the figure specifically includes the following steps:

[0031] S110, obtaining a screening task for power data, and obtaining the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include anomaly types.

[0032] In the power system, the screening task may be a task for screening the abnormal causes of abnormal data in the power data. Exemplarily, the screening task may be automatically generated after abnormal data is found in the power system, or it may be set by a business person, and this application does not specifically limit this. The power data is the relevant data in the power system, for example, the power data may include user identification, active power indication number, metering point status and transaction date, etc. The abnormal type may be an abnormal type determined according to the abnormal form after the data abnormality is found in the power system. Exemplarily, the abnormal type may include data duplication, metering point suspension power is not 0 and negative power, etc., and this application does not specifically limit this, and may be determined according to the regulations of different power supply bureaus. The screening conditions in the screening task include at least the abnormal type, and may also include the power supply bureau to which it belongs and the screening period, etc., and this application does not specifically limit this. Exemplarily, the screening task may be determined by the business person by selecting the screening period, the power supply bureau to which it belongs and the abnormal type and other screening conditions to determine the screening task. Exemplarily, the screening task may also be generated periodically by the program. For example, the following screening task is automatically generated periodically on the 15th of each month: the abnormal causes of the data of the negative power abnormal type of the A power supply bureau from the 1st to the 12th of the previous month are screened. The screening conditions in the screening task include the abnormality type, which can help narrow the screening scope when conducting subsequent abnormal cause screening, improve the specificity of subsequent cause screening, and thus improve the efficiency and accuracy of cause screening.

[0033] The data to be screened is the power data that needs to be screened for abnormal causes obtained according to the screening task. After obtaining the screening task, the crawler script is started to obtain the data to be screened from the corresponding web page according to the screening task.

[0034] In an optional embodiment, the data to be screened corresponding to the screening task is obtained from the corresponding page through a crawler script, including: determining the URL to be crawled according to the screening conditions in the screening task; and obtaining the data to be screened corresponding to the screening task from the page corresponding to the URL to be crawled through a crawler script.

[0035] The URL to be crawled can be the URL of the page that needs to be crawled according to the screening task. The URLs of the query pages corresponding to different screening conditions can be configured in the crawler script, and the URL to be crawled can be determined according to at least one of the screening conditions. For example, the URL to be crawled can be determined according to the power supply bureau or the abnormality type. After the screening task is obtained, the URL to be crawled of the page to be crawled is determined according to the screening conditions, and the data to be screened that meets the screening conditions in the screening task is crawled from the page.

[0036] The crawler script is used to obtain the data to be screened corresponding to the screening task from the page corresponding to the URL to be crawled. The crawler script can first obtain the URL of the page where the data to be screened is located from the business system according to the screening task, as the address to be crawled; then obtain the screening conditions and the format and writing method of the required fields from the developer tool, that is, the page code editing page; finally, the data to be screened obtained after the query is stored in an array in a loop, and after storing all the data to be screened, it is exported to the specified cell of the Excel (professional term, a file format) file.

[0037] By determining the URL to be crawled according to the screening conditions in the screening task; obtaining the data to be screened corresponding to the screening task from the page corresponding to the URL to be crawled through the crawler script, the data to be screened can be automatically obtained without manual data export, thereby improving the export efficiency and accuracy of the data to be screened.

[0038] S120, uploading the data to be screened to the table to be screened in the screening database, and determining the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type.

[0039] The screening database may be a database for storing data to be screened. The table to be screened may be a Structured Query Language (SQL) table established in advance in the database to be screened, which is used to store the data to be screened. A data mapping table may be configured in the screening database, and the data mapping table contains the table name and column name of each table to be screened. The table to be screened to which the data to be screened needs to be uploaded may be determined based on the data mapping table. After obtaining the data to be screened, the corresponding table to be screened is determined based on the column name of the data to be screened in the original data table, and the data to be screened is uploaded to the corresponding position in the table to be screened.

[0040] The candidate screening script can be an abnormality cause screening script based on structured query language, which is used to determine the abnormal cause of the data to be screened. Different abnormality types correspond to different candidate abnormality screening scripts. The screening methods for the data to be screened of different abnormality types are different. Therefore, the screening database contains screening scripts corresponding to different abnormality types. According to the correspondence between different abnormality types and candidate screening scripts, the candidate screening script corresponding to the abnormality type is determined as the target screening script.

[0041] In an optional embodiment, the candidate screening scripts include at least: a repeated screening script, a pause screening script and a negative battery screening script.

[0042] The duplicate screening script is a script that screens the abnormal causes of the abnormal types of repeated data, and is used to screen the abnormal causes of repeated data. The pause screening script is a script that screens the abnormal causes of the abnormal types of the metering point pause power not being 0, and is used to screen the abnormal causes of the metering point pause power not being 0. The negative power screening script is a script that screens the abnormal causes of the abnormal types of negative power, and is used to screen the abnormal causes of negative power. Through the duplicate screening script, the pause screening script, and the negative power screening script, targeted abnormal cause screening can be performed for different types of abnormalities, reducing the screening of unnecessary causes and improving the efficiency of abnormal cause screening.

[0043] When the exception type is data duplication, the duplication screening script is determined as the target screening script; when the exception type is that the pause power at the metering point is not 0, the pause screening script is determined as the target screening script; when the exception type is negative power, the negative power screening script is determined as the target screening script.

[0044] S130, automatically screening the data to be screened in the screening table for abnormal causes according to the target screening script to determine the abnormal causes.

[0045] The target screening script can automatically screen the abnormal causes of the data to be screened in the screening table according to the judgment conditions, and determine the abnormal causes of the data to be screened. The judgment conditions in different target screening scripts are different. For example, when the abnormal type is data duplication, the judgment condition can be to determine whether the electrometer reading is not fitted.

[0046] Optionally, the screening database in the present application can be established in the intranet environment of the power system, and the screening task of power data can be obtained through the front-end interactive page, the data to be screened can be obtained based on the power grid big data cloud platform, and the data write-back rules can be set, that is, the abnormal causes of the data to be screened are written back to the corresponding database for storing the abnormal causes.

[0047] Due to the reform of electricity market transactions in recent years, the marketing staff of power grid enterprises need to calculate the daily electricity consumption of market-based trading users every day. In actual operation, business personnel need to query the global market-based trading household data for the past month by day and by power supply bureau. For users with abnormal daily electricity calculation, it is necessary to manually determine the cause of the abnormality and send it to the responsible personnel of each department. In the whole process, many links will consume a lot of time of business personnel. For example, when querying, it is necessary to search by day and by branch, that is, it is necessary to query and export data "30×branch" times and summarize it into a general table; when judging abnormalities, it is necessary to analyze them one by one, and it is necessary to query the related data in the relevant business system again to assist in judgment.

[0048] The technical solution of this embodiment is to obtain the screening task of power data, and obtain the data to be screened corresponding to the screening task from the corresponding page through the crawler script; the screening conditions in the screening task include the abnormality type; the data to be screened is automatically obtained, and there is no need to manually query and export the data one by one, thereby improving the efficiency of the entire abnormal cause screening, reducing export errors, and improving the accuracy of data export; the data to be screened is uploaded to the table to be screened in the screening database, and according to the abnormality type, the target screening script is determined from the candidate screening scripts based on the structured query language, and by importing the data to be screened into the screening database, a script file can be written based on the structured query language to realize automatic screening of abnormal causes, and by determining the target screening script according to the abnormality type, there is no need to screen the abnormal causes one by one through the candidate screening scripts, thereby narrowing the scope of abnormal cause screening and improving the efficiency of abnormal cause screening; the data to be screened in the table to be screened is automatically screened for abnormal causes according to the target screening script to determine the abnormal cause, and the target screening script can be used to perform targeted abnormal cause screening on the data to be screened of the corresponding abnormal type, thereby improving the accuracy of the abnormal cause. Therefore, the technical solution of the present application solves the problem that manual screening has a large workload and cannot guarantee the efficiency and accuracy of screening, thereby achieving the effect of improving the efficiency and accuracy of screening of abnormal causes of power data.

[0049] Embodiment 2

[0050] Figure 2 This is a flow chart of a method for screening causes of power data anomalies provided in Example 2 of the present application. The technical solution of this embodiment is further refined on the basis of the above technical solution.

[0051] Furthermore, if the target screening script is a duplicate screening script, the "automatic screening of abnormal causes for the data to be screened in the screening table according to the target screening script to determine the abnormal cause" is refined as: "determine whether the data type corresponding to the duplicate data in the screening table is an active representation number; if so, query whether the fitting identifier corresponding to the duplicate data is a table code fit; if so, determine that the abnormal cause is that the table code is not fitted" to automatically realize the screening of abnormal causes.

[0052] See also Figure 2 A method for screening causes of abnormal power data is shown, comprising:

[0053] S210, obtaining a screening task for power data, and obtaining the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include anomaly types.

[0054] S220, uploading the data to be screened to the table to be screened in the screening database, and determining the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type.

[0055] S230: Determine whether the data type corresponding to the repeated data in the table to be screened is an active representation number.

[0056] The duplicate screening script is a target screening script for the data to be screened whose abnormal type is data duplication. The duplicate data can be data with the same continuous numerical value in a column of data in the table to be screened. When the number of duplicate data exceeds the preset number threshold, the duplicate data can be determined as abnormal data, and the abnormal type is data duplication. The preset number threshold can be determined by professional technicians. For example, the preset number threshold can be 3.

[0057] If the target screening script is a duplicate screening script, the cause of data duplication is screened at this time. In the power system, data duplication is mainly an abnormal type of "active power representation" in the metering system. Therefore, the duplicate screening script first determines whether the data type corresponding to the duplicate data in the table to be screened is active power representation.

[0058] S240: If yes, query whether the fitting mark corresponding to the repeated data is table code fitting.

[0059] If so, that means the data type corresponding to the repeated data in the screening table is the active representation number. The reason for the duplication of the active representation number is mostly because the table code is not fitted, so check whether the corresponding fitting flag is that the table code is not fitted. The "fitting flag" is used to indicate the way the active representation number is obtained. The values ​​corresponding to the "fitting flag" include "copy and see" and "table code fitting". If the value corresponding to the "fitting flag" is "table code fitting", it means that the active representation number is obtained by fitting; if the value corresponding to the "fitting flag" is "copy and see", it means that the active representation number is obtained by copying.

[0060] If not, that is, the data type corresponding to the repeated data in the screening table is not an active representation number, then you can continue to judge other data types, or you can send the screened table to the metering system for manual verification. This application does not make specific restrictions on this.

[0061] S250: If yes, determine that the abnormality is caused by the table code not fitting.

[0062] If yes, that is, the fitting mark is table code fitting, and the active power representation number is repeated, it means that an error occurred during fitting, so it can be determined that the abnormal cause is that the table code is not fitted. If no, that is, the fitting mark is copying, and the active power representation number is repeated, it means that an error occurred during copying, so it can be determined that the abnormal cause is a copying error.

[0063] Optionally, when the cause of the exception is that the table code is not fitted, the duplicate data can be sent to the relevant module of the metering system for exception processing.

[0064] The technical solution of this embodiment is as follows: if the target screening script is a repeated screening script, it is determined whether the data type corresponding to the repeated data in the table to be screened is an active power representation number; if so, it is queried whether the fitting identifier corresponding to the repeated data is a table code fit; if so, it is determined that the abnormal cause is that the table code does not fit. The abnormal cause that causes data duplication can be automatically screened, and it can be accurately determined whether the abnormal cause is that the table code does not fit, without the need for manual screening, thereby improving the efficiency and accuracy of screening of abnormal causes of power data.

[0065] Embodiment 3

[0066] Figure 3 This is a flow chart of a method for screening causes of power data anomalies provided in Example 3 of the present application. The technical solution of this embodiment is further refined on the basis of the above technical solution.

[0067] Furthermore, if the target screening script is a suspended screening script, "automatically screen the data to be screened in the screening table for abnormal reasons according to the target screening script to determine the abnormal reasons" is refined as: "query the metering point status and transaction date of each user corresponding to the screening table, and query whether each user has a recovery work order within the preset time period before the transaction date; if there is a recovery work order and the metering point status is suspended, determine that the abnormal reason is that there is a recovery work order but the metering point status is wrong; otherwise, judge that the fitting mark of the positive active power is table code fitting, and when the judgment result is yes, determine that the abnormal reason is that there is no recovery work order and the table code fitting is wrong" to automatically realize the screening of abnormal reasons.

[0068] See also Figure 3 A method for screening causes of abnormal power data is shown, comprising:

[0069] S310, obtaining a screening task for power data, and obtaining the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include anomaly types.

[0070] S320, uploading the data to be screened to the table to be screened in the screening database, and determining the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type.

[0071] S330, querying the metering point status and transaction date of each corresponding user in the to-be-screened table, and querying whether each user has a recovery work order within a preset time period before the transaction date.

[0072] The suspension screening script is the target screening script for the data to be screened whose abnormal type is that the suspended power of the metering point is not 0. If the target screening script is the suspension screening script, the reason why the suspended power of the metering point is not 0 is screened. The suspended power of the metering point is not 0, which means that the status of the metering point is suspended, but the active power is not 0. At this time, the corresponding metering point status and transaction date of each user in the table to be screened are first queried to determine the metering point status and transaction date corresponding to the abnormal data.

[0073] The metering point status can include pause and run. A data mapping table is configured in the screening database. According to the "user number" and "metering point number" in the table to be screened as the screening conditions, the "electricity customer" table in the mapping table is queried, and the metering point status is queried. The transaction date is the transaction date corresponding to the data to be screened, which can be obtained from the table to be screened.

[0074] In the power system, after the metering point is suspended, the recovery work order is needed as the basis for enabling the metering point. Therefore, it is necessary to query whether each user has a recovery work order within the preset time period before the transaction date. The recovery work order can include a suspension recovery work order and a capacity reduction recovery work order. The preset time period can be a restricted time period for determining the date of the recovery work order relative to the transaction date. For example, the preset time period can be 30 days, that is, if the transaction date is October 1, then query whether each user has a recovery work order within 30 days before the transaction date. The preset time period can also be limited in other ways. For example, the preset time period can also be the month in which the transaction date is located and the previous month. This application does not make specific restrictions on this. The query time limit of the recovery work order can be limited by the preset time period to avoid the recovery work order from a long time ago affecting the judgment result of the abnormal cause. Specifically, the "User Number" can be used to query the "Business Expansion Work Order Basic Information" table in the mapping table to query whether there is a recovery work order within the preset time period before the transaction date.

[0075] S340. If there is a recovery work order and the metering point status is suspended, determine that the abnormal cause is that there is a recovery work order but the metering point status is wrong.

[0076] If there is a recovery work order and the metering point status is suspended, it means that the metering point is no longer suspended. At this time, the suspended status of the metering point is wrong. Therefore, it can be determined that the cause of the exception is that there is a recovery work order but the metering point status is wrong.

[0077] S350. Otherwise, determine that the fitting mark of the total positive active power is table code fitting, and when the judgment result is yes, determine that the abnormal cause is that there is no recovery work order and the table code fitting is wrong.

[0078] Otherwise, that is, there is no recovery work order or the meter point status is not suspended. However, since both the situations of having a recovery work order and the meter point status is not suspended, and having no recovery work order and the meter point status is suspended are normal states, it will not be judged that the meter point suspended power is not 0. Therefore, this step judges the abnormal reason for having no recovery work order and the meter point status is not suspended.

[0079] If there is no recovery work order, the value of the total positive active power corresponding to the metering point may be wrong. Therefore, it can be determined whether the fitting mark of the total positive active power in the "Metering Point Information" table is table code fitting. When the judgment result is yes, it can be determined that the value of the total active power is fitting. Therefore, it can be determined that the cause of the abnormality is that there is no recovery work order and the table code fitting is wrong.

[0080] Optionally, when the judgment result is no, it can be determined that the total value of the positive active power is not fitted, and therefore, it can be determined that the abnormal cause is that there is no recovery work order and the table code is not fitted.

[0081] The technical solution of this embodiment is as follows: if the target screening script is a suspended screening script, the meter point status and transaction date of each user corresponding to the to-be-screened table are queried, and whether each user has a recovery work order within a preset time period before the transaction date; if there is a recovery work order and the meter point status is suspended, the abnormal cause is determined to be that there is a recovery work order but the meter point status is wrong; otherwise, it is determined that the fitting mark of the positive active power total is table code fitting, and when the judgment result is yes, the abnormal cause is determined to be that there is no recovery work order and the table code fitting is wrong. The abnormal cause that causes the meter point suspension power to be not 0 can be automatically screened, and it can be accurately judged based on the recovery work order and the positive active power total whether the abnormal cause is the meter point status error or non-fitting, without the need for manual screening, thereby improving the efficiency and accuracy of screening of abnormal causes of power data.

[0082] Embodiment 4

[0083] Figure 4 This is a flow chart of a method for screening causes of power data anomalies provided in Example 4 of the present application. The technical solution of this embodiment is further refined on the basis of the above technical solution.

[0084] Furthermore, if the target screening script is negative power screening, the "automatic screening of abnormal causes for the data to be screened in the screening table according to the target screening script to determine the abnormal causes" will be refined to: "determine whether there is a reverse active total in the screening table; if so, determine that the abnormal cause is the existence of a reverse active total" to automatically realize the screening of abnormal causes.

[0085] See also Figure 4 A method for screening causes of abnormal power data is shown, comprising:

[0086] S410, obtaining a screening task for power data, and obtaining the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include anomaly types.

[0087] S420, uploading the data to be screened to the table to be screened in the screening database, and determining the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type.

[0088] S430, determining whether there is total reverse active power in the table to be screened.

[0089] The negative power screening script is the target screening script for the data to be screened with the anomaly type of negative power. If the target screening script is the negative power screening script, there is negative power at this time. At this time, check whether there is a negative total active power in the table to be screened. According to the user number, metering point number and transaction date in the table to be screened, the "Daily Power Detail Query" table in the mapping table can be queried to determine whether there is a negative total active power.

[0090] S440: If yes, determine that the abnormal cause is the existence of total reverse active power.

[0091] If so, that is, there is a reverse total active power, it can be determined that the abnormal cause is the existence of a reverse total active power. Otherwise, the abnormal data can be ignored at this time, and thus the abnormal data can be eliminated.

[0092] The technical solution of this embodiment is that, if the target screening script is negative power screening, it is determined whether there is a reverse active total in the table to be screened; if so, the abnormal cause is determined to be the existence of a reverse active total, and the abnormal cause leading to the negative power can be automatically screened, and the abnormal cause can be accurately determined based on the reverse active total, without the need for manual screening, thereby improving the efficiency and accuracy of screening abnormal causes of power data.

[0093] Embodiment 5

[0094] Figure 5 The figure shows a schematic diagram of the structure of a device for screening the cause of abnormal power data provided by the fifth embodiment of the present application. This embodiment can be applied to the case of screening the cause of abnormal power data in the power system. The device is configured in the power system. The specific structure of the device for screening the cause of abnormal power data is as follows:

[0095] The module 510 for obtaining data to be screened is used to obtain a screening task for power data, and obtain the data to be screened corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include anomaly types;

[0096] A target screening script determination module 520 is used to upload the data to be screened to the table to be screened in the screening database, and determine the target screening script from the candidate screening scripts based on the structured query language according to the abnormality type;

[0097] The abnormality cause screening module 530 is used to automatically perform abnormality cause screening on the data to be screened in the screening table according to the target screening script to determine the abnormality cause.

[0098] The technical solution of this embodiment is to obtain the screening task of power data, and obtain the data to be screened corresponding to the screening task from the corresponding page through the crawler script; the screening conditions in the screening task include the abnormality type; the data to be screened is automatically obtained, and there is no need to manually query and export the data one by one, thereby improving the efficiency of the entire abnormal cause screening, reducing export errors, and improving the accuracy of data export; the data to be screened is uploaded to the table to be screened in the screening database, and according to the abnormality type, the target screening script is determined from the candidate screening scripts based on the structured query language, and by importing the data to be screened into the screening database, a script file can be written based on the structured query language to realize automatic screening of abnormal causes, and by determining the target screening script according to the abnormality type, there is no need to screen the abnormal causes one by one through the candidate screening scripts, thereby narrowing the scope of abnormal cause screening and improving the efficiency of abnormal cause screening; the data to be screened in the table to be screened is automatically screened for abnormal causes according to the target screening script to determine the abnormal cause, and the target screening script can be used to perform targeted abnormal cause screening on the data to be screened of the corresponding abnormal type, thereby improving the accuracy of the abnormal cause. Therefore, the technical solution of the present application solves the problem that manual screening has a large workload and cannot guarantee the efficiency and accuracy of screening, thereby achieving the effect of improving the efficiency and accuracy of screening of abnormal causes of power data.

[0099] Optionally, the candidate screening scripts include at least: a repeated screening script, a paused screening script and a negative battery screening script.

[0100] Optionally, if the target screening script is a repeated screening script, the abnormal cause screening module 530 includes:

[0101] A data type determination unit, used to determine whether the data type corresponding to the repeated data in the table to be screened is an active representation number;

[0102] A fitting identification query unit, used for querying whether the fitting identification corresponding to the repeated data is table code fitting;

[0103] The table code does not fit determining unit is used to determine that the abnormal cause is that the table code does not fit.

[0104] Optionally, if the target screening script is a pause screening script, the abnormal cause screening module 530 includes:

[0105] A recovery work order query unit is used to query the metering point status and transaction date of each user corresponding to the to-be-screened table, and to query whether each user has a recovery work order within a preset time period before the transaction date;

[0106] A metering point status error determination unit, for determining, if there is a recovery work order and the metering point status is suspended, that the abnormal cause is that there is a recovery work order but the metering point status is wrong;

[0107] The meter code fitting error determination unit is used to determine that the fitting mark of the positive active power total is meter code fitting, and when the judgment result is yes, determine that the abnormal cause is that there is no recovery work order and the meter code fitting is wrong.

[0108] Optionally, if the target screening script is a negative power screening script, the abnormal cause screening module 530 includes:

[0109] The total reverse active power query unit is used to determine whether there is a total reverse active power in the table to be screened;

[0110] The abnormality cause determination unit is used to determine that the abnormality cause is the existence of total reverse active power.

[0111] Optionally, the module 510 for obtaining data to be screened includes:

[0112] A unit for determining a website to be crawled, used to determine the website to be crawled according to the screening conditions in the screening task;

[0113] The data acquisition unit is used to obtain the data to be screened corresponding to the screening task from the page corresponding to the URL to be crawled through a crawler script.

[0114] The device for screening causes of abnormal power data provided in the embodiments of the present application can execute the method for screening causes of abnormal power data provided in any embodiment of the present application, and has the corresponding functional modules and beneficial effects for executing the method for screening causes of abnormal power data.

[0115] Embodiment 6

[0116] Figure 6 A schematic diagram of the structure of an electronic device provided in Example 6 of the present application is shown in FIG. Figure 6 As shown, the electronic device includes a processor 610, a memory 620, an input device 630, and an output device 640; the number of the processor 610 in the electronic device can be one or more. Figure 6 A processor 610 is taken as an example; the processor 610, the memory 620, the input device 630 and the output device 640 in the electronic device can be connected via a bus or other means. Figure 6 The example of connecting through bus is taken in the following.

[0117] The memory 620, as a computer-readable storage medium, can be used to store software programs, computer executable programs and modules, such as program instructions / modules corresponding to the power data abnormality cause screening method in the embodiment of the present application (for example, the data acquisition module 510 to be screened, the target screening script determination module 520 and the abnormal cause screening module 530). The processor 610 executes various functional applications and data processing of the electronic device by running the software programs, instructions and modules stored in the memory 620, that is, realizes the above-mentioned power data abnormality cause screening method.

[0118] The memory 620 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system and at least one application required for a function; the data storage area may store data created according to the use of the terminal, etc. In addition, the memory 620 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device. In some instances, the memory 620 may further include a memory remotely arranged relative to the processor 610, and these remote memories may be connected to the electronic device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0119] The input device 630 may be used to receive input character information and generate key signal input related to user settings and function control of the electronic device. The output device 640 may include a display device such as a display screen.

[0120] According to an embodiment of the present invention, the present invention also provides an electronic device, a readable storage medium and a computer program product.

[0121] Embodiment 7

[0122] Embodiment 7 of the present application also provides a storage medium comprising computer executable instructions, which, when executed by a computer processor, are used to perform a method for screening causes of power data anomalies, the method comprising: obtaining a screening task for power data, and obtaining data to be screened corresponding to the screening task from a corresponding page through a crawler script; the screening conditions in the screening task include an abnormality type; uploading the data to be screened to a table to be screened in a screening database, and determining a target screening script from candidate screening scripts based on a structured query language according to the abnormality type; and automatically screening the data to be screened in the table to be screened according to the target screening script to determine the cause of the abnormality.

[0123] Of course, the storage medium containing computer executable instructions provided in the embodiment of the present application is not limited to the method operations described above, and the computer executable instructions can also execute related operations in the power data abnormality cause screening method provided in any embodiment of the present application.

[0124] Through the above description of the implementation method, the technicians in the relevant field can clearly understand that the present application can be implemented with the help of software and necessary general hardware, and of course it can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present application can be essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as a computer floppy disk, read-only memory (ROM), random access memory (RAM), flash memory (FLASH), hard disk or optical disk, etc., including a number of instructions for an electronic device (which can be a personal computer, server, or network device, etc.) to execute the methods described in each embodiment of the present application.

[0125] It is worth noting that in the embodiment of the above-mentioned power data abnormality cause screening device, the various units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be achieved; in addition, the specific names of the functional units are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application.

[0126] Note that the above are only preferred embodiments of the present application and the technical principles used. Those skilled in the art will understand that the present application is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present application. Therefore, although the present application is described in more detail through the above embodiments, the present application is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present application, and the scope of the present application is determined by the scope of the appended claims.

Claims

1. A method for screening causes of abnormal power data, characterized in that: include: Obtain a screening task for power data, and obtain the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script; The screening conditions in the screening task include abnormality types; Uploading the data to be screened into a table to be screened in a screening database, and determining a target screening script from candidate screening scripts based on a structured query language according to the abnormality type; According to the target screening script, the data to be screened in the screening table are automatically screened for abnormal causes to determine the abnormal causes.

2. The method according to claim 1, characterized in that The candidate screening scripts include at least: a repeated screening script, a pause screening script and a negative power screening script.

3. The method according to claim 2, characterized in that If the target screening script is the repeated screening script, then automatically screening the data to be screened in the screening table for abnormal causes according to the target screening script to determine the abnormal causes includes: Determine whether the data type corresponding to the repeated data in the table to be screened is an active representation number; If so, query whether the fitting mark corresponding to the repeated data is table code fitting; If so, it is determined that the cause of the abnormality is that the table code is not fitted.

4. The method according to claim 2, characterized in that: If the target screening script is the pause screening script, then the process of automatically screening the data to be screened in the screening table for abnormal reasons according to the target screening script to determine the abnormal reasons includes: Query the metering point status and transaction date of each user in the to-be-screened table, and query whether each user has a recovery work order within a preset time period before the transaction date; If there is a recovery work order and the metering point status is suspended, the abnormal cause is determined to be that there is a recovery work order but the metering point status is wrong; Otherwise, the fitting mark of the total positive active power is determined to be table code fitting, and when the judgment result is yes, the abnormal cause is determined to be that there is no recovery work order and the table code fitting is wrong.

5. The method according to claim 2, characterized in that: If the target screening script is the negative power screening script, then the data to be screened in the screening table to be screened are automatically screened for abnormal causes according to the target screening script to determine the abnormal causes, including: Determine whether there is total reverse active power in the table to be screened; If so, it is determined that the cause of the abnormality is the existence of reverse active power.

6. The method according to claim 1, characterized in that The step of obtaining the to-be-screened data corresponding to the screening task from the corresponding page through a crawler script includes: Determine the URL to be crawled according to the screening conditions in the screening task; The data to be screened corresponding to the screening task is obtained from the page corresponding to the URL to be crawled through the crawler script.

7. A device for screening causes of abnormal power data, characterized in that: include: The module for acquiring data to be screened is used to acquire a screening task for power data, and acquire the data to be screened corresponding to the screening task from the corresponding page through a crawler script; the screening conditions in the screening task include anomaly types; A target screening script determination module is used to upload the data to be screened to a table to be screened in a screening database, and determine a target screening script from candidate screening scripts based on a structured query language according to the abnormality type; The abnormal cause screening module is used to automatically screen the abnormal cause of the data to be screened in the screening table according to the target screening script to determine the abnormal cause.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the method for screening causes of abnormal power data as described in any one of claims 1-6 is implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the method for screening causes of abnormal power data as described in any one of claims 1-6 is implemented.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the method for screening causes of abnormal power data according to any one of claims 1 to 6 is implemented.

Images