CN108363789A - A kind of industry and commerce user power utilization table code data lack method for repairing and mending and device in short term - Google Patents
A kind of industry and commerce user power utilization table code data lack method for repairing and mending and device in short term Download PDFInfo
- Publication number
- CN108363789A CN108363789A CN201810146112.6A CN201810146112A CN108363789A CN 108363789 A CN108363789 A CN 108363789A CN 201810146112 A CN201810146112 A CN 201810146112A CN 108363789 A CN108363789 A CN 108363789A
- Authority
- CN
- China
- Prior art keywords
- period
- complement
- table code
- candidate reference
- code value
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 230000000295 complement effect Effects 0.000 claims abstract description 217
- 230000004048 modification Effects 0.000 claims abstract description 16
- 238000012986 modification Methods 0.000 claims abstract description 16
- 230000008439 repair process Effects 0.000 claims description 17
- 238000013480 data collection Methods 0.000 claims description 8
- 238000012163 sequencing technique Methods 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 description 6
- 239000000919 ceramic Substances 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 5
- 230000005611 electricity Effects 0.000 description 4
- 238000003860 storage Methods 0.000 description 4
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 230000003466 anti-cipated effect Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 241001269238 Data Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000009825 accumulation Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000003066 decision tree Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000010248 power generation Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Classifications
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Primary Health Care (AREA)
- Marketing (AREA)
- Software Systems (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
An embodiment of the present invention provides a kind of industry and commerce user power utilization table code data to lack method for repairing and mending and device in short term, wherein this method includes：Obtain user's meter waits for the complement period, and each candidate reference period corresponding with the complement period is waited for is determined according to preset time interval and the preset quantity of candidate reference period；It calculates separately and waits for the distance between complement period and each candidate reference period, determine that the candidate reference period corresponding with minimum range is to choose with reference to the period；Judging to choose with reference to the period, with after being not more than preset distance at a distance between the complement period, complement period progress data modification to be treated according to the table code data with reference to the period are chosen；Wherein, preset time interval is the time interval between two periods of arbitrary neighborhood in comprising all periods for waiting for complement period and candidate reference period.
Description
Technical field
The present invention relates to electric network data fields of measurement more particularly to a kind of industry and commerce user power utilization table code data to lack in short term
Method for repairing and mending and device.
Background technology
Along with the arrival in Information technology epoch, big data has been more and more widely used in every field.And with
China's intelligent grid construction is in full swing, and electric power big data should be needed and be given birth to, and as indispensable during power grid intelligence
A part.
The final goal of intelligent grid construction is to become the covering entire production process of electric system, including power generation, transmission of electricity, change
The panorama real-time system of multiple links such as electricity, distribution, electricity consumption and scheduling.And it is power grid to support the basis of intelligent grid reliability service
Panorama real-time data acquisition, transimission and storage, and the magnanimity electric power data of accumulation are quickly analyzed.But acquired in data, it passes
During defeated and storage, inevitably will appear shortage of data, shortage of data causes strong influence to data analysis,
The practical value that missing data is related to analysis result is effectively treated.Therefore the analysis to electric power data is completed, how to be carried out
Data modification is a significant and stubborn problem.
Data analysis precision is not only interfered in the presence of missing data, also influences effectively opening for statistical analysis personnel's follow-up work
Exhibition.For industry and commerce user, when existing, when carrying out data modification with the short-term missing of ammeter code data, common method has coarse
Set method, decision tree and Bayesian network etc..
However, the above method when carrying out data modification, can not utilize the part throttle characteristics of industry and commerce user, lead to it
It is not high to the repairing quality of industry and commerce user's table code data.
Invention content
An embodiment of the present invention provides a kind of industry and commerce user power utilization table code data to lack method for repairing and mending and device in short term, fills
The part throttle characteristics that industry and commerce user is utilized is divided to also achieve higher repair while providing fabulous data filling rate
Mend the quality of data.
An embodiment of the present invention provides a kind of industry and commerce user power utilization table code data to lack method for repairing and mending in short term, including：
Obtain user's meter waits for the complement period, is determined according to preset time interval and the preset quantity of candidate reference period
Corresponding each candidate reference period complement period is waited for described；
It is waited for the distance between complement period and each candidate reference period described in calculating separately, determining and minimum range
The corresponding candidate reference period is to choose with reference to the period；
It is chosen described in judgement with reference to the period with described after being not more than preset distance at a distance between the complement period, according to
It is described that the table code data with reference to the period is chosen to wait for that the complement period carries out data modification to described；
Wherein, the preset time interval for comprising the institute for waiting for complement period and the candidate reference period sometimes
Duan Zhong, the time interval between two periods of arbitrary neighborhood.
Preferably, a kind of industry and commerce user power utilization table code data provided by the invention lack method for repairing and mending and further include in short term：
Described in determination after the quantity of complement period be at least two after, by it is all it is described when the complement period when long-press from
It is small to being ranked up greatly, if there are waiting for that the duration of complement period is consistent described in several, then by several consistent institutes of duration
It states to carve at the beginning of waiting for the complement period by each period and be ranked up from front to back.
Preferably, by it is described wait for the complement period centered on point, positioned at it is described wait for the complement period before the candidate reference
The quantity of period waits for that the quantity of candidate reference period after the complement period is equal with positioned at described.
Preferably, described calculate separately described waits for the distance between complement period and each candidate reference period specifically
For：
According to the table code value for waiting for start time complement period, the table code value for waiting for finish time complement period, each
The table code value of a start time candidate reference period and the table code value of each finish time candidate reference period pass through
Preset first formula waits for the distance between complement period and each candidate reference period described in calculating separately；
Wherein, preset first formula is：
Dist(t0,ti)=| (Vt0_e-Vt0_s)-(Vti_e-Vti_s)|/|Vt0_e-Vt0_s| * 100%
In formula, t0To wait for complement period, tiFor i-th of candidate reference period, Vt0_sTo wait for the table of start time complement period
Code value, Vt0_eTo wait for the table code value of finish time complement period, Vti_sFor the table code value of i-th of start time candidate reference period,
Vti_eFor the table code value of i-th of finish time candidate reference period.
Preferably, described chosen described in judgement is waited at a distance between the complement period with described no more than preset with reference to the period
After distance, the table code data with reference to the period are chosen to wait for that the complement period carries out data modification and specifically includes to described according to described：
It is chosen described in judgement with reference to the period with described after being not more than preset distance at a distance between the complement period, is determined
The each scarce several moment for waiting for the complement period, and determination is corresponding with each scarce several moment in described choose with reference to the period
The complement moment；
According to the table code value for waiting for start time complement period, the table code value for waiting for finish time complement period, institute
It states and chooses the table code value with reference to start time period, described choose the table code value with reference to finish time period and described choose reference
The table code value at period at each complement moment waits for complement period at each scarce several moment by preset second formula to described
Carry out corresponding data repairing；
Wherein, preset second formula is：
Vt0_s+j×m=Vt0_s+(Vti_s+j×m-Vti_s)×(Vt0_e-Vt0_s)÷(Vti_e-Vti_s)
In formula, t0To wait for complement period, tiThe period is referred to choose, m is data collection interval, Vt0_s+j×mTo wait mending
Number period t0J-th of table code value for lacking the number moment, Vti_s+j×mPeriod t is referred to chooseiThe table code value at j-th of complement moment.
Preferably, the embodiment of the present invention additionally provides a kind of industry and commerce user power utilization table code data and lacks repairing dress in short term
It sets, including：
Acquiring unit waits for the complement period, according to preset time interval and candidate reference period for obtain user's meter
Preset quantity determine and wait for corresponding each candidate reference period complement period with described；
Computing unit, for calculate separately it is described wait for the distance between complement period and each candidate reference period,
Determine that the candidate reference period corresponding with minimum range is to choose with reference to the period；
Unit is repaired, is waited at a distance between the complement period no more than pre- with described with reference to the period for being chosen described in judgement
After setting distance, the table code data with reference to the period are chosen to wait for that the complement period carries out data modification to described according to described；
Wherein, the preset time interval for comprising the institute for waiting for complement period and the candidate reference period sometimes
Duan Zhong, the time interval between two periods of arbitrary neighborhood.
Preferably, a kind of industry and commerce user power utilization table code data provided in an embodiment of the present invention lack repair apparatus in short term,
Further include：
Sequencing unit, for after the quantity of complement period is at least two, described complement to be waited for by all described in determination
The when long-press of period is ranked up from small to large, if there are waiting for that the duration of complement period is consistent described in several, then by duration
It carves at the beginning of waiting for the complement period by each period described in several consistent and is ranked up from front to back.
Preferably, by it is described wait for the complement period centered on point, positioned at it is described wait for the complement period before the candidate reference
The quantity of period waits for that the quantity of candidate reference period after the complement period is equal with positioned at described.
Preferably, the computing unit specifically includes：
Computation subunit, for calculate separately it is described wait between complement period and each candidate reference period away from
From；
First determination subelement, for determining that the candidate reference period corresponding with minimum range is when choosing reference
Section；
The computation subunit is additionally operable to wait for the table code value of start time complement period according to, described waits for the complement period
The table code value of finish time, the table code value of each start time candidate reference period and each candidate reference period knot
The table code value at beam moment by preset first formula calculate separately it is described wait for complement period and each candidate reference period it
Between distance；
Wherein, preset first formula is：
Dist(t0, ti)=| (Vt0_e-Vt0_s)-(Vti_e-Vti_s)|/|Vt0_e-Vt0_s| * 100%
In formula, t0To wait for complement period, tiFor i-th of candidate reference period, Vt0_sTo wait for the table of start time complement period
Code value, Vt0_eTo wait for the table code value of finish time complement period, Vti_sFor the table code value of i-th of start time candidate reference period,
Vti_eFor the table code value of i-th of finish time candidate reference period.
Preferably, the repairing unit specifically includes：
Second determination subelement waits at a distance between the complement period not with reference to the period with described for being chosen described in judgement
After preset distance, determine described in wait for each scarce several moment of complement period, and determine in described choose with reference to the period with
The corresponding complement moment at each scarce several moment；
Repair subelement, for according to when the table code value of start time complement period, described to the end of the complement period
The table code value at moment described chooses the table code value with reference to start time period, the table code chosen with reference to finish time period
Value and described the table code value with reference to period at each complement moment is chosen to wait for the complement period to described by preset second formula
Each scarce several moment carry out corresponding data repairing；
Wherein, preset second formula is：
Vt0_s+j×m=Vt0_s+(Vti_s+j×m-Vti_s)×(Vt0_e-Vt0_s)÷(Vti_e-Vti_s)
In formula, t0To wait for complement period, tiThe period is referred to choose, m is data collection interval, Vt0_s+j×mTo wait mending
Number period t0J-th of table code value for lacking the number moment, Vti_s+j×mPeriod t is referred to chooseiThe table code value at j-th of complement moment.
As can be seen from the above technical solutions, the embodiment of the present invention has the following advantages：
An embodiment of the present invention provides a kind of industry and commerce user power utilization table code data to lack method for repairing and mending and device in short term,
In, this method includes：Obtain user's meter waits for the complement period, according to the preset number of preset time interval and candidate reference period
Amount determines each candidate reference period corresponding with the complement period is waited for；It calculates separately and waits for complement period and each candidate reference period
The distance between, determine that the candidate reference period corresponding with minimum range is to choose with reference to the period；Judging to choose with reference to the period
, no more than after preset distance, the complement period is treated according to the table code data with reference to the period are chosen with after the distance between complement period
Carry out data modification；Wherein, preset time interval is to appoint in comprising all periods for waiting for complement period and candidate reference period
The time interval anticipated between the two neighboring period.The present invention is having found user's meter there are in the case of shortage of data, abundant profit
Has the characteristics of higher similarity between industry and commerce user daily load curve interior for a period of time, by using shortage of data
The front and back several days table code data of period repair data loss period, are capable of providing fabulous data filling rate, and
Has higher repairing data quality.
Description of the drawings
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention without having to pay creative labor, may be used also for those of ordinary skill in the art
To obtain other attached drawings according to these attached drawings.
Fig. 1 is the implementation that a kind of industry and commerce user power utilization table code data provided by the invention lack method for repairing and mending in short term
The flow diagram of example；
Fig. 2 is another reality that a kind of industry and commerce user power utilization table code data provided by the invention lack method for repairing and mending in short term
Apply the flow diagram of example；
Fig. 3 is the implementation that a kind of industry and commerce user power utilization table code data provided by the invention lack repair apparatus in short term
The structural schematic diagram of example.
Specific implementation mode
An embodiment of the present invention provides a kind of industry and commerce user power utilization table code data to lack method for repairing and mending and device in short term, fills
The part throttle characteristics that industry and commerce user is utilized is divided to also achieve higher repair while providing fabulous data filling rate
Mend the quality of data.
In order to make the invention's purpose, features and advantages of the invention more obvious and easy to understand, below in conjunction with the present invention
Attached drawing in embodiment, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that disclosed below
Embodiment be only a part of the embodiment of the present invention, and not all embodiment.Based on the embodiments of the present invention, this field
All other embodiment that those of ordinary skill is obtained without making creative work, belongs to protection of the present invention
Range.
Referring to Fig. 1, a kind of industry and commerce user power utilization table code data provided by the invention lack the one of method for repairing and mending in short term
A embodiment, including：
101, obtain user's meter waits for the complement period, according to the preset quantity of preset time interval and candidate reference period
Determine each candidate reference period corresponding with the complement period is waited for；
102, it calculates separately and waits for the distance between complement period and each candidate reference period, determination is corresponding with minimum range
The candidate reference period be choose with reference to the period；
103, judge to choose with reference to the period at a distance between the complement period no more than after preset distance, according to choosing
Complement period progress data modification is treated with reference to the table code data of period.
Wherein, preset time interval is the arbitrary phase in comprising all periods for waiting for complement period and candidate reference period
Time interval between adjacent two periods.
An embodiment of the present invention provides a kind of industry and commerce user power utilization table code data to lack method for repairing and mending and device in short term,
In, this method includes：Obtain user's meter waits for the complement period, according to the preset number of preset time interval and candidate reference period
Amount determines each candidate reference period corresponding with the complement period is waited for；It calculates separately and waits for complement period and each candidate reference period
The distance between, determine that the candidate reference period corresponding with minimum range is to choose with reference to the period；Judging to choose with reference to the period
, no more than after preset distance, the complement period is treated according to the table code data with reference to the period are chosen with after the distance between complement period
Carry out data modification；Wherein, preset time interval is to appoint in comprising all periods for waiting for complement period and candidate reference period
The time interval anticipated between the two neighboring period.The present invention is having found user's meter there are in the case of shortage of data, abundant profit
Has the characteristics of higher similarity between industry and commerce user daily load curve interior for a period of time, by using shortage of data
The front and back several days table code data of period repair data loss period, are capable of providing fabulous data filling rate, and
Has higher repairing data quality.
It is one embodiment that a kind of industry and commerce user power utilization table code data lack method for repairing and mending in short term above, to carry out more
Another embodiment that a kind of industry and commerce user power utilization table code data lack method for repairing and mending in short term is provided below in specific description,
Referring to Fig. 2, a kind of industry and commerce user power utilization table code data provided by the invention lack another implementation of method for repairing and mending in short term
Example.
It should be noted that is referred in this implementation waits for the complement period that (i.e. table code data loss period) refers to based on acquisition
Some of time interval continuous time serieses carve at the beginning of the time series and there are table code data, but its in finish time
He all lacks the table code data at moment.Individually wait for that the complement period can use triple (start time, finish time, a data
Missing points) it indicates.
The candidate reference period：Refer to some periods, the data of complement period can be treated based on the data of any of which period
It is repaired, but repair efficiency will be different.The single candidate reference period can with two tuples (start time, at the end of
Carve) it indicates.
It chooses and refers to the period：Refer to according to certain rule, some period selected from the candidate reference period utilizes
The data of the period are repaired, and effect can be best.
The present embodiment includes：
201, obtain user's meter waits for the complement period, according to the preset quantity of preset time interval and candidate reference period
Determine each candidate reference period corresponding with the complement period is waited for；
It should be noted that wait for that the shortage of data points of complement period are usually provided with a threshold value, even data are adopted
Collection time interval is 1 hour, if setting threshold value is 24, the threshold value is corresponding when indicating to shortage of data the complement period
It is long to wait for that the complement period carries out complement no more than 24 hours (1 day).
In the present embodiment, preset time interval is to include all periods for waiting for complement period and candidate reference period
In, the time interval between two periods of arbitrary neighborhood.And the point centered on waiting for the complement period, before waiting for the complement period
The quantity of candidate reference period is equal with the quantity of candidate reference period after waiting for the complement period.
Such as to certain critical point ammeter (case 1) of Mr. Yu's Production of Ceramics enterprise, table code data collection interval is 1 small
When.Since its same day load characteristic curve often has larger similitude with the daily load characteristic curve of front and back a few days, can set
UL=24 is set, SL (preset distance)=15%, K (half of the preset quantity of candidate reference period)=7, ST is (between preset time
Every)=1.Wherein K=7, ST=1 indicate that the candidate reference period is the front and back 7*1=7 days periods same period for waiting for the complement period.
For another example to certain critical point meter (case 2) of Mr. Yu's large sized commercial center, table code data collection interval is same
It is 1 hour.Since its same day load characteristic curve often has larger similitude with the daily load characteristic curve of same period last week,
UL=24, SL=15%, K=4, ST=7 can be set.Wherein K=4, ST=7 indicate that the candidate reference period is to wait for the complement period
Preceding 28,21,14,7 days and the rear period same period on the 7th, 14,21,28.
Before step 201, determine after the quantity of complement period be at least two after, by the needed complement period when
Long-press is ranked up from small to large, if there are several to wait for that the duration of complement period is consistent, then by consistent several of duration
It carves at the beginning of waiting for the complement period by each period and is ranked up from front to back.
Such as the critical point ammeter of Production of Ceramics enterprise in case 1,1 day 0 October in 2017 was up on October 31st, 2017
Its shortage of data points wait for that the complement period is respectively tm1=(2017-10-05 10 less than 24 when 23:00:00,2017-
10-06 06:00:00,19), tm2=(2017-10-11 11:00:00,2017-10-11 16:00:00,4), tm3=
(2017-10-13 12:00:00,2017-10-13 17:00:00,4), tm4=(2017-10-15 12:00:00,2017-
10-15 14:00:00,1), tm5=(2017-10-25 12:00:00,2017-10-26 03:00:00,14), according to data
Missing points from as little as more, start time from front to back sequence sequence after result be tm4, tm2, tm3, tm5, tm1.Again by
It is a to wait for that the complement period executes step 201 to 206.
202, basis waits for the table code value of start time complement period, waits for table code value, the Ge Gehou of finish time complement period
Choosing passes through preset first formula with reference to the table code value and the table code value of each finish time candidate reference period of start time period
It calculates separately and waits for the distance between complement period and each candidate reference period, when determining candidate reference corresponding with minimum range
Section is to choose with reference to the period；Judge to choose with reference to the period at a distance between the complement period no more than after preset distance, root
Complement period progress data modification is treated according to the table code data with reference to the period are chosen；
Wherein, preset first formula is：
Dist(t0, ti)=| (Vt0_e-Vt0_s)-(Vti_e-Vti_s)|/|Vt0_e-Vt0_s| * 100%
In formula, t0To wait for complement period, tiFor i-th of candidate reference period, Vt0_sTo wait for the table of start time complement period
Code value, Vt0_eTo wait for the table code value of finish time complement period, Vti_sFor the table code value of i-th of start time candidate reference period,
Vti_eFor the table code value of i-th of finish time candidate reference period.
It should be noted that ensure that the validity of data needs before calculating distance by the incomplete candidate of data
It is rejected with reference to the period.Such as scarce several period t of the critical point ammeter of Production of Ceramics enterprise in case 1m4=(2017-10-15 12:
00:00,2017-10-15 14:00:00,1), because of K=7, ST=1, so tm4The candidate reference period be the period before and after 7
The period same period of day, i.e. tm4_1=(2017-10-08 12:00:00,2017-10-08 14:00:00), tm4_2=(2017-10-
09 12:00:00,2017-10-09 14:00:00) ..., tm4_7=(2017-10-14 12:00:00,2017-10-14 14:
00:00), tm4_8=(2017-10-16 12:00:00,2017-10-16 14:00:00) ..., tm4_14=(2017-10-22
12:00:00,2017-10-22 14:00:00), wherein tm4_4=(2017-10-11 12:00:00,2017-10-11 14:
00:And t 00)m4_6=(2017-10-13 12:00:00,2017-10-13 14:00:00) table code data are imperfect, picked
Remove out the candidate reference period.Then it calculates again and waits for the distance between complement period and each candidate reference period.
Such as scarce several period t of the critical point ammeter of Production of Ceramics enterprise in case 1m4=(2017-10-15 12:00:
00,2017-10-15 14:00:00,1), start time table code and finish time table code be respectively 2001.46kWh and
2003.46kWh, each candidate reference period is calculated using formula 1 and waits for being respectively 8.8% at a distance from the complement period,
8.4% ..., 5% ..., 7.5%, wherein being 5% apart from minimum value, the corresponding candidate reference period is tm4_7=(2017-
10-14 12:00:00,2017-10-14 14:00:00), using the period as choosing with reference to the period.
203, judge to choose with reference to the period and wait for whether the distance between complement period is more than preset distance, if so, holding
Row 204, if it is not, then executing 205；
204, it abandons executing data retrieval operations；
205, judging to choose with reference to the period that determination waits mending with after being not more than preset distance at a distance between the complement period
Each scarce several moment of number periods, and choosing with reference to determining the complement moment corresponding with each scarce several moment in the period；
206, basis waits for the table code value of start time complement period, the table code value for waiting for finish time complement period, chooses ginseng
The table code value of start time period is examined, the table code value with reference to finish time period is chosen and chooses with reference to period at each complement moment
Table code value complement period at each scarce several moment treated by preset second formula carry out corresponding data repairings.
Wherein, preset second formula is：
Vt0_s+j×m=Vt0_s+(Vti_s+j×m-Vti_s)×(Vt0_e-Vt0_s)÷(Vti_e-Vti_s)
In formula, t0To wait for complement period, tiThe period is referred to choose, m is data collection interval, Vt0_s+j×mTo wait mending
Number period t0J-th of table code value for lacking the number moment, Vti_s+j×mPeriod t is referred to chooseiThe table code value at j-th of complement moment.
Such as scarce several period t of the critical point ammeter of Production of Ceramics enterprise in case 1m4=(2017-10-15 12:00:
00,2017-10-15 14:00:00,1), start time table code and finish time table code be respectively 2001.46kWh and
2003.46kWh needs at the time of complement to be 2017-10-15 13:00:00；
And it chooses with reference to period tm4_7=(2017-10-14 12:00:00,2017-10-14 14:00:00) at the beginning of
Quarter table code and finish time table code be respectively 1951.24kWh and 1953.34kWh, correspond to the moment same period for needing the complement moment
For 2017-10-14 13:00:00, table code value is 1952.74kWh.Then need table code value at the time of complement：
V2017-10-15 13:00:00=2001.46+ (1952.74-1951.24) × (2003.46-2001.46) ÷
(1953.34-1951.24)=2002.89kWh.
The case where embodiment of the present invention lacks industry and commerce user power utilization table code data in short term, is providing fabulous number
While according to filling rate, higher repairing data quality is also achieved.Table code shortage of data problem is handled based on the inventive technique,
The table code quality of data can effectively be promoted so that existing data obtain more extensively, deeper into utilization, realize electric cost estimate
Calculation, electricity demand forecasting, peak Pinggu utilize the finings applications such as proficiency assessment.
Be above to a kind of commercial user provided by the invention with ammeter code data lack in short term method for repairing and mending carry out it is detailed
It describes in detail bright, will lack repair apparatus in short term with ammeter code data to a kind of commercial user provided by the invention below and illustrate,
Referring to Fig. 3, a kind of commercial user provided by the invention lacks one embodiment of repair apparatus with ammeter code data in short term, packet
It includes：
Acquiring unit 301 waits for the complement period, when according to preset time interval and candidate reference for obtain user's meter
The preset quantity of section determines each candidate reference period corresponding with the complement period is waited for；
Computing unit 302 waits for the distance between complement period and each candidate reference period for calculating separately, determine with
The minimum range corresponding candidate reference period is to choose with reference to the period；
Repair unit 303, for judge to choose with reference to the period with wait at a distance between the complement period no more than it is preset away from
From rear, data modification is carried out according to choosing the table code data with reference to the period to treat the complement period；
Wherein, preset time interval is the arbitrary phase in comprising all periods for waiting for complement period and candidate reference period
Time interval between adjacent two periods.
Further, a kind of industry and commerce user power utilization table code data provided in an embodiment of the present invention lack repairing dress in short term
It sets, further includes：
Sequencing unit 300, for determining after the quantity of complement period is at least two, by the needed complement period
When long-press be ranked up from small to large, if there are several to wait for that the duration of complement period is consistent, then by consistent several of duration
It is a wait for the complement period by each period at the beginning of carve and be ranked up from front to back.
Further, the point centered on waiting for the complement period, the number of the candidate reference period before waiting for the complement period
Amount is equal with the quantity of candidate reference period after waiting for the complement period.
Further computing unit 302 specifically includes：
Computation subunit 3021 waits for the distance between complement period and each candidate reference period for calculating separately；
First determination subelement 3022, for determining that the candidate reference period corresponding with minimum range is when choosing reference
Section；
Computation subunit 3021 is additionally operable to basis and waits for the table code value of start time complement period, waits for finish time complement period
Table code value, the table code value of each start time candidate reference period and the table code value of each finish time candidate reference period it is logical
It crosses preset first formula and calculates separately and wait for the distance between complement period and each candidate reference period；
Wherein, preset first formula is：
Dist(t0, ti)=| (Vt0_e-Vt0_s)-(Vti_e-Vti_s)|/|Vt0_e-Vt0_s| * 100%
In formula, t0To wait for complement period, tiFor i-th of candidate reference period, Vt0_sTo wait for the table of start time complement period
Code value, Vt0_eTo wait for the table code value of finish time complement period, Vti_sFor the table code value of i-th of start time candidate reference period,
Vti_eFor the table code value of i-th of finish time candidate reference period.
Further, repairing unit 303 specifically includes：
Second determination subelement 3031, for judge to choose with reference to the period with wait for being not more than at a distance between the complement period
After preset distance, each scarce several moment for waiting for the complement period are determined, and determined and each scarce several moment in choosing with reference to the period
The corresponding complement moment；
Subelement 3032 is repaired, the table code value of start time complement period is waited for for basis, waits for finish time complement period
Table code value, choose the table code value with reference to start time period, choose the table code value with reference to finish time period and choose reference
The table code value at period at each complement moment treats complement period each scarce several moment progress corresponding datas by preset second formula
Repairing；
Wherein, preset second formula is：
Vt0_s+j×m=Vt0_s+(Vti_s+j×m-Vti_s)×(Vt0_e-Vt0_s)÷(Vti_e-Vti_s)
In formula, t0To wait for complement period, tiThe period is referred to choose, m is data collection interval, Vt0_s+j×mTo wait mending
Number period t0J-th of table code value for lacking the number moment, Vti_s+j×mPeriod t is referred to chooseiThe table code value at j-th of complement moment.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description,
The specific work process of device and unit, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
In several embodiments provided herein, it should be understood that disclosed system, device and method can be with
It realizes by another way.For example, the apparatus embodiments described above are merely exemplary, for example, the unit
It divides, only a kind of division of logic function, formula that in actual implementation, there may be another division manner, such as multiple units or component
It can be combined or can be integrated into another system, or some features can be ignored or not executed.Another point, it is shown or
The mutual coupling, direct-coupling or communication connection discussed can be the indirect coupling by some interfaces, device or unit
It closes or communicates to connect, can be electrical, machinery or other forms.
The unit illustrated as separating component may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, you can be located at a place, or may be distributed over multiple
In network element.Some or all of unit therein can be selected according to the actual needs to realize the mesh of this embodiment scheme
's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
It is that each unit physically exists alone, it can also be during two or more units be integrated in one unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can be stored in a computer read/write memory medium.Based on this understanding, technical scheme of the present invention is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes the complete of each embodiment the method for the present invention
Portion or part steps.And storage medium above-mentioned includes：USB flash disk, mobile hard disk, read-only memory (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), magnetic disc or CD etc. are various can store journey
The medium of sequence code.
The above, the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although with reference to before
Stating embodiment, invention is explained in detail, it will be understood by those of ordinary skill in the art that：It still can be to preceding
The technical solution recorded in each embodiment is stated to modify or equivalent replacement of some of the technical features；And these
Modification or replacement, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of industry and commerce user power utilization table code data lack method for repairing and mending in short term, which is characterized in that including：
Obtain user's meter waits for the complement period, according to preset time interval and the determination of the preset quantity of candidate reference period and institute
It states and waits for complement period corresponding each candidate reference period；
It is waited for the distance between complement period and each candidate reference period described in calculating separately, determination is corresponding with minimum range
The candidate reference period be choose with reference to the period；
It is chosen described in judgement with reference to the period with described after being not more than preset distance at a distance between the complement period, according to described
The table code data with reference to the period are chosen to wait for that the complement period carries out data modification to described；
Wherein, the preset time interval is to include all periods for waiting for complement period and the candidate reference period
In, the time interval between two periods of arbitrary neighborhood.
2. industry and commerce user power utilization table code data according to claim 1 lack method for repairing and mending in short term, which is characterized in that also
Including：
Described in determination after the quantity of complement period be at least two after, by it is all it is described when the complement period when long-press from it is small to
It is ranked up greatly, if there are waiting for that the duration of complement period is consistent described in several, then will be waited for described in consistent several of duration
The complement period by each period at the beginning of carve and be ranked up from front to back.
3. industry and commerce user power utilization table code data according to claim 1 lack method for repairing and mending in short term, which is characterized in that with
The point centered on waiting for the complement period, positioned at it is described wait for the complement period before the candidate reference period quantity and be located at institute
The quantity for stating the candidate reference period after waiting for the complement period is equal.
4. industry and commerce user power utilization table code data according to claim 3 lack method for repairing and mending in short term, which is characterized in that institute
It states and waits for that the distance between complement period and each candidate reference period are specially described in calculating separately：
According to the table code value for waiting for start time complement period, table code value, the Ge Gesuo for waiting for finish time complement period
State the table code value of start time candidate reference period and the table code value of each finish time candidate reference period pass through it is preset
First formula waits for the distance between complement period and each candidate reference period described in calculating separately；
Wherein, preset first formula is：
Dist(t0,ti)=| (Vt0_e-Vt0_s)-(Vti_e-Vti_s)|/|Vt0_e-Vt0_s| * 100%
In formula, t0To wait for complement period, tiFor i-th of candidate reference period, Vt0_sTo wait for the table code of start time complement period
Value, Vt0_eTo wait for the table code value of finish time complement period, Vti_sFor the table code value of i-th of start time candidate reference period,
Vti_eFor the table code value of i-th of finish time candidate reference period.
5. industry and commerce user power utilization table code data according to claim 4 lack method for repairing and mending in short term, which is characterized in that institute
It states and is chosen described in judgement with reference to the period with described after being not more than preset distance at a distance between the complement period, according to the choosing
The middle table code data with reference to the period wait for that the complement period carries out data modification and specifically includes to described：
It is chosen described in judgement with reference to the period with described after being not more than preset distance at a distance between the complement period, described in determination
It waits for each scarce several moment of complement period, and determines in described choose with reference to the period benefit corresponding with each scarce several moment
The number moment；
According to the table code value for waiting for start time complement period, the table code value for waiting for finish time complement period, the choosing
Middle table code value with reference to start time period described chosen the table code value with reference to finish time period and described is chosen with reference to the period
The table code value at each complement moment waits for that complement period at each scarce several moment carry out by preset second formula to described
Corresponding data is repaired；
Wherein, preset second formula is：
Vt0_s+j×m=Vt0_s+(Vti_s+j×m-Vti_s)×(Vt0_e-Vt0_s)÷(Vti_e-Vti_s)
In formula, t0To wait for complement period, tiThe period is referred to choose, m is data collection interval, Vt0_s+j×mFor when complement
Section t0J-th of table code value for lacking the number moment, Vti_s+j×mPeriod t is referred to chooseiThe table code value at j-th of complement moment.
6. a kind of industry and commerce user power utilization table code data lack repair apparatus in short term, which is characterized in that including：
Acquiring unit waits for the complement period for obtain user's meter, pre- according to preset time interval and candidate reference period
It sets quantity and determines and wait for corresponding each candidate reference period complement period with described；
Computing unit, for calculate separately it is described wait for the distance between complement period and each candidate reference period, determination
The candidate reference period corresponding with minimum range is to choose with reference to the period；
Repair unit, for chosen described in judgement with reference to the period with it is described wait at a distance between the complement period no more than it is preset away from
From rear, the table code data with reference to the period are chosen to wait for that the complement period carries out data modification to described according to described；
Wherein, the preset time interval is to include all periods for waiting for complement period and the candidate reference period
In, the time interval between two periods of arbitrary neighborhood.
7. industry and commerce user power utilization table code data according to claim 6 lack repair apparatus in short term, which is characterized in that also
Including：
Sequencing unit, for after the quantity of complement period is at least two, described the complement period to be waited for by all described in determination
When long-press be ranked up from small to large, if there are waiting for that the duration of complement period is consistent described in several, then it is duration is consistent
Several described in wait for the complement period by each period at the beginning of carve and be ranked up from front to back.
8. industry and commerce user power utilization table code data according to claim 6 lack repair apparatus in short term, which is characterized in that with
The point centered on waiting for the complement period, positioned at it is described wait for the complement period before the candidate reference period quantity and be located at institute
The quantity for stating the candidate reference period after waiting for the complement period is equal.
9. industry and commerce user power utilization table code data according to claim 8 lack repair apparatus in short term, which is characterized in that institute
Computing unit is stated to specifically include：
Computation subunit described waits for the distance between complement period and each candidate reference period for calculating separately；
First determination subelement, for determining that the candidate reference period corresponding with minimum range is to choose with reference to the period；
The computation subunit is additionally operable to according to when the table code value of start time complement period, described to the end of the complement period
The table code value at moment, the table code value of each start time candidate reference period and at the end of each candidate reference period
The table code value at quarter calculates separately described wait between complement period and each candidate reference period by preset first formula
Distance；
Wherein, preset first formula is：
Dist(t0,ti)=| (Vt0_e-Vt0_s)-(Vti_e-Vti_s)|/|Vt0_e-Vt0_s| * 100%
In formula, t0To wait for complement period, tiFor i-th of candidate reference period, Vt0_sTo wait for the table code of start time complement period
Value, Vt0_eTo wait for the table code value of finish time complement period, Vti_sFor the table code value of i-th of start time candidate reference period,
Vti_eFor the table code value of i-th of finish time candidate reference period.
10. industry and commerce user power utilization table code data according to claim 9 lack repair apparatus in short term, which is characterized in that
The repairing unit specifically includes：
Second determination subelement waits for being not more than at a distance between the complement period with reference to the period for choosing described in judgement with described
After preset distance, determine described in wait for each scarce several moment of complement period, and determine in described choose with reference to the period with it is each
The corresponding complement moment at scarce several moment；
Subelement is repaired, for waiting for the table code value of start time complement period according to, described waiting for finish time complement period
Table code value, it is described choose the table code value with reference to start time period, it is described choose with reference to finish time period table code value and
It is described that the table code value with reference to period at each complement moment is chosen to wait for that the complement period is each to described by preset second formula
Scarce several moment carry out corresponding data repairing；
Wherein, preset second formula is：
Vt0_s+j×m=Vt0_s+(Vti_s+j×m-Vti_s)×(Vt0_e-Vt0_s)÷(Vti_e-Vti_s)
In formula, t0To wait for complement period, tiThe period is referred to choose, m is data collection interval, Vt0_s+j×mFor when complement
Section t0J-th of table code value for lacking the number moment, Vti_s+j×mPeriod t is referred to chooseiThe table code value at j-th of complement moment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810146112.6A CN108363789B (en) | 2018-02-12 | 2018-02-12 | Short-term missing repairing method and device for electricity consumption meter data of industrial and commercial users |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810146112.6A CN108363789B (en) | 2018-02-12 | 2018-02-12 | Short-term missing repairing method and device for electricity consumption meter data of industrial and commercial users |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108363789A true CN108363789A (en) | 2018-08-03 |
| CN108363789B CN108363789B (en) | 2021-09-17 |
Family
ID=63005770
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810146112.6A Active CN108363789B (en) | 2018-02-12 | 2018-02-12 | Short-term missing repairing method and device for electricity consumption meter data of industrial and commercial users |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108363789B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111127247A (en) * | 2019-11-21 | 2020-05-08 | 深圳供电局有限公司 | Electric quantity data acquisition method and device, computer equipment and storage medium |
| CN117632927A (en) * | 2023-11-24 | 2024-03-01 | 九科信息技术(深圳)有限公司 | Data processing method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150092251A1 (en) * | 2011-09-27 | 2015-04-02 | Samsung Electronics Co., Ltd. | Image scanning apparatus and method |
| CN104992239A (en) * | 2015-06-24 | 2015-10-21 | 国网山东省电力公司电力科学研究院 | Correlation coefficient-based industry electricity consumption law forecasting method |
| CN105678046A (en) * | 2014-11-18 | 2016-06-15 | 日本电气株式会社 | Missing data repairing method and device in time-space sequence data |
| US20170300317A1 (en) * | 2016-03-24 | 2017-10-19 | Knight Point Systems, Inc. | System and method for patching software in a target computer system device |
-
2018
- 2018-02-12 CN CN201810146112.6A patent/CN108363789B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150092251A1 (en) * | 2011-09-27 | 2015-04-02 | Samsung Electronics Co., Ltd. | Image scanning apparatus and method |
| CN105678046A (en) * | 2014-11-18 | 2016-06-15 | 日本电气株式会社 | Missing data repairing method and device in time-space sequence data |
| CN104992239A (en) * | 2015-06-24 | 2015-10-21 | 国网山东省电力公司电力科学研究院 | Correlation coefficient-based industry electricity consumption law forecasting method |
| US20170300317A1 (en) * | 2016-03-24 | 2017-10-19 | Knight Point Systems, Inc. | System and method for patching software in a target computer system device |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111127247A (en) * | 2019-11-21 | 2020-05-08 | 深圳供电局有限公司 | Electric quantity data acquisition method and device, computer equipment and storage medium |
| CN111127247B (en) * | 2019-11-21 | 2024-01-19 | 深圳供电局有限公司 | Electric quantity data acquisition method, device, computer equipment and storage medium |
| CN117632927A (en) * | 2023-11-24 | 2024-03-01 | 九科信息技术(深圳)有限公司 | Data processing method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108363789B (en) | 2021-09-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112001618B (en) | Method for integrating and optimizing construction period assignment, order acceptance and production scheduling | |
| CN109492774B (en) | Deep learning-based cloud resource scheduling method | |
| CN110059834A (en) | Electric power O&M method, system and terminal device | |
| CN110738413A (en) | Multi-constraint scheduling calculation method and device for automatic aviation part machining production line | |
| CN110781562A (en) | Multi-objective optimization method and device for airplane pulsation final assembly operation process | |
| CN103679388B (en) | Production scheduling method and production scheduling system | |
| CN108681815B (en) | Power distribution system operation reliability evaluation method based on rapid sequencing and block matrix | |
| CN109410054B (en) | Block chain consensus method based on information sharing contribution value in autonomous domain mode | |
| CN106502918B (en) | A kind of scheduling memory method and device | |
| CN108230147A (en) | A kind of exchange settlement method, system and device for quantifying investment tactics | |
| CN105388876B (en) | Obtain the method and device of the batch-type chemical production technology degree of conformity based on teams and groups | |
| CN110991901A (en) | Task allocation method, computer storage medium and electronic device | |
| CN108363789A (en) | A kind of industry and commerce user power utilization table code data lack method for repairing and mending and device in short term | |
| CN110928261A (en) | Distributed estimation scheduling method and system for distributed heterogeneous flow shop | |
| EP2608123B1 (en) | System for distributing electrical energy over a cluster of electrical devices, method for distributing electrical energy over a cluster of electrical devices of such a system and controller for use in such a system | |
| CN107423914A (en) | A kind of method for scheduling task and system based on cloud manufacture | |
| CN105528521B (en) | A kind of definite method on Reconfigurable Manufacturing System reconstruct opportunity | |
| CN111798119A (en) | Order accepting and scheduling integrated optimization method for prefabricated part flow shop | |
| CN112332420B (en) | Device and method for determining hierarchical load reduction in power system risk assessment | |
| CN111724129A (en) | Source network load storage multi-round discharge method, system, equipment and storage medium | |
| CN110165657A (en) | Consider substation's load characteristics clustering analysis method of user's industry attribute | |
| CN109741047A (en) | Charging system on a kind of line | |
| CN113496322A (en) | Inter-area power declaration matching method and system considering available transmission capacity | |
| CN110765355A (en) | Method and device for pushing financial market product transaction strategy courses | |
| CN111047161A (en) | Industrial park operation management system and method |
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 |