Method, apparatus, electronic device and storage medium for processing abnormal data
By obtaining power outage information and incoming call information to supplement the abnormal load curve meter code and conducting data testing when necessary, the problems of low processing efficiency and large workload caused by abnormal meter code acquisition in the power grid metering automation system are solved, and rapid positioning and re-production are achieved, reducing the verification workload.
Patent Information
- Application Number
- CN202111546464.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-16
- Publication Date
- 2025-07-18
- Estimated Expiration
- 2041-12-16
AI Technical Summary
The grid metering automation system cannot quickly locate the problem of abnormal user meter code acquisition, resulting in low daily settlement processing efficiency, low automatic meter reading rate, and large workload for later data fitting verification.
By obtaining the original load curve code of the target user, and using power outage information and incoming call information to supplement the abnormal load curve code. If there is still data missing, data testing will be conducted until the complete target load curve code is obtained.
It realizes rapid positioning of abnormal problems and performs table code re-scoring, which reduces the verification workload and improves processing efficiency.
Smart Images

Figure CN114218204B_ABST
Abstract
Description
Technical Field
[0001] Embodiments of the present invention relate to power system technologies, and in particular, to a method, device, electronic device, and storage medium for processing abnormal data. Background Art
[0002] The power grid metering automation system provides multiple function entrances, through which relevant information such as the on-site terminal status of users, power outage warning information, real-time meter code data, and archive materials can be queried.
[0003] However, through the power grid metering automation system, it is impossible to quickly locate the problem of abnormal user meter code collection. Moreover, a large amount of real-time settlement data is generated in the daily clearing mode, and processing these real-time settlement data also brings a great workload to the staff, resulting in a low processing efficiency of metering collection faults. This will lead to the inability to perform daily settlement in a timely manner. Therefore, there are problems such as a low automatic meter reading rate and a large workload for subsequent data fitting verification. Summary of the Invention
[0004] Embodiments of the present invention provide a method, device, electronic device, and storage medium for processing abnormal data, so as to achieve the technical effect of locating abnormal problems through multiple methods and supplementing meter codes to reduce the verification workload.
[0005] In a first aspect, embodiments of the present invention provide a method for processing abnormal data, the method comprising:
[0006] Obtaining the original load curve meter codes corresponding to a target user within a preset date, and determining abnormal load curve meter codes with missing data according to the respective original load curve meter codes;
[0007] Obtaining the power outage information and power-on information stored in a target terminal corresponding to the abnormal load curve meter code, and supplementing the abnormal load curve meter code according to the power outage information and the power-on information to obtain a first load curve meter code;
[0008] If there is missing data in the first load curve meter code, data is called from the target terminal according to the first time point of data missing in the first load curve meter code to obtain first called data, and the first load curve meter code is processed according to the first called data to obtain a target load curve meter code.
[0009] In a second aspect, embodiments of the present invention further provide a device for processing abnormal data, the device comprising:
[0010] An abnormality determination module, configured to obtain the original load curve meter codes corresponding to a target user within a preset date, and determine abnormal load curve meter codes with missing data according to the respective original load curve meter codes;
[0011] A power outage update module, configured to obtain power outage information and power restoration information stored in a target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and the power restoration information to obtain a first load curve table code;
[0012] A first data acquisition module, configured to, if there is data missing in the first load curve table code, perform data acquisition on the target terminal according to a first time point at which data is missing in the first load curve table code to obtain first acquired data, and process the first load curve table code according to the first acquired data to obtain a target load curve table code.
[0013] In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:
[0014] One or more processors;
[0015] A storage device, configured to store one or more programs,
[0016] When the one or more programs are executed by the one or more processors, the one or more processors implement the method for processing abnormal data according to any one of the embodiments of the present invention.
[0017] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the method for processing abnormal data according to any one of the embodiments of the present invention is implemented.
[0018] The technical solution of the embodiment of the present invention obtains the original load curve table codes corresponding to target users within a preset date, determines abnormal load curve table codes with data missing according to each original load curve table code, obtains power outage information and power restoration information stored in a target terminal corresponding to the abnormal load curve table code, supplements the abnormal load curve table code according to the power outage information and the power restoration information to obtain a first load curve table code, if there is data missing in the first load curve table code, performs data acquisition on the target terminal according to a first time point at which data is missing in the first load curve table code to obtain first acquired data, and processes the first load curve table code according to the first acquired data to obtain a target load curve table code, solving the problems of large workload and low processing efficiency in manual data fitting verification, and achieving the technical effect of locating abnormal problems in multiple ways and supplementing data acquisition for the table codes to reduce the verification workload. BRIEF DESCRIPTION OF THE DRAWINGS
[0019] To more clearly illustrate the technical solutions of the exemplary embodiments of the present invention, the following briefly introduces the drawings required for describing the embodiments. Obviously, the introduced drawings are only the drawings of a part of the embodiments to be described by the present invention, rather than all the drawings. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings without creative efforts.
[0020] Figure 1 It is a schematic flowchart of a method for processing abnormal data provided in the first embodiment of the present invention;
[0021] Figure 2 It is a schematic flowchart of a method for processing abnormal data provided in the second embodiment of the present invention;
[0022] Figure 3 It is a schematic structural diagram of a device for processing abnormal data provided in the fourth embodiment of the present invention;
[0023] Figure 4 It is a schematic structural diagram of an electronic device provided in the fourth embodiment of the present invention. Detailed implementation manners
[0024] The present invention will be further described in detail below with reference to the drawings and embodiments. It can be understood that the specific embodiments described herein are only used to explain the present invention, rather than limiting the present invention. Additionally, it should be noted that for the sake of description, only the parts related to the present invention rather than all the structures are shown in the drawings.
[0025] Embodiment 1
[0026] Figure 1 It is a schematic flowchart of a method for processing abnormal data provided in the first embodiment of the present invention. This embodiment is applicable to the situation of supplementing abnormal data when there are abnormalities in the load curve table codes. This method can be executed by a device for processing abnormal data, and this device can be implemented in the form of software and / or hardware. The hardware can be an electronic device. Optionally, the electronic device can be a mobile terminal, a PC, a server, etc.
[0027] As Figure 1 described, the method of this embodiment specifically includes the following steps:
[0028] S110. Obtain the original load curve table codes corresponding to the target user within a preset date, and determine the abnormal load curve table codes with data missing according to each original load curve table code.
[0029] Among them, the preset date can be the date corresponding to the electricity quantity list for settlement. The target user(s) can be one or more settlement users. The original load curve table code can be the table code information uploaded by the electricity meter corresponding to the target user to the master station. The abnormal load curve table code can be the original load curve table code with data missing problems.
[0030] Specifically, obtain the information of the original load curve table code uploaded by the electricity meters of each target user to the master station within the preset date. For example: within 24 hours, one table code information per hour, etc. If there is data missing in the original load curve table code, then determine this original load curve table code as the abnormal load curve table code.
[0031] S120. Obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and power-on information to obtain the first load curve table code.
[0032] Among them, the target terminal can be the terminal device corresponding to the target user. The target terminal can obtain the table code of the electricity meter corresponding to the target user at regular intervals and upload it to the master station, and can also collect power outage information, power-on information, etc. The power outage information can include the power outage time, power outage reason, etc., and the power-on information can include the power-on time, etc. The first load curve table code can be the load curve table code after data supplementation of the abnormal load curve table code according to the power outage information and power-on information.
[0033] Specifically, obtain the power outage information and power-on information corresponding to the preset date uploaded by the target terminal corresponding to the abnormal load curve table code. If it is determined that there is a power outage situation within the preset date according to the power outage information and power-on information, then supplement the missing part of the data of the abnormal load curve table code according to the power outage and / or power-on time. For example: supplement the table code between the power outage time and the power-on time with the previously collected table code. Furthermore, regard the supplemented table code as the first load curve table code. If it is determined that there is no power outage situation within the preset date according to the power outage information and power-on information, then regard the abnormal load curve table code as the first load curve table code.
[0034] S130. If there is data missing in the first load curve table code, then according to the first time point of the data missing in the first load curve table code, conduct data polling on the target terminal to obtain the first polled data, and process the first load curve table code according to the first polled data to obtain the target load curve table code.
[0035] Among them, the first time point can be the time point corresponding to the missing data in the first load curve table code. The first polled data can be the data at the first time point obtained through the target terminal. The target load curve table code can be the table code after supplementing the missing data.
[0036] Specifically, if there is missing data in the first load curve table code, data can be recalled through the target terminal. It can be to determine the first time points corresponding to each missing data in the first load curve table code, send an instruction to the target terminal, so that the target terminal recalls the data at each first time point to obtain the first recalled data. Furthermore, add the first recalled data to the first load curve table code, supplement the data in the first load curve table code, and use the obtained table code as the target load curve table code.
[0037] The technical solution of the embodiment of the present invention is to obtain the original load curve table code corresponding to the target user within the preset date, determine the abnormal load curve table code with missing data according to each original load curve table code, obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and power-on information to obtain the first load curve table code. If there is missing data in the first load curve table code, data is recalled from the target terminal according to the first time point of the missing data in the first load curve table code to obtain the first recalled data, and the first load curve table code is processed according to the first recalled data to obtain the target load curve table code, which solves the problems of large workload and low processing efficiency of manual data fitting verification, and realizes the technical effect of locating abnormal problems through various methods and supplementing the collection of table codes to reduce the verification workload.
[0038] Embodiment 2
[0039] Figure 2 It is a flowchart of a method for processing abnormal data provided by the second embodiment of the present invention. On the basis of the above embodiments, the processing methods for various situations that occur in data supplementation and recall can refer to the technical solution of this embodiment. Among them, the explanations of the same or corresponding terms as those in the above embodiments will not be repeated here.
[0040] As Figure 2 described, the method of this embodiment specifically includes the following steps:
[0041] S201. Obtain the original load curve table code corresponding to the target user within the preset date, and determine the abnormal load curve table code with missing data according to each original load curve table code.
[0042] S202. Determine the working state of the target terminal corresponding to the abnormal load curve table code. If the working state is an offline state, send the user information corresponding to the target terminal to the operation and maintenance system so that the target terminal is in an online state.
[0043] Among them, the working status can be an online status or an offline status. The user information can include the household number, terminal location, etc. The operation and maintenance system can be an electronic system used by the operation and maintenance team.
[0044] Specifically, obtain the working status of the target terminal corresponding to the abnormal load curve table code. If the working status is the online status, then subsequent operations can be performed. If the working status is the offline status, it indicates that the target terminal cannot be used. At this time, send the user information corresponding to the target terminal to the operation and maintenance system, so that the operation and maintenance personnel can process the target terminal in the offline status and make it in the online status for subsequent data retrieval.
[0045] S203. Obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and power-on information to obtain the first load curve table code.
[0046] Specifically, obtain the power outage information and power-on information corresponding to the preset date uploaded by the target terminal corresponding to the abnormal load curve table code. Furthermore, determine whether the data loss is caused by a power outage according to the power outage information and power-on information. If so, the abnormal load curve table code can be supplemented to obtain the first load curve table code.
[0047] Optionally, the abnormal load curve table code can be supplemented according to the power outage information and power-on information in the following manner to obtain the first load curve table code:
[0048] Step 1. Have the power supply department review the power outage information and power-on information. If the review is passed, enter the target power outage event based on the power outage information and power-on information.
[0049] Among them, the target power outage event can be a power outage event reviewed within the preset date.
[0050] Specifically, upload the power outage information and power-on information recorded by the target terminal to the power supply department for confirmation and review. If the review is passed, it indicates that the recorded power outage situation is true, and enter the power outage information and power-on information into the target power outage event.
[0051] Step 2. Supplement the abnormal load curve table code based on the target power outage event to obtain the first load curve table code.
[0052] Specifically, according to the target power outage event, determine the time points in the abnormal load curve table code corresponding to the target power outage event, and complete the table code information at these time points. For example: complete it as the table code at the previous valid moment to obtain the first load curve table code.
[0053] S204. If there is missing data in the first load curve table code, according to the first time point of the missing data in the first load curve table code, data is called for measurement from the target terminal to obtain the first called-for measurement data, and the first load curve table code is processed according to the first called-for measurement data.
[0054] S205. If there is still missing data in the processed first load curve table code, according to the second time point of the missing data in the processed first load curve table code, it is judged whether there is a target real-time table code in the original real-time table code corresponding to the original load curve table code that matches the second time point. If not, execute S206; if so, execute S207.
[0055] Among them, the second time point can be the time point corresponding to the missing data in the processed first load curve table code. The original real-time table code can be the table code obtained by collecting the electricity meter table code based on the time of the target terminal and uploading it to the master station. The target real-time table code can be the table code corresponding to the second time point.
[0056] Specifically, if there is still missing data in the processed first load curve table code, determine the second time point where there is still missing data, and obtain the original real-time table code corresponding to the original load curve table code. Judge whether there is table code information at the second time point in the original real-time table code. If so, it is possible that data loss occurred in the table code uploaded by the electricity meter and supplementary collection can be performed. If not, it is possible that there is a power outage situation that has not been reported and further verification is required.
[0057] S206. If the table code difference between two adjacent real-time table codes adjacent to the second time point in the original real-time table code is within the preset range, send the second time point and the user information corresponding to the target terminal to the power supply department to judge whether there is a power outage at the second time point, and execute S210.
[0058] Among them, the adjacent real-time table codes can be two valid table codes adjacent to the second time point in the original real-time table code. The preset range can be a relatively small preset table code difference, which can be set according to the actual electricity consumption situation of the target user.
[0059] Specifically, obtain two valid table codes adjacent to the second time point in the original real-time table code as the adjacent real-time table codes, determine the table code difference between these two adjacent real-time table codes, and judge whether the difference is within the preset range. If so, it indicates that neither the electricity meter nor the target terminal has collected the data at the second time point, and there may be a power outage at the second time point, but the target terminal has not sent the power outage information. At this time, the second time point and the user information corresponding to the target terminal can be sent to the power supply department so that the power supply department can verify the situation and return to determine whether there is a power outage at the second time point. If so, record the target power outage event and update the first compliance curve table code. If not, subsequent operations can be performed.
[0060] S207. If there is a spare real-time meter code corresponding to the target user within the preset date in the spare terminal corresponding to the target terminal, data is called from the spare terminal to obtain spare called data, the processed first load curve meter code is updated based on the spare called data, and the spare terminal is set as the main terminal instead of the target terminal.
[0061] Among them, the target user can be equipped with two terminals, one as the main terminal, that is, the target terminal, for collecting meter codes and reporting to the main station, and the other as the spare terminal for collecting meter codes. The spare real-time meter code can be the meter code collected by the spare terminal based on the time of the spare terminal. The spare called data can be the data called by the spare terminal.
[0062] Specifically, if there is a spare terminal corresponding to the target terminal, it can be determined whether the spare real-time meter code corresponding to the target user stored in the spare terminal is complete. If the spare real-time meter code is complete, data can be called from the spare terminal to obtain spare called data, the processed first load curve meter code is updated through the spare called data, and the identifiers of the main terminal and the spare terminal are swapped for subsequent use of the spare terminal as the target terminal. If not, both the main terminal and the spare terminal can be restarted and then data is called, or information is generated and sent to the staff to enable the staff to handle this situation manually.
[0063] S208. If there is no spare terminal corresponding to the target terminal, the target terminal is reset and restarted. After the target terminal is reset and restarted, data is called from the target terminal to obtain second called data, and the processed first load curve meter code is processed according to the second called data.
[0064] Among them, the second called data can be the data called after the target terminal is reset and restarted.
[0065] Specifically, if there is no spare terminal corresponding to the target terminal, the target terminal can be reset and restarted. After the target terminal is reset and restarted, for example, 5 minutes after the reset and restart, data is called from the target terminal again, and the obtained data is used as the second called data. Furthermore, the missing data in the processed first load curve meter code is supplemented and processed according to the second called data.
[0066] S209. If the second retrieved data does not exist, restore the parameter configuration in the target terminal to the factory settings and restart it. After the target terminal restarts, configure the parameters of the target electric meter corresponding to the target terminal into the target terminal. After a preset time, perform data retrieval on the target terminal to obtain the third retrieved data, and process the processed first load curve table code according to the third retrieved data.
[0067] Among them, the parameter configuration can be parameters such as the corresponding relationship between the target terminal and the electric meter. Restoring the factory settings can be erasing all parameter configurations. The preset time can be the time waiting for the target terminal to restart and restore its functions, for example, it can be 30 minutes, etc. The third retrieved data can be the data retrieved after the target terminal is reset and restarted.
[0068] Specifically, if the second retrieved data does not exist, it may be that the configuration information in the target terminal is incorrect. At this time, the parameter configuration in the target terminal can be restored to the factory settings and restarted. After the target terminal restarts, reconfigure the parameter configuration in the target terminal. You can wait for a certain period of time, for example: wait for 30 minutes, etc., and try to perform data retrieval on the target terminal again. The obtained data is used as the third retrieved data. Furthermore, supplement and process the missing data in the processed first load curve table code according to the third retrieved data.
[0069] S210. Obtain the target load curve table code according to the processed first load curve table code.
[0070] It should be noted that if there are still problems with missing data in the target load curve table code, the staff can be notified for manual processing.
[0071] As an alternative implementation of the above embodiments, the embodiments of the present invention provide another method for processing abnormal data. Among them, the explanations of the same or corresponding terms as those in the above embodiments will not be repeated here.
[0072] The method specifically includes the following steps:
[0073] 1. Query the settlement users with abnormal load curve table codes collected within the preset date in the metering automation system.
[0074] 2. According to the list of current offline terminals exported, match and screen out the user information with missing load curve table code collection caused by terminal offline, and transfer it to the operation and maintenance team for on-site processing.
[0075] 3. By querying the power outage alarm and power-on alarm (power outage information and power-on information) sent by the terminal, match and screen out the users with missing load curve table code collection caused by power outage, and transfer them to the power supply department to verify the power outage situation and supervise the entry of the power outage event (target power outage event) into the system.
[0076] 4. For users whose terminals are running online but have abnormal data collection, query through the metering automation system the time points (first time points) of the missing load curve table codes of the user within the preset date, attempt to supplement the missing table codes by data calling, save the retrieved load curve table codes (first retrieved data), and verify and confirm the successful supplement.
[0077] 5. For users who cannot retrieve the load curve table codes, query the collection status of the real-time table codes (target real-time table codes) of the user corresponding to the preset date. If both the real-time table codes and the load curve table codes are missing in the same time period and the difference in the meter readings before and after the table code missing is small, it is preliminarily judged that the user's site may have experienced a power outage but the terminal did not send a power outage alarm. Transfer it to the power supply department to verify the power outage situation and supervise the entry of the power outage event into the system.
[0078] 6. For users who cannot retrieve the load curve table codes but have complete real-time table code collection, use a hierarchical processing method.
[0079] The first-level method: Query through the metering automation system whether the user is configured with a primary and standby dual terminal. If there is a standby terminal (backup terminal) and the backup terminal has complete collection of the load curve table codes, modify the primary and standby terminal identifiers of the user so that the primary terminal of the user has complete collection of the load curve table codes.
[0080] The second-level method: If there is no standby terminal or the backup terminal also has missing load curve table codes, perform a background reset and restart of the user's terminal through the metering automation system. After waiting for 5 minutes, attempt again to supplement the missing table codes by data calling, save the retrieved load curve table codes (second retrieved data), and verify and confirm the successful supplement.
[0081] The third-level method: For users who still cannot retrieve the load curve table codes after the terminal restart, restore all the parameters of the user's terminal to the factory settings and restart it again through the metering automation system. After the restart, set the meter parameters under the terminal back to the terminal and set the terminal collection task. After waiting for 30 minutes, attempt again to supplement the missing table codes by data calling, save the retrieved load curve table codes (third retrieved data), and verify and confirm the successful supplement.
[0082] In the technical solution of the embodiment of the present invention, by obtaining the original load curve table codes corresponding to the target users within a preset date, and determining the abnormal load curve table codes with missing data according to the original load curve table codes, determining the working state of the target terminal corresponding to the abnormal load curve table codes. If the working state is an offline state, the user information corresponding to the target terminal is sent to the operation and maintenance system to make the target terminal in an online state, obtaining the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table codes, and supplementing the abnormal load curve table codes according to the power outage information and the power-on information to obtain the first load curve table codes. If there is missing data in the first load curve table codes, according to the first time point of the missing data in the first load curve table codes, data is called from the target terminal to obtain the first called data, and the first load curve table codes are processed according to the first called data. If there is still missing data in the processed first load curve table codes, according to the second time point of the missing data in the processed first load curve table codes, it is judged whether there is a target real-time table code in the original real-time table codes corresponding to the original load curve table codes that matches the second time point, and then multi-level processing is carried out in different cases according to the judgment result to obtain the target load curve table codes, which solves the problems of large workload and low processing efficiency of manual data fitting verification, and realizes the technical effect of locating abnormal problems and supplementing the table codes in multiple ways to reduce the verification workload.
[0083] Embodiment 4
[0084] Figure 3 FIG. 7 is a structural schematic diagram of a device for processing abnormal data provided by Embodiment 4 of the present invention. The device includes: an abnormality determination module 310, a power outage update module 320, and a first call module 330.
[0085] Among them, the abnormality determination module 310 is configured to obtain the original load curve table codes corresponding to the target users within a preset date, and determine the abnormal load curve table codes with missing data according to the original load curve table codes; the power outage update module 320 is configured to obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table codes, and supplement the abnormal load curve table codes according to the power outage information and the power-on information to obtain the first load curve table codes; the first call module 330 is configured to, if there is missing data in the first load curve table codes, according to the first time point of the missing data in the first load curve table codes, call data from the target terminal to obtain the first called data, and process the first load curve table codes according to the first called data to obtain the target load curve table codes.
[0086] Optionally, the device further includes: a terminal status detection module, configured to determine the working status of a target terminal corresponding to the abnormal load curve table code; if the working status is an offline status, send the user information corresponding to the target terminal to an operation and maintenance system, so that the target terminal is in an online status.
[0087] Optionally, the power outage update module 320 is further configured to audit the power outage information and the power restoration information via a power supply department, and if the audit is passed, record a target power outage event based on the power outage information and the power restoration information; supplement the abnormal load curve table code based on the target power outage event to obtain a first load curve table code.
[0088] Optionally, the device further includes: a power outage detection module, configured to, if there is still data missing in the processed first load curve table code, determine whether there is a target real-time table code in the original real-time table code corresponding to the original load curve table code that matches the second time point according to the second time point of the data missing in the processed first load curve table code; if the target real-time table code does not exist and the code difference between two adjacent real-time table codes adjacent to the second time point in the original real-time table code is within a preset range, send the second time point and the user information corresponding to the target terminal to the power supply department to determine whether there is a power outage at the second time point.
[0089] Optionally, the device further includes: a primary / standby replacement module, configured to, if the target real-time table code exists and there is a standby real-time table code corresponding to a target user within a preset date in a standby terminal corresponding to the target terminal, perform data polling on the standby terminal to obtain standby polled data, update the processed first load curve table code based on the standby polled data, and set the standby terminal to replace the target terminal as the primary terminal.
[0090] Optionally, the device further includes: a second polling module, configured to, if the target real-time table code exists and there is no standby terminal corresponding to the target terminal, reset and restart the target terminal; after the target terminal completes the reset and restart, perform data polling on the target terminal to obtain second polled data, and process the processed first load curve table code according to the second polled data.
[0091] Optionally, the device further includes: a third data calling module, configured to, if the second called data does not exist, restore the parameter configuration in the target terminal to the factory settings and restart the target terminal. After the target terminal restarts, configure the parameters of the target electric meter corresponding to the target terminal into the target terminal, and after a preset time, perform data calling on the target terminal to obtain third called data, and process the processed first load curve table code according to the third called data.
[0092] In the technical solution of the embodiment of the present invention, by obtaining the original load curve table codes corresponding to the target users within a preset date, and determining the abnormal load curve table codes with missing data according to each original load curve table code, obtaining the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table codes, and supplementing the abnormal load curve table codes according to the power outage information and power-on information to obtain the first load curve table code. If there is missing data in the first load curve table code, data calling is performed on the target terminal according to the first time point of the missing data in the first load curve table code to obtain the first called data, and the first load curve table code is processed according to the first called data to obtain the target load curve table code, which solves the problems of large workload and low processing efficiency of manual data fitting verification, and realizes the technical effect of locating abnormal problems through various methods and supplementing the collection of table codes to reduce the verification workload.
[0093] The abnormal data processing device provided by the embodiment of the present invention can execute the abnormal data processing method provided by any embodiment of the present invention, and has the corresponding functional modules and beneficial effects for executing the method.
[0094] It should be noted that the various units and modules included in the above device are only divided according to the functional logic, but are not limited to the above division, as long as the corresponding functions can be realized; in addition, the specific names of the functional units are only for the convenience of mutual distinction and do not limit the protection scope of the embodiment of the present invention.
[0095] Embodiment 4
[0096] Figure 4 It is a schematic structural diagram of an electronic device provided by Embodiment 4 of the present invention. Figure 4 It shows a block diagram of an exemplary electronic device 40 suitable for implementing the implementation manner of the embodiment of the present invention. Figure 4 The shown electronic device 40 is only an example and should not bring any limitation to the functions and usage scope of the embodiment of the present invention.
[0097] Such as Figure 4As shown, the electronic device 40 is presented in the form of a general-purpose computing device. The components of the electronic device 40 may include, but are not limited to: one or more processors or processing units 401, a system memory 402, and a bus 403 that connects different system components (including the system memory 402 and the processing unit 401).
[0098] The bus 403 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus structures. By way of example, these architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.
[0099] The electronic device 40 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device 40, including volatile and non-volatile media, removable and non-removable media.
[0100] The system memory 402 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 404 and / or cache memory 405. The electronic device 40 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, a storage system 406 can be used for reading and writing on non-removable, non-volatile magnetic media ( Figure 4 not shown, typically referred to as a "hard disk drive"). Although Figure 4 not shown in the figure, a disk drive for reading and writing on a removable non-volatile disk (such as a "floppy disk"), and an optical disk drive for reading and writing on a removable non-volatile optical disk (such as a CD-ROM, DVD-ROM, or other optical media) can be provided. In these cases, each drive can be connected to the bus 403 through one or more data media interfaces. The system memory 402 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the embodiments of the present invention.
[0101] A program / utility 408 having a set (at least one) of program modules 407 can be stored, for example, in the system memory 402. Such program modules 407 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. The program modules 407 generally execute the functions and / or methods in the embodiments described in the present invention.
[0102] The electronic device 40 can also communicate with one or more external devices 409 (such as a keyboard, a pointing device, a display 410, etc.), and can also communicate with one or more devices that enable a user to interact with the electronic device 40, and / or communicate with any device that enables the electronic device 40 to communicate with one or more other computing devices (such as a network card, a modem, etc.). Such communication can be carried out through an input / output (I / O) interface 411. Moreover, the electronic device 40 can also communicate with one or more networks (such as a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) through a network adapter 412. As shown in the figure, the network adapter 412 communicates with other modules of the electronic device 40 through a bus 403. It should be understood that although Figure 4 not shown in the figure, other hardware and / or software modules can be used in combination with the electronic device 40, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, etc.
[0103] The processing unit 401 executes various functional applications and data processing by running programs stored in the system memory 402, such as implementing the method for processing abnormal data provided in the embodiments of the present invention.
[0104] Embodiment Five
[0105] Embodiment Five of the present invention also provides a storage medium containing computer-executable instructions, and the computer-executable instructions are used to execute a method for processing abnormal data when executed by a computer processor. The method includes:
[0106] Obtain the original load curve table codes corresponding to the target user within a preset date, and determine the abnormal load curve table codes with data missing according to each original load curve table code;
[0107] Obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and the power-on information to obtain a first load curve table code;
[0108] If there is data missing in the first load curve table code, then according to the first time point of data missing in the first load curve table code, perform data polling on the target terminal to obtain first polled data, and process the first load curve table code according to the first polled data to obtain a target load curve table code.
[0109] The computer storage medium of the embodiments of the present invention may adopt any combination of one or more computer-readable media. The computer-readable media may be computer-readable signal media or computer-readable storage media. The computer-readable storage media may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. More specific examples (a non-exhaustive list) of the computer-readable storage media include: an electrical connection having one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, the computer-readable storage media may be any tangible medium that contains or stores a program, which can be used by or in conjunction with an instruction execution system, apparatus, or device.
[0110] The computer-readable signal media may include data signals propagated in a baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. The computer-readable signal media may also be any computer-readable media other than the computer-readable storage media, which can send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.
[0111] The program code contained on the computer-readable media may be transmitted by any appropriate medium, including but not limited to wireless, wire, optical fiber cable, RF, etc., or any suitable combination of the above.
[0112] The computer program code for performing the operations of the embodiments of the present invention may be written in one or more programming languages or combinations thereof. The programming languages include object-oriented programming languages such as Java, Smalltalk, C++, and also include conventional procedural programming languages such as the "C" language or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, executed as an independent software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).
[0113] Note that the above is only a preferred embodiment of the present invention and the technical principles applied. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein. Various obvious changes, re-adjustments, and substitutions can be made by those skilled in the art without departing from the protection scope of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments. Without departing from the concept of the present invention, more other equivalent embodiments can be included, and the scope of the present invention is determined by the scope of the appended claims.
Claims
1. A method for processing abnormal data, characterized in that, Including: Obtain the original load curve table codes corresponding to the target users within a preset date, and determine the abnormal load curve table codes with missing data according to each original load curve table code; Obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and the power-on information to obtain the first load curve table code; If there is missing data in the first load curve table code, according to the first time point of the missing data in the first load curve table code, perform data polling on the target terminal to obtain the first polled data, and process the first load curve table code according to the first polled data to obtain the target load curve table code; After processing the first load curve table code according to the first polled data, it further includes: If there is still missing data in the processed first load curve table code, according to the second time point of the missing data in the processed first load curve table code, determine whether there is a target real-time table code in the original real-time table code corresponding to the original load curve table code that matches the second time point; If the target real-time table code does not exist and the code difference between the two adjacent real-time table codes adjacent to the second time point in the original real-time table code is within the preset range, send the second time point and the user information corresponding to the target terminal to the power supply department to determine whether there is a power outage at the second time point.
2. The method according to claim 1, wherein Before obtaining the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, it further includes: Determine the working state of the target terminal corresponding to the abnormal load curve table code; If the working state is an offline state, send the user information corresponding to the target terminal to the operation and maintenance system to make the target terminal in an online state.
3. The method according to claim 1, wherein The supplementing the abnormal load curve table code according to the power outage information and the power-on information to obtain the first load curve table code includes: The power supply department audits the power outage information and the power-on information. If the audit passes, enter the target power outage event based on the power outage information and the power-on information; Supplement the abnormal load curve table code based on the target power outage event to obtain the first load curve table code.
4. The method according to claim 1, characterized in that, It further includes: If the target real-time table code exists and there is a backup real-time table code corresponding to the target user within the preset date in the backup terminal corresponding to the target terminal, perform data polling on the backup terminal to obtain the backup polled data, update the processed first load curve table code based on the backup polled data, and replace the backup terminal with the target terminal as the main terminal.
5. The method according to claim 1, characterized in that, It further includes: If the target real-time table code exists and there is no backup terminal corresponding to the target terminal, reset and restart the target terminal. After the target terminal completes the reset and restart, perform data polling on the target terminal to obtain the second polled data, and process the processed first load curve table code according to the second polled data.
6. The method according to claim 5, characterized in that, It further includes: If the second polled data does not exist, restore the parameter configuration in the target terminal to the factory settings and restart it. After the target terminal restarts, configure the parameters of the target electric meter corresponding to the target terminal into the target terminal, and after a preset time, perform data polling on the target terminal to obtain the third polled data, and process the processed first load curve table code according to the third polled data.
7. A processing device for abnormal data, characterized in that, It includes: An anomaly determination module, configured to obtain the original load curve table codes corresponding to the target user within a preset date, and determine the abnormal load curve table codes with missing data according to each original load curve table code; A power outage update module, configured to obtain the power outage information and power-on information stored in the target terminal corresponding to the abnormal load curve table code, and supplement the abnormal load curve table code according to the power outage information and the power-on information to obtain the first load curve table code; A first polling module, configured to, if there is missing data in the first load curve table code, perform data polling on the target terminal according to the first time point of the missing data in the first load curve table code, obtain the first polled data, and process the first load curve table code according to the first polled data to obtain the target load curve table code; A power outage detection module, configured to, if there is still missing data in the processed first load curve table code, determine whether there is a target real-time table code in the original real-time table code corresponding to the original load curve table code that matches the second time point according to the second time point of the missing data in the processed first load curve table code; If the target real-time table code does not exist and the code difference between the two adjacent real-time table codes adjacent to the second time point in the original real-time table code is within a preset range, send the second time point and the user information corresponding to the target terminal to the power supply department to determine whether there is a power outage at the second time point.
8. An electronic device, characterized in that, The electronic device includes: One or more processors; A storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method for processing abnormal data as described in any one of claims 1-6.
9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the method for processing abnormal data as described in any one of claims 1-6.
Citation Information
Patent Citations
Method and device for realizing rapid storage, search and complementation for self-described fixed point records of power distribution terminal
CN106557550A
Supplemental recording method for electric energy meter load curve
CN109490618A