CN111090973A - Report generation method and device and electronic equipment - Google Patents
Report generation method and device and electronic equipment Download PDFInfo
- Publication number
- CN111090973A CN111090973A CN201911170831.2A CN201911170831A CN111090973A CN 111090973 A CN111090973 A CN 111090973A CN 201911170831 A CN201911170831 A CN 201911170831A CN 111090973 A CN111090973 A CN 111090973A
- Authority
- CN
- China
- Prior art keywords
- power grid
- maintenance
- grid maintenance
- flow log
- maintenance flow
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 67
- 238000012423 maintenance Methods 0.000 claims abstract description 263
- 238000012545 processing Methods 0.000 claims abstract description 52
- 238000007781 pre-processing Methods 0.000 claims abstract description 14
- 230000011218 segmentation Effects 0.000 claims description 12
- 238000000605 extraction Methods 0.000 claims description 10
- 238000004590 computer program Methods 0.000 claims description 3
- 238000003058 natural language processing Methods 0.000 abstract description 5
- 230000009471 action Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 9
- 230000000694 effects Effects 0.000 description 8
- 230000006870 function Effects 0.000 description 7
- 230000003442 weekly effect Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 4
- 230000002354 daily effect Effects 0.000 description 4
- 239000000284 extract Substances 0.000 description 3
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 3
- 238000001816 cooling Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000007670 refining Methods 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 230000002441 reversible effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002457 bidirectional effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000007373 indentation Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000011664 signaling Effects 0.000 description 1
- 239000000779 smoke Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000013024 troubleshooting Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/20—Administration of product repair or maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- General Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a report generation method, a report generation device and electronic equipment, wherein the report generation method comprises the steps of preprocessing the acquired power grid maintenance flow logs to remove invalid information in the power grid maintenance flow logs; extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises equipment names, fault types, maintenance steps and maintenance results; and combining at least one part of effective information according to a preset template to generate a report. Information in the power grid maintenance flow logs is extracted based on a natural language processing algorithm, and then a readable maintenance report is generated according to a preset template, so that careless mistakes are avoided when information is manually read and statistical information is easily generated, meanwhile, the processing efficiency is improved, a uniform and accurate maintenance report is formed, the report generation efficiency is improved, and the report generation precision is improved.
Description
Technical Field
The application relates to the technical field of word processing, in particular to a report generation method and device and electronic equipment.
Background
The power grid distribution network dispatcher manually and regularly issues distribution network line maintenance reports every day, every week and every month, not only is detailed description on the description, maintenance schemes and solution conditions of all line problems in corresponding time required, but also data statistics summary is required according to different types of the problems. The materials of the report form are daily commuting water records of a large number of dispatchers. The existing report generation method completely depends on manual refining and sorting, and needs to consume a large amount of time of scheduling personnel. Because the data of a plurality of data systems needs to be collected and sorted, the time cost for manually sorting the report forms is high; due to the difference of arrangement personnel, a standard and uniform report is difficult to form; in addition, manual arrangement is difficult to avoid statistics and arrangement errors, so that reports are not strict.
Disclosure of Invention
In order to solve the problem that a large amount of time is consumed by scheduling personnel in the conventional report generation method, the application provides a report generation method, a report generation device and electronic equipment.
The technical scheme adopted by the invention is as follows:
in a first aspect, the present invention provides a report generating method, including; preprocessing the obtained power grid maintenance flow log to remove invalid information in the power grid maintenance flow log; extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises an equipment name, a fault type, a maintenance step and a maintenance result; and combining at least one part of the effective information according to a preset template to generate a report.
Further, the step of extracting the effective information in the preprocessed power grid maintenance flow log includes: extracting the equipment name in the preprocessed power grid maintenance flow log; extracting problem content description in the preprocessed power grid maintenance flow log by using a preset line problem extraction model; determining the fault type in the power grid maintenance flow log according to the problem content description, wherein the fault type comprises tripping or grounding; and extracting the maintenance steps and the maintenance results in the power grid maintenance flow log according to the fault type in the power grid maintenance flow log.
Further, before combining at least a part of the effective information according to a preset template to generate a report, the method further includes: and counting the extracted effective information based on preset dimensionality, wherein the preset dimensionality comprises at least one of an operation and maintenance unit, an operation and maintenance team, maintenance time and fault types.
Further, the step of preprocessing the obtained power grid maintenance flow log to remove invalid information in the power grid maintenance flow log comprises: removing invalid symbols in the power grid maintenance flow log, wherein the invalid symbols comprise line feed symbols, tab symbols and punctuation marks; and performing word segmentation processing on the power grid maintenance flow log after the invalid symbol is removed.
Further, before preprocessing the obtained power grid maintenance flow log to remove invalid information in the power grid maintenance flow log, the method further includes: and acquiring at least one part of the power grid maintenance flow log.
In a second aspect, the present invention further provides a report generating apparatus, where the report generating apparatus is configured to execute the report generating method described above, and the report generating apparatus includes: the acquisition module is used for acquiring at least one power grid maintenance flow log; the processing module is used for preprocessing the acquired power grid maintenance flow log to remove invalid information in the power grid maintenance flow log; the system is also used for extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises an equipment name, a fault type, a maintenance step and a maintenance result; the processing module is further used for combining at least one part of the effective information according to a preset template to generate a report.
Further, the processing module is configured to extract a device name in the preprocessed power grid maintenance flow log; the system is also used for extracting problem content description in the preprocessed power grid maintenance flow log by using a line problem extraction model; the fault type in the power grid maintenance flow log is determined according to the problem content description, and the fault type comprises tripping and grounding; the processing module is further used for extracting the maintenance steps and the maintenance results in the power grid maintenance flow log according to the fault type in the power grid maintenance flow log.
Further, the processing module is further configured to perform statistics on the extracted effective information based on preset dimensions, where the preset dimensions include at least one of an operation and maintenance unit, an operation and maintenance team, maintenance time, and a fault type.
Further, the processing module is used for removing invalid symbols in the power grid maintenance flow log, wherein the invalid symbols comprise line feed symbols, tab symbols and punctuation marks; the processing module is further used for performing word segmentation processing on the power grid maintenance flow log after the invalid symbol is removed.
In a third aspect, the present invention further provides an electronic device, where the electronic device includes a processor, and the processor is configured to execute a computer program to implement the steps of the report generating method described above.
Compared with the prior art, the invention has the following beneficial effects:
the invention provides a report generation method, a report generation device and electronic equipment, wherein the report generation method comprises the steps of preprocessing the acquired power grid maintenance flow logs to remove invalid information in the power grid maintenance flow logs; extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises equipment names, fault types, maintenance steps and maintenance results; and combining at least one part of effective information according to a preset template to generate a report. Information in the power grid maintenance flow logs is extracted based on a natural language processing algorithm, and then a readable maintenance report is generated according to a preset template, so that careless mistakes are avoided when information is manually read and statistical information is easily generated, meanwhile, the processing efficiency is improved, a uniform and accurate maintenance report is formed, the report generation efficiency is improved, and the report generation precision is improved.
In order to make the aforementioned and other objects, features and advantages of the present invention comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 shows a flowchart of a report generation method provided by the present invention.
Fig. 2 is a schematic flow chart illustrating another report generation method provided by the present invention.
Fig. 3 is a flowchart illustrating another report generation method provided by the present invention.
Fig. 4 is a flowchart illustrating another report generation method provided by the present invention.
Fig. 5 is a flowchart illustrating another report generation method provided by the present invention.
Fig. 6 shows a functional module schematic diagram of a report generation apparatus provided by the present invention.
Fig. 7 shows a schematic diagram of an electronic device provided by the present invention.
Icon: 200-report generating means; 210-an obtaining module; 220-a processing module; 300-an electronic device; 310-a processor; 320-a memory; 330-a bus; 340-communication interface.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present invention without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. In the description of the present invention, it should also be noted that relational terms such as first and second, and the like, may be used solely herein to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions.
Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
Some embodiments of the invention are described in detail below with reference to the accompanying drawings. The embodiments described below and the features of the embodiments can be combined with each other without conflict.
The power grid distribution network dispatcher periodically issues distribution network line maintenance reports every day, every week and every month, details of description, maintenance schemes and solution conditions of all line problems in corresponding time are described, and meanwhile data statistics needs to be summarized according to different types of problems. The materials of the report form are daily commuting water records of a large number of dispatchers. The existing report generation method completely depends on manual refining and sorting, and needs to consume a large amount of time of scheduling personnel.
In the existing actual operation process, reports are generated mainly through two methods, one is a data system statistical method, namely, equipment attribute information is automatically extracted through equipment information recorded by an informatization system, and a numerical report is generated. The other method is a manual sorting method, namely, reports are periodically written by manually sorting running water logs of dispatching personnel and combining system data.
However, the data system cannot perform self-checking and automatic repair on the line problem, so that only static data related to the line can be provided, and dynamic information related to the line problem and repair cannot be generated; the data system does not have the capability of natural language processing, so that only a numerical report can be generated, but the textual description of the line problem cannot be provided, and the description of the line problem is unclear.
The manual sorting method needs to collect and sort the data of a plurality of data systems, and the manual sorting time cost is high; due to the difference of the collators, a standard and uniform report is difficult to form; and manual arrangement is difficult to avoid statistics and arrangement errors, so that reports are not strict.
In order to solve the above problem, an embodiment of the present application provides a report generation method, and referring to fig. 1, fig. 1 shows a flowchart of the report generation method provided in the embodiment of the present application. The report generation method provided by the embodiment of the application comprises the steps 110 to 140.
Step 110: and preprocessing the obtained power grid maintenance flow log to remove invalid information in the power grid maintenance flow log.
The power grid maintenance flow log is a work log recorded by a dispatcher by using a natural language, wherein the work log comprises information such as date, equipment name, fault type, maintenance process or step, maintenance result and the like, but the power grid maintenance flow log is recorded by the natural language and comprises a large amount of invalid information such as punctuation marks and daily use expression and the like, so that the obtained power grid maintenance flow log is preprocessed firstly to remove the invalid information in the power grid maintenance flow log.
Step 120: extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises equipment name, fault type, maintenance step and maintenance result.
After the power grid maintenance flow log is preprocessed, effective information in the preprocessed power grid maintenance flow log is extracted by using a preset extraction rule model, wherein the effective information comprises information such as equipment names, fault types, maintenance steps and maintenance results. The equipment name generally refers to a line name or a substation name, the fault type comprises tripping or grounding, different maintenance steps are extracted for different fault types in the power grid maintenance flow log, and different maintenance results are determined.
Step 130: and combining at least one part of effective information according to a preset template to generate a report.
After information such as equipment names, fault types, maintenance steps and maintenance results is extracted, at least a part of effective information or all effective information in the power grid maintenance journal is combined according to a preset template or rule, preset natural language description is added to generate a complete report, and when the report is generated, the report can be generated by one power grid maintenance journal or multiple power grid maintenance journals.
According to the report generation method provided by the embodiment of the application, the obtained power grid maintenance flow log is preprocessed to remove invalid information in the power grid maintenance flow log. Then extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises equipment names, fault types, maintenance steps and maintenance results, and at least a part of effective information is combined according to a preset template to generate a report. According to the report generation method provided by the embodiment of the application, invalid information is removed from the manually written power grid maintenance flow logs, the valid information is extracted, and then the report is generated according to the preset template or rule, so that the complex process of manually writing the report is simplified, a large batch of power grid maintenance flow logs can be processed simultaneously, the efficiency of generating the report is improved, and meanwhile, the precision of generating the report is improved.
The report provided in the embodiment of the present application is generated based on the power grid maintenance journal, and referring to fig. 2 on the basis of fig. 1, before the step 110 of preprocessing the obtained power grid maintenance journal to remove invalid information in the power grid maintenance journal, the report generating method further includes:
step 101: and acquiring at least one power grid maintenance flow log.
In a possible implementation manner, a maintenance unit regularly maintains each power grid line at regular intervals, and writes and uploads a corresponding power grid maintenance flow log to a designated server when the line is maintained, so that a specific power grid maintenance flow log can be obtained according to requirements, for example, a power grid maintenance flow log uploaded by a specific maintenance unit on a specific date and a specific line; it may also be multiple grid maintenance journals, for example, all the grid maintenance journals for a particular line in a particular time period.
Two different examples of grid maintenance journal are given below:
log 1
"device name: steam line
The treatment process comprises the following steps: and (4) tripping the over-current protection action of the steam system wire tree 368 circuit within 22 days and 47 days, wherein the reclosing is unsuccessful. The fault is detected as the wire clamp of the #015 pole edge phase equipment is burnt out, and the 303 line of the 02:31 steam-making line military security #4 switching station is cooled for standby. The rear section of a 56-steam-line military security #4 switch station 303 supplies power through a Quwan II rotary Happy-gate I-hui forest 306. The fault is applied for electrification processing on day 1. "
Log 2
"device name: large bridge wire
The treatment process comprises the following steps: the 30 days 22:47 trees ridge is changed into 10kV IV mother A phase which is not completely grounded, no line is selected on site, the D5000 line is a 378 line (wrong) of the Guitang line tree, 23:25 the 334 line of the bridge line tree (for the later section of a 307 switch station of Changdou II Hui Xiangfu Teng City) is turned hot for standby, and the grounding disappears. And (3) checking that the Toscany switch station is damaged by the collision of the automobile, cooling the 307 line of the Changdong-II-Zhongyan switch station for standby at 00:38, then switching the breaker of the large bridge wire tree 334 to operate at 00:51, normally transmitting power and waiting for contact during fault processing. "
After obtaining at least one power grid maintenance journal, preprocessing the obtained power grid maintenance journal to remove invalid information in the power grid maintenance journal, and referring to fig. 3 on the basis of fig. 2, this embodiment provides a possible implementation manner, and step 110 includes the following sub-steps:
step 110-1: and removing invalid symbols in the power grid maintenance flow logs.
Because the power grid maintenance flow log is recorded by a maintainer by using a natural language and has a specific format, and the specific format is adopted, the power grid maintenance flow log can provide convenience for extracting effective information in the power grid maintenance flow log. However, the power grid maintenance journal recorded by using the natural language includes more invalid symbols, where the invalid symbols include a line feed symbol, a tab symbol (or an indentation symbol), and a punctuation symbol, such as a quotation mark, and after the power grid maintenance journal is obtained, the invalid symbols are removed first, and interference of the symbols on extraction of effective information in the power grid maintenance journal is eliminated.
Step 110-2: and performing word segmentation processing on the power grid maintenance flow log after the invalid symbol is removed.
The method includes that the power grid maintenance journal with the invalid symbol removed is subjected to word segmentation, in a possible implementation manner, the power grid maintenance journal can be subjected to word segmentation by using a forward maximum matching algorithm, a reverse maximum matching algorithm or a bidirectional maximum matching algorithm, and the like, and this embodiment does not limit this, and other algorithms with the same or similar functions can be adopted for word segmentation.
And obtaining the power grid maintenance flow log after word segmentation, extracting effective information according to the power grid maintenance flow log after word segmentation, and extracting information such as problem lines, problem types, problem line condition description, maintenance operation description, maintenance results and the like in the power grid maintenance flow log.
Most of invalid information is removed from the preprocessed power grid maintenance journal, but the invalid information cannot be completely removed, so that the valid information in the preprocessed power grid maintenance journal is extracted by using a preset rule, and referring to fig. 4 on the basis of fig. 3, fig. 4 shows a flow diagram of another report generation method provided by this embodiment. Step 120 includes the following substeps;
step 120-1: and extracting the equipment name in the preprocessed power grid maintenance flow log.
The power grid maintenance flow log records the name of a specific line or equipment to be overhauled, generally speaking, the name of the equipment is searched in the power grid maintenance flow log, and characters behind the name of the equipment are intercepted until a carriage return symbol is the name of the line or the equipment.
Taking the power grid maintenance journal 1 given in the above embodiment as an example, the text following the "device name" is intercepted until the carriage return symbol, that is, the "device name: and the steam line can obtain the name of the line or equipment repaired by the power grid maintenance flow log, namely the steam line.
Taking the power grid maintenance journal 2 given in the above embodiment as an example, the text following the "device name" is intercepted until the carriage return symbol, that is, the "device name: and the large bridge line can obtain the line or equipment name overhauled by the power grid maintenance flow log, namely the large bridge line.
It should be noted that, part of the lines may be the alternate lines, and when the lines are alternate lines, the name of the extracting device should be extracted from the names of the lines that are specifically alternate. When the power grid maintenance flow log has a 'generation supply' word, the name of a generation supply line needs to be extracted. For example, since there is "(generation supply lead ii hui xiang fu ten city #2 switch station 307 post stage)" in the grid maintenance journal 2, it is necessary to extract the name of the generation supply line from the name of the seat device, that is, "generation supply lead ii hui".
It should be further noted that, since the word segmentation processing cannot be absolutely accurate, in order to avoid extracting the device names by mistake, a database storing all the device names may be preset, and after extracting the device names, the device names are matched with the prestored device names, and the device name with the highest matching degree is determined to be the device name of the power grid maintenance journal.
For example, if the name of the device "generation and supply for longevity" is stored in the database, and the name of the device extracted from the power grid maintenance journal is "generation and supply for longevity" ii ", the name of the device stored in the database may be used as the name of the device in the power grid maintenance journal according to the matching result.
Step 120-2: and extracting problem content description in the preprocessed power grid maintenance flow log by using a preset line problem extraction model.
In a possible implementation mode, when a maintainer uploads or writes the power grid maintenance journal, the maintainer sets a secondary label for the power grid maintenance journal, wherein the secondary label comprises 'trip', 'fault abnormity', 'grounding' and the like.
And for the power grid maintenance journal with different secondary labels, different line problem extraction models are set. For example, when the secondary label is "trip", the first short sentence of "processing procedure" of the contents in the power grid maintenance journal starts until a short sentence containing "find is encountered.
Taking the power grid maintenance journal 1 provided in the above embodiment as an example, starting from the first short sentence of the content "processing procedure" until the short sentence containing "check" is encountered, the short sentence is: and the overcurrent protection action of the line of the steam line tree 368 is tripped at 22:47 days after 30 days, and the reclosing is unsuccessful. The extracted information is the question content description.
It should be noted that, the above embodiment only takes the secondary label as "trip" for example, and for the power grid maintenance flow log with different types of secondary labels, the problem content description in the power grid maintenance flow log may also be extracted through other manners or rules.
Step 120-3: and determining the fault type in the power grid maintenance flow log according to the problem content description, wherein the fault type comprises equipment tripping or equipment grounding.
Taking the power grid maintenance journal 1 provided in the above embodiment as an example, the extracted problem content is described as "30-day 22:47 steam system wire tree 368 line overcurrent protection action trip, coincidence is unsuccessful", and the word "trip" is included, and the fault type is determined to be "equipment trip".
Taking the power grid maintenance journal 2 provided by the above embodiment as an example, the extracted problem content is described as that "30 days 22:47 trees ridge change 10kV ivmother a phase is incompletely grounded, no line is selected on site, D5000 line selection is 378 line (error) of guy line tree, 23:25 line 334 line (for generation of changdou ii hui xiangfu ten city #2 switching station 307 back segment) is turned to hot standby, and grounding disappears. If "ground" is included, the fault type is determined to be.
It should be noted that, the above embodiment only takes the case where the fault type is "equipment trip" or "equipment ground" as an example, and if there are other fault types, the fault type in the power grid maintenance journal may also be extracted by other manners or rules.
Step 120-4: and extracting the maintenance steps and the maintenance results in the power grid maintenance flow log according to the fault type in the power grid maintenance flow log.
And extracting the maintenance step by using a preset rule model, for example, selecting the content containing a 'failure check is' sentence as the maintenance step.
Taking the power grid maintenance journal 1 provided by the above embodiment as an example, the content "02: 31 steam line military security #4 switching station 303 line cooling standby after the sentence of" troubleshooting "is extracted. 02, supplying power to the rear section of a 56-steam-line military security #4 switch station 303 through a Quwan II rotary Happy-gate I-hui forest 306 to serve as an overhauling step.
Taking the power grid maintenance journal 2 provided in the above embodiment as an example, after the content of the sentence "failure detection is extracted" 00:38 turns the long-wide-second-return smoke switching station 307 line cold for standby, 00:51 turns the bridge wire tree 334 breaker to operate "as a maintenance step.
In a possible implementation manner, the power grid maintenance journal is recorded according to a preset format, and a maintenance result is recorded after the maintenance step. And extracting the content after the maintenance step, namely the maintenance result.
In a possible implementation manner, taking the power grid maintenance journal 1 provided in the above embodiment as an example, the content "the fault applies for the live processing on day 1" after the maintenance step is extracted as the maintenance result.
Taking the power grid maintenance journal 2 provided by the above embodiment as an example, the content after the overhaul step is extracted: the 'normal power transmission and the fault processing to be linked' are the maintenance results.
Because the number of lines in the power grid is large, the number of power grid maintenance flow logs processed by the report generation method provided by the embodiment is large. In order to generate a corresponding report more intuitively, before step 130, the method further comprises the following sub-steps:
step 121: and counting the extracted effective information based on preset dimensionality.
The preset dimension comprises at least one of an operation and maintenance unit, an operation and maintenance team, maintenance time and fault type. In the actual processing process, a plurality of power grid maintenance flow logs uploaded by different operation and maintenance units and operation and maintenance teams may be processed at the same time, and the power grid maintenance flow logs may be generated by overhauling a plurality of lines. In order to visually represent the overhaul condition, effective information extracted from the power grid maintenance flow log needs to be counted in advance.
In one possible implementation, the dimension of the statistics includes, but is not limited to, an operation and maintenance unit, an operation and maintenance team, time to overhaul, fault type, and the like. For example, information such as trip times, grounding times, temporary fault times and the like overhauled by different time periods, different operation and maintenance units or teams can be counted.
And after the statistics of the effective information is completed, generating a corresponding report according to the requirements of the user. In one possible implementation, the reports may be divided into daily reports, weekly reports, monthly reports, and the like.
The report generation is to combine the extracted effective information according to the template and add a certain natural language description. The following description will be made by taking the weekly report as an example in combination with the above embodiments.
The weekly report forms are divided into a plurality of different templates according to different faults, for example, the weekly report forms comprise a tripping fault template, a grounding fault template, a fault power failure maintenance template, a charged fault processing template and a quick-dividing switch tripping template. And selecting part of effective information or all effective information in the power grid maintenance flow log according to different templates to generate a report, wherein the information contained in different templates is different.
Taking the fault trip template as an example, the fault trip template includes the following fields: the operation and maintenance team, the operation and maintenance unit, the time, the trip line and protection action condition, the distribution self-signaling condition, the coincidence condition, the grounding condition, the line inspection processing condition and the like. Except that the operation and maintenance team and the operation and maintenance unit directly obtain the fields from the system, the other fields are extracted from the power grid maintenance flow log according to a preset extraction rule.
For example, the time field extracts the "time" in the power grid maintenance journal as the record date, but also needs to extract the true current date according to the time information in the content. And a trip line and protection action condition field, wherein the first short sentence of the processing process of the content in the power grid maintenance flow log is extracted to start until the short sentence containing the check result is used as the trip line and protection action condition. And under the superposition condition, if the contents in the power grid maintenance flow log contain 'superposition success', the result is 'yes', if the contents do not contain or contain 'superposition failure', the result is 'no'. If the content in the power grid maintenance flow log contains contents such as 'ungrounded' or 'ungrounded', the field is 'no'; if the contents in the power grid maintenance flow log contain "ground", the field is "yes". The line-finding processing condition is defined as a content starting from a sentence including "finding" or a sentence including "finding".
Referring to table 1, table 1 shows an example of a weekly report provided in an embodiment of the present application.
The above embodiment only uses the fault trip template as an example to introduce the form and content of the weekly report, but the method cannot be understood as a limitation to the scheme of the present application.
According to the report generation method provided by the embodiment of the application, the power grid maintenance flow logs are obtained, then the obtained power grid maintenance flow logs are preprocessed to remove invalid information in the power grid maintenance flow logs, and the preprocessed valid information in the power grid maintenance flow logs is extracted; the effective information comprises equipment names, fault types, maintenance steps and maintenance results, the extracted effective information is counted based on preset dimensionality, and then at least one part of the effective information is combined according to a preset template to generate a report. The method comprises the steps of extracting information in the power grid maintenance flow logs based on a natural language processing algorithm, and then generating a readable maintenance report according to a preset template, so that careless mistakes are avoided when information is manually read and information is counted, meanwhile, the processing efficiency is improved, and a uniform and accurate maintenance report is formed.
In order to execute corresponding steps in the foregoing embodiments and various possible embodiments, an implementation manner of the report generating apparatus 200 is provided below, please refer to fig. 6, and fig. 6 is a schematic diagram of functional modules of the report generating apparatus 200 according to the present invention. It should be noted that the basic principle and the technical effect of the report generating apparatus 200 according to the embodiment of the present invention are the same as those of the foregoing method embodiment, and for brief description, reference may be made to the corresponding contents of the foregoing method embodiment for a part not mentioned in the embodiment. The report generation apparatus 200 is described below with reference to fig. 1 to 5 and fig. 6, where the report generation apparatus 200 includes: an acquisition module 210 and a processing module 220.
The obtaining module 210 is configured to obtain at least one power grid maintenance flow log.
In a possible implementation manner, the obtaining module 210 may be specifically configured to execute step 101 in each of the above-mentioned figures, so as to achieve the corresponding technical effect.
The processing module 220 is configured to pre-process the obtained power grid maintenance flow log to remove invalid information in the power grid maintenance flow log
In a possible implementation manner, the processing module 220 may be specifically configured to execute the step 110 in each of the above-mentioned figures to achieve the corresponding technical effect.
Specifically, the processing module 220 is configured to remove an invalid symbol in the power grid maintenance flow log, and perform word segmentation processing on the power grid maintenance flow log after the invalid symbol is removed.
In a possible implementation manner, the obtaining module 210 may be specifically configured to execute the steps 101-1 to 101-2 in the above-mentioned figures, so as to achieve the corresponding technical effect.
The processing module 220 is further configured to extract effective information in the preprocessed power grid maintenance flow log; the effective information comprises an equipment name, a fault type, a maintenance step and a maintenance result.
In a possible implementation manner, the processing module 220 may be specifically configured to execute the step 120 in each of the above-mentioned figures to achieve the corresponding technical effect.
Specifically, the processing module 220 is configured to extract a device name in the preprocessed power grid maintenance flow log, extract a problem content description in the preprocessed power grid maintenance flow log by using a preset line problem extraction model, determine a fault type in the power grid maintenance flow log according to the problem content description, and extract an overhaul step and an overhaul result in the power grid maintenance flow log according to the fault type in the power grid maintenance flow log.
In a possible implementation manner, the processing module 220 may be specifically configured to execute steps 120-1 to 120-4 in the above-mentioned figures, so as to achieve the corresponding technical effect.
The processing module 220 is further configured to perform statistics on the extracted valid information based on a preset dimension.
In a possible implementation manner, the processing module 220 may be specifically configured to execute step 121 in each of the above-mentioned figures to achieve the corresponding technical effect.
The processing module 220 is further configured to combine at least a part of the valid information according to a preset template to generate a report.
In a possible implementation manner, the processing module 220 may be specifically configured to execute the step 130 in each of the above figures to achieve the corresponding technical effect.
The embodiment also provides an electronic device, which can be a server or a computer with the same or similar functions. Referring to fig. 7, fig. 7 shows a schematic diagram of an electronic device 300 provided in the present embodiment. The electronic device 300 includes: a processor 310, a memory 320, a bus 330, and a communication interface 340.
The processor 310 may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the report generation method may be performed by integrated logic of hardware or instructions in the form of software in the processor 310. The Processor 310 may be a general-purpose Processor, and includes a Central Processing Unit (CPU), a Network Processor (NP), and the like; the device can also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, or a discrete hardware component.
The Memory 320 may comprise a Random Access Memory (RAM) and may further comprise a non-volatile Memory (non-volatile Memory), such as at least one disk Memory.
The bus 330 may be an ISA (Industry Standard architecture) bus, a PCI (peripheral component interconnect) bus, an EISA (extended Industry Standard architecture) bus, or the like. Only one bi-directional arrow is shown in fig. 7, but this does not indicate only one bus 330 or one type of bus 330.
The memory 320 is used for storing programs, such as programs corresponding to the report generating apparatus. The report generating means includes at least one software function module which can be stored in the memory 320 in the form of software or firmware (firmware) or solidified in an Operating System (OS) of the electronic device. The processor 310 executes the program to implement the report generation method after receiving the execution instruction.
The communication interface 340 is used to implement communication connection between the electronic device 300 and other devices, for example, to connect a server storing a power grid maintenance flow log to obtain the power grid maintenance flow log.
In summary, the present invention provides a report generation method, an apparatus and an electronic device, where the report generation method includes preprocessing an acquired power grid maintenance journal to remove invalid information in the power grid maintenance journal; extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises equipment names, fault types, maintenance steps and maintenance results; and combining at least one part of effective information according to a preset template to generate a report. Information in the power grid maintenance flow logs is extracted based on a natural language processing algorithm, and then a readable maintenance report is generated according to a preset template, so that careless mistakes are avoided when information is manually read and statistical information is easily generated, meanwhile, the processing efficiency is improved, a uniform and accurate maintenance report is formed, the report generation efficiency is improved, and the report generation precision is improved.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method can be implemented in other ways. The apparatus embodiments described above are merely illustrative, and for example, the flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, the functional modules in the embodiments of the present invention may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Although the present invention is disclosed above, the present invention is not limited thereto. Various changes and modifications may be effected therein by one skilled in the art without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (10)
1. A report generation method is characterized by comprising the following steps of;
preprocessing the obtained power grid maintenance flow log to remove invalid information in the power grid maintenance flow log;
extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises an equipment name, a fault type, a maintenance step and a maintenance result;
and combining at least one part of the effective information according to a preset template to generate a report.
2. The report generation method according to claim 1, wherein the step of extracting the valid information in the preprocessed power grid maintenance flow log comprises:
extracting the equipment name in the preprocessed power grid maintenance flow log;
extracting problem content description in the preprocessed power grid maintenance flow log by using a preset line problem extraction model;
determining the fault type in the power grid maintenance flow log according to the problem content description, wherein the fault type comprises tripping or grounding;
and extracting the maintenance steps and the maintenance results in the power grid maintenance flow log according to the fault type in the power grid maintenance flow log.
3. A report generation method according to claim 1, wherein before generating a report by combining at least a part of said valid information according to a preset template, further comprising:
and counting the extracted effective information based on preset dimensionality, wherein the preset dimensionality comprises at least one of an operation and maintenance unit, an operation and maintenance team, maintenance time and fault types.
4. The report generation method according to claim 1, wherein the step of preprocessing the obtained power grid maintenance flow logs to remove invalid information in the power grid maintenance flow logs comprises:
removing invalid symbols in the power grid maintenance flow log, wherein the invalid symbols comprise line feed symbols, tab symbols and punctuation marks;
and performing word segmentation processing on the power grid maintenance flow log after the invalid symbol is removed.
5. The report generation method according to claim 1, wherein before the pre-processing of the obtained power grid maintenance journal to remove invalid information in the power grid maintenance journal, the method further comprises:
and acquiring at least one part of the power grid maintenance flow log.
6. A report generation apparatus for performing the method according to any one of claims 1 to 5, the report generation apparatus comprising:
the acquisition module is used for acquiring at least one power grid maintenance flow log;
the processing module is used for preprocessing the acquired power grid maintenance flow log to remove invalid information in the power grid maintenance flow log; the system is also used for extracting effective information in the preprocessed power grid maintenance flow log; the effective information comprises an equipment name, a fault type, a maintenance step and a maintenance result; the processing module is further used for combining at least one part of the effective information according to a preset template to generate a report.
7. The report generation apparatus according to claim 6, wherein the processing module is configured to extract a device name in the preprocessed power grid maintenance journal; the system is also used for extracting problem content description in the preprocessed power grid maintenance flow log by using a line problem extraction model; the fault type in the power grid maintenance flow log is determined according to the problem content description, and the fault type comprises tripping and grounding; the processing module is further used for extracting the maintenance steps and the maintenance results in the power grid maintenance flow log according to the fault type in the power grid maintenance flow log.
8. The report generation device according to claim 6, wherein the processing module is further configured to count the extracted valid information based on preset dimensions, and the preset dimensions include at least one of an operation and maintenance unit, an operation and maintenance team, maintenance time, and a fault type.
9. The report generation device according to claim 6, wherein the processing module is configured to remove invalid symbols in the power grid maintenance journal, where the invalid symbols include a line break symbol, a tab symbol, and a punctuation symbol; the processing module is further used for performing word segmentation processing on the power grid maintenance flow log after the invalid symbol is removed.
10. An electronic device, characterized in that the electronic device comprises a processor to execute a computer program to implement the steps of the method according to any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911170831.2A CN111090973A (en) | 2019-11-26 | 2019-11-26 | Report generation method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911170831.2A CN111090973A (en) | 2019-11-26 | 2019-11-26 | Report generation method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111090973A true CN111090973A (en) | 2020-05-01 |
Family
ID=70394277
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911170831.2A Pending CN111090973A (en) | 2019-11-26 | 2019-11-26 | Report generation method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111090973A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111830931A (en) * | 2020-07-15 | 2020-10-27 | 中国科学院微电子研究所 | Fault diagnosis method of DCS (distributed control system) |
| CN112102107A (en) * | 2020-07-30 | 2020-12-18 | 广东电网有限责任公司广州供电局 | Method, device and equipment for generating report of power supply system |
| CN112131852A (en) * | 2020-09-14 | 2020-12-25 | 中国南方电网有限责任公司超高压输电公司昆明局 | Converter station fault report automatic generation method and device, electronic equipment and storage medium |
| CN112148897A (en) * | 2020-09-14 | 2020-12-29 | 深圳供电局有限公司 | Automatic retrieval and classification method and system for fault information of power system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170108856A1 (en) * | 2015-10-14 | 2017-04-20 | Honeywell International Inc. | Devices, methods, and systems for a distributed rule based automated fault detection |
| CN107742162A (en) * | 2017-10-24 | 2018-02-27 | 国网江苏省电力公司南京供电公司 | A kind of multidimensional characteristic association analysis method based on auxiliary tone monitoring information |
| CN107992597A (en) * | 2017-12-13 | 2018-05-04 | 国网山东省电力公司电力科学研究院 | A kind of text structure method towards electric network fault case |
| CN108734418A (en) * | 2018-06-13 | 2018-11-02 | 国网山东省电力公司蓬莱市供电公司 | A kind of electric network fault statistical analysis system and its analysis method |
| CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技（中国）有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
| CN110287279A (en) * | 2019-05-24 | 2019-09-27 | 国网冀北电力有限公司 | A method of non-structured Log Report is switched into architectural system report |
-
2019
- 2019-11-26 CN CN201911170831.2A patent/CN111090973A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170108856A1 (en) * | 2015-10-14 | 2017-04-20 | Honeywell International Inc. | Devices, methods, and systems for a distributed rule based automated fault detection |
| CN107742162A (en) * | 2017-10-24 | 2018-02-27 | 国网江苏省电力公司南京供电公司 | A kind of multidimensional characteristic association analysis method based on auxiliary tone monitoring information |
| CN107992597A (en) * | 2017-12-13 | 2018-05-04 | 国网山东省电力公司电力科学研究院 | A kind of text structure method towards electric network fault case |
| CN108734418A (en) * | 2018-06-13 | 2018-11-02 | 国网山东省电力公司蓬莱市供电公司 | A kind of electric network fault statistical analysis system and its analysis method |
| CN109766534A (en) * | 2018-12-19 | 2019-05-17 | 益萃网络科技（中国）有限公司 | Report form generation method, device, computer equipment and readable storage medium storing program for executing |
| CN110287279A (en) * | 2019-05-24 | 2019-09-27 | 国网冀北电力有限公司 | A method of non-structured Log Report is switched into architectural system report |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111830931A (en) * | 2020-07-15 | 2020-10-27 | 中国科学院微电子研究所 | Fault diagnosis method of DCS (distributed control system) |
| CN111830931B (en) * | 2020-07-15 | 2021-08-20 | 中国科学院微电子研究所 | Fault diagnosis method of DCS (distributed control system) |
| CN112102107A (en) * | 2020-07-30 | 2020-12-18 | 广东电网有限责任公司广州供电局 | Method, device and equipment for generating report of power supply system |
| CN112131852A (en) * | 2020-09-14 | 2020-12-25 | 中国南方电网有限责任公司超高压输电公司昆明局 | Converter station fault report automatic generation method and device, electronic equipment and storage medium |
| CN112148897A (en) * | 2020-09-14 | 2020-12-29 | 深圳供电局有限公司 | Automatic retrieval and classification method and system for fault information of power system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111090973A (en) | Report generation method and device and electronic equipment | |
| CN112115026B (en) | Server cluster monitoring method and device, electronic equipment and readable storage medium | |
| CN110909123B (en) | Data extraction method and device, terminal equipment and storage medium | |
| CN111327514B (en) | WeChat image-text message group sending method, system, server and storage medium | |
| CN113688987B (en) | Training method of photovoltaic monitoring model, monitoring method and device of photovoltaic device | |
| CN110196848A (en) | A kind of cleaning De-weight method and its system towards public resource transaction data | |
| Taylor | Statistics of design error in the process industries | |
| CN114078252A (en) | Intelligent work ticket checking method and system | |
| CN109284331B (en) | Certificate making information acquisition method based on service data resources, terminal equipment and medium | |
| CN112396359A (en) | Water and soil loss region supervision method and device, mobile terminal and storage medium | |
| CN105528264A (en) | Anti-misoperation data recovery method and system | |
| JP2019049802A (en) | Failure analysis supporting device, incident managing system, failure analysis supporting method, and program | |
| CN111865673A (en) | Automatic fault management method, device and system | |
| CN109766552B (en) | Announcement information-based reference resolution method and device | |
| CN109343993A (en) | A kind of error message processing method and processing device of cloud platform | |
| CN112148897A (en) | Automatic retrieval and classification method and system for fault information of power system | |
| CN106294115A (en) | The method of testing of a kind of application system animal migration and device | |
| CN108170838B (en) | Topic evolution visualization display method, application server and computer readable storage medium | |
| CN115860495A (en) | Emergency plan processing method, device, equipment, medium and product | |
| CN115391059A (en) | Data playback method and device, computer equipment and computer readable storage medium | |
| CN115482075A (en) | Financial data anomaly analysis method and device, electronic equipment and storage medium | |
| CN112926951A (en) | Equipment transaction identification method and device | |
| CN201570025U (en) | System for identifying repeated texts | |
| CN114548825B (en) | Complaint work order distortion detection method, device, equipment and storage medium | |
| CN117875948B (en) | Equipment-based power grid overhaul event determination method, device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200501 |