Power grid outage data comparison method and device based on RPA and AI

Abstract

The present application discloses a method and device for comparing power outage data of a power grid based on RPA and AI. Among them, the method is applied to an RPA robot. The method includes: obtaining power outage data and medium voltage data; matching the power outage data with the medium voltage data according to matching rules; in response to the power outage data matching the medium voltage data, exporting and storing the medium voltage data that meets the matching rules; in response to the power outage data not matching the medium voltage data, exporting and storing the power outage data that does not meet the matching rules. The present application can compare and process the power outage data with the medium voltage data according to the matching rules, and obtain and store the data that meets the matching rules and does not meet the matching rules respectively. Solve the problems of low efficiency and high error rate when manually processing power outage data of the power grid, and reduce labor costs.

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a method and device for comparing power grid outage data based on RPA and AI. Background Art

[0002] RPA (Robotic Process Automation) uses specific "robot software" to simulate human operations on computers and automatically execute process tasks according to rules.

[0003] AI (Artificial Intelligence) is a technical science that studies and develops theories, methods, technologies and application systems for simulating, extending and expanding human intelligence.

[0004] Since there are errors in the power outage data collected by multiple different systems within the power company, in order to eliminate the impact of data errors on the statistics and analysis of subsequent power outage data, it is necessary to compare and process the power outage data and medium voltage data of a large number of transmission lines recorded by multiple different systems. However, the traditional manual data processing method is inefficient, has a high error rate, and requires high labor costs. Summary of the invention

[0005] This application provides a method and device for comparing power outage data based on RPA and AI, which can compare and process power outage data and medium voltage data according to matching rules based on RPA and AI technology to obtain data that meets the matching rules. This solves the problem of low efficiency and high error rate when manually processing power outage data, and reduces labor costs.

[0006] In a first aspect, the present application provides a method for comparing power outage data of a power grid based on RPA and AI, and the method is applied to a robotic process automation (RPA) robot, and the method includes: obtaining power outage data and medium voltage data; matching the power outage data with the medium voltage data according to a matching rule; in response to the power outage data matching the medium voltage data, exporting and storing the medium voltage data that meets the matching rule; in response to the power outage data not matching the medium voltage data, exporting and storing the power outage data that does not meet the matching rule.

[0007] Through this technical solution, the power outage data and the medium voltage data can be compared and processed according to the matching rules to obtain the data that meets the matching rules and the data that does not meet the matching rules. This solves the problem of low efficiency and high error rate when manually processing power outage data of the power grid, and reduces labor costs.

[0008] In one implementation, the power outage data includes: line power outage data; substation power outage data.

[0009] In one implementation, the power outage data and the medium voltage data both include: line name, power outage start time and power outage end time; wherein, the power outage data matches the medium voltage data, including: the line name of the power outage data matches the line name of the medium voltage data; the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a first preset range; the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a second preset range.

[0010] In an optional implementation, the first preset range is ±5 minutes, and the second preset range is ±5 minutes.

[0011] In one implementation, the power outage data does not match the medium voltage data, including: the line name in the power outage data does not match the line name in the medium voltage data; or, the line name in the power outage data matches the line name in the medium voltage data, and the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within the first preset range, and / or, the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within the second preset range.

[0012] In an implementation, the method further includes: before matching the power outage data with the medium voltage data according to a matching rule, performing data cleaning on the medium voltage data.

[0013] Through this technical solution, the medium voltage data can be cleaned, the power grid outage data comparison time can be saved, and the accuracy of the comparison results can be improved.

[0014] In one implementation, the obtaining of power outage data and medium voltage data includes: taking a screenshot of the first system login interface based on the RPA robot to obtain the first system login interface image, and performing optical character recognition (OCR) processing on the first system login interface image based on artificial intelligence (AI) technology, determining the first login control area in the first system login interface based on the OCR processing result, and filling in the first account information into the first login control area based on the RPA robot simulating manual operation to log in to the first system to download the power outage data; taking a screenshot of the second system login interface based on the RPA robot to obtain the second system login interface image, and performing optical character recognition (OCR) processing on the second system login interface image based on artificial intelligence (AI) technology, determining the second login control area in the second system login interface based on the OCR processing result, and filling in the second account information into the second login control area based on the RPA robot simulating manual operation to log in to the second system to download the medium voltage data.

[0015] In one implementation, the method further includes: generating a data table based on the stored data, and sending the data table to a terminal device held by the user.

[0016] Through this technical solution, the power grid outage data comparison results can be sent to the user's terminal device in the form of a data table, which is convenient for the user to view.

[0017] In the second aspect, the present application provides a power grid power outage data comparison device based on RPA and AI, and the device is applied to a robotic process automation (RPA) robot, and the device includes: an acquisition module: used to acquire power outage data and medium voltage data; a first processing module: used to match the power outage data with the medium voltage data according to a matching rule; a storage module: used to export and store the medium voltage data that meets the matching rule in response to the power outage data matching the medium voltage data; and export and store the power outage data that does not meet the matching rule in response to the power outage data not matching the medium voltage data.

[0018] In one implementation, the power outage data includes: line power outage data; substation power outage data.

[0019] In one implementation, the power outage data and the medium voltage data both include: line name, power outage start time and power outage end time; wherein, the power outage data matches the medium voltage data, including: the line name of the power outage data matches the line name of the medium voltage data; the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a first preset range; the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a second preset range.

[0020] In an optional implementation, the first preset range is ±5 minutes, and the second preset range is ±5 minutes.

[0021] In an optional implementation, the power outage data does not match the medium voltage data, including: the line name in the power outage data does not match the line name in the medium voltage data; or, the line name in the power outage data matches the line name in the medium voltage data, and the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within the first preset range, and / or, the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within the second preset range.

[0022] In one implementation, the device further includes: a second processing module, configured to clean the medium voltage data before matching the power outage data with the medium voltage data according to a matching rule.

[0023] In one implementation, the acquisition module is specifically used to: take a screenshot of the first system login interface based on the RPA robot to obtain the first system login interface image, perform optical character recognition (OCR) processing on the first system login interface image based on artificial intelligence (AI) technology, determine the first login control area in the first system login interface based on the OCR processing result, fill in the first account information into the first login control area based on the RPA robot simulating manual operation to log in to the first system to download the power outage data; take a screenshot of the second system login interface based on the RPA robot to obtain the second system login interface image, perform optical character recognition (OCR) processing on the second system login interface image based on artificial intelligence (AI) technology, determine the second login control area in the second system login interface based on the OCR processing result, fill in the second account information into the second login control area based on the RPA robot simulating manual operation to log in to the second system to download the medium voltage data.

[0024] In one implementation, the apparatus further includes: a third processing module, configured to generate a data table based on the stored data, and send the data table to a terminal device held by the user.

[0025] In a third aspect, an embodiment of the present application provides an electronic device, comprising at least one processor; and a memory connected to the at least one processor in communication. The memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the power grid power outage data comparison method based on RPA and AI described in the first aspect above.

[0026] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium for storing instructions for implementing the above method. When the instructions are executed, the method described in the first aspect is executed.

[0027] In a fifth aspect, the present application provides a computer program product, comprising a computer program, which implements the steps of the method described in the first aspect when executed by a processor.

[0028] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present application, nor is it intended to limit the scope of the present application. Other features of the present application will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] The accompanying drawings are used to better understand the present solution and do not constitute a limitation of the present application.

[0030] Figure 1 A flowchart of a power grid outage data comparison method based on RPA and AI provided in an embodiment of the present application;

[0031] Figure 2 A flowchart of another power grid outage data comparison method based on RPA and AI provided in an embodiment of the present application;

[0032] Figure 3 A flowchart of another power grid outage data comparison method based on RPA and AI provided in an embodiment of the present application;

[0033] Figure 4 A schematic diagram of the structure of a power grid power outage data comparison device based on RPA and AI provided in an embodiment of the present application;

[0034] Figure 5 A structural schematic diagram of an electronic device provided in an embodiment of the present application for implementing a power grid power outage data comparison method based on RPA and AI. DETAILED DESCRIPTION

[0035] The following is a description of the exemplary embodiments of the present application in conjunction with the accompanying drawings, including various details of the embodiments of the present application to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications can be made to the embodiments described in the present application without departing from the scope and spirit of the present application. Similarly, for the sake of clarity and conciseness, the description of well-known functions and structures is omitted in the following description.

[0036] In the description of this application, unless otherwise specified, " / " means or, for example, A / B can mean A or B; "and / or" in this article is only a description of the association relationship of associated objects, indicating that there can be three relationships, for example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone. The various numbers such as first, second, etc. involved in this application are only distinguished for the convenience of description, and are not used to limit the scope of the embodiments of this application, nor do they indicate the order of precedence.

[0037] In the description of this application, the term "power outage data" refers to data generated by recording information including but not limited to the name of the line where the power outage event occurred, the start time and end time of the power outage event, etc.

[0038] In the description of this application, the term "line outage data" refers to a data set of multiple outage events occurring on (one) transmission line.

[0039] In the description of this application, the term "power outage data in a transformer area" refers to a data set of multiple power outage events occurring within the power supply range or area of ​​(one) transformer.

[0040] In the description of this application, the term "medium voltage data" refers to operation data of a medium voltage transmission line.

[0041] In the description of this application, the term "line name" refers to a specific noun used to identify a certain transmission line.

[0042] In the description of this application, the term "power outage start time" refers to the specific time when the power outage event starts as recorded by the corresponding system.

[0043] In the description of this application, the term "power outage end time" refers to the specific time when the power outage event recorded by the corresponding system ends.

[0044] In the description of this application, the term "data cleaning" refers to discovering and correcting identifiable errors in medium voltage data files, including checking data consistency, processing invalid values, duplicate values, etc.

[0045] See also Figure 1 , Figure 1 The present application provides a flowchart of a method for comparing power outage data based on RPA (Robotic Process Automation) and AI (Artificial Intelligence). This method can compare and process power outage data collected by multiple different systems within a power company, thereby obtaining accurate power outage data, reducing the labor cost of power outage data processing, and improving processing accuracy. Figure 1As shown, the power grid power outage data comparison method based on RPA and AI may include but is not limited to the following steps.

[0046] Step S101: Obtain power outage data and medium voltage data.

[0047] Among them, the power outage data includes line power outage data and substation power outage data; the line power outage data, substation power outage data and medium voltage data are composed of multiple data, and each data includes at least: line name, power outage start time and power outage end time.

[0048] In one implementation, a screenshot of the first system login interface can be taken based on an RPA robot to obtain an image of the first system login interface, and optical character recognition (OCR) processing can be performed on the image of the first system login interface based on artificial intelligence (AI) technology. A first login control area in the first system login interface is determined based on the OCR processing result, and the first account information is filled into the first login control area based on the RPA robot simulating manual operation to log in to the first system to download the power outage data.

[0049] For example, after logging into the power grid metering system, the RPA robot can take a screenshot of the system interface and perform artificial intelligence AI OCR recognition on the screenshot to identify the text representing the login system in the screenshot, such as "login". Based on the location of the text, the area where the login control is located in the screenshot is determined, and then the corresponding area of ​​the login control in the system interface is simulated by manual operation to fill in the preset account information, so as to log in to the system, retrieve and download the power outage data.

[0050] Based on the RPA robot, a screenshot of the second system login interface is taken to obtain the second system login interface image, and optical character recognition (OCR) processing is performed on the second system login interface image based on artificial intelligence (AI) technology. Based on the OCR processing result, the second login control area in the second system login interface is determined, and based on the RPA robot simulating manual operation, the second account information is filled into the second login control area to log in to the second system to download the medium voltage data.

[0051] For example, after logging into the power grid reliability system, the RPA robot can take a screenshot of the system interface and perform artificial intelligence AI OCR recognition on the screenshot to identify the text representing the login system in the screenshot, such as "login". Based on the location of the text, the area where the login control is located in the screenshot is determined, and then the corresponding area of ​​the login control in the system interface is simulated by manual operation to fill in the preset account information, so as to log in to the system, retrieve and download the medium voltage data.

[0052] Step S102: Match the power outage data with the medium voltage data according to the matching rules.

[0053] In one implementation, the matching rules may include: the line name of the power outage data matches the line name of the medium voltage data; the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a preset range; the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a preset range.

[0054] For example, the RPA robot reads each piece of power outage data one by one, obtains the line name, power outage start time and power outage end time in each piece of data, and compares them with the line name of each piece of data in the medium voltage data one by one to determine whether there is data in the medium voltage data with the same line name as the power outage data being compared. If there is data with the same line name, the power outage start time and power outage end time of the two data with the same line name will continue to be compared; if there is no data in the medium voltage data with the same line name as the power outage data being compared, the comparison of the power outage data is completed, and the next power outage data will continue to be compared with the medium voltage data.

[0055] Step S103: In response to the power outage data matching the medium voltage data, the medium voltage data satisfying the matching rule is exported and stored.

[0056] In one implementation, the power outage data is matched with the medium voltage data, including: the line name of the power outage data is matched with the line name of the medium voltage data; the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a first preset range; the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a second preset range.

[0057] In an optional implementation, the first preset range is ±5 minutes, and the second preset range is ±5 minutes.

[0058] For example, when a piece of data in the power outage data has the same line name as a piece of data in the medium voltage data, and the difference between the power outage start time and the power outage end time of the above two data is less than or equal to 5 minutes, the two data match, and the medium voltage data in the two matching data will be exported and stored.

[0059] Step S104: In response to the power outage data not matching the medium voltage data, the power outage data not satisfying the matching rule is exported and stored.

[0060] In one implementation, the power outage data does not match the medium voltage data, including: the line name in the power outage data does not match the line name in the medium voltage data; or, the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within a first preset range, and / or, the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within a second preset range.

[0061] As an example, if the line name in the power outage data does not match the line name in the medium voltage data, it is determined that the power outage data does not match the medium voltage data.

[0062] As another example, if the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within a first preset range, it is determined that the power outage data does not match the medium voltage data.

[0063] As another example, if the line name in the power outage data matches the line name in the medium voltage data, the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a first preset range, and the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within a second preset range, then it is determined that the power outage data and the medium voltage data do not match.

[0064] As another example, if the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within a first preset range, and the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within a second preset range, then it is determined that the power outage data and the medium voltage data do not match.

[0065] For example, when the line name of a certain piece of data in the power outage data is different from the line name of each piece of data in the medium voltage data, there is no match with the power outage data in the medium voltage data, and the power outage data is exported and stored. When a line name in the power outage data is the same as a line name in the medium voltage data, the difference in the power outage start time of the two lines is less than or equal to 5 minutes, and the difference in the power outage end time of the two lines is greater than 5 minutes, there is no match with the power outage data in the medium voltage data, and the power outage data is exported and stored. When a line name in the power outage data is the same as a line name in the medium voltage data, the difference in the power outage start time of the two lines is greater than 5 minutes, and the difference in the power outage end time of the two lines is less than or equal to 5 minutes, there is no match with the power outage data in the medium voltage data, and the power outage data is exported and stored. When the name of a line in the power outage data is the same as the name of a line in the medium voltage data, the difference in the power outage start time of the two lines is greater than five minutes, and the difference in the power outage end time of the two lines is greater than 5 minutes, there is no match for the power outage data in the medium voltage data. At this time, the power outage data is exported and stored.

[0066] By implementing the embodiments of the present application, the power outage data and the medium voltage data can be compared and processed according to the matching rules, and the medium voltage data that meets the matching rules and the power outage data that does not meet the matching rules can be obtained and stored respectively. The problem of low efficiency and high error rate when manually processing the power outage data of the power grid is solved, and the labor cost is reduced.

[0067] See also Figure 2 , Figure 2 A flowchart of another method for comparing power outage data based on RPA and AI provided in an embodiment of the present application, which can compare and process line outage data with medium voltage data. Figure 2 As shown, the power grid power outage data comparison method based on RPA and AI may include but is not limited to the following steps.

[0068] Step S201: Acquire line power outage data and medium voltage data.

[0069] For example, after logging into the power grid metering system, the RPA robot can perform image recognition on the system page based on artificial intelligence (AI) technology to obtain the location of the page elements corresponding to the various functions of the system, thereby simulating manual operation to click on the corresponding elements to enter the download page, and enter data retrieval conditions at the corresponding location to retrieve and download line power outage data.

[0070] In the embodiment of the present application, the acquisition of medium voltage data can be implemented by any method in the embodiments of the present application. The embodiment of the present application does not limit this and will not be repeated.

[0071] Step S202: Match the line power outage data with the medium voltage data according to the matching rules.

[0072] For example, the RPA robot reads each piece of line power outage data one by one, obtains the line name, power outage start time and power outage end time in each piece of data, and compares them with the line name of each piece of data in the medium voltage data one by one to determine whether there is data in the medium voltage data with the same line name as the line power outage data being compared. If there is data with the same line name, the power outage start time and power outage end time of the two data with the same line name will continue to be compared; if there is no data in the medium voltage data with the same line name as the line power outage data being compared, the comparison of the power outage data of the line is completed, and the next line power outage data will continue to be compared with the medium voltage data.

[0073] Step S203: In response to the line outage data matching the medium voltage data, the medium voltage data satisfying the matching rule is exported and stored.

[0074] For example, when a piece of data in the line power outage data has the same line name as a piece of data in the medium voltage data, and the difference between the power outage start time and the power outage end time of the above two data is less than or equal to 5 minutes, the two data match, and the medium voltage data in the two matching data will be exported and stored.

[0075] Step S204: In response to the line outage data not matching the medium voltage data, the line outage data not satisfying the matching rule is exported and stored.

[0076] For example, when the line name of a certain data in the line power outage data is different from the line name of each data in the medium voltage data; or, a line name in the line power outage data is the same as a line name in the medium voltage data, the difference in the power outage start time of the two lines is less than or equal to 5 minutes, and the difference in the power outage end time of the two lines is greater than 5 minutes; or, a line name in the line power outage data is the same as a line name in the medium voltage data, the difference in the power outage start time of the two lines is greater than 5 minutes, and the difference in the power outage end time of the two lines is less than or equal to 5 minutes; or, a line name in the line power outage data is the same as a line name in the medium voltage data, the difference in the power outage start time of the two lines is greater than five minutes, and the difference in the power outage end time of the two lines is greater than 5 minutes; then there is no matching item in the medium voltage data with the power outage data of the line, and the power outage data of the line is exported and stored.

[0077] By implementing the embodiments of the present application, the line outage data and the medium voltage data can be compared and processed according to the matching rules, and the medium voltage data that meets the matching rules and the line outage data that does not meet the matching rules can be obtained and stored respectively. The problem of low efficiency and high error rate when manually processing the power grid outage data is solved, and the labor cost is reduced.

[0078] See also Figure 3 , Figure 3 A flowchart of another method for comparing power outage data based on RPA and AI provided in an embodiment of the present application, which can compare and process the power outage data of the substation area with the medium voltage data. Figure 3 As shown, the power grid power outage data comparison method based on RPA and AI may include but is not limited to the following steps.

[0079] Step S301: Obtaining power outage data and medium voltage data in the substation area.

[0080] For example, after logging into the power grid metering system, the RPA robot can perform image recognition on the system page based on artificial intelligence (AI) technology to obtain the location of the page elements corresponding to the various functions of the system, simulate manual operation to click on the corresponding elements to enter the download page, and enter data retrieval conditions at the corresponding location to retrieve and download power outage data in the substation area.

[0081] In the embodiment of the present application, the acquisition of medium voltage data can be implemented by any method in the embodiments of the present application. The embodiment of the present application does not limit this and will not be repeated.

[0082] Step S302: Match the line power outage data with the medium voltage data according to the matching rules.

[0083] For example, the RPA robot reads each piece of data in the substation power outage data one by one, obtains the line name, power outage start time and power outage end time in each piece of data, and compares them with the line name of each piece of data in the medium voltage data one by one to determine whether there is data in the medium voltage data with the same line name as the substation power outage data being compared. If there is data with the same line name, the power outage start time and power outage end time of the two data with the same line name will continue to be compared; if there is no data in the medium voltage data with the same line name as the substation power outage data being compared, the comparison of the substation power outage data is completed, and the next substation power outage data will continue to be compared with the medium voltage data.

[0084] Step S303: In response to the matching of the substation power outage data and the medium voltage data, the medium voltage data satisfying the matching rule is exported and stored.

[0085] For example, when a piece of data in the power outage data of the substation has the same line name as a piece of data in the medium voltage data, and the difference between the power outage start time and the power outage end time of the two data is less than or equal to 5 minutes, the two data match. At this time, the medium voltage data in the two matching data will be exported and stored.

[0086] Step S304: In response to the fact that the power outage data of the substation area does not match the medium voltage data, the line power outage data that does not meet the matching rule is exported and stored.

[0087] For example, when the line name of a certain data in the substation power outage data is different from the line name of each data in the medium voltage data; or, the name of a certain line in the substation power outage data is the same as the name of a certain line in the medium voltage data, the difference in the power outage start time of the two lines is less than or equal to 5 minutes, and the difference in the power outage end time of the two lines is greater than 5 minutes; or, the name of a certain line in the substation power outage data is the same as the name of a certain line in the medium voltage data, the difference in the power outage start time of the two lines is greater than 5 minutes, and the difference in the power outage end time of the two lines is less than or equal to 5 minutes; or, the name of a certain line in the substation power outage data is the same as the name of a certain line in the medium voltage data, the difference in the power outage start time of the two lines is greater than five minutes, and the difference in the power outage end time of the two lines is greater than 5 minutes; then there is no matching item in the medium voltage data with the power outage data of the line, and the substation power outage data is exported and stored.

[0088] By implementing the embodiments of the present application, the power outage data of the substation area and the medium voltage data can be compared and processed according to the matching rules, and the medium voltage data that meets the matching rules and the power outage data of the substation area that does not meet the matching rules can be obtained and stored respectively. The problem of low efficiency and high error rate when manually processing the power outage data of the power grid is solved, and the labor cost is reduced.

[0089] In some embodiments of the present application, before matching the power outage data with the medium voltage data according to matching rules, the medium voltage data can be cleaned and duplicate data in the medium voltage data can be deleted to save power outage data comparison time and improve the accuracy of the comparison results.

[0090] In some embodiments of the present application, a data table may be generated based on the stored data and sent to a terminal device held by the user.

[0091] In the embodiment of the present application, the terminal device may be a mobile phone, a tablet computer, a personal digital assistant, a PC (Personal Computer), or other hardware device with various operating systems.

[0092] For example, the RPA robot can generate corresponding data tables for the stored successfully matched medium voltage data, unsuccessfully matched line power outage data, and unsuccessfully matched substation power outage data, and send the generated data tables to the user's terminal device via email for the user to view.

[0093] See also Figure 4 , Figure 4 Schematic diagram of a power grid outage data comparison device based on RPA and AI provided in an embodiment of the present application. Figure 4 The power grid power outage data comparison device 400 based on RPA and AI shown may include: an acquisition module 401 , a first processing module 402 and a storage module 403 .

[0094] Among them, the acquisition module 401 is used to acquire power outage data and medium voltage data; the first processing module 402 is used to match the power outage data with the medium voltage data according to the matching rules; the storage module 403 is used to export and store the medium voltage data that meets the matching rules in response to the power outage data matching the medium voltage data; in response to the power outage data not matching the medium voltage data, export and store the power outage data that does not meet the matching rules.

[0095] In one implementation, the power outage data includes: line power outage data; substation power outage data.

[0096] In one implementation, the power outage data or medium voltage data includes: line name; power outage start time; power outage end time, and the first processing module 402 is specifically used to: match the line name of the power outage data with the line name of the medium voltage data; match the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data with a first preset range; match the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data with a second preset range.

[0097] In one implementation, both the power outage data and the medium voltage data include: line name, power outage start time and power outage end time; wherein, the power outage data matches the medium voltage data, including: the line name of the power outage data matches the line name of the medium voltage data; the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a first preset range; the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a second preset range.

[0098] In an optional implementation, the first preset range is ±5 minutes, and the second preset range is ±5 minutes.

[0099] In an optional implementation, the power outage data does not match the medium voltage data, including: the line name in the power outage data does not match the line name in the medium voltage data; or, the line name in the power outage data matches the line name in the medium voltage data, and the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within a first preset range, and / or, the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within a second preset range.

[0100] In one implementation, the device further includes: a second processing module 404, configured to clean the medium voltage data before matching the power outage data with the medium voltage data according to a matching rule.

[0101] In one implementation, the acquisition module 401 is specifically used for: taking a screenshot of the first system login interface based on the RPA robot to obtain the first system login interface image, and performing optical character recognition (OCR) processing on the first system login interface image based on artificial intelligence (AI) technology, determining the first login control area in the first system login interface based on the OCR processing result, and filling the first account information into the first login control area based on the RPA robot simulating manual operation to log in to the first system to download power outage data; taking a screenshot of the second system login interface based on the RPA robot to obtain the second system login interface image, and performing optical character recognition (OCR) processing on the second system login interface image based on artificial intelligence (AI) technology, determining the second login control area in the second system login interface based on the OCR processing result, and filling the second account information into the second login control area based on the RPA robot simulating manual operation to log in to the second system to download medium voltage data.

[0102] In one implementation, the apparatus further includes: a third processing module 405, configured to generate a data table based on the stored data, and send the data table to a terminal device held by the user.

[0103] Regarding the device in the above embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.

[0104] Based on the embodiments of the present application, the present application also provides an electronic device, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the power grid power outage data comparison method based on RPA and AI of any of the aforementioned embodiments.

[0105] Based on the embodiments of the present application, the present application further provides a computer-readable storage medium storing computer instructions, wherein the computer instructions are used to enable a computer to execute the power grid outage data comparison method based on RPA and AI according to any of the aforementioned embodiments provided in the embodiments of the present application.

[0106] See also Figure 5 ,like Figure 5 , is a schematic block diagram of an example electronic device that can be used to implement an embodiment of the present application. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present application described and / or required in the present application.

[0107] like Figure 5 As shown, the device 500 includes a computing unit 501, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 502 or a computer program loaded from a storage unit 508 to a random access memory (RAM) 503. In the RAM 503, various programs and data required for the operation of the device 500 can also be stored. The computing unit 501, the ROM 502, and the RAM 503 are connected to each other via a bus 504. An input / output (I / O) interface 505 is also connected to the bus 504.

[0108] A number of components in the device 500 are connected to the I / O interface 505, including: an input unit 506, such as a keyboard, a mouse, etc.; an output unit 507, such as various types of displays, speakers, etc.; a storage unit 508, such as a disk, an optical disk, etc.; and a communication unit 509, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 509 allows the device 500 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0109] The computing unit 501 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the computing unit 501 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, digital signal processors (DSP), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 501 performs the various methods and processes described above, such as a power grid outage data comparison method based on RPA and AI. For example, in some embodiments, the power grid outage data comparison method based on RPA and AI may be implemented as a computer software program, which is tangibly included in a machine-readable medium, such as a storage unit 508. In some embodiments, part or all of the computer program may be loaded and / or installed on the device 500 via the ROM 502 and / or the communication unit 509. When the computer program is loaded into the RAM 503 and executed by the computing unit 501, one or more steps of the power grid outage data comparison method based on RPA and AI described above may be performed. Alternatively, in other embodiments, the computing unit 501 may be configured to execute the RPA and AI-based power grid outage data comparison method in any other appropriate manner (for example, by means of firmware).

[0110] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard parts (ASSPs), system on chip systems (SOCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments can include: being implemented in one or more computer programs, which can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a dedicated or general programmable processor, which can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0111] The program code for implementing the method of the present application can be written in any combination of one or more programming languages. These program codes can be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that the program code, when executed by the processor or controller, implements the functions / operations specified in the flow chart and / or block diagram. The program code can be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0112] In the context of the present application, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, 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 foregoing.

[0113] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a cathode ray tube (CRT) or LCD (Liquid Crystal Display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0114] The systems and techniques described herein can be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: Local Area Network (LAN), Wide Area Network (WAN), the Internet, and blockchain networks.

[0115] A computer system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The relationship between the client and the server is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or a cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS (Virtual Private Server) services. The server may also be a server of a distributed system, or a server combined with a blockchain.

[0116] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the disclosure of the present invention can be performed in parallel, sequentially or in different orders, as long as the desired results of the technical solution disclosed in the present application can be achieved, and this document does not limit this.

[0117] The above specific implementations do not constitute a limitation on the protection scope of this application. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of this application should be included in the protection scope of this application.

Claims

1. A power grid outage data comparison method based on RPA and AI, characterized in that: The method is applied to a Robotic Process Automation (RPA) robot, and the method includes: Obtain power outage data and medium voltage data; Matching the power outage data with the medium voltage data according to a matching rule; In response to the power outage data matching the medium voltage data, exporting and storing the medium voltage data satisfying a matching rule; In response to the power outage data not matching the medium voltage data, the power outage data not satisfying the matching rule is exported and stored; wherein, The medium voltage data refers to the operation data of the medium voltage transmission line; The matching rules include: The power outage data matches the line name of the medium voltage data; The difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a preset range; The difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a preset range.

2. The method according to claim 1, characterized in that The power outage data includes: Line power outage data; Substation power outage data.

3. The method according to claim 1, characterized in that The power outage data and the medium voltage data both include: line name, power outage start time and power outage end time; The power outage data matches the medium voltage data, including: The line name of the power outage data matches the line name of the medium voltage data; The difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a first preset range; A difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a second preset range.

4. The method according to claim 3, characterized in that The first preset range is ±5 minutes; the second preset range is ±5 minutes.

5. The method according to claim 3, characterized in that: The power outage data does not match the medium voltage data, including: The line name in the power outage data does not match the line name in the medium voltage data; or, The line name in the power outage data matches the line name in the medium voltage data, and the line name in the power outage data matches the line name in the medium voltage data, and the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is not within the first preset range, and / or the difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is not within the second preset range.

6. The method according to claim 1, characterized in that The method further comprises: Before matching the power outage data with the medium voltage data according to a matching rule, the medium voltage data is cleansed.

7. The method according to claim 1, characterized in that The obtaining of power outage data and medium voltage data includes: Taking a screenshot of the first system login interface based on the RPA robot to obtain an image of the first system login interface, performing optical character recognition (OCR) processing on the image of the first system login interface based on artificial intelligence (AI) technology, determining a first login control area in the first system login interface based on the OCR processing result, and filling in the first account information into the first login control area based on the RPA robot simulating manual operation to log in to the first system and download the power outage data; Based on the RPA robot, a screenshot of the second system login interface is taken to obtain an image of the second system login interface, and optical character recognition (OCR) processing is performed on the image of the second system login interface based on artificial intelligence (AI) technology. Based on the OCR processing result, a second login control area in the second system login interface is determined, and based on the RPA robot simulating manual operation, the second account information is filled into the second login control area to log in to the second system to download the medium voltage data.

8. The method according to claim 1, characterized in that The method further comprises: A data table is generated based on the stored data, and the generated data table is sent to a terminal device held by the user.

9. A power grid power outage data comparison device based on RPA and AI, characterized in that: The device is applied to a Robotic Process Automation (RPA) robot, and the device includes: Acquisition module: used to obtain power outage data and medium voltage data; A first processing module: used for matching the power outage data with the medium voltage data according to a matching rule; Storage module: used for exporting and storing the medium voltage data that meets the matching rule in response to the power outage data matching the medium voltage data; exporting and storing the power outage data that does not meet the matching rule in response to the power outage data not matching the medium voltage data; wherein, The medium voltage data refers to the operation data of the medium voltage transmission line; The matching rules include: The power outage data matches the line name of the medium voltage data; The difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data is within a preset range; The difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is within a preset range.

10. The device according to claim 9, characterized in that The first processing module is specifically used for: Matching the line name of the power outage data with the line name of the medium voltage data; Matching the difference between the power outage start time in the power outage data and the power outage start time in the medium voltage data with a first preset range; The difference between the power outage end time in the power outage data and the power outage end time in the medium voltage data is matched with a second preset range.

11. The device according to claim 9, characterized in that The device also includes: The second processing module is used to clean the medium voltage data before matching the power outage data with the medium voltage data according to a matching rule.

12. The device according to claim 9, characterized in that The acquisition module is specifically used for: Taking a screenshot of the first system login interface based on the RPA robot to obtain an image of the first system login interface, performing optical character recognition (OCR) processing on the image of the first system login interface based on artificial intelligence (AI) technology, determining a first login control area in the first system login interface based on the OCR processing result, and filling in the first account information into the first login control area based on the RPA robot simulating manual operation to log in to the first system and download the power outage data; Based on the RPA robot, a screenshot of the second system login interface is taken to obtain an image of the second system login interface, and optical character recognition (OCR) processing is performed on the image of the second system login interface based on artificial intelligence (AI) technology. Based on the OCR processing result, a second login control area in the second system login interface is determined, and based on the RPA robot simulating manual operation, the second account information is filled into the second login control area to log in to the second system to download the medium voltage data.

13. The device according to claim 9, characterized in that The device also includes: The third processing module is used to generate a data table based on the stored data and send it to the terminal device held by the user.

14. An electronic device, characterized in that: at least one processor; and a memory communicatively coupled to the at least one processor; Wherein, the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the power grid power outage data comparison method based on RPA and AI as described in any one of claims 1 to 8.

15. A computer-readable storage medium, characterized in that: The computer instructions are used to enable the computer to execute the power grid power outage data comparison method based on RPA and AI as described in any one of claims 1 to 8.

16. A computer program product, comprising a computer program, wherein when the computer program is executed by a processor, the computer program implements the power grid power outage data comparison method based on RPA and AI as described in any one of claims 1 to 8.

Images