CN113706103B - Data screening method and system for power users - Google Patents
Data screening method and system for power users Download PDFInfo
- Publication number
- CN113706103B CN113706103B CN202110984886.8A CN202110984886A CN113706103B CN 113706103 B CN113706103 B CN 113706103B CN 202110984886 A CN202110984886 A CN 202110984886A CN 113706103 B CN113706103 B CN 113706103B
- Authority
- CN
- China
- Prior art keywords
- rule
- preset
- power
- screening
- user
- 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.)
- Active
Links
- 238000012216 screening Methods 0.000 title claims abstract description 143
- 238000000034 method Methods 0.000 title claims abstract description 34
- 230000005611 electricity Effects 0.000 claims abstract description 115
- 230000002159 abnormal effect Effects 0.000 claims abstract description 76
- 238000004364 calculation method Methods 0.000 claims description 15
- 230000005856 abnormality Effects 0.000 claims description 11
- 230000007704 transition Effects 0.000 claims description 9
- 230000011218 segmentation Effects 0.000 claims description 6
- 230000003247 decreasing effect Effects 0.000 claims description 5
- 238000005457 optimization Methods 0.000 claims description 4
- 230000001502 supplementing effect Effects 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 8
- 238000004458 analytical method Methods 0.000 description 7
- 238000007726 management method Methods 0.000 description 6
- 238000012795 verification Methods 0.000 description 6
- 230000000737 periodic effect Effects 0.000 description 5
- 230000006399 behavior Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 238000011084 recovery Methods 0.000 description 3
- XEEYBQQBJWHFJM-UHFFFAOYSA-N Iron Chemical compound [Fe] XEEYBQQBJWHFJM-UHFFFAOYSA-N 0.000 description 2
- 238000012300 Sequence Analysis Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000007689 inspection Methods 0.000 description 2
- 238000010801 machine learning Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 238000012731 temporal analysis Methods 0.000 description 2
- 238000000700 time series analysis Methods 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000001680 brushing effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 229910052742 iron Inorganic materials 0.000 description 1
- 230000035772 mutation Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy 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
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Computational Linguistics (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- Primary Health Care (AREA)
- Fuzzy Systems (AREA)
- Public Health (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a data screening method and a data screening system for a power user, comprising the following steps of S1, acquiring historical power consumption data of the power user, and archiving the historical power consumption data through a preset archive rule to obtain corresponding archive data of the power user; step S2, screening the file data of the power user through a preset re-screening rule, and determining whether the file data of the power user 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 re-screening rule has an error or not, and adjusting the preset re-screening rule according to the judging result; and S4, screening the file data of the power user according to the adjusted re-screening rule to obtain a final screening result. The invention analyzes and judges the abnormal electricity consumption in advance so as to improve the meter reading accuracy. And when the abnormal information is provided, quick and accurate information support is provided, and the abnormal processing efficiency is improved.
Description
Technical Field
The invention relates to the technical field of electric quantity and electricity charge accounting, in particular to a data screening method and system for electric power users.
Background
The electricity charge of the user is calculated by the charge electric quantity and the charge file of the user, so that the checking of the electric quantity and the charge file is particularly important. However, based on the existing marketing system, the verification of the electric quantity and the files faces the mutual game of the verification rule duplicate rate and the verification rate, and the electric charge accounting work efficiency is further improved to meet the bottleneck.
In the aspect of electric quantity checking, because the electricity consumption behaviors of different users are very different, if the same mutation threshold value is adopted for abnormal electric quantity screening, the game of invalid trigger quantity and bill errors is frequently faced, and the accuracy of checking rules is sacrificed for avoiding core leakage.
In the aspect of file checking, at the present stage, no effective method is provided for clearing the specifications of various user file settings, and the establishment of checking rules is carried out only by the experience of staff, so that the correct setting of common user files can be ensured, but when new error files appear, no effective screening method is provided, and the error files caused by service change cannot be found and processed in time.
An intelligent electric charge accounting platform is urgently needed, a targeted solution is provided for the problem of low precision rate of the electric charge checking work by using methods such as time sequence analysis, artificial intelligence and the like, the recall rate and the precision rate are improved, and the efficiency of the electric charge accounting work is improved to a higher level.
Disclosure of Invention
The invention aims to provide a data screening method and system for electric power users, which solve the technical problems of low recall ratio and low precision ratio faced by the electric charge checking work of the existing method.
In one aspect, a method for screening data of a power consumer is provided, including the steps of:
Step S1, acquiring historical electricity utilization data of a power user, and archiving the historical electricity utilization data through a preset archive rule to obtain corresponding archive data of the power user;
Step S2, screening the file data of the power user through a preset re-screening rule, and determining whether the file data of the power user 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 an error 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 S4, screening the file data of the power user according to the adjusted re-screening rule to obtain a final screening result.
Preferably, in step S1, the preset archive rule includes:
the file rule in the aspect of metering is used for identifying historical electricity utilization data of the power consumer, and data which accords with a preset metering information standard are stored as metering information files;
the electricity charge file management system comprises a file rule in the aspect of electricity charge, a file management module and a management module, wherein the file rule is used for identifying historical electricity consumption data of an electricity user and storing data which accords with a preset electricity charge information standard as an electricity charge information file;
the file rule in the aspect of electric quantity is used for identifying historical electricity utilization data of electric power users, and the data which accords with the preset electric quantity information standard are stored as electric quantity information files;
And the file rule in the aspect of the extended attribute is used for identifying historical electricity utilization data of the power consumer, and storing 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 user belongs to a time-sharing power price user and does not conduct time-sharing charging, and if the power user belongs to the time-sharing power price user and does not conduct time-sharing charging, the power user is judged to be abnormal;
the average daily electric quantity rule is used for checking whether the average daily electric quantity/single-phase average daily electric quantity of the three-phase public transformer of the power consumer is larger than a preset electric quantity upper limit, and if so, judging that the power consumer is abnormal;
the average daily power fluctuation rule is used for checking whether the average daily power fluctuation rate of the power user is larger than a preset fluctuation normal range or not under the expression change condition, and judging that the power user is abnormal if the average daily power fluctuation rate is larger than the preset fluctuation normal range;
the basic electricity charge calculation rule is used for checking whether the positive deviation of the meter reading degree in the previous period and the current period of the reading of the maximum demand of the electric power user exceeds a preset normal amplitude when the electricity charge calculation mode of the electric power user belongs to the basic electricity charge calculation according to the actual maximum demand and the maximum demand, and judging that the electric power user is abnormal if the positive deviation exceeds the preset normal amplitude;
the basic electric charge compensation rule is used for checking whether the electric power user belongs to a compensation amount user and does not charge electric charge, and if the electric power user belongs to the compensation amount user and does not charge electric charge, the electric power user is judged to be abnormal;
the daily capacity basic electricity charge rule is used for checking whether the power consumer has the condition that the transformer segmentation or period is inconsistent in the prior charging or the current charging, and if so, judging that the power consumer is abnormal;
A quantitative user rule for checking whether the power user belongs to a quantitative user, comparing whether the charging period of the power user is charged or not when the power user belongs to the quantitative user, and judging that the power user is abnormal if the charging period is charged;
the electricity quantity increasing and decreasing rule is used for checking whether the electricity quantity of the electricity consumer has electricity quantity returning and supplementing flow to participate in the charging, and if so, judging that the electricity consumer is abnormal;
the daily average electric quantity rule of the transition user is used for checking whether the power user has the transition user or not, when the power user belongs to the transition user, whether the transformer capacity of the power user is larger than a preset electric quantity upper limit or not, and if the transformer capacity of the power user is larger than the preset electric quantity upper limit, the power user is judged to be abnormal;
the total electric quantity rule is used for checking whether the total electric quantity of the power consumer is less than the sum of the sub-meter electric quantities, and if the total electric quantity is less than the sum of the sub-meter electric quantities, determining that the power consumer is abnormal;
the time-sharing rule is used for checking whether the power consumer has the non-time-sharing electricity price and does not allow time-sharing charging, and if the power consumer has the non-time-sharing electricity price and does not allow time-sharing charging, the power consumer is judged to be abnormal;
And the demand value rule is used for checking whether the power consumer has a great number of current consumers with high-demand sectional relations, merging and calculating at a metering point in basic electricity charge calculation, and judging that the power consumer is abnormal if the power consumer exists.
Preferably, in step S2, the determining whether the profile data of the power consumer has an abnormality includes:
Comparing the file data of the power user with the preset rescreening rules, judging whether any condition in the preset rescreening rules is met according to a comparison result, judging that the power user is abnormal if the file data of the power user meets any condition, and judging that the power user is normal if the file data of the power user does not meet all conditions.
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 a preset re-screening rule has no error;
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 user is judged to be abnormal, abnormal condition information is determined 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 rescreening rule includes:
Comparing the file data of the power user with each preset condition in the adjusted re-screening rule to obtain a comparison result, and outputting the comparison result as a final screening result;
When the comparison result shows that the profile data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
On the other hand, a data screening system of the electric power user is also provided, and the data screening method for the electric power user comprises the following steps:
The system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring historical electricity utilization data of an electric power user, and archiving the historical electricity utilization data through a preset archive rule to obtain corresponding archive data of the electric power user;
The first screening module is used for screening the file data of the power user through a preset re-screening rule, determining whether the file data of the power user 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 rescreening rule has an error or not, and adjusting the preset rescreening rule according to the judging result until the adjusted rescreening rule meets the preset screening standard;
And the second screening module is used for screening the file 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 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.
Preferably, the second screening module is further configured to compare the profile data of the power consumer with each preset condition in the adjusted re-screening rule to obtain a comparison result, and output the comparison result as a final screening result;
When the comparison result shows that the profile data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the archive data of the power consumer does not meet 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 electric power user, under the support of the construction result of the intelligent electric meter and the low-voltage centralized meter reading full coverage, time series analysis is conducted on the electricity consumption condition of the user, the electricity consumption behavior characteristics of the electricity consumption client are extracted, and the electricity consumption abnormality is analyzed and judged in advance by combining with the historical electricity consumption condition, so that the metering and inspection professional is guided to conduct field processing, and the meter reading accuracy is improved. Linking all business information of the user according to time sequence by taking the user as a unit, and providing rapid and accurate information support for personnel to locate problems when the problems are abnormal through the analysis of association relation among the businesses; on-line verification is carried out on the client bill result, and analysis judgment of abnormality or error is provided; by adopting a full-link data monitoring technology, a full-data link from electricity collection to electricity fee recovery is established for each bill of each electricity consumer, clear full-life-cycle view of the electricity fee bill is provided for the meter reading and checking business personnel, and meanwhile, complete information support is provided for handling electric quantity and electricity fee customer complaints.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions of the prior art, the drawings which are required in the description of the embodiments or the prior art will be briefly described, it being obvious that the drawings in the description below are only some embodiments of the invention, and that it is within the scope of the invention to one skilled in the art to obtain other drawings from these drawings without inventive faculty.
Fig. 1 is a schematic flow chart of a data screening method for a power consumer according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of a data screening system for power consumers according to an embodiment of the present invention.
Fig. 3 is a schematic diagram of a preset archive rule in an embodiment of the present invention.
Fig. 4 is a schematic diagram of a preset archive rule in an embodiment of the present invention.
Fig. 5 is a schematic diagram of a preset re-screening rule in an embodiment of the present invention.
Fig. 6 is a schematic diagram of a preset rescreening rule in an embodiment of the invention.
FIG. 7 is a schematic diagram of a first screening result in an embodiment of the present invention.
FIG. 8 is a schematic representation of the final screening results in an embodiment of the present invention.
FIG. 9 is a schematic representation of the final screening results in an embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings, for the purpose of making the objects, technical solutions and advantages of the present invention more apparent.
Fig. 1 is a schematic diagram of 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 electricity utilization data of a power user, and archiving the historical electricity utilization data through a preset archive rule to obtain corresponding archive data of the power user; it can be understood that the file rule is established through the step, and the custom rule is established according to the metering, the electricity charge, the electric quantity and the extended attribute rule category; the file rules are set in a custom mode through preset file rules, and a data basis is provided for the processing of procedures.
In a specific embodiment, the preset archive rules (archive rule types) include: the file rule in the aspect of metering is used for identifying historical electricity utilization data of the power consumer, and data which accords with a preset metering information standard are stored as metering information files; the electricity charge file management system comprises a file rule in the aspect of electricity charge, a file management module and a management module, wherein the file rule is used for identifying historical electricity consumption data of an electricity user and storing data which accords with a preset electricity charge information standard as an electricity charge information file; the file rule in the aspect of electric quantity is used for identifying historical electricity utilization data of electric power users, and the data which accords with the preset electric quantity information standard are stored as electric quantity information files; and the file rule in the aspect of the extended attribute is used for identifying historical electricity utilization data of the power consumer, and storing the data which accords with the preset extended attribute information standard as an extended attribute information file. Specifically, the content, name, etc. of each rule may be set according to actual requirements, as shown in fig. 3 and fig. 4.
Step S2, screening the file data of the power user through a preset re-screening rule, and determining whether the file data of the power user is abnormal or not to obtain a first screening result, as shown in fig. 7; it can be understood that the data is cleaned and screened in a background database (the electricity consumption behavior characteristics of electricity consumption customers are extracted by adopting a time sequence analysis method, the electricity consumption abnormality is analyzed and judged in advance to improve the meter reading accuracy, the association relation analysis among businesses is carried out by adopting a chain type data storage method, the rapid and accurate information support is provided for the problem positioning of personnel when the abnormality occurs, the abnormal processing work efficiency is improved, and an intelligent engine based on rule and knowledge analysis is established by adopting an expert system and a machine learning method to verify the bill result of the customers.
In a specific embodiment, as shown in fig. 5 and fig. 6, a preset rescreening rule may be set according to specific requirements, where the preset rescreening rule includes:
The non-time-sharing charging rule is used for checking whether the power user belongs to a time-sharing power price user and does not conduct time-sharing charging, and if the power user belongs to the time-sharing power price user and does not conduct time-sharing charging, the power user is judged to be abnormal; specifically, the rule is a strong rule of electricity price files, 202008 triggers a spring number 2581, because screening logic aiming at a '5G operator client' is not caused by online (net protection reason), and the expansion attribute '5G operator client' (the expansion attribute inquiry of a customizable inquiry user) is compared in the checking process, if the user has marked the '5G operator client', the user directly turns to concentrated confirmation (not distributed); the remaining triggering rule users may refer to whether there are 5G operator customers (mobile, telecom, UNICOM, iron tower) settlers. Distribution is performed that cannot be confirmed as a 5G operator customer.
The average daily electric quantity rule is used for checking whether the average daily electric quantity/single-phase average daily electric quantity of the three-phase public transformer of the power consumer is larger than a preset electric quantity upper limit, and if so, judging that the power consumer is abnormal; specifically, the rule belongs to an electric quantity threshold rule, and is distributed for triggering rule users (electricity consumption overrun values) such as that the daily average electric quantity of three-phase public transformer users is larger than an electric quantity upper limit N (N default 675) or the daily average electric quantity of single-phase public transformer users is larger than the electric quantity upper limit N (N default 422), the electricity consumption is close to the electric quantity in the upper period and the same period, direct transfer and centralized confirmation are performed, and other conditions are distributed.
The average daily power fluctuation rule is used for checking whether the average daily power fluctuation rate of the power user is larger than a preset fluctuation normal range or not under the expression change condition, and judging that the power user is abnormal if the average daily power fluctuation rate is larger than the preset fluctuation normal range; specifically, the rule aims at the deviation of the daily average electricity consumption condition under the condition of meter replacement, namely the fluctuation of the daily average electricity quantity before and after meter replacement is larger; because the date of the control change list cannot be effectively and accurately recorded at present, the total power consumption is still compared with the deviation of the upper period and the same period, and if the total power consumption deviates, the total power consumption is distributed.
The basic electricity charge calculation rule is used for checking whether the positive deviation of the meter reading degree in the previous period and the current period of the reading of the maximum demand of the electric power user exceeds a preset normal amplitude when the electricity charge calculation mode of the electric power user belongs to the basic electricity charge calculation according to the actual maximum demand and the maximum demand, and judging that the electric power user is abnormal if the positive deviation exceeds the preset normal amplitude; specifically, the two rules are pointing rules, the basic electric charge marking calculation mode is to calculate the basic electric charge user according to the actual maximum demand and the maximum demand, namely, the basic electric charge of the user is calculated according to the actual maximum demand/the maximum demand of the conversion user. The method is characterized in that the demand degree is focused, the last time of the user meter with the maximum demand reading is read and recorded by the background, and the meter reading degree in the current period is read and recorded, if the positive deviation exceeds the set amplitude (such as 20%), the demand value is larger than 5, the key check is performed, the current time is not available, and the current time is not available.
The basic electric charge compensation rule is used for checking whether the electric power user belongs to a compensation amount user and does not charge electric charge, and if the electric power user belongs to the compensation amount user and does not charge electric charge, the electric power user is judged to be abnormal; specifically, the rule normally pauses for more than 180 days in a calendar year in the electric charge accounting process, and full basic electric charges are required to be paid, and users with generated pay-per-service amounts are actually screened, so that paying-per-service amounts are focused on but no electric charges are paid. The pause record of 'supplement volume maintenance' is normally required to be analyzed, no entry problem is confirmed, but the pause record of the vacuum period of about one month cannot be synchronized to 'supplement volume maintenance', and the later-period sea jockey brushing record logic has problems, and the rule user is triggered to carry out full volume distribution correspondingly in the near two periods even though the part is cleaned up through preliminary checking.
The daily capacity basic electricity charge rule is used for checking whether the power consumer has the condition that the transformer segmentation or period is inconsistent in the prior charging or the current charging, and if so, judging that the power consumer is abnormal; in particular, the rule is a strong rule trigger, the comprehensive triggering rules are related to transformer changing rules such as first charging after archiving (with non-periodic charging link), first charging after archiving (with non-periodic charging link) for increasing (decreasing) capacity, first charging after archiving (with non-periodic charging link) for non-permanent decreasing capacity, first charging after archiving (with non-periodic charging link), first charging after pausing (with non-periodic charging link) and the like, if the synchronization triggers, the distribution may not be made. The rule is triggered independently, whether the previous charging or the current charging has the condition of inconsistent transformer segmentation or period can be checked individually one by one, and the meeting condition can not be distributed; and a large number of metering points with high-demand segmental relation exist, and the basic electric charge allocation mark of the metering points is 'according to the electric quantity proportion' or is empty, so that the metering points per month have different allocation charging capacities, and if the total charging capacities are consistent, the metering points can not be distributed, and meanwhile, the subsequent specification files are set.
A quantitative user rule for checking whether the power user belongs to a quantitative user, comparing whether the charging period of the power user is charged or not when the power user belongs to the quantitative user, and judging that the power user is abnormal if the charging period is charged; specifically, the rule is a pointing rule, the quantitative user is screened out, and because of the special charging property of the quantitative user, each charging is charged according to a set quantitative value (irrelevant meter reading period), the current conventional meter reading period is 'once per month', and whether the charging period of the user is charging or not can be compared, if no charging exists, the charging is abnormal.
The electricity quantity increasing and decreasing rule is used for checking whether the electricity quantity of the electricity consumer has electricity quantity returning and supplementing flow to participate in the charging, and if so, judging that the electricity consumer is abnormal; specifically, the rule is a pointing rule, and the electric quantity of the electric quantity returning and supplementing process is screened to participate in the charging, and the situation currently needs to pay attention to the conditions of reducing the electricity cost in stages from 2020-2-1, whether the resident step electricity price user spans second gear, third gear and the like, and if the situation is influenced, the situation needs to be distributed.
The daily average electric quantity rule of the transition user is used for checking whether the power user has the transition user or not, when the power user belongs to the transition user, whether the transformer capacity of the power user is larger than a preset electric quantity upper limit or not, and if the transformer capacity of the power user is larger than the preset electric quantity upper limit, the power user is judged to be abnormal; specifically, the rule is handled similar to the average daily electricity rule, except that the rule is related to the transformer capacity of the user, and the situation that whether the file is abnormal or not causes the rule to be misplaced is additionally paid attention to.
The total electric quantity rule is used for checking whether the total electric quantity of the power consumer is less than the sum of the sub-meter electric quantities, and if the total electric quantity is less than the sum of the sub-meter electric quantities, determining that the power consumer is abnormal; specifically, the rule is for the case that the total metering point is calculated as 0 (there is a possibility of a large error) when the total-split amount is <0 under the total split relation, such as a total table or sub-table fault; the total meter reading period is 1 month, the sub meter reading period is 4 months, etc.; checking the total power distribution condition when checking, and currently, special structures such as total 1 and total 2 exist; divide 1, divide 2", because the case of divide 1+divide 2> total 1 (or total 2) is mis-screened, actually divide 1+divide 2< total 1+total 2 may not be dispensed. In a special case, the total electric quantity is smaller than the sub-meter electric quantity, but the difference is only a few degrees, and the situation still exists in comparison with the charging in the last month, so that the distribution is not performed (the actual total electricity is not used, and the difference of the accuracy of the multiplying power of the total sub-meter transformer is caused).
The time-sharing rule is used for checking whether the power consumer has the non-time-sharing electricity price and does not allow time-sharing charging, and if the power consumer has the non-time-sharing electricity price and does not allow time-sharing charging, the power consumer is judged to be abnormal; specifically, the rule is a strong rule of electricity price files, and the current trigger is wrong and needs to be distributed.
And the demand value rule is used for checking whether the power consumer has a great number of current consumers with high-demand sectional relations, merging and calculating at a metering point in basic electricity charge calculation, and judging that the power consumer is abnormal if the power consumer exists. Specifically, the rule is stronger and needs to be checked with emphasis, but a great number of users with high-demand segmentation relations exist at present, basic electricity charge calculation is combined and calculated on one metering point, and partial false triggering exists; a single view is required in the case of manual verification.
And then specifically, comparing the file data of the power user with the preset rescreening rule, judging whether any condition (any rule) in the preset rescreening rule is met according to a comparison result, judging that the power user is abnormal if the file data of the power user meets any condition, and judging that the power user is normal if the file data of the power user does not meet all conditions.
Step S3, comparing the first screening result with a preset screening standard, judging whether the preset rescreening rule has an error 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 appreciated that the accuracy of the screened data may not reach the ideal result, and for this reason, the preset re-screening rule needs to be continuously and optimally adjusted, so as to finally reach the optimal screening effect and meet the requirements.
In a specific embodiment, when judging whether the preset re-screening rule has an error or not, judging that the preset re-screening rule has no error when the first screening result meets the preset screening standard; 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, abnormal condition information is determined 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. The method has the advantages that rapid and accurate information support is provided for personnel to locate problems during abnormality, and the work efficiency of abnormality processing is improved; an expert system and a machine learning method are adopted, an intelligent engine based on rule and knowledge analysis is established, the client bill result is verified, and meanwhile, the screened data are classified into preset archive rules.
And S4, screening the file data of the power user 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 screening the profile data of the power user, comparing the profile data of the power user with each preset condition in the adjusted re-screening rule to obtain a comparison result, and outputting the comparison result as a final screening result; when the comparison result shows that the profile data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal. And after rule optimization, the two dimensionality query and screening results of the full link of the user (a 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 file abnormality are obtained, so that the positioning is more accurate.
As shown in fig. 2, a schematic diagram of an embodiment of a data screening system for a power consumer according to the present invention is provided. In this embodiment, the system is configured to implement the data screening method of the power consumer, including:
The system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring historical electricity utilization data of an electric power user, and archiving the historical electricity utilization data through a preset archive rule to obtain corresponding archive data of the electric power user;
The first screening module is used for screening the file data of the power user through a preset re-screening rule, determining whether the file data of the power user 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 rescreening rule has an error or not, and adjusting the preset rescreening rule according to the judging result until the adjusted rescreening rule meets the preset screening standard;
And the second screening module is used for screening the file 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 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.
Specifically, the second screening module is further configured to compare the profile data of the power consumer with each preset condition in the adjusted re-screening rule to obtain a comparison result, and output the comparison result as a final screening result;
When the comparison result shows that the profile data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
The implementation process of a data screening system for a power consumer may refer to the specific process of the data screening method for a power consumer, and will not be described herein.
In summary, the embodiment of the invention has the following beneficial effects:
According to the data screening method and system for the electric power user, under the support of the construction result of the intelligent electric meter and the low-voltage centralized meter reading full coverage, time series analysis is conducted on the electricity consumption condition of the user, the electricity consumption behavior characteristics of the electricity consumption client are extracted, and the electricity consumption abnormality is analyzed and judged in advance by combining with the historical electricity consumption condition, so that the metering and inspection professional is guided to conduct field processing, and the meter reading accuracy is improved. Linking all business information of the user according to time sequence by taking the user as a unit, and providing rapid and accurate information support for personnel to locate problems when the problems are abnormal through the analysis of association relation among the businesses; on-line verification is carried out on the client bill result, and analysis judgment of abnormality or error is provided; by adopting a full-link data monitoring technology, a full-data link from electricity collection to electricity fee recovery is established for each bill of each electricity consumer, clear full-life-cycle view of the electricity fee bill is provided for the meter reading and checking business personnel, and meanwhile, complete information support is provided for handling electric quantity and electricity fee customer complaints.
The foregoing disclosure is illustrative of the present invention and is not to be construed as limiting the scope of the invention, which is defined by the appended claims.
Claims (8)
1. A method of screening data for a power consumer, comprising the steps of:
Step S1, acquiring historical electricity utilization data of a power user, and archiving the historical electricity utilization data through a preset archive rule to obtain corresponding archive data of the power user;
wherein, the preset archive rules include:
the file rule in the aspect of metering is used for identifying historical electricity utilization data of the power consumer, and data which accords with a preset metering information standard are stored as metering information files;
the electricity charge file management system comprises a file rule in the aspect of electricity charge, a file management module and a management module, wherein the file rule is used for identifying historical electricity consumption data of an electricity user and storing data which accords with a preset electricity charge information standard as an electricity charge information file;
the file rule in the aspect of electric quantity is used for identifying historical electricity utilization data of electric power users, and the data which accords with the preset electric quantity information standard are stored as electric quantity information files;
The file rule in the aspect of the extended attribute is used for identifying historical electricity utilization data of the power user, and the data which accords with the preset extended attribute information standard is stored as an extended attribute information file;
Step S2, screening the file data of the power user through a preset re-screening rule, and determining whether the file data of the power user is abnormal or not to obtain a first screening result;
wherein, the preset rescreening rule comprises:
the non-time-sharing charging rule is used for checking whether the power user belongs to a time-sharing power price user and does not conduct time-sharing charging, and if the power user belongs to the time-sharing power price user and does not conduct time-sharing charging, the power user is judged to be abnormal;
the average daily electric quantity rule is used for checking whether the average daily electric quantity/single-phase average daily electric quantity of the three-phase public transformer of the power consumer is larger than a preset electric quantity upper limit, and if so, judging that the power consumer is abnormal;
the average daily power fluctuation rule is used for checking whether the average daily power fluctuation rate of the power user is larger than a preset fluctuation normal range or not under the expression change condition, and judging that the power user is abnormal if the average daily power fluctuation rate is larger than the preset fluctuation normal range;
the basic electricity charge calculation rule is used for checking whether the positive deviation of the meter reading degree in the previous period and the current period of the reading of the maximum demand of the electric power user exceeds a preset normal amplitude when the electricity charge calculation mode of the electric power user belongs to the basic electricity charge calculation according to the actual maximum demand and the maximum demand, and judging that the electric power user is abnormal if the positive deviation exceeds the preset normal amplitude;
the basic electric charge compensation rule is used for checking whether the electric power user belongs to a compensation amount user and does not charge electric charge, and if the electric power user belongs to the compensation amount user and does not charge electric charge, the electric power user is judged to be abnormal;
the daily capacity basic electricity charge rule is used for checking whether the power consumer has the condition that the transformer segmentation or period is inconsistent in the prior charging or the current charging, and if so, judging that the power consumer is abnormal;
A quantitative user rule for checking whether the power user belongs to a quantitative user, comparing whether the charging period of the power user is charged or not when the power user belongs to the quantitative user, and judging that the power user is abnormal if the charging period is charged;
the electricity quantity increasing and decreasing rule is used for checking whether the electricity quantity of the electricity consumer has electricity quantity returning and supplementing flow to participate in the charging, and if so, judging that the electricity consumer is abnormal;
the daily average electric quantity rule of the transition user is used for checking whether the power user has the transition user or not, when the power user belongs to the transition user, whether the transformer capacity of the power user is larger than a preset electric quantity upper limit or not, and if the transformer capacity of the power user is larger than the preset electric quantity upper limit, the power user is judged to be abnormal;
the total electric quantity rule is used for checking whether the total electric quantity of the power consumer is less than the sum of the sub-meter electric quantities, and if the total electric quantity is less than the sum of the sub-meter electric quantities, determining that the power consumer is abnormal;
the time-sharing rule is used for checking whether the power consumer has the non-time-sharing electricity price and does not allow time-sharing charging, and if the power consumer has the non-time-sharing electricity price and does not allow time-sharing charging, the power consumer is judged to be abnormal;
the requirement value rule is used for checking whether the power consumer has a great number of current consumers with high-requirement segmentation relations, merging calculation is carried out on a metering point in basic electricity charge calculation, and if so, the power consumer is judged to be abnormal;
Step S3, comparing the first screening result with a preset screening standard, judging whether the preset rescreening rule has an error 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 S4, screening the file data of the power user according to the adjusted re-screening rule to obtain a final screening result.
2. The method according to claim 1, wherein in step S2, the determining whether there is an abnormality in the profile data of the power consumer comprises:
Comparing the file data of the power user with the preset rescreening rules, judging whether any condition in the preset rescreening rules is met according to a comparison result, judging that the power user is abnormal if the file data of the power user meets any condition, and judging that the power user is normal if the file data of the power user does not meet all conditions.
3. The method as claimed in claim 2, wherein 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 a preset re-screening rule has no error;
and when the first screening result does not meet the preset screening standard, judging that the preset re-screening rule has errors.
4. The method of claim 3, wherein said step S3 further comprises:
When the power user is judged to be abnormal, abnormal condition information is determined 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.
5. The method according to claim 4, wherein in step S4, the screening of the profile data of the power consumer according to the adjusted rescreening rule comprises:
Comparing the file data of the power user with each preset condition in the adjusted re-screening rule to obtain a comparison result, and outputting the comparison result as a final screening result;
When the comparison result shows that the profile data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
6. A data screening system for a power consumer to implement the method of any one of claims 1-5, comprising:
The system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring historical electricity utilization data of an electric power user, and archiving the historical electricity utilization data through a preset archive rule to obtain corresponding archive data of the electric power user;
The first screening module is used for screening the file data of the power user through a preset re-screening rule, determining whether the file data of the power user 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 rescreening rule has an error or not, and adjusting the preset rescreening rule according to the judging result until the adjusted rescreening rule meets the preset screening standard;
And the second screening module is used for screening the file data of the power user according to the adjusted re-screening rule to obtain a final screening result.
7. The system of claim 6, 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 one of 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 one of the preset rescreening rules, and determine that the power consumer is normal if the profile data of the power consumer does not meet all the preset rescreening rules.
8. The system of claim 7, wherein the second screening module is further configured to compare the profile data of the power consumer with each preset condition in the adjusted re-screening rule to obtain a comparison result, and output the comparison result as a final screening result; when the comparison result shows that the profile data of the power consumer meets any condition, judging that the power consumer is abnormal; and when the comparison result shows that the archive data of the power consumer does not meet all conditions, judging that the power consumer is normal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110984886.8A CN113706103B (en) | 2021-08-26 | 2021-08-26 | Data screening method and system for power users |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110984886.8A CN113706103B (en) | 2021-08-26 | 2021-08-26 | Data screening method and system for power users |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113706103A CN113706103A (en) | 2021-11-26 |
| CN113706103B true CN113706103B (en) | 2024-10-22 |
Family
ID=78654901
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110984886.8A Active CN113706103B (en) | 2021-08-26 | 2021-08-26 | Data screening method and system for power users |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113706103B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933605A (en) * | 2019-03-08 | 2019-06-25 | 广东电网有限责任公司 | Electricity charge mistake checks method, apparatus and electronic equipment |
| CN110825724A (en) * | 2019-10-11 | 2020-02-21 | 深圳供电局有限公司 | User charging data exception interception system and method in electricity price system |
-
2021
- 2021-08-26 CN CN202110984886.8A patent/CN113706103B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933605A (en) * | 2019-03-08 | 2019-06-25 | 广东电网有限责任公司 | Electricity charge mistake checks method, apparatus and electronic equipment |
| CN110825724A (en) * | 2019-10-11 | 2020-02-21 | 深圳供电局有限公司 | User charging data exception interception system and method in electricity price system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113706103A (en) | 2021-11-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110659273B (en) | Data abnormity monitoring and repairing method of distributed big data acquisition platform | |
| CN110825724B (en) | System and method for intercepting user charging data abnormality in electricity price system | |
| CN109683059B (en) | Method and device for determining line loss abnormity, storage medium and processor | |
| CN110633889A (en) | Regional spot market technical support system | |
| CN107862467A (en) | A kind of electric network synthetic data target monitoring method and system based on big data platform | |
| CN108256723B (en) | Economic benefit evaluation method for accessing coal-to-electricity into power grid and terminal equipment | |
| CN107871214A (en) | Method for establishing comprehensive evaluation index system of multi-energy complementary energy supply system | |
| CN110866035A (en) | Method and system for detecting abnormal electricity quantity and electricity charge | |
| CN116011827B (en) | Power failure monitoring analysis and early warning system and method for key cells | |
| CN104794554A (en) | Electric power marketing inspection monitoring system based on software platform support | |
| CN108647246A (en) | Diagnosis method of special transformer power quantity abnormity diagnosis platform architecture | |
| CN113112136A (en) | Comprehensive evaluation method and system for reliability of power distribution network | |
| CN107705055A (en) | Power network technology innovation project backlog control method based on bill of quantities | |
| CN106845748A (en) | A kind of INTELLIGENT IDENTIFICATION method of low-voltage collecting meter reading system data deviation reason | |
| CN108320081A (en) | A kind of meter reading business datum analysis and processing method and system based on automation | |
| CN111178676A (en) | Power distribution network project investment assessment method and system | |
| CN115330404A (en) | System and method for electric power marketing inspection | |
| CN114548650A (en) | Power grid asset life cycle cost analysis method and system | |
| CN113706103B (en) | Data screening method and system for power users | |
| CN113362191A (en) | Equipment application data processing method and device, computer equipment and storage medium | |
| CN113743894B (en) | Method and system for establishing rechecking rule model for rechecking electric bill | |
| CN117913974A (en) | Daily electric quantity monitoring and analyzing system | |
| CN113627821B (en) | Method and system for identifying abnormal electricity based on electricity behavior characteristics | |
| Kirby et al. | Cost-causation-based tariffs for wind ancillary service impacts | |
| Pratt et al. | DSO+ T: Valuation Methodology and Economic Metrics (DSO+ T Study: Volume 4) |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |