CN113706103A - Data screening method and system for power consumer - Google Patents
Data screening method and system for power consumer Download PDFInfo
- Publication number
- CN113706103A CN113706103A CN202110984886.8A CN202110984886A CN113706103A CN 113706103 A CN113706103 A CN 113706103A CN 202110984886 A CN202110984886 A CN 202110984886A CN 113706103 A CN113706103 A CN 113706103A
- Authority
- CN
- China
- Prior art keywords
- rule
- power
- screening
- preset
- power consumer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention provides a data screening method and a data screening system for power consumers, and the method comprises the following steps of S1, acquiring historical power consumption data of the power consumers, and filing the historical power consumption data through a preset filing rule to obtain corresponding file data of the power consumers; step S2, screening the archive data of the power consumer according to a preset re-screening rule, and determining whether the archive data of the power consumer is abnormal or not to obtain a first screening result; step S3, comparing the first screening result with a preset screening standard, judging whether the preset rescreening rule has errors, and adjusting the preset rescreening rule according to the judgment result; and step S4, screening the archive data of the power consumer according to the adjusted re-screening rule to obtain a final screening result. The invention analyzes and judges the abnormal electricity consumption in advance to improve the meter reading accuracy. And fast and accurate information support is provided during exception, and exception handling efficiency is improved.
Description
Technical Field
The invention relates to the technical field of electric quantity and electric charge accounting, in particular to a data screening method and system for a power consumer.
Background
The user's electricity charge is calculated from the charging electricity amount and the user charging profile, and thus it is particularly important to check the electricity amount and the profile. However, based on the existing marketing system, the checking of the electric quantity and the archives faces the mutual game of the check rule duplication checking rate and the check accuracy rate, and the working efficiency of electric charge accounting is further improved to meet the bottleneck.
In the aspect of electric quantity checking, because the difference of the electric consumption behaviors of different users is large, if the same mutation threshold value is adopted for abnormal electric quantity screening, the games of invalid triggering quantity and bill errors are frequently encountered, and the precision rate of the checking rule is sacrificed for avoiding missing checks.
In the aspect of file checking, at the present stage, there is no effective method for clarifying the specification of various user file settings, and the checking rule is made only by the experience of the staff, so that the user files of common categories can be correctly set, but when a new error file appears, no method is available for effective discrimination, and the error file caused by service change can not be timely found and processed.
An intelligent electricity fee accounting platform is urgently needed, a targeted solution is provided for the problems of low recall ratio and low precision ratio of the electricity fee checking work by using methods such as time sequence analysis, artificial intelligence and the like, the recall ratio and the precision ratio are improved, and the efficiency of the electricity fee accounting work is improved to a higher level.
Disclosure of Invention
The invention aims to provide a data screening method and a data screening system for a power consumer, and solves the technical problems of low recall ratio and low precision ratio in the electricity charge checking work of the conventional method.
In one aspect, a data screening method for a power consumer is provided, which includes the following steps:
step S1, acquiring historical power consumption data of a power consumer, and archiving the historical power consumption data through a preset archive rule to obtain corresponding archive data of the power consumer;
step S2, screening the archive data of the power consumer according to a preset re-screening rule, and determining whether the archive data of the power consumer is abnormal or not to obtain a first screening result;
step S3, comparing the first screening result with a preset screening standard, judging whether the preset rescreening rule has errors according to the comparison result, and adjusting the preset rescreening rule according to the judgment result until the adjusted rescreening rule meets the preset screening standard;
and step S4, screening the archive data of the power consumer according to the adjusted re-screening rule to obtain a final screening result.
Preferably, in step S1, the preset profile rule includes:
the metering file rule is used for identifying historical electricity utilization data of the power consumer and storing the data meeting a preset metering information standard as a metering information file;
the system comprises a record rule in the aspect of electric charge, a data processing module and a data processing module, wherein the record rule is used for identifying historical electricity consumption data of an electric power user and storing the data meeting a preset electric charge information standard as an electric charge information record;
the electric quantity archive rule is used for identifying historical electricity utilization data of an electricity consumer and storing the data meeting a preset electric quantity information standard as an electric quantity information archive;
and the file rule in the aspect of the extended attribute is used for identifying the historical electricity utilization data of the power consumer and saving the data which accords with the preset extended attribute information standard as an extended attribute information file.
Preferably, in step S2, the preset rescreening rule includes:
the non-time-sharing charging rule is used for checking whether the power consumer belongs to a time-sharing power rate user and does not carry out time-sharing charging, and if the power consumer belongs to the time-sharing power rate user and does not carry out time-sharing charging, the power consumer is judged to be abnormal;
the daily average electric quantity rule is used for checking whether the daily average electric quantity/single-phase daily average electric quantity of the three-phase public transformer user of the power user is greater than a preset electric quantity upper limit or not, and if the daily average electric quantity/single-phase daily average electric quantity of the three-phase public transformer user of the power user is greater than the preset electric quantity upper limit, judging that the power user is abnormal;
the daily average power fluctuation rule is used for checking whether the daily average power consumption fluctuation rate of the power consumer is larger than a preset fluctuation normal range or not under the condition of changing the table, and if the daily average power consumption fluctuation rate is larger than the preset fluctuation normal range, judging that the power consumer is abnormal;
a basic electricity fee calculation rule, when the electricity fee calculation mode of the power consumer belongs to the basic electricity fee calculation according to the actual maximum demand and the maximum demand, checking whether the positive deviation of the reading line degree of the reading line of the last reading line and the current period of the reading line of the power consumer exceeds a preset normal amplitude, and if the positive deviation exceeds the preset normal amplitude, judging that the power consumer is abnormal;
the basic electricity fee supplementing rule is used for checking whether the power consumer belongs to a capacity supplementing consumer and does not have the electricity fee for supplementing, and if the power consumer belongs to the capacity supplementing consumer and does not have the electricity fee for supplementing, the power consumer is judged to be abnormal;
the daily average capacity basic electricity charge rule is used for checking whether the power consumer has the condition of the existing charging or the current charging that the transformer sections or the periods are inconsistent, and if so, judging that the power consumer is abnormal;
the quantitative user rule is used for checking whether the power user belongs to a quantitative user, when the power user belongs to the quantitative user, comparing whether the last charging period of the power user has charging, and if the last charging period of the power user has charging, judging that the power user is abnormal;
the electric quantity increasing and decreasing rule is used for checking whether the electric quantity of the electric power user is involved in the charging of the time when the electric quantity of the electric power user is returned, and if the electric quantity of the electric power user is involved in the charging of the time, judging that the electric power user is abnormal;
the daily average electric quantity rule of the special transformer users is used for checking whether the electric power users have the transformer users, when the electric power users belong to the special transformer users, whether the transformer capacity of the electric power users is larger than a preset electric quantity upper limit, and if the transformer capacity of the electric power users is larger than the preset electric quantity upper limit, the electric power users are judged to be abnormal;
the total meter electric quantity rule is used for checking whether the total meter electric quantity of the electric power user is less than the sum of the sub-meter electric quantities, and if the total meter electric quantity is less than the sum of the sub-meter electric quantities, the electric power user is judged to be abnormal;
the time-sharing rule is used for checking whether the electricity consumer belongs to non-time-sharing electricity price and is not allowed to carry out time-sharing charging or not, and if the electricity consumer belongs to non-time-sharing electricity price and is not allowed to carry out time-sharing charging, judging that the electricity consumer is abnormal;
and the demand value rule is used for checking whether the power consumer has a large number of current consumers with high demand segmentation relation, combining and calculating on a metering point in the basic power charge calculation, and if so, judging that the power consumer is abnormal.
Preferably, in step S2, the determining whether there is an abnormality in the profile data of the power consumer includes:
comparing the archive data of the power consumer with the preset rescreening rules, judging whether any condition in the preset rescreening rules is met or not according to a comparison result, if the archive data of the power consumer meets any condition, judging that the power consumer is abnormal, and if the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
Preferably, in step S3, the determining whether the preset rescreening rule has an error according to the comparison result includes:
when the first screening result meets a preset screening standard, judging that no error exists in a preset re-screening rule;
and when the first screening result does not meet the preset screening standard, judging that the preset re-screening rule has errors.
Preferably, the step S3 further includes:
when the power consumer is judged to be abnormal, determining abnormal condition information according to a first screening result;
and classifying the abnormal condition information, and storing the classified abnormal condition information into a corresponding preset archive rule.
Preferably, in step S4, the screening the profile data of the power consumer according to the adjusted re-screening rule includes:
comparing the file data of the power consumer with each preset condition in the adjusted re-screening rule one by one to obtain a comparison result, and outputting the comparison result as a final screening result;
when the comparison result shows that the archive data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the file data of the power consumer does not accord with all conditions, judging that the power consumer is normal.
In another aspect, a data screening system for an electric power consumer is further provided, so as to implement the data screening method for the electric power consumer, including:
the acquisition module is used for acquiring historical power utilization data of a power consumer and archiving the historical power utilization data through a preset archive rule to obtain corresponding archive data of the power consumer;
the first screening module is used for screening the archive data of the power consumer according to a preset re-screening rule, determining whether the archive data of the power consumer is abnormal or not, and obtaining a first screening result;
the optimization module is used for comparing the first screening result with a preset screening standard, judging whether the preset re-screening rule has errors or not, and adjusting the preset re-screening rule according to the judgment result until the adjusted re-screening rule meets the preset screening standard;
and the second screening module is used for screening the archive data of the power user according to the adjusted re-screening rule to obtain a final screening result.
Preferably, the first screening module is further configured to compare the archive data of the power consumer with the preset rescreening rule, determine whether any condition in the preset rescreening rule is met according to a comparison result, determine that the power consumer is abnormal if the archive data of the power consumer meets any condition, and determine that the power consumer is normal if the archive data of the power consumer does not meet all conditions.
Preferably, the second screening module is further configured to compare the archive data of the power consumer with each preset condition in the adjusted re-screening rule one by one to obtain a comparison result, and output the comparison result as a final screening result;
when the comparison result shows that the archive data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the file data of the power consumer does not accord with all conditions, judging that the power consumer is normal.
In summary, the embodiment of the invention has the following beneficial effects:
according to the data screening method and system for the power users, provided by the invention, under the support of the construction result of full coverage of intelligent electricity meter and low-voltage centralized meter reading, the electricity utilization condition of the users is subjected to time series analysis, the electricity utilization behavior characteristics of electricity customers are extracted, the electricity consumption abnormity is analyzed and judged in advance by combining the historical electricity utilization condition, and the measurement inspection professionals are guided to carry out field processing, so that the meter reading accuracy is improved. Linking all service information of a user according to a time sequence by taking the user as a unit, and providing quick and accurate information support for personnel to perform problem positioning in abnormal conditions through analysis of incidence relation among services; the client bill result is verified on line, and abnormal or error analysis and judgment are provided; by adopting a full-link data monitoring technology, a full-data link from electric quantity collection to electric charge recovery is established for each bill of each electricity consumer, a clear full life cycle view of the electric charge bill is provided for reading and checking service personnel, and meanwhile, complete information support is provided for handling electric quantity and electric charge customer complaints.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is within the scope of the present invention for those skilled in the art to obtain other drawings based on the drawings without inventive exercise.
Fig. 1 is a schematic main flow chart of a data screening method for a power consumer in an embodiment of the present invention.
Fig. 2 is a schematic diagram of a data screening system for a power consumer according to an embodiment of the present invention.
FIG. 3 is a diagram illustrating default file rules according to an embodiment of the present invention.
FIG. 4 is a diagram illustrating default file rules according to an embodiment of the present invention.
Fig. 5 is a schematic diagram of a rescreening rule preset in an embodiment of the present invention.
Fig. 6 is a schematic diagram of a rescreening rule preset in an embodiment of the present invention.
FIG. 7 is a graphical representation of a first screening result in an embodiment of the present invention.
FIG. 8 is a schematic illustration of the final screening results in an embodiment of the present invention.
FIG. 9 is a schematic illustration of the final screening results in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings.
Fig. 1 is a schematic diagram illustrating an embodiment of a data screening method for a power consumer according to the present invention. In this embodiment, the method comprises the steps of:
step S1, acquiring historical power consumption data of a power consumer, and archiving the historical power consumption data through a preset archive rule to obtain corresponding archive data of the power consumer; it can be understood that the archive rule is established through the steps, and the self-defined rule is established according to the categories of the metering rule, the electric charge rule, the electric quantity rule and the extended attribute rule; the archive rules are set in a user-defined mode through the preset archive rules, and a data basis is provided for the processing of procedures.
In an embodiment, the preset profile rule (profile rule type) includes: the metering file rule is used for identifying historical electricity utilization data of the power consumer and storing the data meeting a preset metering information standard as a metering information file; the system comprises a record rule in the aspect of electric charge, a data processing module and a data processing module, wherein the record rule is used for identifying historical electricity consumption data of an electric power user and storing the data meeting a preset electric charge information standard as an electric charge information record; the electric quantity archive rule is used for identifying historical electricity utilization data of an electricity consumer and storing the data meeting a preset electric quantity information standard as an electric quantity information archive; and the file rule in the aspect of the extended attribute is used for identifying the historical electricity utilization data of the power consumer and saving the data which accords with the preset extended attribute information standard as an extended attribute information file. Specifically, the content and name of each rule may be set according to actual requirements, as shown in fig. 3 and 4.
Step S2, screening the archive data of the power consumer according to a preset re-screening rule, and determining whether the archive data of the power consumer is abnormal, so as to obtain a first screening result, as shown in fig. 7; it can be understood that data cleaning and screening are carried out in a background database (electricity utilization behavior characteristics of electricity utilization customers are extracted by adopting a time sequence analysis method, abnormal electricity utilization is analyzed and judged in advance to improve meter reading accuracy rate, business association relation analysis is carried out by adopting a chain data storage method, rapid and accurate information support is provided for personnel to carry out problem location when abnormal occurs, abnormal processing work efficiency is improved, an intelligent engine based on rule and knowledge analysis is established by adopting an expert system and a machine learning method, and a customer bill result is verified.
In a specific embodiment, as shown in fig. 5 and fig. 6, a preset rescreening rule may be set according to a specific requirement, where the preset rescreening rule includes:
the non-time-sharing charging rule is used for checking whether the power consumer belongs to a time-sharing power rate user and does not carry out time-sharing charging, and if the power consumer belongs to the time-sharing power rate user and does not carry out time-sharing charging, the power consumer is judged to be abnormal; specifically, the rule is a strong rule of electricity price archives, 202008 triggers a number of 2581, the reason is caused by the fact that the screening logic for the "5G operator client" is not on-line (network protection reason), and the comparison expansion attribute of the "5G operator client" (customizable query for user expansion attribute query) is compared in the verification process, if the user marks the "5G operator client", the centralized confirmation is directly carried out (no distribution is carried out); the remaining trigger rules user can refer to whether there is a 5G operator customer (mobile, telecom, unicom, tower) settlements. And distributing the data which cannot be confirmed as 5G operator customers.
The daily average electric quantity rule is used for checking whether the daily average electric quantity/single-phase daily average electric quantity of the three-phase public transformer user of the power user is greater than a preset electric quantity upper limit or not, and if the daily average electric quantity/single-phase daily average electric quantity of the three-phase public transformer user of the power user is greater than the preset electric quantity upper limit, judging that the power user is abnormal; specifically, the rule belongs to an electric quantity threshold rule, and for a triggering rule user (power utilization over-limit value), for example, the daily average electric quantity of a three-phase public transformer user is greater than an electric quantity upper limit N (N defaults to 675) or the single-phase daily average electric quantity is greater than the electric quantity upper limit N (N defaults to 422), comparing the electric quantities of the previous period and the same period, the power utilization is similar, directly forwarding to centralized confirmation, and distributing under other conditions.
The daily average power fluctuation rule is used for checking whether the daily average power consumption fluctuation rate of the power consumer is larger than a preset fluctuation normal range or not under the condition of changing the table, and if the daily average power consumption fluctuation rate is larger than the preset fluctuation normal range, judging that the power consumer is abnormal; specifically, the rule aims at the daily average electricity consumption condition deviation under the condition of changing the meter, namely the daily average electricity quantity fluctuation before and after changing the meter is large; because the date of the control change table cannot be accurately recorded at present, the total power consumption is still compared with the deviation of the current date and the current date, and if the total power consumption deviates, the total power consumption is distributed.
A basic electricity fee calculation rule, when the electricity fee calculation mode of the power consumer belongs to the basic electricity fee calculation according to the actual maximum demand and the maximum demand, checking whether the positive deviation of the reading line degree of the reading line of the last reading line and the current period of the reading line of the power consumer exceeds a preset normal amplitude, and if the positive deviation exceeds the preset normal amplitude, judging that the power consumer is abnormal; specifically, the two rules are direction rules, and the basic electric charge calculation mode is marked to calculate the basic electric charge user according to the actual maximum demand and the maximum demand, that is, the basic electric charge calculation mode is to calculate the basic electric charge according to the actual maximum demand/the special transformer user according to the maximum demand. Focusing on the demand running degree, and leading out the last time of reading the maximum demand reading user meter and the current period of reading the meter running degree by a background, if the positive deviation exceeds a set range (such as 20%), wherein the conditions of checking whether the demand value is greater than 5, whether the demand exists at the last time, and the like are distributed.
The basic electricity fee supplementing rule is used for checking whether the power consumer belongs to a capacity supplementing consumer and does not have the electricity fee for supplementing, and if the power consumer belongs to the capacity supplementing consumer and does not have the electricity fee for supplementing, the power consumer is judged to be abnormal; specifically, the rule normally pauses for more than 180 days in the calendar year during the electricity fee accounting process, and the full basic electricity fee needs to be paid in a supplementing manner, and the actually screened users with generated supplementing capacity are mainly concerned with the supplementing capacity but not the supplementing electricity fee. Normally, the pause record of 'supplementary receiving capacity maintenance' needs to be analyzed, no input problem is confirmed, but the pause record in the vacuum period of about one month cannot be synchronized to 'supplementary receiving capacity maintenance', and the later-stage Yiyi brushing record logic has problems, although the record is preliminarily checked, part of abnormal records are cleared, and the rule user is correspondingly triggered to still carry out full distribution in the last two periods.
The daily average capacity basic electricity charge rule is used for checking whether the power consumer has the condition of the existing charging or the current charging that the transformer sections or the periods are inconsistent, and if so, judging that the power consumer is abnormal; specifically, the rule belongs to strong rule triggering, and the transformer change rules such as the comprehensive triggering rules of 'first charging after recovery (non-periodic charging link exists) filing', 'first charging after increasing (decreasing) capacity (non-periodic charging link exists) filing', 'first charging after non-permanent decreasing capacity (non-periodic charging link exists) filing', 'first charging after suspending (non-periodic charging link exists) filing', and the like are involved, and if synchronous triggering is carried out, distribution can be omitted. The rule is triggered independently, and the rule can be checked one by one, whether the condition that the transformer is segmented or inconsistent exists in the charging of the previous period or the charging of the current period, and the condition is met without distribution; and a large number of metering points with high demand segmentation relation exist, the basic electricity charge sharing mark of the metering points to be metered is 'according to the electricity quantity proportion' or is empty, so that the sharing charging capacities of the metering points in each month are different, if the total charging capacity is consistent, the metering points can not be distributed, and meanwhile, the subsequent file setting is standardized.
The quantitative user rule is used for checking whether the power user belongs to a quantitative user, when the power user belongs to the quantitative user, comparing whether the last charging period of the power user has charging, and if the last charging period of the power user has charging, judging that the power user is abnormal; specifically, the rule is a directional rule, a quantitative user is screened out, each charging is carried out according to a set quantitative value (irrelevant to the period of meter reading) due to the particularity of the quantitative user charging, the current conventional meter reading period is 'once-a-month meter reading', and whether the user has charging in the last charging period can be compared, if the user has no charging, the charging is abnormal.
The electric quantity increasing and decreasing rule is used for checking whether the electric quantity of the electric power user is involved in the charging of the time when the electric quantity of the electric power user is returned, and if the electric quantity of the electric power user is involved in the charging of the time, judging that the electric power user is abnormal; specifically, the rule is a directional rule, the electric quantity of the electric quantity compensation flow is screened out to participate in the charging, and in the situation, attention needs to be paid to the conditions of an epidemic situation reduction policy (step reduction of electricity consumption cost) from 2020-2-1, whether a resident step electricity price user crosses a second gear, a third gear and the like, and distribution needs to be performed if the situation is influenced.
The daily average electric quantity rule of the special transformer users is used for checking whether the electric power users have the transformer users, when the electric power users belong to the special transformer users, whether the transformer capacity of the electric power users is larger than a preset electric quantity upper limit, and if the transformer capacity of the electric power users is larger than the preset electric quantity upper limit, the electric power users are judged to be abnormal; specifically, the processing of the rule is similar to the daily average power rule, and the difference is that the rule is related to the transformer capacity of a user, and whether the condition that the rule is mistakenly screened due to abnormal files needs to be concerned.
The total meter electric quantity rule is used for checking whether the total meter electric quantity of the electric power user is less than the sum of the sub-meter electric quantities, and if the total meter electric quantity is less than the sum of the sub-meter electric quantities, the electric power user is judged to be abnormal; specifically, the rule is directed to the situation (with a large possibility of error) that when the total-power-split amount is less than 0, the total meter metering point is calculated according to 0 under the total-power-split relationship, such as a total meter fault or a sub meter fault; 1 month in the meter reading period of the master meter, 4 months in the meter reading period of the sub-meters and the like; checking the total power distribution quantity condition when checking, wherein special structures such as total 1 and total 2 exist at present; divide 1, divide 2 ", because divide 1+ divide 2> total 1 (or total 2) the condition is sieved by mistake, in fact if divide 1+ divide 2< total 1+ total 2 can not do the distribution. There is also a special case, the total electric quantity is less than the sub-meter electric quantity, but the difference is only a few degrees, and the case still exists in comparison with the last month charging, which can be regarded as normal and not distributed (the actual total meter does not use electricity, caused by the difference of accuracy of the multiplying factor of the total sub-meter mutual inductor).
The time-sharing rule is used for checking whether the electricity consumer belongs to non-time-sharing electricity price and is not allowed to carry out time-sharing charging or not, and if the electricity consumer belongs to non-time-sharing electricity price and is not allowed to carry out time-sharing charging, judging that the electricity consumer is abnormal; specifically, the rule is a strong power price file rule, and the current trigger is immediately wrong and needs to be distributed.
And the demand value rule is used for checking whether the power consumer has a large number of current consumers with high demand segmentation relation, combining and calculating on a metering point in the basic power charge calculation, and if so, judging that the power consumer is abnormal. Specifically, the rule is strong, key check is needed, but a large number of users with segmentation relation are needed at present, basic electric charge calculation is combined and calculated on one metering point, and partial false triggering exists; a single look-up is required in the case of manual verification.
And then specifically, comparing the archive data of the power consumer with the preset rescreening rules, judging whether any condition (any rule) in the preset rescreening rules is met or not according to a comparison result, if the archive data of the power consumer meets any condition, judging that the power consumer is abnormal, and if the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
Step S3, comparing the first screening result with a preset screening standard, judging whether the preset rescreening rule has errors according to the comparison result, and adjusting the preset rescreening rule according to the judgment result until the adjusted rescreening rule meets the preset screening standard; it can be understood that the screened data may not achieve an ideal result in terms of accuracy, and for this reason, a preset re-screening rule needs to be continuously optimized and adjusted, so as to achieve an optimal screening effect and meet requirements.
In the specific embodiment, when the preset rescreening rule is judged to have an error, and when the first screening result meets the preset screening standard, the preset rescreening rule is judged to have no error; and when the first screening result does not meet the preset screening standard, judging that the preset re-screening rule has errors.
Specifically, when the power consumer is judged to be abnormal, determining abnormal condition information according to a first screening result; and classifying the abnormal condition information, and storing the classified abnormal condition information into a corresponding preset archive rule. When the abnormal condition occurs, quick and accurate information support is provided for personnel to carry out problem positioning, and the working efficiency of abnormal processing is improved; establishing an intelligent engine based on rule and knowledge analysis by adopting an expert system and a machine learning method, verifying the client bill result), and classifying the screened data into a preset archive rule.
Step S4, screening the archive data of the power consumer according to the adjusted re-screening rule to obtain a final screening result, as shown in fig. 8 and 9.
In a specific embodiment, when the archive data of the power consumer is screened, the archive data of the power consumer is compared with each preset condition in the adjusted re-screening rule one by one to obtain a comparison result, and the comparison result is output as a final screening result; when the comparison result shows that the archive data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the file data of the power consumer does not accord with all conditions, judging that the power consumer is normal. After the rule is optimized, the screening result is inquired from two dimensions of the full link of the user (the full data link from electric quantity collection to electric charge recovery is established for each bill of each electricity consumer by adopting a full link data monitoring technology) and the abnormal file, so that the positioning is more accurate.
Fig. 2 is a schematic diagram of an embodiment of a data screening system for a power consumer according to the present invention. In this embodiment, the system is configured to implement the data screening method for the power consumer, and includes:
the acquisition module is used for acquiring historical power utilization data of a power consumer and archiving the historical power utilization data through a preset archive rule to obtain corresponding archive data of the power consumer;
the first screening module is used for screening the archive data of the power consumer according to a preset re-screening rule, determining whether the archive data of the power consumer is abnormal or not, and obtaining a first screening result;
the optimization module is used for comparing the first screening result with a preset screening standard, judging whether the preset re-screening rule has errors or not, and adjusting the preset re-screening rule according to the judgment result until the adjusted re-screening rule meets the preset screening standard;
and the second screening module is used for screening the archive data of the power user according to the adjusted re-screening rule to obtain a final screening result.
In a specific embodiment, the first screening module is further configured to compare the archive data of the power consumer with the preset rescreening rule, determine whether any condition in the preset rescreening rule is met according to a comparison result, determine that the power consumer is abnormal if the archive data of the power consumer meets any condition, and determine that the power consumer is normal if the archive data of the power consumer does not meet all conditions.
Specifically, the second screening module is further configured to compare the archive data of the power consumer with each preset condition in the adjusted re-screening rule one by one to obtain a comparison result, and output the comparison result as a final screening result;
when the comparison result shows that the archive data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the file data of the power consumer does not accord with all conditions, judging that the power consumer is normal.
For the implementation process of the data screening system for the power consumer, reference may be made to the above specific process of the data screening method for the power consumer, and details are not repeated here.
In summary, the embodiment of the invention has the following beneficial effects:
according to the data screening method and system for the power users, provided by the invention, under the support of the construction result of full coverage of intelligent electricity meter and low-voltage centralized meter reading, the electricity utilization condition of the users is subjected to time series analysis, the electricity utilization behavior characteristics of electricity customers are extracted, the electricity consumption abnormity is analyzed and judged in advance by combining the historical electricity utilization condition, and the measurement inspection professionals are guided to carry out field processing, so that the meter reading accuracy is improved. Linking all service information of a user according to a time sequence by taking the user as a unit, and providing quick and accurate information support for personnel to perform problem positioning in abnormal conditions through analysis of incidence relation among services; the client bill result is verified on line, and abnormal or error analysis and judgment are provided; by adopting a full-link data monitoring technology, a full-data link from electric quantity collection to electric charge recovery is established for each bill of each electricity consumer, a clear full life cycle view of the electric charge bill is provided for reading and checking service personnel, and meanwhile, complete information support is provided for handling electric quantity and electric charge customer complaints.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.
Claims (10)
1. A data screening method for a power consumer is characterized by comprising the following steps:
step S1, acquiring historical power consumption data of a power consumer, and archiving the historical power consumption data through a preset archive rule to obtain corresponding archive data of the power consumer;
step S2, screening the archive data of the power consumer according to a preset re-screening rule, and determining whether the archive data of the power consumer is abnormal or not to obtain a first screening result;
step S3, comparing the first screening result with a preset screening standard, judging whether the preset rescreening rule has errors according to the comparison result, and adjusting the preset rescreening rule according to the judgment result until the adjusted rescreening rule meets the preset screening standard;
and step S4, screening the archive data of the power consumer according to the adjusted re-screening rule to obtain a final screening result.
2. The method as claimed in claim 1, wherein in step S1, the preset profile rule comprises:
the metering file rule is used for identifying historical electricity utilization data of the power consumer and storing the data meeting a preset metering information standard as a metering information file;
the system comprises a record rule in the aspect of electric charge, a data processing module and a data processing module, wherein the record rule is used for identifying historical electricity consumption data of an electric power user and storing the data meeting a preset electric charge information standard as an electric charge information record;
the electric quantity archive rule is used for identifying historical electricity utilization data of an electricity consumer and storing the data meeting a preset electric quantity information standard as an electric quantity information archive;
and the file rule in the aspect of the extended attribute is used for identifying the historical electricity utilization data of the power consumer and saving the data which accords with the preset extended attribute information standard as an extended attribute information file.
3. The method of claim 2, wherein in step S2, the preset rescreening rules include:
the non-time-sharing charging rule is used for checking whether the power consumer belongs to a time-sharing power rate user and does not carry out time-sharing charging, and if the power consumer belongs to the time-sharing power rate user and does not carry out time-sharing charging, the power consumer is judged to be abnormal;
the daily average electric quantity rule is used for checking whether the daily average electric quantity/single-phase daily average electric quantity of the three-phase public transformer user of the power user is greater than a preset electric quantity upper limit or not, and if the daily average electric quantity/single-phase daily average electric quantity of the three-phase public transformer user of the power user is greater than the preset electric quantity upper limit, judging that the power user is abnormal;
the daily average power fluctuation rule is used for checking whether the daily average power consumption fluctuation rate of the power consumer is larger than a preset fluctuation normal range or not under the condition of changing the table, and if the daily average power consumption fluctuation rate is larger than the preset fluctuation normal range, judging that the power consumer is abnormal;
a basic electricity fee calculation rule, when the electricity fee calculation mode of the power consumer belongs to the basic electricity fee calculation according to the actual maximum demand and the maximum demand, checking whether the positive deviation of the reading line degree of the reading line of the last reading line and the current period of the reading line of the power consumer exceeds a preset normal amplitude, and if the positive deviation exceeds the preset normal amplitude, judging that the power consumer is abnormal;
the basic electricity fee supplementing rule is used for checking whether the power consumer belongs to a capacity supplementing consumer and does not have the electricity fee for supplementing, and if the power consumer belongs to the capacity supplementing consumer and does not have the electricity fee for supplementing, the power consumer is judged to be abnormal;
the daily average capacity basic electricity charge rule is used for checking whether the power consumer has the condition of the existing charging or the current charging that the transformer sections or the periods are inconsistent, and if so, judging that the power consumer is abnormal;
the quantitative user rule is used for checking whether the power user belongs to a quantitative user, when the power user belongs to the quantitative user, comparing whether the last charging period of the power user has charging, and if the last charging period of the power user has charging, judging that the power user is abnormal;
the electric quantity increasing and decreasing rule is used for checking whether the electric quantity of the electric power user is involved in the charging of the time when the electric quantity of the electric power user is returned, and if the electric quantity of the electric power user is involved in the charging of the time, judging that the electric power user is abnormal;
the daily average electric quantity rule of the special transformer users is used for checking whether the electric power users have the transformer users, when the electric power users belong to the special transformer users, whether the transformer capacity of the electric power users is larger than a preset electric quantity upper limit, and if the transformer capacity of the electric power users is larger than the preset electric quantity upper limit, the electric power users are judged to be abnormal;
the total meter electric quantity rule is used for checking whether the total meter electric quantity of the electric power user is less than the sum of the sub-meter electric quantities, and if the total meter electric quantity is less than the sum of the sub-meter electric quantities, the electric power user is judged to be abnormal;
the time-sharing rule is used for checking whether the electricity consumer belongs to non-time-sharing electricity price and is not allowed to carry out time-sharing charging or not, and if the electricity consumer belongs to non-time-sharing electricity price and is not allowed to carry out time-sharing charging, judging that the electricity consumer is abnormal;
and the demand value rule is used for checking whether the power consumer has a large number of current consumers with high demand segmentation relation, combining and calculating on a metering point in the basic power charge calculation, and if so, judging that the power consumer is abnormal.
4. The method as claimed in claim 3, wherein in step S2, the determining whether there is an abnormality in the profile data of the power consumer comprises:
comparing the archive data of the power consumer with the preset rescreening rules, judging whether any condition in the preset rescreening rules is met or not according to a comparison result, if the archive data of the power consumer meets any condition, judging that the power consumer is abnormal, and if the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
5. The method of claim 4, wherein the determining whether the preset rescreening rule has an error according to the comparison result in step S3 comprises:
when the first screening result meets a preset screening standard, judging that no error exists in a preset re-screening rule;
and when the first screening result does not meet the preset screening standard, judging that the preset re-screening rule has errors.
6. The method of claim 5, wherein the step S3 further comprises:
when the power consumer is judged to be abnormal, determining abnormal condition information according to a first screening result;
and classifying the abnormal condition information, and storing the classified abnormal condition information into a corresponding preset archive rule.
7. The method as claimed in claim 6, wherein in step S4, the screening the archival data of the power consumer according to the adjusted re-screening rule includes:
comparing the file data of the power consumer with each preset condition in the adjusted re-screening rule one by one to obtain a comparison result, and outputting the comparison result as a final screening result;
when the comparison result shows that the archive data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the file data of the power consumer does not accord with all conditions, judging that the power consumer is normal.
8. A power consumer data screening system for implementing the method of any one of claims 1-7, comprising:
the acquisition module is used for acquiring historical power utilization data of a power consumer and archiving the historical power utilization data through a preset archive rule to obtain corresponding archive data of the power consumer;
the first screening module is used for screening the archive data of the power consumer according to a preset re-screening rule, determining whether the archive data of the power consumer is abnormal or not, and obtaining a first screening result;
the optimization module is used for comparing the first screening result with a preset screening standard, judging whether the preset re-screening rule has errors or not, and adjusting the preset re-screening rule according to the judgment result until the adjusted re-screening rule meets the preset screening standard;
and the second screening module is used for screening the archive data of the power user according to the adjusted re-screening rule to obtain a final screening result.
9. The system of claim 8, wherein the first screening module is further configured to compare the profile data of the power consumer with the preset rescreening rules, determine whether any condition in the preset rescreening rules is met according to a comparison result, determine that the power consumer is abnormal if the profile data of the power consumer meets any condition, and determine that the power consumer is normal if the profile data of the power consumer does not meet all conditions.
10. The system of claim 9, wherein the second screening module is further configured to compare the archive data of the power consumer with each preset condition in the adjusted re-screening rule one by one to obtain a comparison result, and output the comparison result as a final screening result;
when the comparison result shows that the archive data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the file data of the power consumer does not accord with all conditions, judging that the power consumer is normal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110984886.8A CN113706103A (en) | 2021-08-26 | 2021-08-26 | Data screening method and system for power consumer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110984886.8A CN113706103A (en) | 2021-08-26 | 2021-08-26 | Data screening method and system for power consumer |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113706103A true CN113706103A (en) | 2021-11-26 |
Family
ID=78654901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110984886.8A Pending CN113706103A (en) | 2021-08-26 | 2021-08-26 | Data screening method and system for power consumer |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113706103A (en) |
-
2021
- 2021-08-26 CN CN202110984886.8A patent/CN113706103A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110659273B (en) | Data abnormity monitoring and repairing method of distributed big data acquisition platform | |
| CN109683059B (en) | Method and device for determining line loss abnormity, storage medium and processor | |
| CN113267692B (en) | Low-voltage transformer area line loss intelligent diagnosis and analysis method and system | |
| CN115018139A (en) | Current transformer error state online identification method and system based on interphase characteristics | |
| CN109298379A (en) | A kind of recognition methods of the intelligent electric meter site error exception based on data monitoring | |
| CN113406438B (en) | Intelligent fault diagnosis method suitable for low-voltage transformer area and operation and maintenance system thereof | |
| CN111724060A (en) | Integrated analysis monitoring system and analysis method for transformer area line loss | |
| CN114328625A (en) | Electric charge data rescreening method and system | |
| CN112685885A (en) | Transformer area line loss analysis method for comprehensive big data analysis | |
| CN108362958A (en) | A kind of acquisition fault point diagnosis and method for repairing and mending automatically | |
| CN111027026A (en) | Meter reading data abnormity intelligent diagnosis system | |
| CN111612019A (en) | Method for identifying and analyzing fault abnormality of intelligent electric meter based on big data model | |
| CN110675018B (en) | Line loss anomaly analysis and closed-loop management method based on expert rules | |
| CN112560214A (en) | Transformer substation bus balance fault diagnosis method, system, equipment and storage medium | |
| CN115293257A (en) | Detection method and system for abnormal electricity utilization user | |
| CN108320081A (en) | A kind of meter reading business datum analysis and processing method and system based on automation | |
| CN114548650A (en) | Power grid asset life cycle cost analysis method and system | |
| CN113687293A (en) | Line loss abnormity intelligent analysis method based on big data | |
| CN110968703B (en) | Method and system for constructing abnormal metering point knowledge base based on LSTM end-to-end extraction algorithm | |
| CN113706103A (en) | Data screening method and system for power consumer | |
| CN115267422A (en) | Sensing, diagnosing and positioning method for line faults of complex power distribution network | |
| CN112986884B (en) | User metering multiplying power file checking method and system | |
| CN113743894A (en) | Method and system for establishing rechecking rule model for rechecking electric bill | |
| CN115330404A (en) | System and method for electric power marketing inspection | |
| CN114168662A (en) | Power distribution network problem combing and analyzing method and system based on multiple data sources |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |