Auxiliary service assessment data processing method and device
By automatically obtaining and filtering auxiliary service assessment data and generating reports in different preset formats, the problems of low efficiency and accuracy of manual processing are solved, and the entire process of auxiliary service assessment data is automatically processed, reducing costs and improving efficiency and accuracy sex.
Patent Information
- Application Number
- CN202111573954.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-12-21
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2041-12-21
AI Technical Summary
The existing data processing methods for assisted service assessment based on manual have problems such as high time and labor costs, and low data processing efficiency and accuracy.
By obtaining initial auxiliary service assessment data from the computer monitoring system and the power grid company auxiliary service assessment system, screening and feature data extraction, and generating reports in different preset formats, the entire process of auxiliary service assessment data is realized.
It effectively reduces time and labor costs, improves data processing efficiency, and ensures the accuracy of data processing results.
Smart Images

Figure CN114429407B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of power assessment management, and in particular to a method and device for processing auxiliary service assessment data. Background Art
[0002] In recent years, the power grid companies have increasingly increased their requirements for the power quality of power generation companies. As a means of control, the power grid companies will conduct monthly assessments on the execution of power regulation instructions of power generation companies, namely, auxiliary service assessments. Ancillary services refer to services provided by power generation companies, power grid operating companies and power users in addition to normal power production, transmission and use, in order to maintain the safe and stable operation of the power system and ensure power quality, including primary frequency regulation, automatic power generation control, peak regulation, automatic voltage reactive power control, standby, etc. In order to reduce the economic losses caused by unqualified assessment items to enterprises, power generation companies need to regularly summarize and analyze the generated auxiliary service assessment data in order to promptly identify unqualified assessment items and make rectifications.
[0003] At present, auxiliary service assessment data exists in systems of two different network partitions, which cannot communicate with each other and need to be exported manually. Moreover, message data are mostly text files, which cannot be screened and searched more complexly. Manual verification of message information line by line and data extraction are required. Faced with the current large amount of message data and much redundant data, data analysis and processing are difficult. It can be seen that the existing manual auxiliary service assessment data processing method has the problems of high time and labor costs, and low data processing efficiency and accuracy. Summary of the invention
[0004] In view of this, the present application provides an auxiliary service assessment data processing method and device, the main purpose of which is to solve the problems of high time and labor costs, and low data processing efficiency and accuracy in the existing manual auxiliary service assessment data processing method.
[0005] According to one aspect of the present application, a method for processing auxiliary service assessment data is provided, the method comprising:
[0006] Obtain initial auxiliary service assessment data from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively;
[0007] By screening the initial auxiliary service assessment data, target messages corresponding to multiple auxiliary service types are obtained;
[0008] For each auxiliary service type, extracting characteristic data from the target message respectively to obtain characteristic data corresponding to multiple auxiliary service types;
[0009] Reports corresponding to different preset formats are generated according to the characteristic data corresponding to the multiple auxiliary service types.
[0010] According to another aspect of the present application, there is provided an auxiliary service assessment data processing device, the device comprising:
[0011] Acquisition module: used to obtain initial auxiliary service assessment data from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively;
[0012] Screening module: used for screening the initial auxiliary service assessment data to obtain target messages corresponding to multiple auxiliary service types;
[0013] Extraction module: for extracting characteristic data from the target message for each auxiliary service type, and obtaining characteristic data corresponding to multiple auxiliary service types;
[0014] Generating module: used for generating reports corresponding to different preset formats according to the characteristic data corresponding to the multiple auxiliary service types.
[0015] According to another aspect of the present application, a storage medium is provided, on which a computer program is stored, and when the program is executed by a processor, the above-mentioned auxiliary service assessment data processing method is implemented.
[0016] According to another aspect of the present application, a computer device is provided, including a storage medium, a processor, and a computer program stored on the storage medium and executable on the processor, wherein the processor implements the auxiliary service assessment data processing method when executing the program.
[0017] By means of the above technical scheme, the auxiliary service assessment data processing method and device provided by the present application, compared with the existing manual auxiliary service assessment data processing method, the present application obtains initial auxiliary service assessment data from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively, obtains target messages corresponding to multiple auxiliary service types by screening the initial auxiliary service assessment data, extracts feature data from the target message for each auxiliary service type, obtains feature data corresponding to multiple auxiliary service types, and generates reports corresponding to different preset formats according to the feature data corresponding to multiple auxiliary service types. It can be seen that by automatically obtaining initial auxiliary service assessment data from systems of different network partitions, extracting feature data based on the data screening results, and then generating reports of different preset formats according to the feature data extraction results, it is possible to effectively avoid the technical problems of high time and labor costs, low data processing efficiency and accuracy of the existing manual auxiliary service assessment data processing method, thereby realizing full-process automatic processing of auxiliary service assessment data, and effectively reducing time and labor costs, improving data processing efficiency, while ensuring the accuracy of data processing results.
[0018] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS
[0019] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:
[0020] Figure 1 A flowchart of a method for processing auxiliary service assessment data provided by an embodiment of the present application is shown;
[0021] Figure 2 A flow chart of another auxiliary service assessment data processing method provided in an embodiment of the present application is shown;
[0022] Figure 3 A schematic diagram of the structure of an auxiliary service assessment data processing device provided in an embodiment of the present application is shown;
[0023] Figure 4 A schematic diagram of the structure of another auxiliary service assessment data processing device provided in an embodiment of the present application is shown. DETAILED DESCRIPTION
[0024] The present application will be described in detail below with reference to the accompanying drawings and in combination with embodiments. It should be noted that the embodiments and features in the embodiments of the present application can be combined with each other without conflict.
[0025] The current manual auxiliary service assessment data processing method has technical problems such as high time and labor costs and low accuracy of analysis results. This embodiment provides an auxiliary service assessment data processing method, which obtains initial auxiliary service assessment data from systems in different network partitions at regular intervals, extracts feature data based on data screening results, and then generates reports according to different preset formats based on feature data, thereby realizing full-process automatic processing of auxiliary service assessment data, effectively reducing time and labor costs, improving data processing efficiency, and ensuring the accuracy of data processing results. Figure 1 As shown, the method includes:
[0026] Step 101: Obtain initial auxiliary service assessment data from a computer monitoring system and an auxiliary service assessment system of a power grid company respectively.
[0027] In this embodiment, the computer monitoring system and the auxiliary service assessment system of the power grid company belong to different network areas. In order to achieve data connectivity between different systems, initial auxiliary service assessment data are obtained from the two systems respectively through cross-network area data transmission and same-network area data transmission. At the same time, according to the preset timing task, the initial auxiliary service assessment data is read regularly through the interface program to realize the automatic import of auxiliary service assessment data from different network partitions. Among them, the message format of the initial auxiliary service assessment data can include text document format and Excel spreadsheet format. At the same time, the preset timing task can be set according to data analysis requirements. In this embodiment, it is necessary to process the data of each natural month, so the preset timing task is to read the initial auxiliary service assessment data of the previous natural month at zero o'clock on the first day of the current natural month.
[0028] Step 102: Filter the initial auxiliary service assessment data to obtain target messages corresponding to multiple auxiliary service types.
[0029] In this embodiment, the acquired initial auxiliary service assessment data corresponds to multiple auxiliary service types, wherein the auxiliary service types include: primary frequency regulation, bus voltage, automatic voltage control (AVC: Automatic Voltage Control), etc. The initial auxiliary service assessment data of each auxiliary service type includes complicated messages, and the proportion of messages that need to be specifically analyzed is relatively small. For each auxiliary service type, the messages that need to be specifically analyzed are screened out from the initial auxiliary service assessment data to obtain target messages corresponding to multiple auxiliary service types, which can remove data redundancy in the initial auxiliary service assessment data, thereby reducing the workload of backward feature data extraction and improving the work efficiency of data processing.
[0030] Step 103: For each auxiliary service type, extract feature data from the target message to obtain feature data corresponding to multiple auxiliary service types.
[0031] In this embodiment, the characteristic data includes first characteristic data obtained by extracting characteristic data from the target message and second characteristic data calculated from the first characteristic data. For each auxiliary service type, characteristic data is extracted from the target message to obtain first characteristic data corresponding to multiple auxiliary service types, wherein the first characteristic data includes time data, reason data, and data on whether the corresponding auxiliary service is in an exit state in the power unit equipment, and whether the exit state belongs to the category of exemption from auxiliary service assessment set by the power grid company. Further, according to the exit state time data, reason data, and data on whether it belongs to the exemption from assessment, the second characteristic data is calculated, wherein the second characteristic data includes: unit full stop time, total auxiliary service exit time, monthly exemption from assessment time, auxiliary service commissioning rate, etc.
[0032] Step 104: Generate reports corresponding to different preset formats according to the characteristic data corresponding to the multiple auxiliary service types.
[0033] In this embodiment, different preset formats correspond to different report template formats. The report template is obtained based on the report template file issued by the power grid company, specifically including a first report template in the format of an Excel spreadsheet and a second report template in the format of a Word electronic document. The feature data corresponding to multiple auxiliary service types are imported into the first report template using a preset import function to generate a first report; further, the screenshot file of the first report is imported into the second report template using a preset import function to generate a second report. When the power grid company issues a new report template file, the new report template file needs to be imported. Before importing the report template file, the report template file name (including the full path) and the dictionary of replacement content need to be manually input into the preset import function so that the preset import function can recognize it.
[0034] In actual application scenarios, since power companies need to provide reports to power grid companies every month, report templates are generated based on the report template files issued by the power grid companies, and the extracted feature data are imported into the corresponding positions of different templates to generate reports that meet the format requirements of the power grid companies. This can effectively improve the efficiency and accuracy of report generation, thereby reducing manpower and time costs.
[0035] For this embodiment, according to the above scheme, initial auxiliary service assessment data can be obtained from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively, and the target messages corresponding to multiple auxiliary service types are obtained by screening the initial auxiliary service assessment data. For each auxiliary service type, feature data is extracted from the target message respectively to obtain feature data corresponding to multiple auxiliary service types, and reports corresponding to different preset formats are generated according to the feature data corresponding to the multiple auxiliary service types. Compared with the existing manual-based auxiliary service assessment data processing method, this embodiment automatically obtains initial auxiliary service assessment data from systems in different network partitions, extracts feature data based on data screening results, and then generates reports in different preset formats according to the feature data extraction results. It can effectively avoid the technical problems of high time and labor costs and low data processing efficiency and accuracy in the existing manual-based auxiliary service assessment data processing method, thereby realizing full-process automatic processing of auxiliary service assessment data, and effectively reducing time and labor costs and improving data processing efficiency while ensuring the accuracy of data processing results.
[0036] Further, as a refinement and extension of the specific implementation of the above embodiment, in order to fully illustrate the specific implementation process of this embodiment, another auxiliary service assessment data processing method is provided, such as Figure 2 As shown, the method includes:
[0037] Step 201: Transmit data across network areas through a firewall and a horizontal isolation device to obtain initial auxiliary service assessment data on the computer monitoring system side.
[0038] Step 202: Transmit data in the same network area through a network switch to obtain initial auxiliary service assessment data on the auxiliary service assessment system side of the power grid company.
[0039] During implementation, for the computer monitoring system that belongs to a different network partition from the data processing side, cross-region data transmission is performed through firewalls and horizontal isolation devices, and the initial auxiliary service assessment data of this side is read regularly using an interface program; for the auxiliary service assessment system of the power grid company that belongs to the same network partition as the data processing side, same-region data transmission is performed through a network switch, and the initial auxiliary service assessment data of this side is read regularly using an interface program, wherein the auxiliary service assessment system of the power grid company can be the Southern Power Grid "1+5" auxiliary service assessment system, and the network partition of its server belongs to security zone III (production management zone); the computer monitoring system can be the monitoring system on the power equipment side, and the network partition of its server belongs to security zone I (production real-time control zone). Acquisition of auxiliary service assessment data of different network partitions through firewalls and horizontal isolation devices can effectively solve the problem of cross-region data transmission and ensure the security of data transmission.
[0040] Step 203: Filter the message of the initial auxiliary service assessment data by using preset keywords to obtain a target message containing the preset keywords, wherein the preset keywords are set according to multiple auxiliary service types of the initial auxiliary service assessment data.
[0041] During implementation, the preset keywords are set based on the message signal content that needs to be specifically analyzed in the historical auxiliary service data messages of each auxiliary service type. For each auxiliary service type, the corresponding preset keywords are used to match the messages of the initial auxiliary service assessment data, and the messages containing the preset keywords are retained as target messages to achieve the elimination of non-essential processing messages and the extraction of necessary processing messages in the initial auxiliary service assessment data.
[0042] Step 204: For each auxiliary service type, extract characteristic data from the target message to obtain first characteristic data corresponding to multiple auxiliary service types.
[0043] In order to illustrate the specific implementation method of step 204, as a preferred embodiment, step 204 specifically includes: for each auxiliary service type, using the corresponding preset condition judgment process to judge the multiple message signals in the target message in turn, and determine the arrangement order between different message signals; according to the arrangement order between the different message signals, output the characteristic data corresponding to each message signal according to the preset condition judgment process, and obtain the first characteristic data of the target message.
[0044] During implementation, each target message includes multiple message signals arranged in chronological order, and the message signals include content, status and time, wherein the content and status of different message signals represent different operating states of the auxiliary service, the time of the message signal corresponds to the time when the auxiliary service is put into operation or withdrawn from operation, and the order of appearance of adjacent different auxiliary service operating states represents different reasons for the auxiliary service to withdraw from operation, and the multiple message signals of each target message are judged in turn by the preset condition judgment process to determine the permutation and combination formed by every two adjacent different message signals, and further according to the correspondence between the different permutations and combinations of message signals and the preset output characteristic data in the preset condition judgment process, the first characteristic data of the target message is obtained, wherein the first characteristic data at least includes: input time, exit time, total exit time, first preset reason, second preset reason, exemption from assessment is met, and exemption from assessment is not met, wherein the total exit time is the difference between the input time and the exit time.
[0045] Specifically, the preset condition judgment process includes five conditional branches, including:
[0046] The first conditional branch: get the message, flag bit = False; judge the first message signal: whether the message signal content contains "auxiliary service input"; if yes, enter the second conditional branch; if no, determine that the message signal contains "unit shutdown state" and "action"; further judge: whether "flag bit = False"; if no, end the current message signal; if yes, get the current message signal time as "input time"; the exit reason is "first preset reason"; whether it meets the exemption from assessment is "yes"; assign the flag bit to Ture; get the current message signal time "Time"; further judge: whether the message is over; if yes, the process ends; if no, read the next message signal.
[0047] The second conditional branch: determine whether the message signal state contains "reset"; if yes, obtain the current message signal time as the "exit time", end the current message signal, and read the next message signal; if no, enter the third conditional branch.
[0048] The third conditional branch: judge: whether "flag bit = False"; if yes, enter the fourth conditional branch; if no, use "Time" in the first conditional branch as "exit time"; obtain the current message signal time as "entry time"; the exit reason is "second preset reason"; whether it meets the exemption from assessment is "no"; end the current message signal.
[0049] The fourth conditional branch: judge: whether the filled data list is empty; if not, enter the fifth conditional branch; if yes, take the first day of the current natural month at 0:00 as the "exit time"; obtain the current message signal time as the "entry time"; the exit reason is the "second preset reason"; whether it meets the exemption from assessment is "no"; end the current message signal.
[0050] The fifth conditional branch: obtain the current message signal time as the "investment time"; the exit reason is the "first preset reason"; whether it meets the exemption from assessment is "yes"; end the current message signal.
[0051] It should be noted that the "investment time" of the first conditional branch and the fifth conditional branch corresponds to the "exit time" of the second conditional branch. In addition, the characteristic data (first characteristic data) such as the exit time, investment time, exit reason, and whether to be exempted from assessment obtained through the preset conditional judgment process are all filled into the data list with a single natural month as the statistical period. The judgment statement "whether the filled data list is empty" in the "fourth conditional branch" determines whether the current message signal is the first message signal of the current natural month.
[0052] Furthermore, the corresponding relationship between different message signal combinations and preset output characteristic data specifically includes:
[0053] If the message signal corresponds to the permutation and combination of the power unit action signal and the auxiliary service input signal, the exit time is the time of the power unit action signal, the input time is the time of the auxiliary service input signal, and the exit reason is "unit shutdown", which does not meet the exemption from assessment;
[0054] If the message signal corresponds to the combination of the reset signal of the auxiliary service and the action signal of the power unit, the exit time is the time when the reset signal of the auxiliary service is put into operation, the input time is the time when the action signal of the power unit is put into operation, and the exit reason is "centralized control exits auxiliary service", which meets the exemption from assessment;
[0055] If the message signal corresponds to the reset signal of the auxiliary service input and the permutation and combination of the auxiliary service input signal, the exit time is the time when the auxiliary service input reset signal is input, the input time is the time when the auxiliary service input signal is input, and the exit reason is "centralized control exits auxiliary service", which meets the exemption from assessment;
[0056] If the first message signal of the target message is an auxiliary service input signal, the exit time is midnight of the first day of the month, the input time is the time of the auxiliary service input signal, and the exit reason is "unit shutdown", which does not meet the exemption from assessment.
[0057] Specifically, the above method is explained by taking a process link of the automatic voltage control AVC auxiliary service type as an example, wherein the message signal content and status corresponding to the AVC auxiliary service type include: "unit AVC input", "unit AVC input" and "reset", "unit shutdown state" and "action", the first characteristic data includes the first preset reason of "before the unit is shut down, the centralized control exits the single machine AVC", and the second preset reason is "unit shutdown", and the message signal is judged by using the preset condition judgment process corresponding to the AVC auxiliary service type to obtain the first characteristic data, which specifically includes:
[0058] If the current message signal is "unit AVC put into operation" and the data list is empty, it will flow through the fourth conditional branch, take the zero o'clock of the first day of the current natural month as the exit time, obtain the current message signal time as the entry time, the total exit time = entry time - exit time, the exit reason is "unit shutdown", whether it meets the exemption from assessment "no".
[0059] If the current message signal is "unit AVC is engaged" and "reset", the flow goes through the second conditional branch and the current message signal is obtained as the exit time.
[0060] If the current message signal is "unit shutdown state" and "action" and the previous message signal is "unit AVC activation" and "reset", it flows through the first conditional branch, obtains the exit time obtained from the previous message signal as the exit time, obtains the current message signal time as the activation time, the total exit time = activation time - exit time, the exit reason is "before the unit is shut down, the centralized control exits the single-machine AVC", whether it meets the exemption from assessment "yes", the flag bit = Ture, and the current message signal time is obtained and stored as Time.
[0061] If the current message signal is "unit AVC on" and the previous message signal is "unit shutdown" and "action", then flow through the third conditional branch, get the Time time as the exit time, get the current message signal time as the entry time, the total exit time = entry time - exit time, the exit reason is "unit shutdown", whether it meets the exemption from assessment "no".
[0062] If the current message signal is "unit AVC is on" and the previous message signal is "unit AVC is on" and "reset", then the flow goes through the fifth conditional branch, and the current message signal time is obtained as the on-time, and the exit time obtained from the previous message signal is obtained as the exit time. The total exit time = on-time - exit time. The exit reason is "before the unit is shut down, the centralized control system exits the single-machine AVC". Whether it meets the exemption from assessment is "yes".
[0063] In actual application scenarios, the message signals representing different auxiliary service operating states are not in a one-to-one correspondence with the first feature data, and the first feature data cannot be directly obtained by pairing keyword dictionary key values. Instead, it is necessary to extract the first feature data according to the order in which two adjacent different auxiliary service operating states appear, and use the preset condition judgment process to extract feature data from multiple message signals in the target message. This can accurately extract the feature data represented by the message signal, thereby improving the efficiency and accuracy of auxiliary service assessment data processing.
[0064] Step 205: For each auxiliary service type, calculation is performed based on the first characteristic data to obtain second characteristic data corresponding to multiple auxiliary service types.
[0065] During implementation, the second characteristic data includes: "Total auxiliary service withdrawal time", "Full unit shutdown time", "Monthly assessment-free time", and "Auxiliary service operation rate". For each auxiliary service type, the second characteristic data is calculated based on the first characteristic data, specifically including: summing up all "withdrawal times" in the current data list to obtain the "total auxiliary service withdrawal time"; summing up all "withdrawal times" in the current data list corresponding to the withdrawal reason of "unit shutdown" to obtain the "full unit shutdown time"; summing up all "withdrawal times" in the current data list corresponding to whether to be exempted from assessment as "yes" to obtain the "monthly assessment-free time"; the difference between the "total auxiliary service withdrawal time" and the "full unit shutdown time" is compared with the "total time of the current natural month" to obtain the "auxiliary service operation rate".
[0066] Step 206: Generate a first report according to the first characteristic data and the second characteristic data in accordance with a preset format corresponding to a first report template.
[0067] During implementation, the first characteristic data output after the message signal undergoes a preset condition judgment process is filled into the first characteristic data area (data list) of the first report template, and further, the second characteristic data is filled into the second characteristic data area of the first report template to obtain a first report, wherein the first report is a data type report that meets the Excel spreadsheet format of the power grid company, which is used to store all data analysis results and provide data basis for the generation of the second report, the third report and the data graph.
[0068] Step 207: fill the screenshot of the corresponding content of the first report into the second report template according to the preset format of the second report template to generate a second report.
[0069] During implementation, the content to be captured in the first report is determined according to the keywords of the current picture filling area of the second report template, and the maximum filling size of the current picture filling area of the second report template and the size of the screenshot area corresponding to the content to be captured in the first report are determined by using a preset screenshot function. Further, according to the maximum filling size and the size of the area to be captured, one or more screenshot files corresponding to the content to be captured are obtained by using a preset screenshot function. Based on the first report and the one or more screenshot files, a second report is generated according to a preset format of a second preset template, wherein the second report is a report-type report that meets the word electronic document format of a power grid company, and the corresponding second report template includes multiple picture filling areas and keywords and explanations of the corresponding filling content. The specific process includes the following steps:
[0070] 1) Based on the fixed text format of the second report template, such as font, line spacing, etc., a preset screenshot function is used to calculate the maximum filling size of the picture filling area in the second report template in the current page.
[0071] 2) Since the data in the first report will be converted into text data during the program reading process, the beginning of the content to be intercepted contains a text field that has a unique correspondence with the keyword of the picture fill area. Therefore, the content to be intercepted can be determined from the first report according to the keyword of the picture fill area. Further, the area to be intercepted is determined according to the position of the content to be intercepted in the Excel cell, and then based on the fixed cell format, the size of the area to be intercepted is calculated using the preset screenshot function.
[0072] 3) Using the screenshot function and the adjustment judgment statement to capture the screenshot area: compare the length of the screenshot area with the length of the maximum filling size. If the length of the screenshot area is less than or equal to the maximum filling size, the screenshot area is captured to obtain a screenshot file; if the length of the screenshot area is greater than the maximum filling size, the screenshot area is split and captured to obtain multiple screenshot files, wherein the first report and the second report are both in fixed formats, and the default screenshot area size width is less than the maximum filling size width. In addition, each time a screenshot is completed, the final position of the last screenshot will be recorded so that the next time a screenshot is taken, the screenshot area will be automatically transferred to the position where there is no screenshot, referring to the last screenshot position, to ensure that the screenshot area is complete and without overlap. For example, the area to be screenshotted is [A1:I80], the maximum fill size of the current page of the second report template corresponds to the size of 30 rows of data, and the fill size of the blank page corresponds to the size of 50 rows of data. The area to be screenshotted is captured twice, screen_area is ['A1:I30', 'A31:I80'], flag: y, picture_name is ['1', '2'], and screenshot file 1 and screenshot file 2 are obtained.
[0073] Among them, the preset screenshot function includes 5 inputs, namely: #filename: excel file name (including full path), #sheetname: sheet page name of excel file, #screen_area: screenshot area, stored in list form such as: ['A1:M11','A13:L23','A26:L36'], which means to capture 3 areas respectively: A1 to M11, A13 to L23, A26 to L36, #picture_name: file name of generated screenshot (including full path), stored in list form, the program will add .png suffix such as: ['E: / png1','E: / png2','E: / png3'], #flag: a mark for whether to continue processing, y means that the screenshot is abnormal and not all screenshots are generated. It is necessary to call this preset screenshot function again to process the ungenerated screenshots; if all processing is completed, it is represented by n.
[0074] 4) Using a preset import function, one or more screenshot files are imported into corresponding filling areas of the second report template to generate a second report.
[0075] Step 208: Generate data graphs of different dimensions based on the first report, and the data graphs of different dimensions include at least: a data graph of a time dimension, a data graph of a device dimension, and a data graph of an auxiliary service type dimension.
[0076] In actual application scenarios, data graphs corresponding to different dimensions can be generated in real time according to the user's needs in different dimensions, where the data graph dimensions can specifically include: time dimension, such as month, year, auxiliary service type dimension, such as primary frequency regulation auxiliary service type, bus voltage auxiliary service type, AVC auxiliary service type, equipment dimension, such as Unit 1, AVC substation, etc. The data graph types can specifically include: bar charts, pie charts, line charts, etc., which are not specifically limited here. In addition, the obtained data graph can be used to import the first report, the second report and the third report to provide a reference for the user's further data analysis, thereby achieving data visualization while meeting the user's analysis needs for data of different dimensions.
[0077] Step 209: Summarize the first reports of the corresponding time period to obtain a third report.
[0078] During implementation, based on the user's requirements for the time period of data analysis, multiple first reports within the corresponding time period are read through a preset storage path, and the data in the multiple first reports are calculated on a month-on-month and year-on-year basis. Then, a third report is generated based on the month-on-month and year-on-year calculation results. The third report is used for analysis of auxiliary service assessment data within the power company, and can be an annual report, quarterly report, etc., which is not specifically limited here.
[0079] By applying the technical solution of this embodiment, initial auxiliary service assessment data is obtained from a computer monitoring system and an auxiliary service assessment system of a power grid company respectively. By screening the initial auxiliary service assessment data, target messages corresponding to multiple auxiliary service types are obtained. For each auxiliary service type, feature data is extracted from the target message respectively to obtain feature data corresponding to multiple auxiliary service types. Reports corresponding to different preset formats are generated according to the feature data corresponding to the multiple auxiliary service types. Compared with the existing manual-based auxiliary service assessment data analysis and processing method, this embodiment automatically obtains initial auxiliary service assessment data from systems of different network partitions, extracts feature data based on data screening results, and then generates reports in different preset formats according to the feature data extraction results. This can effectively avoid the technical problems of high time and labor costs and low data processing efficiency and accuracy in the existing manual-based auxiliary service assessment data processing method, thereby realizing full-process automatic processing of auxiliary service assessment data, and effectively reducing time and labor costs and improving data processing efficiency while ensuring the accuracy of data processing results.
[0080] Further, as Figure 1 The specific implementation of the method, the embodiment of the present application provides a device for detecting abnormalities in user access behavior, such as Figure 3 As shown, the device includes: an acquisition module 31, a screening module 32, an extraction module 33, and a generation module 34.
[0081] Acquisition module 31: can be used to acquire initial auxiliary service assessment data from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively.
[0082] The screening module 32 can be used to screen the messages in the initial auxiliary service assessment data using preset keywords corresponding to multiple auxiliary service types to obtain target messages corresponding to multiple auxiliary service types.
[0083] The extraction module 33 can be used to extract characteristic data from the target message for each auxiliary service type, and obtain characteristic data corresponding to multiple auxiliary service types, wherein the characteristic data includes first characteristic data and second characteristic data.
[0084] The generating module 34 may be used to generate reports corresponding to different preset formats according to the characteristic data corresponding to the multiple auxiliary service types, wherein the different preset formats correspond to the first report template preset format and the second report template preset format.
[0085] In specific application scenarios, such as Figure 4 As shown, the acquisition module 31 includes a first acquisition unit 311 and a second acquisition unit 312 .
[0086] The first acquisition unit 311 can be used to transmit data across network areas through a firewall and a horizontal isolation device to acquire initial auxiliary service assessment data on the computer monitoring system side.
[0087] The second acquisition unit 312 may be used to transmit data in the same network area through a network switch to acquire the initial auxiliary service assessment data of the auxiliary service assessment system of the power grid company.
[0088] In a specific application scenario, the screening module 32 can be specifically used to screen the message of the initial auxiliary service assessment data using preset keywords to obtain a target message containing the preset keywords; wherein the preset keywords are set according to multiple auxiliary service types of the initial auxiliary service assessment data.
[0089] In a specific application scenario, the extraction module 33 includes a first extraction unit 331 and a second extraction unit 332 .
[0090] The first extraction unit 331 may be configured to extract feature data from the target message for each auxiliary service type, to obtain first feature data corresponding to multiple auxiliary service types.
[0091] The second extraction unit 332 may be configured to perform calculations based on the first characteristic data for each auxiliary service type to obtain second characteristic data corresponding to a plurality of auxiliary service types.
[0092] In a specific application scenario, the first extraction unit 331 can be specifically used to judge the multiple message signals in the target message in turn for each auxiliary service type using the corresponding preset condition judgment process to determine the arrangement order between different message signals; according to the arrangement order between the different message signals, the characteristic data corresponding to each message signal is output according to the preset condition judgment process to obtain the first characteristic data of the target message.
[0093] In a specific application scenario, the generating module 34 includes a first report generating unit 341 , a second report generating unit 342 , a data graph generating unit 343 , and a third report generating unit 344 .
[0094] The first report generating unit 341 may be configured to generate a first report according to the first characteristic data and the second characteristic data and in accordance with a preset format of the first report template.
[0095] The second report generating unit 342 may be configured to fill the screenshot of the corresponding content of the first report into the second report template according to a preset format of the second report template to generate a second report.
[0096] The data graph generating unit 343 may be configured to generate data graphs of different dimensions according to the first report, wherein the data graphs of different dimensions include at least a data graph of a time dimension, a data graph of a device dimension, and a data graph of an auxiliary service type dimension.
[0097] The third report generating unit 344 may be configured to obtain a third report based on the first reports of the corresponding time period.
[0098] It should be noted that for other corresponding descriptions of the functional units involved in the auxiliary service assessment data processing device provided in the embodiment of the present application, reference can be made to Figure 1 and Figure 2 The corresponding description in will not be repeated here.
[0099] Based on the above Figure 1 and Figure 2 The method shown in the embodiment of the present application accordingly provides a storage medium on which a computer program is stored, and when the program is executed by a processor, the above-mentioned Figure 1 and Figure 2 The auxiliary service assessment data processing method shown.
[0100] Based on this understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.), and includes a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each implementation scenario of the present application.
[0101] Based on the above Figure 1 , Figure 2 The method shown, and Figure 4 In order to achieve the above-mentioned purpose, the embodiment of the present application also provides a computer device, which can be a personal computer, a server, a network device, etc. The physical device includes a storage medium and a processor; the storage medium is used to store a computer program; the processor is used to execute the computer program to achieve the above-mentioned Figure 1 and Figure 2 The auxiliary service assessment data processing method shown.
[0102] Optionally, the computer device may further include a user interface, a network interface, a camera, a radio frequency (RF) circuit, a sensor, an audio circuit, a WI-FI module, etc. The user interface may include a display, an input unit such as a keyboard, etc., and the optional user interface may also include a USB interface, a card reader interface, etc. The network interface may optionally include a standard wired interface, a wireless interface (such as a Bluetooth interface, a WI-FI interface), etc.
[0103] Those skilled in the art will appreciate that the computer device structure provided in this embodiment does not constitute a limitation on the physical device, and may include more or fewer components, or a combination of certain components, or different component arrangements.
[0104] The storage medium may also include an operating system and a network communication module. The operating system is a program that manages the hardware and software resources of a computer device and supports the operation of information processing programs and other software and / or programs. The network communication module is used to achieve communication between components within the storage medium and with other hardware and software in the physical device.
[0105] Through the description of the above implementation methods, those skilled in the art can clearly understand that the present application can be implemented by means of software plus a necessary general hardware platform, or by hardware. By applying the technical solution of the present application, compared with the existing manual-based auxiliary service assessment data processing method, the present embodiment automatically obtains initial auxiliary service assessment data from systems in different network partitions, and extracts feature data based on the data screening results, and then generates reports in different preset formats according to the feature data extraction results. It can effectively avoid the existing manual-based auxiliary service assessment data processing method, which has the technical problems of high time and labor costs, low data processing efficiency and accuracy, thereby realizing the full-process automatic processing of auxiliary service assessment data, and effectively reducing time and labor costs, improving data processing efficiency, while ensuring the accuracy of data processing results.
[0106] Those skilled in the art will appreciate that the accompanying drawings are only schematic diagrams of a preferred implementation scenario, and the modules or processes in the accompanying drawings are not necessarily necessary for implementing the present application. Those skilled in the art will appreciate that the modules in the devices in the implementation scenario can be distributed in the devices of the implementation scenario according to the description of the implementation scenario, or can be changed accordingly and located in one or more devices different from the present implementation scenario. The modules of the above-mentioned implementation scenario can be combined into one module, or can be further split into multiple submodules.
[0107] The above serial numbers of this application are only for description and do not represent the advantages and disadvantages of the implementation scenarios. The above disclosure is only a few specific implementation scenarios of this application, but this application is not limited to them, and any changes that can be thought of by technicians in this field should fall within the scope of protection of this application.
Claims
1. A method for processing auxiliary service assessment data, characterized in that: include: Obtain initial auxiliary service assessment data from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively; By screening the initial auxiliary service assessment data, target messages corresponding to multiple auxiliary service types are obtained; For each auxiliary service type, extracting characteristic data from the target message respectively to obtain characteristic data corresponding to multiple auxiliary service types; Generate reports corresponding to different preset formats according to the characteristic data corresponding to the multiple auxiliary service types, the reports including a first report meeting the grid company's Excel spreadsheet format, a second report meeting the grid company's Word electronic document format, and a third report for analyzing auxiliary service assessment data within the power enterprise; Among them, the characteristic data includes first characteristic data and second characteristic data, and for each auxiliary service type, the characteristic data of the target message is extracted respectively to obtain characteristic data corresponding to multiple auxiliary service types, specifically including: for each auxiliary service type, using the corresponding preset condition judgment process to judge the multiple message signals in the target message in turn to determine the arrangement order between different message signals; according to the arrangement order between the different message signals, output the characteristic data corresponding to each message signal according to the preset condition judgment process to obtain the first characteristic data of the target message; for each auxiliary service type, calculation is performed according to the first characteristic data to obtain the second characteristic data corresponding to multiple auxiliary service types.
2. The method according to claim 1, characterized in that The initial auxiliary service assessment data is obtained from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively, specifically including: Transmitting data across network regions through firewalls and horizontal isolation devices to obtain initial auxiliary service assessment data on the computer monitoring system side; The initial auxiliary service assessment data of the auxiliary service assessment system of the power grid company is obtained by transmitting data in the same network area through the network switch.
3. The method according to claim 1, characterized in that The obtaining of target messages corresponding to multiple auxiliary service types by screening the initial auxiliary service assessment data specifically includes: Using preset keywords to filter the messages of the initial auxiliary service assessment data to obtain target messages containing the preset keywords; The preset keywords are set according to multiple auxiliary service types of the initial auxiliary service assessment data.
4. The method according to claim 1, characterized in that: The different preset formats correspond to a first report template preset format and a second report template preset format, and generating reports corresponding to different preset formats according to the characteristic data of the target message specifically includes: Generate a first report according to the first characteristic data and the second characteristic data and in accordance with a preset format of the first report template; According to the preset format of the second report template, the screenshot of the corresponding content of the first report is filled into the second report template to generate a second report.
5. The method according to claim 1 or 4, characterized in that: The generating of reports corresponding to different preset formats according to the characteristic data corresponding to the plurality of auxiliary service types further includes: Generate data graphs of different dimensions according to the first report, wherein the data graphs of different dimensions include at least: a data graph of a time dimension, a data graph of a device dimension, and a data graph of an auxiliary service type dimension; A third report is obtained by summarizing the first reports of the corresponding time period.
6. An auxiliary service assessment data processing device, characterized in that: include: Acquisition module: used to obtain initial auxiliary service assessment data from the computer monitoring system and the auxiliary service assessment system of the power grid company respectively; Screening module: used to obtain target messages corresponding to multiple auxiliary service types by screening the initial auxiliary service assessment data; Extraction module: for extracting characteristic data from the target message for each auxiliary service type, and obtaining characteristic data corresponding to multiple auxiliary service types; The characteristic data includes first characteristic data and second characteristic data, and for each auxiliary service type, the characteristic data of the target message is extracted respectively to obtain characteristic data corresponding to multiple auxiliary service types, specifically including: for each auxiliary service type, using the corresponding preset condition judgment process to judge the multiple message signals in the target message in sequence to determine the arrangement order between different message signals; according to the arrangement order between the different message signals, outputting the characteristic data corresponding to each message signal according to the preset condition judgment process to obtain the first characteristic data of the target message; for each auxiliary service type, calculating according to the first characteristic data respectively to obtain the second characteristic data corresponding to multiple auxiliary service types; Generation module: used to generate reports corresponding to different preset formats based on the characteristic data corresponding to multiple auxiliary service types, the reports including a first report that meets the grid company's Excel spreadsheet format, a second report that meets the grid company's Word electronic document format, and a third report used for analysis of auxiliary service assessment data within the power company.
7. A storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the auxiliary service assessment data processing method described in any one of claims 1 to 5 is implemented.
8. A computer device comprising a storage medium, a processor, and a computer program stored in the storage medium and executable on the processor, characterized in that: When the processor executes the program, the auxiliary service assessment data processing method described in any one of claims 1 to 5 is implemented.
Citation Information
Patent Citations
Coupled message credit releasing method and system
CN105429896A
Method, device and server for classifying friend circle information
CN106682010A
Enterprise risk identification monitoring method, device and equipment and storage medium
CN109492945A
Message processing method and device and server
CN110417683A
Data processing method and device, computer equipment and storage medium
CN111552838A
