Zone area ammeter replacement monitoring method and device based on power grid system, and electronic equipment

Abstract

According to the transformer area ammeter replacement monitoring method and device based on the power grid system and the electronic equipment provided by the invention, the method comprises the steps of firstly obtaining ammeter data information of a plurality of transformer areas, then calculating transformer area abnormal indexes corresponding to the transformer areas according to the ammeter data information, and determining the transformer area of which the transformer area abnormal indexes meet a preset condition as a target meter replacement transformer area; the target meter replacement station area is quickly locked by collecting the data of the electric meters in multiple station areas in real time and quantitatively calculating the abnormal indexes of the station areas, and the real-time performance of obtaining the electric meter replacement information is effectively improved. According to the method, the meter replacement information table is obtained based on the meter data information of the target meter replacement area, the meter replacement process information in the meter replacement process is obtained based on the meter replacement information table, a traditional manual one-by-one operation storage mode is replaced, and the acquisition efficiency of the meter replacement information is greatly improved. And finally, the meter replacement process information is stored according to a preset storage template, reliable data support is provided for subsequent operation and maintenance management, and the overall operation and maintenance efficiency of the electric meter replacement service is further optimized.

Description

Technical Field

[0001] This application relates to the field of power system technology, and in particular to a method, device and electronic equipment for monitoring the replacement of transformer substation meters based on a power grid system. Background Technology

[0002] In the power system, power supply companies need to monitor and analyze the electricity consumption behavior of users within their jurisdiction in real time to ensure the integrity, timeliness, and accuracy of electricity meter data. Meter replacement is a crucial part of the daily operation and maintenance of power supply companies.

[0003] In related technologies, the method involves periodically logging into the power grid metering platform, capturing meter replacement data and exporting it to a spreadsheet, and then processing the spreadsheet data to obtain meter replacement information.

[0004] However, the aforementioned technologies suffer from poor real-time performance and low efficiency in the process of obtaining meter replacement information. Summary of the Invention

[0005] This application provides a method, device, and electronic device for monitoring the replacement of transformer substation meters based on a power grid system, in order to solve the problems of poor real-time performance and low efficiency in the acquisition of meter replacement information in related technologies.

[0006] In a first aspect, embodiments of this application provide a method for monitoring the replacement of substation meters based on a power grid system, including:

[0007] Obtain electricity meter data information from multiple transformer substations;

[0008] Based on the electricity meter data, calculate the abnormal indicators for each transformer area.

[0009] The transformer substations whose abnormal indicators meet the preset conditions are identified as target meter replacement substations.

[0010] Based on the meter data information of the target meter replacement area, a meter replacement information table is obtained;

[0011] Based on the meter replacement information table, obtain the meter replacement process information during the meter replacement process;

[0012] Store the table replacement process information according to the preset storage template.

[0013] In one possible implementation, the transformer area anomaly indicator is data coverage; based on meter data, the transformer area anomaly indicator for each area is calculated, including:

[0014] The data coverage rate for each transformer substation is obtained by comparing the number of user meters whose data can be successfully collected with the total number of user meters.

[0015] Accordingly, transformer substations whose abnormal indicators meet preset conditions are identified as target meter replacement substations, including:

[0016] The stations with data coverage less than the first preset threshold are identified as target meter replacement stations.

[0017] In one possible implementation, the transformer area anomaly index is the abnormal power outage rate; based on meter data, the transformer area anomaly index corresponding to each transformer area is calculated, including:

[0018] The abnormal power outage rate for each transformer substation is obtained by comparing the number of user meters experiencing abnormal power outages with the total number of user meters.

[0019] Accordingly, transformer substations whose abnormal indicators meet preset conditions are identified as target meter replacement substations, including:

[0020] The transformer substations with an abnormal power outage rate greater than the second preset threshold are identified as target meter replacement substations.

[0021] In one possible implementation, a meter replacement information table is obtained based on the meter data information of the target meter replacement area, including:

[0022] Based on the meter data information of the target meter replacement area, an online verification document is generated for the confirmation of the meter replacement area;

[0023] Identify the target users for form replacement based on the online verification document;

[0024] Based on the user meter data of the target meter replacement users, a meter replacement information table is obtained.

[0025] In one possible implementation, the method further includes:

[0026] Obtain new meter replacement plans for the power grid system;

[0027] The new meter replacement plan is determined based on the matching results between the new meter replacement plan and the meter data information of the distribution area;

[0028] Based on the meter data information of the newly added meter distribution area, the information on the new meter replacement process is obtained;

[0029] Store the information about adding or replacing tables according to the preset storage template.

[0030] In one possible implementation, the meter replacement process information includes at least one of the following: meter replacement user, meter replacement personnel information, meter replacement time, energy data of the new meter, and operating status of the new meter.

[0031] Secondly, embodiments of this application provide a monitoring device for the replacement of transformer substation meters based on a power grid system, comprising:

[0032] The acquisition module is used to acquire meter data information from multiple transformer substations.

[0033] The calculation module is used to calculate the abnormal indicators of each transformer area based on the meter data.

[0034] The determination module is used to identify transformer areas whose abnormal indicators meet preset conditions as target meter replacement areas;

[0035] The determination module is also used to obtain a meter replacement information table based on the meter data information of the target meter replacement area;

[0036] The acquisition module is also used to acquire meter replacement process information based on the meter replacement information table.

[0037] The storage module is used to store table replacement process information according to a preset storage template.

[0038] In one possible implementation, the anomaly indicator for the transformer area is data coverage; the calculation module is specifically used for:

[0039] The data coverage rate for each transformer substation is obtained by comparing the number of user meters whose data can be successfully collected with the total number of user meters.

[0040] Accordingly, the module is specifically used for:

[0041] The stations with data coverage less than the first preset threshold are identified as target meter replacement stations.

[0042] In one possible implementation, the transformer area anomaly index is the abnormal power outage rate; the calculation module is specifically used for:

[0043] The abnormal power outage rate for each transformer substation is obtained by comparing the number of user meters experiencing abnormal power outages with the total number of user meters.

[0044] Accordingly, the module is specifically used for:

[0045] The transformer substations with an abnormal power outage rate greater than the second preset threshold are identified as target meter replacement substations.

[0046] In one possible implementation, the determining module is specifically used for:

[0047] Based on the meter data information of the target meter replacement area, an online verification document is generated for the confirmation of the meter replacement area;

[0048] Identify the target users for form replacement based on the online verification document;

[0049] Based on the user meter data of the target meter replacement users, a meter replacement information table is obtained.

[0050] In one possible implementation, the method further includes:

[0051] The acquisition module is also used to acquire new meter replacement plans for the power grid system;

[0052] The determination module is also used to determine the new meter distribution area based on the matching results between the new meter replacement plan and the meter data information of the distribution area;

[0053] The determination module is also used to obtain information about the new meter replacement process based on the meter data information of the newly added meter distribution area;

[0054] The storage module is also used to store information about the addition and replacement of tables according to a preset storage template.

[0055] In one possible implementation, the meter replacement process information includes at least one of the following: meter replacement user, meter replacement personnel information, meter replacement time, energy data of the new meter, and operating status of the new meter.

[0056] Thirdly, embodiments of this application provide an electronic device, including: a processor, and a memory communicatively connected to the processor;

[0057] The memory stores instructions that the computer executes;

[0058] The processor executes computer-executable instructions stored in memory to implement the method as described in the first aspect or any of the above.

[0059] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, are used to implement the method described in the first aspect or any of the above-mentioned methods.

[0060] Fifthly, embodiments of this application provide a computer program. The computer program product includes a computer program stored in a computer-readable storage medium. At least one processor can read the computer program from the computer-readable storage medium. When the at least one processor executes the computer program, it can implement the methods described in the first aspect or any of the above-mentioned methods.

[0061] The method, device, and electronic equipment for monitoring meter replacement in power grid systems provided in this application first acquire meter data from multiple distribution areas. Then, based on the meter data, it calculates the corresponding abnormal indicators for each distribution area. Distribution areas whose abnormal indicators meet preset conditions are identified as target replacement areas. By collecting meter data from multiple distribution areas in real time and quantifying the abnormal indicators, the target replacement areas are quickly located, effectively solving the problem of poor real-time acquisition of meter replacement information. Based on the meter data from the target replacement area, a replacement information table is obtained. Based on the replacement information table, the meter replacement process information is acquired. The collection and standardized storage of the replacement process information replaces the traditional manual operation mode, significantly improving the efficiency of meter replacement information acquisition. Finally, the replacement process information is stored according to a preset storage template, providing reliable data support for subsequent operation and maintenance management, further optimizing the overall operation and maintenance efficiency of the meter replacement business. Attached Figure Description

[0062] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0063] Figure 1 A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 1 ;

[0064] Figure 2 A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 2 ;

[0065] Figure 3 A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 3 ;

[0066] Figure 4 A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 4 ;

[0067] Figure 5 A schematic diagram of the structure of the power grid system-based transformer substation meter replacement monitoring device provided in this application embodiment;

[0068] Figure 6 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application.

[0069] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0070] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0071] Before introducing the embodiments of this application, the application background of the embodiments of this application will be explained first:

[0072] In the power system, power supply companies need to monitor and analyze the electricity consumption behavior of users within their jurisdiction in real time to ensure the integrity, timeliness, and accuracy of electricity meter data. Meter replacement is a crucial part of the daily operation and maintenance of power supply companies, involving tens of thousands of meter replacements annually. The meter replacement process requires collaboration among multiple systems, including metering platforms and marketing business platforms, to complete the entire process of meter replacement planning, execution tracking, data replenishment, and record updates.

[0073] However, in related technologies, the monitoring and execution of meter replacement work are often significantly delayed due to issues such as low efficiency of manual operations, data silos between systems, and limitations of automated processes. For example, the metering platform has a long data update cycle, making it impossible to reflect the meter replacement status of the distribution area in real time. Robotic automation processes rely on fixed interface elements, are easily affected by changes in the system interface, and can only handle a small number of devices, making it difficult to meet the needs of large-scale meter replacement.

[0074] In one related technology, power supply companies, after applying for data access through the data feedback library of the metering platform, directly access the backend database using program statements to filter and assemble the meter replacement event list, user information, and electricity consumption data to generate a meter replacement area analysis report. This solution relies on manually writing complex program logic, and due to the long data update cycle, it cannot reflect the meter replacement status in real time. Furthermore, the power supply company's data analysis rules need to be implemented programmatically, resulting in high computational resource consumption and difficulty in flexibly adapting to changes in business rules.

[0075] In another related technology, Robotic Process Automation (RPA) is used to periodically log into the metering platform, retrieve data from specified pages, export Excel templates, and then process the data through an automated process. While this solution can achieve partial automation, it has significant drawbacks:

[0076] Strong interface dependency: RPA executes operations by recognizing page elements. Once the layout or element identifiers of the metering platform interface change, the process becomes invalid and the script needs to be adjusted frequently.

[0077] Poor portability: RPA requires a dedicated executor and cannot be flexibly deployed to different environments.

[0078] Inefficient: The RPA recall function can only operate on no more than 10 devices at a time, and scheduled tasks are prone to reverting to the login state due to prolonged periods without page refresh, requiring manual intervention.

[0079] Incomplete process coverage: It can only realize data export and recall, and cannot cover the entire process of work order status update, parameter configuration, and file verification.

[0080] In summary, the aforementioned technologies suffer from poor real-time performance and low efficiency in the process of obtaining meter replacement information.

[0081] To address the technical problems existing in related technologies, the inventors of this application propose the following solution: The acquisition of meter replacement information suffers from poor real-time performance and low efficiency. Relying on the data resources of multiple power grid systems, the system first acquires meter data information from various distribution areas through cross-system data interaction channels, covering core indicators such as meter reading data and power outage status data. Then, by quantifying these core indicators, it calculates abnormal indicators for distribution areas, such as data coverage rate and abnormal power outage rate. Distribution areas meeting preset threshold conditions are accurately identified as target meter replacement areas, enabling rapid identification of meter replacement needs. Simultaneously, it correlates with new meter replacement plans in the power grid, matching distribution area data to determine new replacement areas, ensuring no monitoring omissions. For target replacement areas, an online verification document is generated to identify target replacement users. User basic files and meter data are integrated to form a meter replacement information table, thereby capturing the entire meter replacement process information, including user information, replacement personnel information, new meter energy data, and operating status. Finally, the information is stored in a standardized manner according to a preset template. This solution combines cross-system collaboration with automated data processing, breaking through the limitations of traditional manual data collection and decentralized monitoring. It significantly improves the real-time performance and efficiency of meter replacement information acquisition, providing technical support for the standardized operation and maintenance of meter replacement services in power grid systems.

[0082] The parts not described in detail are disclosed in the following embodiments.

[0083] The technical solution of this application will now be described in detail through specific embodiments. It should be noted that the following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments.

[0084] The subject of this application is an electronic device, which may specifically be a server, terminal device, etc.

[0085] Figure 1A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 1 ,like Figure 1 As shown, the method may include the following steps:

[0086] Step 11: Obtain meter data information from multiple transformer substations.

[0087] In this step, meter data from multiple distribution areas in the power grid system is acquired synchronously through a pre-defined cross-system data interaction channel, enabling centralized collection of multi-source meter data.

[0088] The meter data includes the transformer substation number, meter status data, and meter user information.

[0089] For example, a communication link built on an interpreted, object-oriented, dynamically typed high-level programming language (Python) framework connects the metering platform, marketing business platform, and online document platform in the power grid system. The metering platform retrieves 15-minute meter status data for all users' meters in each distribution area in real time. The marketing business platform obtains the total number of meters and basic user profiles for each distribution area. Historical meter replacement feedback data is synchronized from the online document platform as supplementary reference. For instance, for distribution area TQ-001, the latest 15-minute meter reading data for 120 users' meters in that area is obtained in real time through the metering platform interface, while the basic information for the total number of meters in that area (120) is retrieved from the marketing platform, ensuring the completeness and relevance of data collection. During the data collection process, the Python Data Analysis Library (Pandas) tool is used for data format standardization, unifying field naming and data types, laying the foundation for subsequent calculations and analysis.

[0090] For example, meter status data includes voltage, current, power, meter reading time, and data acquisition status. Meter user information includes user ID, electricity usage category, and meter model.

[0091] In addition, the application system for the monitoring of electricity meter replacement in the distribution area requires some preliminary preparations before operation. First, based on a configuration file consistent with the system program installation path, it obtains information such as the system login account, operating system version, and operating environment parameters to complete system permission verification and operating environment adaptation, ensuring compliance and compatibility after system startup. Then, through a preset database connection protocol, it establishes a stable communication link with the metering platform, marketing business platform, and online document platform to synchronously retrieve meter data information related to the meter replacement business, opening up cross-platform data interaction channels and providing a data benchmark for subsequent processes. Finally, it loads the system's front-end interactive interface, completes the rendering of interface elements and initialization of function entry points, providing meter replacement operators with a visual entry point for business operations and process monitoring.

[0092] Step 12: Calculate the abnormal indicators for each transformer area based on the meter data.

[0093] In this step, based on the meter data, the abnormal indicators of each transformer area are quantitatively calculated through a preset algorithm to achieve quantitative determination of meter replacement needs. The calculation process is processed in parallel by multiple threads to improve the computational efficiency of massive transformer area data.

[0094] Among them, the abnormal indicators for the transformer area are data coverage rate and abnormal power outage rate.

[0095] Specifically, step 12 can include the following implementation methods:

[0096] Step 1: Based on the ratio of the number of user meters whose data can be successfully collected to the total number of user meters, obtain the data coverage rate for each transformer area.

[0097] In this implementation, the raw data collected from the metering platform and marketing business platform is first cleaned and standardized using Python's Pandas library. Invalid records with duplicate meter numbers, abnormal meter reading times, or missing data fields are removed. The naming of the fields in "User Meter Count Statistics" is unified (e.g., the "meter number" in the metering platform and the "meter number" in the marketing business platform are unified as "User Meter Unique Identifier") to ensure the consistency of data statistics.

[0098] Then, for each transformer substation, two types of core data are extracted from the preprocessed dataset: one is the number of user meters whose meter data can be successfully collected; the other is the total number of user meters, which is the total number of all user meters registered and filed in the transformer substation (including meters that are in normal operation and waiting to be replaced but not removed) retrieved from the marketing business platform.

[0099] Finally, according to the preset formula "Data Coverage Rate = (Number of user meters whose data can be successfully collected ÷ Total number of user meters) × 100%", batch calculations are performed on each transformer area. The calculation process uses a multi-threaded parallel processing mechanism to perform calculations on massive amounts of transformer area data simultaneously, avoiding the efficiency bottleneck caused by single-threaded processing.

[0100] Step 2: Identify the stations with data coverage less than the first preset threshold as target meter replacement stations.

[0101] Under this implementation, based on the actual scenario requirements of the power grid meter rotation business, the default value of the first preset threshold is 50%. This threshold can be dynamically adjusted according to the type of transformer area and the time of electricity consumption. The threshold adjustment can be achieved through the parameter configuration module of the front-end visual interface without modifying the underlying code, thus adapting to different business scenarios.

[0102] Then, the data coverage results are calculated for all transformer substations, and the coverage value of each substation is compared with the currently configured first preset threshold. If the data coverage of a certain substation is less than the first preset threshold, it indicates that there is a large amount of missing meter reading data in that substation, which meets the typical characteristics of meter offline and data collection interruption caused by meter replacement construction, and is judged as a suspected meter replacement substation. After verification by on-site staff from the online document platform, it is officially confirmed as a target meter replacement substation. For substations determined to be target meter replacement substations, key data such as their substation number, total number of user meters, number of meters that can successfully collect data, data coverage value, and threshold configuration information are automatically associated to generate a "Preliminary Judgment List of Target Meter Replacement Substations", which is simultaneously pushed to the marketing business platform and the online document platform to provide data support for subsequent on-site staff verification and work order dispatch.

[0103] Specifically, step 12 can include the following implementation methods:

[0104] S1. Based on the ratio of the number of user meters experiencing abnormal power outages to the total number of user meters, the abnormal power outage rate corresponding to each transformer area is obtained.

[0105] Under this implementation, the number of user meters experiencing abnormal power outages is the total number of user meters in the transformer area whose status is marked as "abnormal power outage"; the total number of user meters is the total number of user meters registered in the transformer area obtained from the marketing business platform, ensuring the integrity of the statistical base.

[0106] Following the preset formula "Abnormal power outage rate = (Number of user meters with abnormal power outages ÷ Total number of user meters) × 100%", Pandas' batch processing capabilities combined with multi-threading mechanisms are used to perform calculations simultaneously on all transformer substations, avoiding efficiency lag caused by massive data processing. During the calculation process, the status update time of each abnormally outage meter is automatically recorded to ensure data timeliness.

[0107] S2. The transformer substations with an abnormal power outage rate greater than the second preset threshold are identified as target meter replacement substations.

[0108] Under this implementation, considering the actual business scenario of power grid meter replacement construction, the default value of the second preset threshold is 50%. This threshold can be dynamically adjusted based on the power consumption attributes and regional characteristics of the distribution area. The abnormal power outage rate calculation results for all distribution areas are iterated, and the value for each distribution area is compared one by one with the currently configured second preset threshold. If the abnormal power outage rate of a certain distribution area is greater than the second preset threshold, it indicates that there are a large number of unplanned centralized power outages for user meters in that area, which meets the characteristics of power outage operations during batch meter replacement construction, and is therefore identified as a suspected meter replacement area. Subsequently, the information for this distribution area is pushed to the online document platform for on-site maintenance personnel to verify and confirm whether meter replacement construction is underway. After verification, it is officially designated as the target meter replacement area.

[0109] Step 13: Identify the transformer areas whose abnormal indicators meet the preset conditions as target meter replacement areas.

[0110] In this step, a first preset threshold and a second preset threshold are first set. By comparing the abnormal indicators of the transformer area with the thresholds, the target transformer area for meter replacement is accurately located.

[0111] The first preset threshold is the data coverage threshold, which is set to 50% by default and can be dynamically adjusted according to the transformer substation type and power consumption period. The second preset threshold is the abnormal power outage rate threshold, which is set to 50% by default and can be adjusted as needed.

[0112] For example, if the data coverage rate of a certain transformer substation is less than the first preset threshold, it indicates that there is a large amount of missing meter reading data in that substation, and it is identified as a suspected meter replacement substation (i.e., the target meter replacement substation). If the abnormal power outage rate of a certain transformer substation is greater than the second preset threshold, it indicates that a large number of user meters in that substation are experiencing power outages, which meets the typical characteristics of meter replacement construction, and it is also identified as a suspected meter replacement substation.

[0113] Step 14: Based on the meter data information of the target meter replacement area, obtain the meter replacement information table.

[0114] In this step, firstly, based on the meter data information of the target meter replacement area, a standardized online verification document is generated through an online document platform. The document includes information such as the area number, the total number of meters for users in the target meter replacement area, the meter numbers for which data was not successfully collected, and the meter numbers for which power is out. This document is used by on-site staff for online confirmation. After the on-site staff confirms the target meter replacement user through the online verification document, the system automatically associates the user's user number, electricity category, meter model, historical meter reading data, area number, and other core information, and integrates them into a meter replacement information table according to a preset field format.

[0115] For example, for the TQ-001 target meter replacement area, after on-site verification, 50 meters were confirmed to be meters to be replaced. Then, the user information and related data corresponding to these 50 meters were automatically extracted to generate a meter replacement information table containing fields such as area number, user number, meter number, electricity consumption category, historical maximum electricity consumption, and reason for meter replacement, to ensure the integrity and traceability of the meter replacement information.

[0116] Step 15: Based on the meter replacement information table, obtain the meter replacement process information during the meter replacement process.

[0117] In this step, the meter replacement information table serves as the data index. Through cross-platform collaboration and automated data collection (e.g., metering platform and marketing business platform), key information throughout the meter replacement process is captured. During the replacement process, by connecting to the marketing business platform, real-time dispatch information for meter replacement work orders can be obtained, including the name, employee number, and contact information of the replacement personnel. The online document platform receives feedback from on-site replacement personnel regarding completion, providing information such as start and end times. The metering platform automatically collects 15 minutes of energy data from the newly replaced meter (e.g., voltage, current, and power data from the first meter reading after replacement) and operational status information such as communication and online status. The dispatch information obtained from the marketing business platform, the meter replacement information recorded on the online document platform, and the energy data collected from the metering platform together constitute the complete meter replacement process information.

[0118] Specifically, the information for the meter replacement process includes at least one of the following: the user replacing the meter, the personnel replacing the meter, the time of the meter replacement, the energy data of the new meter, and the operating status of the new meter.

[0119] Step 16: Store the table replacement process information according to the preset storage template.

[0120] In this step, a standardized preset storage template is used to structure and store the table replacement process information, ensuring data security and reusability. By establishing a stable connection with the marketing business platform database, the structured table replacement process information is written to the database in batches according to the template fields, achieving persistent data storage. At the same time, a data storage log is generated, recording information such as storage time, storage status, and operators, facilitating subsequent data traceability and verification.

[0121] The preset storage template is designed based on the power grid business data management specifications and includes fixed fields such as transformer area number, user number, meter number, meter replacement personnel information, meter replacement time, new meter energy data, new meter operating status, and data storage time. It also supports the expansion of custom fields according to business needs.

[0122] For example, the table replacement process information of the TQ-001 area is organized according to the preset template fields and then written into the marketing business platform database in batches. The storage time is recorded as 2024-05-20 10:30 and the storage status is recorded as successful, so as to ensure the standardized management and quick retrieval of the table replacement process information.

[0123] The method for monitoring meter replacement in power grid systems provided in this application first acquires meter data from multiple distribution areas. Then, based on the meter data, it calculates the corresponding abnormal indicators for each distribution area. Distribution areas whose abnormal indicators meet preset conditions are identified as target replacement areas. By collecting meter data from multiple distribution areas in real time and quantifying the abnormal indicators, the method quickly identifies the target replacement areas, effectively solving the problem of poor real-time acquisition of meter replacement information. Based on the meter data from the target replacement areas, a replacement information table is obtained. Based on this table, the replacement process information is acquired. The collection and standardized storage of this information replaces the traditional manual operation mode, significantly improving the efficiency of meter replacement information acquisition. Finally, the replacement process information is stored according to a preset storage template, providing reliable data support for subsequent operation and maintenance management, further optimizing the overall operation and maintenance efficiency of the meter replacement business.

[0124] Based on the above embodiments, Figure 2 A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 2 ,like Figure 2 As shown, the method may include the following steps:

[0125] Step 21: Based on the meter data information of the target meter replacement area, generate an online verification document for the confirmation of the meter replacement area.

[0126] In this step, the meter data information of the target meter replacement area is filled into a preset structured template (such as a basic information column, anomaly analysis column, meter details column, and confirmation column), and an online verification document is automatically generated through the online document platform API.

[0127] The online verification document supports keyword search and status filtering. It automatically highlights abnormal data such as mismatch between meter number and area file, and meter reading time not updated for more than 72 hours. It also configures hierarchical access permissions, allowing viewing and confirmation permissions only to the corresponding on-site maintenance personnel and business managers. The system pushes document links and provides 24-hour verification deadline reminders through system messages to ensure efficient and compliant verification.

[0128] Step 22: Identify the target users for form replacement based on the online verification document.

[0129] In this step, based on the meter details in the online verification document, a list of suspected meter replacement users with data collection failures, abnormal power outages, and no planned power outage records is automatically filtered out. The abnormality type and duration of each meter are noted. On-site staff log in to the online document platform with mobile terminals, retrieve the list, and go to the target meter replacement area to conduct an on-site inspection. They verify whether the meter actually exists, whether the old meter has been removed or a new meter has been installed due to meter replacement construction, and rule out non-meter replacement scenarios such as meter failure and user-initiated power outages. The verification results are entered into the document in real time, and on-site photos are uploaded simultaneously as evidence to identify the target meter replacement users.

[0130] Step 23: Based on the user meter data of the target meter replacement users, obtain the meter replacement information table.

[0131] In this step, using the unique identifier of the user's meter data as an index, information from multiple dimensions, including user basic files, old meter information, meter replacement construction data, and verification data, is collected across metering platforms, marketing business platforms, and online document platforms. The Pandas library is used to standardize field formats, remove duplicate data, and complete missing fields. Following the preset template of the power grid business specifications, a meter replacement information table is generated, containing required fields such as "transformer area number, user number, old meter information, new meter information, construction information, and verification information." This table is automatically synchronized to the business database for persistent storage, supports export to Excel format, and establishes data association with the metering and marketing platforms, allowing for quick querying and retrieval via the user number.

[0132] The method for monitoring meter replacement in power grid systems provided in this application first generates an online verification document for confirming the target meter replacement area based on the meter data information. This replaces the traditional decentralized data verification mode, reduces the time-consuming manual verification, improves the confirmation efficiency of target meter replacement users, and solves the problem of low efficiency in obtaining meter replacement information. Then, the target meter replacement users are determined based on the online verification document. Finally, based on the user meter data of the target meter replacement users, a meter replacement information table is obtained, laying a standardized foundation for subsequent information collection and storage in the meter replacement process, and further improving the information processing efficiency of the entire meter replacement business process.

[0133] Based on the above embodiments, Figure 3 A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 3 ,like Figure 3 As shown, the method may also include the following steps:

[0134] Step 31: Obtain the new meter replacement plan for the power grid system.

[0135] In this step, the interface of the meter replacement plan management module of the marketing business platform is called to capture the data of newly approved meter replacement plans in the power grid system in real time, ensuring the timeliness and authority of the data acquisition. Pre-set data validation rules automatically filter out unapproved and invalid plan records. Simultaneously, the Pandas library is used to standardize the format of the collected structured data, unifying field naming and data types, and comparing it with historical meter replacement plan data to avoid duplicate collection, ultimately yielding the new meter replacement plan.

[0136] The newly added meter replacement plan data includes core fields such as: plan number, affected transformer area number, planned meter replacement time range, target meter replacement user list, planned replacement meter model, responsible construction team and contact information, etc.

[0137] Step 32: Based on the matching results between the new meter replacement plan and the meter data information of the distribution area, determine the new meter distribution area.

[0138] In this step, the transformer substation number in the new meter replacement plan is used as the core matching keyword to perform multi-dimensional correlation and matching between the new meter replacement plan data and the collected meter data of each transformer substation. Using Python's multi-threaded matching algorithm, the comparison and calculation of massive amounts of data is quickly completed, generating a list of matching results. The substations that successfully match are identified as the new meter substations.

[0139] The associated matching dimensions include: consistency verification of transformer area number, whether the electricity meters of the target users to be replaced in the plan are registered in the transformer area, and whether the current operating status of the electricity meters matches the planned meter replacement requirements (such as whether they are old electricity meters, whether there are any abnormal historical data records, etc.).

[0140] Step 33: Based on the meter data information of the newly added meter area, obtain the information on the new meter replacement process.

[0141] In this step, the meter replacement staff installs the electricity meters for users in the newly added meter distribution area, and records the meter data information of the newly added meter distribution area to obtain the information of the meter replacement process.

[0142] The information included in the form replacement process includes the basic profile of the user, the progress data of the form replacement construction, the operation data of the new form, and the signature of the user.

[0143] Integrate data from multiple platforms to generate information on the process of adding and replacing forms, enabling full data traceability throughout the form replacement process.

[0144] Specifically, the system retrieves basic user profiles (name, electricity address, electricity type) and old meter asset information (model, serial number, service life, last valid meter reading) for the target meter replacement area from the marketing business platform; construction progress data (actual entry time, old meter removal time, new meter installation time, construction personnel employee number) from the construction management module; real-time new meter operation data (first meter reading after installation, communication status, online status) from the metering platform; and the storage path for supporting materials such as on-site construction photos and user-signed confirmation forms from the online document platform. The system integrates and correlates these multi-source data using the Pandas library, organizing them into a hierarchical structure of "area-user-meter" to form new meter replacement process information containing core fields such as "plan number, area number, user number, old meter information, new meter information, construction process data, new meter operation status, and supporting material path," ensuring data integrity and relevance.

[0145] Step 34: Store the information about the newly added table replacement process according to the preset storage template.

[0146] In this step, the newly added table replacement process information is stored in the metering platform, marketing business platform, and online document platform according to the preset storage template and the corresponding transmission protocol.

[0147] Afterwards, real-time operating indicators of the meters (such as current load and power supply stability) from the newly added meter replacement process information are pushed to the maintenance personnel to help them keep abreast of the operating status of the transformer area. A summary of the meter replacement process information table is pushed to the business handlers to help them keep abreast of users' meter replacement information. The verification results of the transformer area's basic records in the meter replacement process information table are pushed to the record management personnel to correct any discrepancies in the records and ensure the accuracy of the meter replacement business. After the meter replacement is completed, a process completion notification is pushed to the relevant responsible persons, synchronizing information such as the equipment status and data recovery status after the meter replacement, completing the business closed-loop notification.

[0148] The method for monitoring meter replacement in power grid systems provided in this application obtains the new meter replacement plan of the power grid system, and then determines the new meter distribution area based on the matching result between the new meter replacement plan and the meter data information of the distribution area. By actively obtaining the new meter replacement plan of the power grid and accurately matching it with the meter data of the distribution area, the method avoids the disconnect between the plan and the actual data, solves the problem of delayed meter replacement information acquisition, and improves the real-time performance of information. Based on the meter data information of the new meter distribution area, the method obtains the new meter replacement process information, and finally stores the new meter replacement process information according to a preset storage template, replacing the traditional mode of manually following up on the plan and collecting statistical information, and significantly improving the efficiency of information acquisition for new meter replacement business.

[0149] In one possible implementation, Figure 4A flowchart illustrating the monitoring method for replacing substation meters based on a power grid system provided in this application embodiment. Figure 4 ,like Figure 4 As shown, this method includes a system initialization phase, a multi-platform data acquisition phase, a multi-threaded automated process concurrency phase, and a phase for real-time information alerts from multiple channels for primary steel production. The work content of each phase is as follows:

[0150] 1. System initialization phase:

[0151] After the process starts, the system initialization operation is performed first. During this stage, four core preparatory tasks are completed in parallel:

[0152] Read basic configuration: Obtain information such as system login account and operating system adaptation parameters to ensure program compliance and compatibility.

[0153] Connect to the database: retrieve historical data of table replacement, base information such as station area archives, and provide basic support for subsequent data comparison.

[0154] Connect multiple business platforms: Establish communication links with the metering platform, marketing business platform, and online document platform to open up cross-system data channels.

[0155] Startup interface: Loads a visual operation entry point, supporting maintenance personnel to monitor the process status in real time.

[0156] 2. Multi-platform data acquisition phase:

[0157] Based on the established cross-system channels, data from multiple sources of electricity meters is collected in parallel. Basic information on distribution areas, energy consumption data, and meter outage information are obtained from the metering platform. Meter replacement plan data is obtained from the marketing platform.

[0158] After summarizing the above data, the target meter replacement area is determined by the judgment logic of the abnormal indicators of the transformer area (data coverage rate, abnormal power outage rate), so as to achieve accurate identification of meter replacement needs.

[0159] 3. Multi-threaded automated process development phase:

[0160] For the target form-changing area, automated operations are executed in parallel using multi-threading:

[0161] Automatically acquire meter data information for the target meter replacement area.

[0162] The data will be automatically transferred to the marketing business platform for online viewing by the personnel who are changing the forms.

[0163] By using an online document platform to record information about the form replacement process and automatically uploading it to the marketing business platform for structured storage, the entire form replacement process can be digitally tracked.

[0164] 4. Real-time information alerts from multiple channels:

[0165] Push operational metrics for the meter replacement plan area to maintenance personnel.

[0166] The process information of the meter replacement area and users is summarized and pushed to the business handler.

[0167] The results of the verification of basic archives in the district were sent to the archive management personnel.

[0168] Push notifications to relevant personnel regarding the completion of the form replacement process to ensure that all roles are kept informed of the business progress.

[0169] The following are embodiments of the apparatus described in this application, which can be used to execute the embodiments of the method described in this application. For details not disclosed in the apparatus embodiments of this application, please refer to the embodiments of the method described in this application.

[0170] Figure 5 This is a schematic diagram of the structure of a power grid system-based substation meter replacement monitoring device provided in an embodiment of this application. Figure 5 As shown, the device includes:

[0171] Module 51 is used to acquire meter data information from multiple transformer substations.

[0172] Calculation module 52 is used to calculate the abnormal indicators of each transformer area based on the meter data information.

[0173] The determination module 53 is used to determine the transformer area whose abnormal indicators meet the preset conditions as the target meter replacement transformer area;

[0174] The determination module 53 is also used to obtain a meter replacement information table based on the meter data information of the target meter replacement area;

[0175] The acquisition module 51 is also used to acquire meter replacement process information during the meter replacement process based on the meter replacement information table;

[0176] Storage module 54 is used to store table replacement process information according to a preset storage template.

[0177] In one possible implementation, the anomaly indicator for the transformer area is data coverage; the calculation module 52 is specifically used for:

[0178] The data coverage rate for each transformer substation is obtained by comparing the number of user meters whose data can be successfully collected with the total number of user meters.

[0179] Accordingly, module 53 is specifically used for:

[0180] The stations with data coverage less than the first preset threshold are identified as target meter replacement stations.

[0181] In one possible implementation, the transformer area anomaly index is the abnormal power outage rate; the calculation module 52 is specifically used for:

[0182] The abnormal power outage rate for each transformer substation is obtained by comparing the number of user meters experiencing abnormal power outages with the total number of user meters.

[0183] Accordingly, module 53 is specifically used for:

[0184] The transformer substations with an abnormal power outage rate greater than the second preset threshold are identified as target meter replacement substations.

[0185] In one possible implementation, the determining module 53 is specifically used for:

[0186] Based on the meter data information of the target meter replacement area, an online verification document is generated for the confirmation of the meter replacement area;

[0187] Identify the target users for form replacement based on the online verification document;

[0188] Based on the user meter data of the target meter replacement users, a meter replacement information table is obtained.

[0189] In one possible implementation, the method further includes:

[0190] The acquisition module 51 is also used to acquire new meter replacement plans for the power grid system;

[0191] The determination module 53 is also used to determine the new meter distribution area based on the matching results between the new meter replacement plan and the meter data information of the distribution area;

[0192] The determination module 53 is also used to obtain the new meter replacement process information based on the meter data information of the newly added meter area;

[0193] Storage module 54 is also used to store information about the new table replacement process according to a preset storage template.

[0194] In one possible implementation, the meter replacement process information includes at least one of the following: meter replacement user, meter replacement personnel information, meter replacement time, energy data of the new meter, and operating status of the new meter.

[0195] The apparatus provided in this application embodiment can be used to execute the determination method in any of the above embodiments. Its implementation principle and technical effect are similar, and will not be described again here.

[0196] It should be noted that the division of the various modules in the above device is merely a logical functional division. In actual implementation, they can be fully or partially integrated into a single physical entity, or they can be physically separated. Furthermore, these modules can be implemented entirely in software via processing element calls; they can be fully implemented in hardware; or some modules can be implemented in software via processing element calls, while others are implemented in hardware. Additionally, these modules can be fully or partially integrated together, or implemented independently. The processing element here can be an integrated circuit with signal processing capabilities. During implementation, each step of the above method or each of the above modules can be completed through the integrated logic circuits in the hardware of the processor element or through software instructions.

[0197] Figure 6 This is a schematic diagram of the structure of the electronic device provided in the embodiments of this application, such as... Figure 6 As shown, the electronic device may include: a processor 61, a memory 62, and computer program instructions stored in the memory 62 and executable on the processor 61. When the processor 61 executes the computer program instructions, it implements the method provided in any of the foregoing embodiments.

[0198] Optionally, the various components of the electronic device can be connected via a system bus.

[0199] The memory 62 can be a separate memory unit or a memory unit integrated into the processor 61. The number of processors 61 can be one or more.

[0200] It should be understood that processor 61 can be a Central Processing Unit (CPU), or other general-purpose processor 61, digital signal processor 61 (DSP), application-specific integrated circuit (ASIC), etc. The general-purpose processor 61 can be a microprocessor 61, or any conventional processor 61. The steps of the method disclosed in this application can be directly manifested as being executed by the hardware processor 61, or being executed by a combination of hardware and software modules within the processor 61.

[0201] The system bus can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. The system bus can be divided into address bus, data bus, control bus, etc. For ease of representation, only one thick line is used in the diagram, but this does not indicate that there is only one bus or one type of bus. Memory 62 may include random access memory (RAM) 62, and may also include non-volatile memory (NVM) 62, such as at least one disk storage device 62.

[0202] All or part of the steps of the above method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a readable memory 62. When the program is executed, it performs the steps of the above method embodiments; and the aforementioned memory 62 (storage medium) includes: read-only memory 62 (ROM), RAM, flash memory 62, hard disk, solid-state hard disk, magnetic tape, floppy disk, optical disk, and any combination thereof.

[0203] The electronic device provided in this application embodiment can be used to execute the method provided in any of the above method embodiments. Its implementation principle and technical effect are similar, and will not be repeated here.

[0204] This application provides a computer-readable storage medium storing computer instructions that, when executed on a computer, cause the computer to perform the above-described method.

[0205] The aforementioned computer-readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory, electrically erasable programmable read-only memory, erasable programmable read-only memory, programmable read-only memory, read-only memory, magnetic storage, flash memory, magnetic disk, or optical disk. The readable storage medium can be any available medium accessible to a general-purpose or special-purpose computer.

[0206] Optionally, a readable storage medium can be coupled to a processor, enabling the processor to read information from and write information to the readable storage medium. Alternatively, the readable storage medium can be an integral part of the processor. Both the processor and the readable storage medium can reside in an Application Specific Integrated Circuit (ASIC). Alternatively, the processor and the readable storage medium can exist as discrete components within the device.

[0207] This application also provides a computer program product, which includes a computer program stored in a computer-readable storage medium. At least one processor can read the computer program from the computer-readable storage medium, and the at least one processor can implement the above-described method when executing the computer program.

[0208] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this application is limited only by the appended claims.

Claims

1. A method for monitoring the replacement of transformer substation meters based on a power grid system, characterized in that, include: Obtain electricity meter data information from multiple transformer substations; Based on the meter data, calculate the abnormal indicators for each transformer area; The transformer substations whose abnormal indicators meet the preset conditions are identified as target meter replacement substations. Based on the meter data information of the target meter replacement area, a meter replacement information table is obtained; Based on the meter replacement information table, obtain the meter replacement process information during the meter replacement process; The table replacement process information is stored according to a preset storage template.

2. The method according to claim 1, characterized in that, The abnormal indicator for the transformer substation is the data coverage rate; the calculation of the abnormal indicator for each transformer substation based on the meter data information includes: The data coverage rate for each transformer substation is obtained by the ratio of the number of user meters whose data can be successfully collected to the total number of user meters. Accordingly, determining the transformer substations whose abnormal indicators meet preset conditions as target meter replacement substations includes: The stations with data coverage less than a first preset threshold are identified as the target meter replacement stations.

3. The method according to claim 1, characterized in that, The abnormal indicator for the transformer substation is the abnormal power outage rate; the calculation of the abnormal indicator for each transformer substation based on the meter data includes: The abnormal power outage rate for each transformer substation is obtained by comparing the number of user meters experiencing abnormal power outages with the total number of user meters. Accordingly, determining the transformer substations whose abnormal indicators meet preset conditions as target meter replacement substations includes: The transformer substations with an abnormal power outage rate greater than a second preset threshold are identified as the target meter replacement substations.

4. The method according to claim 1, characterized in that, Based on the meter data information of the target meter replacement area, a meter replacement information table is obtained, including: Based on the meter data information of the target meter replacement area, an online verification document for confirming the meter replacement area is generated; The target users for form replacement are identified based on the online verification document. The meter replacement information table is obtained based on the user meter data of the target meter replacement user.

5. The method according to claim 1, characterized in that, The method further includes: Obtain the new meter replacement plan for the power grid system; Based on the matching results between the new meter replacement plan and the meter data information of the distribution area, the new meter distribution area is determined; Based on the meter data information of the newly added meter distribution area, the information on the new meter replacement process is obtained; The information about the newly added table replacement process is stored according to the preset storage template.

6. The method according to claim 1, characterized in that, The meter replacement process information includes at least one of the following: meter replacement user, meter replacement personnel information, meter replacement time, power data of the new meter, and operating status of the new meter.

7. A monitoring device for the replacement of electricity meters in a power grid system, characterized in that, include: The acquisition module is used to acquire meter data information from multiple transformer substations. The calculation module is used to calculate the abnormal indicators of each transformer area based on the meter data information. The determination module is used to determine the transformer areas whose abnormal indicators meet preset conditions as target meter replacement areas; The determining module is further configured to obtain a meter replacement information table based on the meter data information of the target meter replacement area; The acquisition module is also used to acquire meter replacement process information during the meter replacement process based on the meter replacement information table; The storage module is used to store the table replacement process information according to a preset storage template.

8. An electronic device, characterized in that, include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory to implement the method as described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method as described in any one of claims 1 to 6.

10. A computer program, characterized in that, The computer program includes a computer program stored in a computer-readable storage medium, which at least one processor can read from the computer-readable storage medium, and which, when executing the computer program, can implement the method described in any one of claims 1 to 7.

Images