Enterprise power consumption data restoration method and system based on data collected by metering points
By calculating the total electricity consumption of all measurement points of enterprise users on the day to repair abnormal electricity consumption data, the problem of repairing distortion in the existing technology is solved, and more accurate electricity consumption data reflection is achieved.
Patent Information
- Application Number
- CN202410991042.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-23
- Publication Date
- 2024-12-31
AI Technical Summary
When the abnormal electricity consumption data is repaired using historical electricity consumption data from adjacent dates in the prior art, it is easy to cause the repaired electricity consumption data to be distorted, which is difficult to reflect the actual electricity consumption level in the actual production situation.
By obtaining all measurement points of the enterprise user to which the abnormal electricity use data belongs, calculate the total electricity consumption of each measurement point on the day, and use it as a basis for repair, and replace the abnormal electricity use data to reflect the real electricity consumption level of the enterprise user.
It reduces errors during the repair process, makes the repaired electricity consumption data more in line with the real electricity consumption level of real production, and improves the accuracy of the data.
Smart Images

Figure CN119226692A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of electricity consumption data processing, and in particular to a method and system for repairing enterprise electricity consumption data based on data collected at metering points. Background Art
[0002] As an important data reflecting the level of social and economic development, the electricity consumption of corporate users has the characteristics of huge data volume and high data complexity. Various factors such as abnormal collection system and abnormal installation of grassroots meters will cause the data meter code collection system to fail, so that there are a lot of problematic data in the received data. Therefore, it is necessary to "clean" the received data by repairing the electricity data.
[0003] In the process of repairing electricity consumption data in the prior art, the features of historical electricity consumption data of adjacent dates are extracted based on the received abnormal power generation data, and the features of the historical electricity consumption data of adjacent dates are used to repair the abnormal electricity consumption data. This will cause the repaired electricity consumption data to be distorted and difficult to reflect the actual electricity consumption level in actual production conditions. Summary of the invention
[0004] In order to solve the problem of distortion caused by using the characteristics of historical electricity consumption data of adjacent dates to repair abnormal electricity consumption data in the prior art, the present invention proposes a method and system for repairing enterprise electricity consumption data based on data collected by metering points. In the method proposed by the present invention, by using the metering point corresponding to the user of abnormal electricity consumption data, the total electricity consumption of the corresponding user on the day is calculated by the electricity consumption data recorded by the metering point, and the abnormal electricity consumption data is corrected by the total electricity consumption on the day; the electricity consumption data of enterprise users collected by the metering point is used to reflect the actual electricity consumption level of the enterprise users. By using the electricity consumption data of enterprise users collected by the metering point as the basis for repairing abnormal electricity consumption data, the error generated when repairing abnormal electricity consumption data can be reduced, so that the repaired electricity consumption data is more in line with the actual electricity consumption level of actual production.
[0005] On the one hand, the present invention proposes a method for repairing enterprise electricity consumption data based on data collected from metering points, comprising:
[0006] Acquire abnormal power consumption data, and acquire the enterprise user to which the abnormal power consumption data belongs;
[0007] Using the enterprise user to which the abnormal electricity consumption data belongs, all metering points corresponding to the enterprise user are obtained;
[0008] For each of the metering points, the total electricity consumption of the metering point on that day is obtained according to the load data collected by the metering point at multiple sampling times;
[0009] The total daily electricity consumption of all metering points of the enterprise user is summed up to obtain the total daily electricity consumption of the enterprise user;
[0010] The abnormal electricity consumption data is replaced with the total electricity consumption of the enterprise user on that day.
[0011] Optionally, before obtaining the total electricity consumption of the metering point on the day according to the load data collected by the metering point at multiple sampling times for each metering point, the process further includes:
[0012] An average value of the load data collected by the metering point at multiple sampling times is obtained. If the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, it is determined that the load data is valid.
[0013] Optionally, if the load data is invalid, the method further includes:
[0014] In the historical data of the enterprise user, two load data with the same attribute type as the abnormal power consumption data are obtained, an average value of the two load data is calculated, and the abnormal power consumption data is repaired using the average value.
[0015] Optionally, obtaining an average value of the load data collected by the metering point at multiple sampling times, and if the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, determining that the load data is valid includes:
[0016] Obtaining an average value of the load data collected by the metering point at multiple sampling times;
[0017] Calculate the product of the installed capacity of the enterprise user and the maximum output coefficient, and use the product as the maximum power consumption threshold of the enterprise user;
[0018] Comparing the maximum power consumption threshold of the enterprise user with the average value;
[0019] If the average value is less than the maximum power consumption threshold of the enterprise user, the load data is confirmed to be valid.
[0020] Optionally, before acquiring the load data collected by the metering point at multiple sampling times, the method further includes:
[0021] The historical data of the metering point is queried to confirm the existence of load data collected by the metering point at multiple sampling times.
[0022] Optionally, if there is no load data collected by the metering point at multiple sampling times, the method further includes:
[0023] Acquire the abnormal type of the abnormal power consumption data, where the abnormal type includes a negative value, a zero value, and a maximum value;
[0024] If the abnormal type of the abnormal power consumption data is a negative value or a zero value, the preset value is determined to be 0; if the abnormal type of the abnormal power consumption data is a maximum value, the preset value is determined to be the calculated power consumption obtained according to the installed capacity of the enterprise user;
[0025] The abnormal power usage data is replaced by corresponding preset values to repair the abnormal power usage data.
[0026] Optionally, the calculation process of the total daily electricity consumption of the enterprise user satisfies the following expression:
[0027]
[0028] Wherein, w is the total electricity consumption of the enterprise user on that day; t is the t-th metering point of the enterprise user, t=1,…,n; n is the number of metering points of the enterprise user; i is the i-th sampling time, i=1,…,96; P i is the load data collected at the metering point at the i-th sampling time.
[0029] On the other hand, the present invention also proposes an enterprise electricity consumption data repair system based on metering point collection data, comprising:
[0030] A user acquisition unit, used to acquire abnormal power consumption data and acquire the enterprise user to which the abnormal power consumption data belongs;
[0031] A metering point acquisition unit, configured to obtain all metering points corresponding to the enterprise user by using the enterprise user to which the abnormal electricity consumption data belongs;
[0032] A user power acquisition unit is used to obtain the total power of the metering point on the day according to the load data collected by the metering point at multiple sampling times for each metering point; sum the total power of all metering points of the enterprise user on the day to obtain the total power of the enterprise user on the day;
[0033] The abnormal data repair unit is used to replace the abnormal power consumption data with the total power consumption of the enterprise user on that day.
[0034] In another aspect, the present invention further provides an electronic device, comprising: at least one processor and a memory; the memory and the processor are connected via a bus;
[0035] The memory is used to store one or more programs;
[0036] When the one or more programs are executed by the at least one processor, a method for repairing enterprise electricity consumption data based on data collected from metering points as described in the above technical solution is implemented.
[0037] On the other hand, the present invention further proposes a readable storage medium having an execution program stored thereon, and when the execution program is executed, a method for repairing enterprise electricity consumption data based on data collected from metering points as described in the above technical solution is implemented.
[0038] Compared with the prior art, the present invention has the following beneficial effects:
[0039] In the method proposed in the present invention, by utilizing the metering points corresponding to the users with abnormal electricity consumption data, the total daily electricity consumption of the corresponding users is calculated through the electricity consumption data recorded at the metering points, and the abnormal electricity consumption data is corrected using the total daily electricity consumption; the characteristic that the electricity consumption data of enterprise users collected by the metering points can reflect the actual electricity consumption level of the enterprise users is utilized, and by using the electricity consumption data of enterprise users collected by the metering points as the basis for repairing the abnormal electricity consumption data, it is possible to reduce the error generated when repairing the abnormal electricity consumption data, so that the repaired electricity consumption data is more in line with the actual electricity consumption level of actual production. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 It is a flow chart of the enterprise electricity consumption data repair method based on metering point collection data of the present invention;
[0041] Figure 2 It is a flow chart of a method for repairing enterprise electricity consumption data based on data collected from metering points in another embodiment of the present invention;
[0042] Figure 3 A flowchart of the method provided by the present invention for repairing electricity consumption data of various enterprises;
[0043] Figure 4 It is a schematic structural diagram of the electronic device of the present invention. DETAILED DESCRIPTION
[0044] The present invention proposes a method and system for repairing enterprise electricity consumption data based on data collected by metering points. In the method proposed in the present application, the electricity consumption data of enterprise users collected by metering points can reflect the actual electricity consumption level of enterprise users. By using the metering points corresponding to users with abnormal electricity consumption data, the total electricity consumption of the corresponding user on the day is calculated by the electricity consumption data recorded by the metering points, and the abnormal electricity consumption data is corrected by the total electricity consumption on the day. By using the electricity consumption data of enterprise users collected by metering points as the basis for repairing abnormal electricity consumption data, the present application can reduce the error generated when repairing abnormal electricity consumption data, so that the repaired electricity consumption data is more in line with the actual electricity consumption level of actual production.
[0045] Embodiment 1:
[0046] A method for repairing enterprise electricity consumption data based on data collected from metering points, such as Figure 1 As shown, including:
[0047] S101, obtaining abnormal electricity usage data, and obtaining the enterprise user to which the abnormal electricity usage data belongs;
[0048] S102, using the enterprise user to which the abnormal electricity consumption data belongs, obtaining all metering points corresponding to the enterprise user;
[0049] S103, for each of the metering points, obtaining the total electricity consumption of the metering point on the day according to the load data collected by the metering point at multiple sampling times;
[0050] S104, summing up the total daily electricity consumption of all metering points of the enterprise user to obtain the total daily electricity consumption of the enterprise user;
[0051] S105: Replace the abnormal electricity consumption data with the total electricity consumption of the enterprise user on that day.
[0052] For example, since the production scale and voltage required in the production process of each enterprise are different, the number of metering points in the power supply area corresponding to each user is different. When the enterprise user is a high-voltage user (a user who receives electricity at a voltage of 35kV or above), there are multiple metering points corresponding to each enterprise user. Therefore, all metering point IDs of the corresponding user are associated by querying the ID of the enterprise user, and the actual electricity consumption of the corresponding enterprise is obtained by obtaining each metering point ID; when the enterprise user is a low-voltage non-residential user (a customer other than a residential customer who is supplied with electricity at a voltage level of 380V or 220V), there is only one metering point corresponding to each enterprise user. Therefore, the actual electricity consumption of the enterprise user is obtained directly by querying the ID of the metering point.
[0053] The method provided in this application is helpful to study the electricity consumption characteristics of massive corporate users, identify the abnormal data characteristics of the electricity consumption of each corporate user, and formulate data standards based on this. Through big data analysis methods, a data quality repair model is constructed to achieve the purpose of quickly identifying abnormal data, repairing abnormal data, and improving the accuracy of obtaining corporate user electricity data.
[0054] As an important data reflecting the level of social and economic development, the electricity consumption of enterprise users has the characteristics of huge data volume and high data complexity. Various factors such as abnormal collection system and abnormal installation of grassroots meters will cause the data table code collection system to fail, so that there are a large number of abnormal electricity consumption data in the received data. The abnormal electricity consumption data mainly includes zero value, negative value and maximum value of electricity consumption. If the abnormal electricity consumption data is not processed, the data including abnormal electricity consumption data is used to enter the data analysis and mining stage of the enterprise's electricity consumption, which will seriously deviate from the actual production situation. Therefore, it is necessary to "clean" the data quality. The purpose is to detect the abnormal electricity consumption data in the target data set manually or automatically, and correct these abnormal electricity consumption data to improve the overall data quality.
[0055] In the prior art, when the moving average method is used to repair abnormal electricity consumption data, the abnormal data is repaired by extracting the historical data features of adjacent dates. During the repair process, it is difficult to identify whether the abnormal data is normal electricity volume changes caused by enterprise production adjustments or data mutations caused by calculation anomalies, which will lead to over-repair and distortion of enterprise data, making it difficult to reflect the true level of electricity economy. Directly using the product of a fixed coefficient and capacity to replace abnormal electricity consumption data with a maximum abnormal type is difficult to be generally applicable to enterprise users of various sizes in all walks of life, resulting in the final repair result being inaccurate.
[0056] Compared with the above-mentioned abnormal electricity consumption data repairing method disclosed herein, when repairing abnormal electricity consumption data, the method provided by the present invention first determines the metering point recording the corresponding enterprise user according to the enterprise user to which the abnormal electricity consumption data to be repaired belongs, and then obtains the load data collected by the metering point at multiple sampling times to obtain the total electricity consumption of each metering point on the day, and according to the number of metering points corresponding to the enterprise user, the total electricity consumption of the day recorded by all metering points is summed up to obtain the total electricity consumption of the enterprise user on the day, and the total electricity consumption of the day of the enterprise user is used to replace the abnormal electricity consumption data, so as to achieve the actual electricity consumption level that is more in line with the actual production of the enterprise user after the abnormal electricity consumption data is repaired.
[0057] like Figure 2 and Figure 3 As shown, optionally, before S102, the method provided by the present invention further includes:
[0058] An average value of the load data collected by the metering point at multiple sampling times is obtained. If the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, it is determined that the load data is valid.
[0059] The maximum power consumption threshold of an enterprise user is specifically implemented as the power when the enterprise user reaches the maximum margin during normal production. For example, when the maximum output coefficient of an enterprise user reaches the maximum margin during production, is 1.2, then the maximum power consumption threshold of the enterprise user is the product of the enterprise user's installed capacity and 1.2, and the result of the product is used to evaluate whether the load data of the enterprise user is valid.
[0060] In order to avoid serious deviations in the load data collected by the metering point at multiple sampling times, it is necessary to use the maximum electricity consumption threshold of the enterprise user to verify the validity of the load data collected by the metering point at multiple sampling times. If the average value of the load data collected by the metering point at multiple sampling times is less than the maximum electricity consumption threshold of the enterprise user, it can be regarded as the current enterprise is in full load production, and the load data collected by the metering point at multiple sampling times are valid and can be used to repair abnormal electricity consumption data.
[0061] Optionally, the process of obtaining the total daily electricity consumption of the enterprise user in S103 satisfies the following expression:
[0062]
[0063] Wherein, w is the total electricity consumption of the enterprise user on that day; t is the t-th metering point of the enterprise user, t=1,…,n; n is the number of metering points of the enterprise user; i is the i-th sampling time, i=1,…,96; P i is the load data collected at the metering point at the i-th sampling time.
[0064] Since the time interval for transmitting the collected load data through the metering point is 15 minutes, a day is divided into 96 sampling moments. The load data obtained by each metering point at each sampling moment is used to obtain the total daily electricity consumption of the current enterprise users, and the abnormal electricity consumption data is repaired by using the total daily electricity consumption of the enterprise users, so that the repaired enterprise electricity consumption data is more in line with the actual production level.
[0065] Optionally, if the load data is invalid, that is, the average value of the load data collected by the metering point at multiple sampling times is greater than or equal to the maximum power consumption threshold of the enterprise user, the method further includes:
[0066] In the historical data of the enterprise user, two load data with the same attribute type as the abnormal power consumption data are obtained, an average value of the two load data is calculated, and the abnormal power consumption data is repaired using the average value.
[0067] The two load data with the same attribute type as the abnormal power consumption data are specifically two load data with the same date type obtained according to the date type to which the abnormal power consumption data belongs. The date type can be implemented as a working day or a rest day. By using the two load data with the same attribute type as the abnormal power consumption data to repair the abnormal power consumption data, the overall repair of the abnormal power consumption data can be achieved, which reduces the impact of using power consumption data to judge the production situation of enterprise users to a certain extent.
[0068] Exemplarily, if the average value of the load data collected at the metering point at multiple sampling times is greater than or equal to the maximum power consumption threshold of the enterprise user, it is considered that although the daily load of the enterprise user can be obtained, the load data of the enterprise user is much greater than the normal value, which means that the load data of the corresponding metering point is unavailable. The average moving method is then used to repair the abnormal power consumption data, that is, by calculating the average value of the previous two load data of the same attribute type as the abnormal power consumption data, and replacing the abnormal power consumption data with the obtained average value.
[0069] Optionally, obtaining an average value of the load data collected by the metering point at multiple sampling times, and if the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, determining that the load data is valid includes:
[0070] Obtaining an average value of the load data collected by the metering point at multiple sampling times;
[0071] Calculate the product of the maximum output coefficient of the installed capacity of the enterprise user, and use the product as the maximum power consumption threshold of the enterprise user;
[0072] Comparing the maximum power consumption threshold of the enterprise user with the average value;
[0073] If the average value is less than the maximum power consumption threshold of the enterprise user, the load data is confirmed to be valid.
[0074] Exemplarily, the installed capacity of an enterprise user corresponds to the current power consumption of the enterprise user, and the maximum output coefficient is usually set to 1.2. Therefore, the maximum power consumption threshold of the enterprise user is the product of the current installed capacity of the enterprise user and the maximum output coefficient of 1.2.
[0075] Optionally, before acquiring the load data collected by the metering point at multiple sampling times, the method further includes:
[0076] The historical data of the metering point is queried to confirm the existence of load data collected by the metering point at multiple sampling times.
[0077] Before repairing the abnormal electricity consumption data, it is necessary to obtain the historical data of the metering point. If the historical data is missing due to reasons such as line aging, it is difficult to repair the abnormal electricity consumption data through the data collected by the metering point. It is necessary to repair the abnormal electricity consumption data of the enterprise user by replacing the preset value. At the same time, in the case of missing historical data of the metering point, the abnormal type of the abnormal electricity consumption data with a zero value is identified as a situation caused by normal business adjustments of the enterprise user, and no repair is required.
[0078] Optionally, if there is no load data collected by the metering point at multiple sampling times, the method further includes:
[0079] Acquire the abnormal type of the abnormal power consumption data, where the abnormal type includes a negative value, a zero value, and a maximum value;
[0080] If the abnormal type of the abnormal power consumption data is a negative value or a zero value, the preset value is determined to be 0; if the abnormal type of the abnormal power consumption data is a maximum value, the preset value is determined to be the calculated power consumption obtained according to the installed capacity of the enterprise user;
[0081] The abnormal power usage data is replaced by corresponding preset values to repair the abnormal power usage data.
[0082] A negative value indicates that the current enterprise user's electricity consumption data is negative, while a zero value indicates that the current enterprise user's electricity consumption data is zero. At the same time, a maximum value indicates that the enterprise user's electricity consumption data is greater than the product of the enterprise user's installed capacity, available hours and output coefficient under full load. The available hours are specifically implemented as 24 hours, and the output coefficient is specifically implemented as 1.5. This proves that the current enterprise user's electricity consumption data is abnormally large, and therefore the abnormal type of the corresponding abnormal electricity consumption data is identified as a maximum value.
[0083] When the load data collected by the metering point at multiple sampling times cannot be obtained, the preset value corresponding to the abnormal type as a negative value or a zero value is replaced with 0, thereby repairing the abnormal electricity consumption data; when the abnormal type is a maximum value, the product of the enterprise user's installed capacity, the corrected output coefficient and the corrected hours is taken, and the result of the product is set to the preset value, among which the corrected output coefficient is specifically implemented as 0.98, and the corrected hours are set to 10.
[0084] For example, when the daily load data of an enterprise user cannot be obtained, when the abnormal type of the abnormal electricity consumption data is a zero value, it is considered that the 0 value is caused by normal business adjustments of the enterprise user and does not need to be repaired; when the abnormal type of the abnormal electricity consumption data is a negative value, 0 is used to replace the abnormal electricity consumption data; when the abnormal type of the abnormal electricity consumption data is a maximum value, the repair value is calculated using installed capacity*97%*10, and is used to replace the abnormal electricity consumption data.
[0085] Embodiment 2:
[0086] The present invention based on the same inventive concept also provides an enterprise electricity consumption data repair system based on metering point collection data, comprising:
[0087] A user acquisition unit, used to acquire abnormal power consumption data and acquire the enterprise user to which the abnormal power consumption data belongs;
[0088] A metering point acquisition unit, configured to obtain all metering points corresponding to the enterprise user by using the enterprise user to which the abnormal electricity consumption data belongs;
[0089] A user power acquisition unit is used to obtain the total power of the metering point on the day according to the load data collected by the metering point at multiple sampling times for each metering point; sum the total power of all metering points of the enterprise user on the day to obtain the total power of the enterprise user on the day;
[0090] The abnormal data repair unit is used to replace the abnormal power consumption data with the total power consumption of the enterprise user on that day.
[0091] Optionally, the system proposed by the present invention further includes:
[0092] The valid data confirmation unit is used to obtain the average value of the load data collected by the metering point at multiple sampling times before obtaining the total power consumption of the metering point on the day for each metering point based on the load data collected by the metering point at multiple sampling times. If the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, it is determined that the load data is valid.
[0093] Optionally, the system proposed by the present invention further includes:
[0094] The second data repair unit is used to obtain two load data with the same attribute type as the abnormal power consumption data from the historical data of the enterprise user when the load data is invalid, calculate the average value of the two load data, and use the average value to repair the abnormal power consumption data.
[0095] Optionally, the valid data confirmation unit proposed in the present invention is specifically used for:
[0096] Obtaining an average value of the load data collected by the metering point at multiple sampling times;
[0097] Calculate the product of the installed capacity of the enterprise user and the maximum output coefficient, and use the product as the maximum power consumption threshold of the enterprise user;
[0098] Comparing the maximum power consumption threshold of the enterprise user with the average value;
[0099] If the average value is less than the maximum power consumption threshold of the enterprise user, the load data is confirmed to be valid.
[0100] Optionally, the system proposed by the present invention further includes:
[0101] The load data acquisition unit is used to query the historical data of the metering point before acquiring the load data collected by the metering point at multiple sampling moments to confirm the existence of the load data collected by the metering point at multiple sampling moments.
[0102] Optionally, the system proposed by the present invention further includes:
[0103] The third data repair unit is configured to implement the following steps when there is no load data collected by the metering point at multiple sampling times:
[0104] Acquire the abnormal type of the abnormal power consumption data, where the abnormal type includes a negative value, a zero value, and a maximum value;
[0105] If the abnormal type of the abnormal power consumption data is a negative value or a zero value, the preset value is determined to be 0; if the abnormal type of the abnormal power consumption data is a maximum value, the preset value is determined to be the calculated power consumption obtained according to the installed capacity of the enterprise user;
[0106] The abnormal power usage data is replaced by corresponding preset values to repair the abnormal power usage data.
[0107] Optionally, in the system proposed by the present invention, the calculation process of summing the total daily electricity consumption of all metering points of the enterprise user by using the user electricity acquisition unit to obtain the total daily electricity consumption of the enterprise user satisfies the following expression:
[0108]
[0109] Wherein, w is the total electricity consumption of the enterprise user on that day; t is the t-th metering point of the enterprise user, t=1,…,n; n is the number of metering points of the enterprise user; i is the i-th sampling time, i=1,…,96; P i is the load data collected at the metering point at the i-th sampling time.
[0110] Embodiment 3:
[0111] like Figure 4As shown, the present invention also provides an electronic device, which may be a computer device, a single-chip device, an intelligent mobile device, etc. The electronic device in this embodiment may include a processor, a memory, a transceiver component, etc. The memory, the processor, and the transceiver component are connected via a bus; the memory may be used to store an execution program, and an exemplary execution program may include instructions; the processor is used to execute the instructions stored in the memory. The memory may also be used to store data, which may be called and / or modified when the instructions are executed.
[0112] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. It is the computing core and control core of the terminal, which is suitable for implementing one or more instructions, and is specifically suitable for loading and executing one or more instructions in a storage medium to implement a corresponding method flow or a corresponding function, so as to implement the steps of a method for repairing enterprise electricity consumption data based on data collected from metering points in the above embodiment.
[0113] Embodiment 4:
[0114] Based on the same inventive concept, the present invention also provides a readable storage medium, specifically an electronic device readable storage medium (Memory), which is a memory device in an electronic device for storing programs and data. It can be understood that the storage medium here can include both built-in storage media in electronic devices and, of course, extended storage media supported by electronic devices. The storage medium provides a storage space, which stores the operating system of the terminal. In addition, one or more instructions suitable for being loaded and executed by a processor are also stored in the storage space, and these instructions can be one or more execution programs (including program codes). It should be noted that the storage medium here can be a high-speed RAM memory or a non-volatile memory, such as at least one disk storage. The processor loads and executes one or more instructions stored in the storage medium, which can implement the steps of a method for repairing enterprise electricity consumption data based on data collected by metering points in the above embodiment.
[0115] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0116] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0117] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0118] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0119] The above are merely embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention are included in the scope of the claims of the present invention to be approved.
Claims
1. A method for repairing enterprise electricity consumption data based on data collected from metering points, characterized in that: include: Acquire abnormal power consumption data, and acquire the enterprise user to which the abnormal power consumption data belongs; Using the enterprise user to which the abnormal electricity consumption data belongs, all metering points corresponding to the enterprise user are obtained; For each of the metering points, the total electricity consumption of the metering point on that day is obtained according to the load data collected by the metering point at multiple sampling times; The total daily electricity consumption of all metering points of the enterprise user is summed up to obtain the total daily electricity consumption of the enterprise user; The abnormal electricity consumption data is replaced with the total electricity consumption of the enterprise user on that day.
2. The method according to claim 1, characterized in that Before the process of obtaining the total daily electricity consumption of each metering point according to the load data collected by the metering point at multiple sampling times for each metering point, the process further includes: An average value of the load data collected by the metering point at multiple sampling times is obtained. If the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, it is determined that the load data is valid.
3. The method according to claim 2, characterized in that If the load data is invalid, the method further comprises: In the historical data of the enterprise user, two load data with the same attribute type as the abnormal power consumption data are obtained, an average value of the two load data is calculated, and the abnormal power consumption data is repaired using the average value.
4. The method according to claim 2, characterized in that The obtaining an average value of the load data collected by the metering point at multiple sampling times, and determining that the load data is valid if the average value of the load data collected by the metering point at multiple sampling times is less than the maximum power consumption threshold of the enterprise user, includes: Obtaining an average value of the load data collected by the metering point at multiple sampling times; Calculate the product of the installed capacity of the enterprise user and the maximum output coefficient, and use the product as the maximum power consumption threshold of the enterprise user; Comparing the maximum power consumption threshold of the enterprise user with the average value; If the average value is less than the maximum power consumption threshold of the enterprise user, the load data is confirmed to be valid.
5. The method according to claim 2, characterized in that Before acquiring the load data collected by the metering point at multiple sampling moments, the method further includes: The historical data of the metering point is queried to confirm the existence of load data collected by the metering point at multiple sampling times.
6. The method according to claim 5, characterized in that If there is no load data collected by the metering point at multiple sampling times, the method further includes: Acquire the abnormal type of the abnormal power consumption data, where the abnormal type includes a negative value, a zero value, and a maximum value; If the abnormal type of the abnormal power consumption data is a negative value or a zero value, the preset value is determined to be 0; if the abnormal type of the abnormal power consumption data is a maximum value, the preset value is determined to be a calculated power consumption obtained according to the installed capacity of the enterprise user; The abnormal power usage data is replaced by corresponding preset values to repair the abnormal power usage data.
7. The method according to claim 1, characterized in that The calculation process of the total daily electricity consumption of the enterprise user satisfies the following expression: Wherein, w is the total electricity consumption of the enterprise user on that day; t is the t-th metering point of the enterprise user, t=1, ..., n; n is the number of metering points of the enterprise user; i is the i-th sampling time, i=1, ..., 96; P i is the load data collected by the metering point at the i-th sampling time.
8. An enterprise electricity consumption data repair system based on metering point data collection, characterized in that: include: A user acquisition unit, used to acquire abnormal power consumption data and acquire the enterprise user to which the abnormal power consumption data belongs; A metering point acquisition unit, configured to obtain all metering points corresponding to the enterprise user by using the enterprise user to which the abnormal electricity consumption data belongs; A user power acquisition unit is used to obtain the total power consumption of each metering point on the day according to the load data collected by the metering point at multiple sampling times; The total daily electricity consumption of all metering points of the enterprise user is summed up to obtain the total daily electricity consumption of the enterprise user; The abnormal data repair unit is used to replace the abnormal power consumption data with the total power consumption of the enterprise user on that day.
9. An electronic device, characterized in that: include: at least one processor and memory; The memory and the processor are connected via a bus; The memory is used to store one or more programs; When the one or more programs are executed by the at least one processor, a method for repairing enterprise electricity consumption data based on data collected at metering points as described in any one of claims 1 to 7 is implemented.
10. A readable storage medium, characterized in that: An execution program is stored thereon, and when the execution program is executed, a method for repairing enterprise electricity consumption data based on data collected at metering points as described in any one of claims 1 to 7 is implemented.
Citation Information
Patent Citations
Abnormal electric quantity data repairing method for electricity consumption information collecting system, and terminal device
CN108197156A
User electric quantity data restoration method based on load curve and historical electric quantity
CN110047014A
Enterprise abnormal electricity consumption discrimination algorithm based on electric quantity data analysis
CN116484302A
