CN111708814A - Data statistical method, device, equipment and medium - Google Patents
Data statistical method, device, equipment and medium Download PDFInfo
- Publication number
- CN111708814A CN111708814A CN202010343103.3A CN202010343103A CN111708814A CN 111708814 A CN111708814 A CN 111708814A CN 202010343103 A CN202010343103 A CN 202010343103A CN 111708814 A CN111708814 A CN 111708814A
- Authority
- CN
- China
- Prior art keywords
- data
- statistical
- user
- load
- counted
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- 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/10—Office automation; Time management
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The embodiment of the invention discloses a data statistical method, a device, equipment and a medium. The method comprises the following steps: acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting; counting the data to be counted according to a preset counting method to obtain a counting result; wherein the statistical method comprises at least one of screening, ranking and summarizing; and responding to the query operation of the user, and displaying the statistical result to the user. The embodiment of the invention realizes automatic statistics of the data to be counted, reduces manual intervention, improves the working efficiency and the accuracy of the data, supports the user to inquire the statistical result, and is favorable for finding out the weak link of distribution network operation in time.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a data statistical method, a device, equipment and a medium.
Background
With the continuous development of economy, the development scale of the power grid is larger and larger, and the power load and the power quantity are higher and higher, particularly during the peak-meeting summer period, the power load of the power grid is obviously increased in the peak period, and the accident rate is increased relatively flat, so that the safety and the benefit of the power grid operation are directly related to the peak load analysis.
The existing statistical analysis of peak load data is basically carried out manually, the efficiency and the accuracy are low, a user cannot check a statistical analysis result on line, and weak links of distribution network operation are not easy to find in time.
Disclosure of Invention
Embodiments of the present invention provide a data statistics method, apparatus, device, and medium, so as to solve the problem of low efficiency and accuracy caused by performing statistical analysis on peak load data in a manual manner in the prior art.
In a first aspect, an embodiment of the present invention provides a data statistics method, where the method includes:
acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
counting the data to be counted according to a preset counting method to obtain a counting result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and responding to the query operation of the user, and displaying the statistical result to the user.
In a second aspect, an embodiment of the present invention provides a data statistics apparatus, where the apparatus includes:
the data acquisition module is used for acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
the data statistics module is used for carrying out statistics on the data to be counted according to a preset statistics method to obtain a statistical result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and the statistical result display module is used for responding to the query operation of the user and displaying the statistical result to the user.
In a third aspect, an embodiment of the present invention provides an apparatus, where the apparatus includes:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a data statistics method as in any of the embodiments of the invention.
In a fourth aspect, the present invention provides a computer-readable medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data statistics method according to any one of the embodiments of the present invention.
According to the embodiment of the invention, statistical results are obtained by acquiring the data to be counted uploaded by each data acquisition department and counting the data to be counted according to a preset statistical method; the statistical method comprises at least one of screening, sorting and summarizing, the query operation of a user is finally responded, the statistical result is displayed to the user, the automatic statistics of the data to be statistically processed is realized, the manual intervention is reduced, the working efficiency and the data accuracy are improved, the manual statistics time is saved, the user is supported to query the statistical result, the weak links of distribution network operation can be found in time, and important operation data support is provided for subsequent distribution network planning, construction and the like.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed 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 is a flow chart of a data statistics method according to an embodiment of the present invention;
FIG. 2 is a flowchart of a data statistics method according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a data statistics apparatus according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an apparatus according to a fourth embodiment of the present invention.
Detailed Description
The embodiments of the present invention will be described in further detail with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the embodiments of the invention and that no limitation of the invention is intended. It should be further noted that, for convenience of description, only the structures related to the embodiments of the present invention are shown in the drawings, not all the structures.
In the power system, the power load is an important part thereof, and the power load, as a consumer of electric energy, has an important influence on the design, analysis, control, and the like of the power system. By analyzing the characteristics of the power load of the urban distribution network, a corresponding prediction method is generated, so that the accuracy of power load prediction is improved, and the stable operation of the urban distribution network is further promoted.
Example one
Fig. 1 is a flowchart of a data statistics method according to an embodiment of the present invention. The embodiment is applicable to the situation of carrying out statistical analysis on the data to be counted uploaded by each data acquisition department automatically, and the method can be executed by the data counting device provided by the embodiment of the invention, and the data counting device can be realized in a software and/or hardware mode. As shown in fig. 1, the method may include:
In this embodiment, the data collection department is a regional power supply bureau, such as a power supply branch office of each city area subordinate to a power supply bureau of a certain province.
Specifically, each power supply branch office is responsible for recording various data to be counted in the affiliated jurisdiction, and locally storing the various data to be counted in a file or database mode in a preset period for subsequent viewing. And simultaneously uploading the data to be counted to a load analysis system by a responsible person. And the load analysis system correspondingly acquires the data to be counted uploaded by each power supply substation.
Optionally, after step 101, the method further includes: and carrying out format verification on the data to be counted according to a preset data format.
In general, the data to be counted uploaded by each data collection department is in the EXCEL format. The EXCEL form file is convenient to send and transmit, the form can be easily issued to each data acquisition department, and the EXCEL files are easily collected after the completion of the filling of each data acquisition department. However, because EXCEL tables have difficulty controlling the correctness of the form, type, and even content of the filled data. For example, some departments may fill out digits as Arabic numerals 1, 2, and 3, while other departments may fill out Chinese capitals of one, two, and three; for another example, the filling of emails, landline telephones, and the like may have irregular filling data and incorrect content. In the existing method, quality testing personnel verify the data to be counted in a manual mode, and the efficiency is very low.
Specifically, the load analysis system is preset with a data format, for example, the data format of the numbers is arabic numbers, the data format of the letters is capital letters, for example, the data format of the Chinese characters is simplified Chinese, after the data to be counted is obtained, the type of the data to be counted, such as the numbers, the letters or the Chinese characters, is identified, and then the format of the data to be counted is checked according to the preset data format. And storing the data to be counted, which passes the verification, in a database associated with the load analysis system, filtering the data to be counted, which does not pass the verification, and feeding error information back to a data acquisition department sending the data to be counted, so that the data acquisition department can upload the data to the load analysis system after modifying the data format of the data to be counted. Therefore, the effects of automatically checking the data to be counted and importing the data into the database are achieved, the checking efficiency is greatly improved, the consistency of the data to be counted is ensured, and the data quality is improved.
The data to be counted uploaded by each data acquisition department is acquired, so that a data base is laid for a subsequent load analysis system to count the data to be counted.
102, counting the data to be counted according to a preset counting method to obtain a counting result; wherein the statistical method comprises at least one of screening, ranking, and summarizing.
Specifically, the load analysis system is preset with at least one statistical method of screening, sorting and summarizing, after the statistical data to be obtained is completed, three executable buttons of "screening", "sorting" and "summarizing" are displayed on a user interaction interface, and when a user selects at least one button according to requirements, the load analysis system executes the corresponding statistical method, wherein the selection mode includes but is not limited to finger touch selection, voice control selection or selection through an external device. For example, after the user selects the "screening" button, the load analysis system screens the data to be counted according to a preset screening method to obtain a statistical result; for another example, after the user selects the "sort" button, the load analysis system sorts the data to be counted according to a preset sorting method to obtain a statistical result; for another example, after the user selects the "filter" and "sort" buttons, the load analysis system performs filtering and sorting on the data to be counted according to a preset filtering method and sorting method to obtain a statistical result. In this embodiment, the statistical method may be one of "screening", "sorting", and "summarizing", or any combination of the three, and this implementation does not limit the specific statistical method at all.
The statistical result is obtained by counting the data to be counted according to a preset statistical method, so that the effect of automatically counting the data to be counted is realized, manual intervention is reduced, and the working efficiency and the accuracy of the data are improved.
And 103, responding to the query operation of the user, and displaying the statistical result to the user.
Specifically, each user can log in the load analysis system according to the pre-allocated account and the pre-allocated password, and click a 'query statistical result' button in the interactive page, and the load analysis system responds to the query operation of the user and displays the statistical result to the user.
Optionally, step 103 includes: acquiring a historical statistical result from a database, comparing the historical statistical result with the statistical result, and determining the variation of the statistical result; wherein the statistical result variation comprises at least one of a synchronization ratio, a last comparison period and a last comparison period; and displaying the statistical result and the statistical result variation to a user.
Specifically, the load analysis system calls a historical statistical result in the database, and performs logical operation on the historical statistical result and the current statistical result to obtain a statistical result variation, for example, a synchronization ratio is obtained according to a ratio of a difference between the statistical result of the current period of the current year and the historical statistical result of the current period of the previous year to the historical statistical result of the current period of the previous year; for example, the specific up period is obtained according to the ratio of the statistical result of the current period of the year to the statistical result of the up period of the year; for another example, the current year is the same as the previous year according to the ratio of the statistical result of the current period of the current year to the historical statistical result of the current period of the previous year. And the obtained variable quantity of the statistical result and the statistical result of this time are displayed to the user together. The obtained variable quantity of the statistical result and the statistical result of this time are displayed to the user together, so that the user can more visually acquire the variation trend of the load statistical result, thereby being capable of timely revealing and finding the weak link of distribution network operation and correspondingly taking measures.
The statistical result is displayed to the user by responding to the query operation of the user, so that the effect of supporting the user to query the statistical result is realized, and the weak link of the distribution network operation is favorably found in time.
According to the technical scheme provided by the embodiment of the invention, the statistical result is obtained by acquiring the data to be counted uploaded by each data acquisition department and counting the data to be counted according to a preset statistical method; the statistical method comprises at least one of screening, sorting and summarizing, the query operation of a user is finally responded, the statistical result is displayed to the user, the automatic statistics of the data to be statistically processed is realized, the manual intervention is reduced, the working efficiency and the data accuracy are improved, the manual statistics time is saved, the user is supported to query the statistical result, the weak links of distribution network operation can be found in time, and important operation data support is provided for subsequent distribution network planning, construction and the like.
Example two
Fig. 2 is a flowchart of a data statistics method according to a second embodiment of the present invention. The present embodiment is optimized based on the above optional embodiments, as shown in fig. 2, the method may include:
step 201, acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of overload line rectification condition, heavy load line rectification condition, highest load increase rate, highest load after the highest load is restored every day, highest load, daily average load, load peak-valley difference, maintenance due to distribution network and no forced peak load.
202, screening the data to be counted according to preset screening conditions to obtain screened data; wherein the screening conditions include at least one of: time, department name, data name, and data value.
The time represents the collection time of the data to be counted, the department name represents the name of the department collecting the data to be counted, such as a power supply bureau in city A or a power supply bureau in county B, the data name represents the name of the data to be counted, such as the highest load and the daily average load, and the data value represents the specific value of the data to be counted, such as the highest load 10000 KWh.
Specifically, the user may set the filtering condition in the load analysis system in advance according to the requirement, for example, the filtering condition is set to "1 month in 2020, power supply bureau in city a", for example, the filtering condition is set to "power supply bureau in city a, average daily load", for example, the filtering condition is set to "1 month in 2020, average daily load 1000KW · h". And after the user finishes setting the screening conditions, selecting a screening button, responding to the selection operation of the user by the load analysis system, and correspondingly screening the data to be counted according to the set screening conditions to obtain the screened data. In this embodiment, the screening condition may be one of "time", "department name", "data name", and "data value", or any combination of the four, and this embodiment does not limit the specific screening condition at all.
Step 203, sorting the screening data according to a preset sorting rule to obtain sorted data; wherein the ordering rule comprises at least one of: numeric ordering, chinese ordering, growth rate ordering, and packet ordering.
The numerical ordering means to perform ascending ordering or descending ordering on the numerical data, the Chinese character ordering means to order the Chinese character data according to the initial, the growth rate ordering means to perform ascending ordering or descending ordering on the growth rate data, the grouping ordering means to group the data to be counted according to a preset rule, for example, grouping according to time or departments, and the numerical ordering, the Chinese character ordering or the growth rate ordering are performed in each group.
Specifically, a user can set a sorting rule in a load analysis system in a user-defined manner in advance according to requirements, the sorting rule in this embodiment may be one of "numeric sorting", "chinese character sorting", "growth rate sorting", and "grouping sorting", or any combination of the four, and the present embodiment does not limit the specific sorting rule at all. And after the user finishes setting the sorting rule, selecting a sorting button, responding to the selection operation of the user by the load analysis system, and correspondingly sorting the screened data according to the set sorting rule to obtain sorted data.
Step 204, summarizing the sequencing data according to a preset summarizing rule to obtain a statistical result; wherein the summary rule comprises at least one of: summing, counting numbers, averaging, maximizing, and minimizing.
Specifically, a user may set a summary rule in a load analysis system in a user-defined manner in advance according to a requirement, where the summary rule in this embodiment may be one of "sum", "statistical number", "average", "maximum", and "minimum", or any combination of the five, and this embodiment does not limit a specific sorting rule at all. And after the user finishes setting the summarizing rule, selecting a summarizing button, responding to the selection operation of the user by the load analysis system, and summarizing the sequencing data according to the set summarizing rule to obtain a statistical result.
The scalable vector graphics format, i.e. SVG format, is based on XML (Extensible markup language), is a brand new open standard vector graphics and animation format, and can display various high-quality vector graphics on a web page by using SVG, supporting numerous functions: characters, geometric figures, object motion, color change, filter and shading audio teaching addition and the like, and the most important is that: SVG differs from traditional binary image and animation in that it is described entirely in plain text, that is, a text-based image format designed specifically for networks. The HTML is a mode for organizing information, which associates characters and diagrams in a text with other information media by a hyperlink method, and the mode for organizing information connects information resources distributed at different positions in a random mode, thereby providing convenience for people to search and retrieve information.
Specifically, when a user clicks a query statistic result button in an interactive page, the load analysis system responds to the query operation of the user, calls built-in SVG generation software, generates a scalable vector graphics format statistic chart according to the statistic result, generates a hypertext markup language page according to the method for constructing the DOM tree in a rendering mode, adds the generated scalable vector graphics format statistic chart to the hypertext markup language page, and finally displays the generated scalable vector graphics format statistic chart to the user.
According to the technical scheme provided by the embodiment of the invention, the statistical result is obtained by screening, sorting and summarizing the data to be counted according to the preset screening condition, the sorting rule and the summarizing rule respectively, so that the automatic statistics of the data to be counted is realized, the manual intervention is reduced, the working efficiency and the accuracy of the data are improved, and the manual statistics time is saved; the statistical chart in the scalable vector graphics format is generated according to the statistical result and displayed to the user on the hypertext markup language page, so that the effect of displaying the statistical result for the user on line is achieved, the user can conveniently check the statistical result at any time only through a web browser, convenience and rapidness are achieved, and the method is favorable for finding weak links of distribution network operation in time.
On the basis of the above embodiment, after the step 205, the method further includes A, B and C:
A. and responding to a document export instruction of a user, and acquiring data information added with the bookmark in the template document.
The template document is a preset WORD format document, wherein the document contains data information needing to be updated, and the bookmark in the template document is used for quickly positioning to a specific position of the data information needing to be updated and associated with the bookmark.
Specifically, a button of "export to WORD" is arranged on a page of the hypertext markup language, after a user clicks the button, the load analysis system responds to a document export instruction of the user, reads a preset template document, and traverses bookmarks in the template document by a method of generating a DOM-format directory tree to obtain data information added with the bookmarks in the template document.
B. According to the identification information of the bookmark, determining replacement information matched with the identification information in the statistical chart of the scalable vector graphics format; wherein the replacement information includes at least one of a picture, a table, and a text.
Specifically, each bookmark is provided with unique corresponding identification information, so that the replacement information corresponding to the data information needing to be updated and associated with the bookmark is determined from a statistical chart in a scalable vector graphics format according to the identification information.
Optionally, step B includes:
1) and taking the words matched with the identification information in the statistic chart in the scalable vector graphics format as search words.
For example, assuming that the identification information of a certain bookmark is a "heavy load line rectification situation table", the "heavy load line rectification situation table" is used as a search term, and assuming that the identification information of another bookmark is a "highest load increase rate", the "highest load increase rate" is also used as a search term.
2) And determining the replacement information associated with the search term according to the mapping relation between the search term and the replacement information in the pre-established statistical chart in the scalable vector graphics format.
Specifically, after the statistical chart in the scalable vector graphics format is generated, a mapping relationship is constructed for all pictures and picture names, tables and table names, for example, a table name "daily average load table" and a table corresponding to the table name "daily average load table", and for example, a picture name "highest load display map" and a picture corresponding to the table name "highest load display map". And all data names and corresponding data values are also mapped, for example, the data name "highest load increase rate" and the data value "10%" are mapped. And the table name, the picture name and the data name are used as search words in the statistic chart of the scalable vector graphics format, and the picture, the table and the data value are used as replacement information. And taking the words matched with the identification information as search words, and determining the replacement information associated with the search words matched with the identification information according to the mapping relation between the search words and the replacement information in the statistical chart.
3) And taking the replacement information associated with the search word as the replacement information matched with the identification information.
C. And replacing the data information with the replacement information in the template document to obtain a statistical document, and displaying the statistical document to a user.
Specifically, the corresponding bookmark is determined according to the identification information, the data information to which the bookmark belongs is replaced by the replacement information matched with the identification information, a statistical document is further generated, and a user can download or forward the statistical document according to the requirement. If the replacement information is a picture, the picture needs to be converted into a PNG format by including a batik toolkit, so that the picture can be inserted into the template document.
The data information added with the bookmark in the template document is obtained by responding to a document export instruction of a user, the replacement information matched with the identification information is determined in the statistical chart in the scalable vector graphics format according to the identification information of the bookmark, finally, the data information is replaced by the replacement information in the template document to obtain the statistical document, and the statistical document is displayed to the user, so that the user can export the statistical chart in the scalable vector graphics format into a specific document format, and the statistical document is convenient for the user to arrange into a corresponding report or store in an archive mode.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a data statistics apparatus according to a third embodiment of the present invention, which is capable of executing a data statistics method according to any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method. As shown in fig. 3, the apparatus may include:
the data acquisition module 31 is used for acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
the data statistics module 32 is configured to perform statistics on the data to be counted according to a preset statistics method to obtain a statistical result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and the statistical result display module 33 is configured to respond to a query operation of a user and display the statistical result to the user.
On the basis of the foregoing embodiment, the data statistics module 32 is specifically configured to:
screening the data to be counted according to preset screening conditions to obtain screening data; wherein the screening conditions include at least one of: time, department name, data name and data value;
sorting the screening data according to a preset sorting rule to obtain sorting data; wherein the ordering rule comprises at least one of: digit sorting, Chinese character sorting, growth rate sorting and grouping sorting;
summarizing the sequencing data according to a preset summarizing rule to obtain a statistical result; wherein the summary rule comprises at least one of: summing, counting numbers, averaging, maximizing, and minimizing.
On the basis of the foregoing embodiment, the statistical result display module 33 is specifically configured to:
acquiring a historical statistical result from a database, comparing the historical statistical result with the statistical result, and determining the variation of the statistical result; wherein the statistical result variation comprises at least one of a synchronization ratio, a last comparison period and a last comparison period;
and displaying the statistical result and the statistical result variation to a user.
On the basis of the foregoing embodiment, the statistical result display module 33 is further specifically configured to:
generating a statistical chart in a scalable vector graphics format according to the statistical result;
and displaying the statistical chart in the scalable vector graphics format to a user in a hypertext markup language page.
On the basis of the above embodiment, the apparatus further includes a statistical document generation module, specifically configured to:
responding to a document export instruction of a user, and acquiring data information added with bookmarks in a template document;
according to the identification information of the bookmark, determining replacement information matched with the identification information in the statistical chart of the scalable vector graphics format; wherein the replacement information comprises at least one of pictures, tables and characters;
and replacing the data information with the replacement information in the template document to obtain a statistical document, and displaying the statistical document to a user.
On the basis of the foregoing embodiment, the statistical document generation module is further specifically configured to:
taking words matched with the identification information in the statistic chart in the scalable vector graphics format as search words;
determining the replacement information associated with the search term according to the mapping relation between the search term and the replacement information in a pre-established statistical chart in a scalable vector graphics format;
and taking the replacement information associated with the search word as the replacement information matched with the identification information.
The data statistical device provided by the embodiment of the invention can execute the data statistical method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method. For technical details that are not described in detail in this embodiment, reference may be made to the data statistics method provided in any embodiment of the present invention.
Example four
Fig. 4 is a schematic structural diagram of an apparatus according to a fourth embodiment of the present invention. Fig. 4 illustrates a block diagram of an exemplary device 400 suitable for use in implementing embodiments of the present invention. The apparatus 400 shown in fig. 4 is only an example and should not bring any limitations to the functionality or scope of use of the embodiments of the present invention.
As shown in FIG. 4, device 400 is in the form of a general purpose computing device. The components of device 400 may include, but are not limited to: one or more processors or processing units 401, a system memory 402, and a bus 403 that couples the various system components (including the system memory 402 and the processing unit 401).
The system memory 402 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 404 and/or cache memory 405. The device 400 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 406 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, and commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 403 by one or more data media interfaces. Memory 402 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 408 having a set (at least one) of program modules 407 may be stored, for example, in memory 402, such program modules 407 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 407 generally perform the functions and/or methods of the described embodiments of the invention.
The processing unit 401 executes various functional applications and data processing by running the program stored in the system memory 402, for example, to implement the data statistics method provided by the embodiment of the present invention, including:
acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
counting the data to be counted according to a preset counting method to obtain a counting result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and responding to the query operation of the user, and displaying the statistical result to the user.
EXAMPLE five
An embodiment of the present invention further provides a computer-readable storage medium, where the computer-executable instructions, when executed by a computer processor, are configured to perform a data statistics method, where the method includes:
acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
counting the data to be counted according to a preset counting method to obtain a counting result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and responding to the query operation of the user, and displaying the statistical result to the user.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the method operations described above, and may also perform related operations in a data statistics method provided by any embodiment of the present invention. The computer-readable storage media of embodiments of the invention may take any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A method of data statistics, the method comprising:
acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
counting the data to be counted according to a preset counting method to obtain a counting result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and responding to the query operation of the user, and displaying the statistical result to the user.
2. The method according to claim 1, wherein the counting the data to be counted according to a preset counting method to obtain a counting result comprises:
screening the data to be counted according to preset screening conditions to obtain screening data; wherein the screening conditions include at least one of: time, department name, data name and data value;
sorting the screening data according to a preset sorting rule to obtain sorting data; wherein the ordering rule comprises at least one of: digit sorting, Chinese character sorting, growth rate sorting and grouping sorting;
summarizing the sequencing data according to a preset summarizing rule to obtain a statistical result; wherein the summary rule comprises at least one of: summing, counting numbers, averaging, maximizing, and minimizing.
3. The method of claim 1, wherein presenting the statistics to a user comprises:
acquiring a historical statistical result from a database, comparing the historical statistical result with the statistical result, and determining the variation of the statistical result; wherein the statistical result variation comprises at least one of a synchronization ratio, a last comparison period and a last comparison period;
and displaying the statistical result and the statistical result variation to a user.
4. The method of claim 3, wherein presenting the statistics to a user further comprises:
generating a statistical chart in a scalable vector graphics format according to the statistical result;
and displaying the statistical chart in the scalable vector graphics format to a user in a hypertext markup language page.
5. The method of claim 4, wherein after presenting the statistics to a user, further comprising:
responding to a document export instruction of a user, and acquiring data information added with bookmarks in a template document;
according to the identification information of the bookmark, determining replacement information matched with the identification information in the statistical chart of the scalable vector graphics format; wherein the replacement information comprises at least one of pictures, tables and characters;
and replacing the data information with the replacement information in the template document to obtain a statistical document, and displaying the statistical document to a user.
6. The method of claim 5, wherein determining replacement information in the statistical chart in the scalable vector graphics format that matches the identification information based on the identification information of the bookmark comprises:
taking words matched with the identification information in the statistic chart in the scalable vector graphics format as search words;
determining the replacement information associated with the search term according to the mapping relation between the search term and the replacement information in a pre-established statistical chart in a scalable vector graphics format;
and taking the replacement information associated with the search word as the replacement information matched with the identification information.
7. A data statistics apparatus, characterized in that the apparatus comprises:
the data acquisition module is used for acquiring data to be counted uploaded by each data acquisition department; wherein the data to be counted comprises at least one of the following items: the method comprises the following steps of (1) overload line rectification condition, heavy load line rectification condition, highest load growth rate, highest load after daily restoration of the highest load, daily average load, load peak-valley difference, maintenance of distribution network and no forced peak load shifting;
the data statistics module is used for carrying out statistics on the data to be counted according to a preset statistics method to obtain a statistical result; wherein the statistical method comprises at least one of screening, ranking and summarizing;
and the statistical result display module is used for responding to the query operation of the user and displaying the statistical result to the user.
8. The apparatus of claim 7, wherein the data statistics module is specifically configured to:
screening the data to be counted according to preset screening conditions to obtain screening data; wherein the screening conditions include at least one of: time, department name, data name and data value;
sorting the screening data according to a preset sorting rule to obtain sorting data; wherein the ordering rule comprises at least one of: digit sorting, Chinese character sorting, growth rate sorting and grouping sorting;
summarizing the sequencing data according to a preset summarizing rule to obtain a statistical result; wherein the summary rule comprises at least one of: summing, counting numbers, averaging, maximizing, and minimizing.
9. An apparatus, characterized in that the apparatus further comprises:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the data statistics method of any of claims 1-6.
10. A computer-readable medium, on which a computer program is stored which, when being executed by a processor, carries out the method of data statistics according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010343103.3A CN111708814A (en) | 2020-04-27 | 2020-04-27 | Data statistical method, device, equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010343103.3A CN111708814A (en) | 2020-04-27 | 2020-04-27 | Data statistical method, device, equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111708814A true CN111708814A (en) | 2020-09-25 |
Family
ID=72536687
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010343103.3A Pending CN111708814A (en) | 2020-04-27 | 2020-04-27 | Data statistical method, device, equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111708814A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112651701A (en) * | 2020-10-20 | 2021-04-13 | 国网重庆市电力公司市北供电分公司 | Automatic processing method for D5000 system data |
| CN113806421A (en) * | 2021-09-16 | 2021-12-17 | 广东电网有限责任公司 | Method and device for processing distribution network peak shifting statistical data |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103150600A (en) * | 2013-03-27 | 2013-06-12 | 平阳电力有限责任公司 | Safety analyzing system of power network |
| CN104123675A (en) * | 2013-04-27 | 2014-10-29 | 国家电网公司 | Power distribution network simulation research and analysis system and method based on network-wide data |
| CN104638642A (en) * | 2015-02-11 | 2015-05-20 | 国家电网公司 | Active power distribution network analysis and evaluation system |
| CN106599038A (en) * | 2016-11-04 | 2017-04-26 | 国网江苏省电力公司 | Visualization statistic publishing system oriented on power application |
| US20170243140A1 (en) * | 2014-05-23 | 2017-08-24 | DataRobot, Inc. | Systems and techniques for predictive data analytics |
| CN107171438A (en) * | 2017-05-18 | 2017-09-15 | 中国南方电网有限责任公司 | A kind of net level matches somebody with somebody electricity consumption monitoring and management system |
| CN107835107A (en) * | 2017-11-13 | 2018-03-23 | 广东电网有限责任公司电力科学研究院 | A kind of metering display systems based on power network metering topological sum WebGis |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN108764683A (en) * | 2018-05-21 | 2018-11-06 | 贵州电网有限责任公司 | Operation of power networks data analysis assessment and reporting system |
| CN109034623A (en) * | 2018-07-27 | 2018-12-18 | 国家电网有限公司 | Electric Power Network Planning data processing method and terminal device |
| CN109669972A (en) * | 2018-12-20 | 2019-04-23 | 广东电网有限责任公司 | Generation method, device and the intelligent terminal of distribution load report |
| CN109766373A (en) * | 2018-11-30 | 2019-05-17 | 厦门亿力吉奥信息科技有限公司 | Electric network data methods of exhibiting and computer readable storage medium |
| CN109885301A (en) * | 2019-01-21 | 2019-06-14 | 新奥特（北京）视频技术有限公司 | A kind of generation method of scalable vector graphics, device, storage medium and equipment |
| CN110378621A (en) * | 2019-07-29 | 2019-10-25 | 广东电网有限责任公司 | A kind of distribution power dispatcher watch bill generates system and generation method |
-
2020
- 2020-04-27 CN CN202010343103.3A patent/CN111708814A/en active Pending
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103150600A (en) * | 2013-03-27 | 2013-06-12 | 平阳电力有限责任公司 | Safety analyzing system of power network |
| CN104123675A (en) * | 2013-04-27 | 2014-10-29 | 国家电网公司 | Power distribution network simulation research and analysis system and method based on network-wide data |
| US20170243140A1 (en) * | 2014-05-23 | 2017-08-24 | DataRobot, Inc. | Systems and techniques for predictive data analytics |
| CN104638642A (en) * | 2015-02-11 | 2015-05-20 | 国家电网公司 | Active power distribution network analysis and evaluation system |
| CN106599038A (en) * | 2016-11-04 | 2017-04-26 | 国网江苏省电力公司 | Visualization statistic publishing system oriented on power application |
| CN107171438A (en) * | 2017-05-18 | 2017-09-15 | 中国南方电网有限责任公司 | A kind of net level matches somebody with somebody electricity consumption monitoring and management system |
| CN107835107A (en) * | 2017-11-13 | 2018-03-23 | 广东电网有限责任公司电力科学研究院 | A kind of metering display systems based on power network metering topological sum WebGis |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN108764683A (en) * | 2018-05-21 | 2018-11-06 | 贵州电网有限责任公司 | Operation of power networks data analysis assessment and reporting system |
| CN109034623A (en) * | 2018-07-27 | 2018-12-18 | 国家电网有限公司 | Electric Power Network Planning data processing method and terminal device |
| CN109766373A (en) * | 2018-11-30 | 2019-05-17 | 厦门亿力吉奥信息科技有限公司 | Electric network data methods of exhibiting and computer readable storage medium |
| CN109669972A (en) * | 2018-12-20 | 2019-04-23 | 广东电网有限责任公司 | Generation method, device and the intelligent terminal of distribution load report |
| CN109885301A (en) * | 2019-01-21 | 2019-06-14 | 新奥特（北京）视频技术有限公司 | A kind of generation method of scalable vector graphics, device, storage medium and equipment |
| CN110378621A (en) * | 2019-07-29 | 2019-10-25 | 广东电网有限责任公司 | A kind of distribution power dispatcher watch bill generates system and generation method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112651701A (en) * | 2020-10-20 | 2021-04-13 | 国网重庆市电力公司市北供电分公司 | Automatic processing method for D5000 system data |
| CN113806421A (en) * | 2021-09-16 | 2021-12-17 | 广东电网有限责任公司 | Method and device for processing distribution network peak shifting statistical data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Becker et al. | Microsoft power BI: extending excel to manipulate, analyze, and visualize diverse data | |
| US9671950B2 (en) | Sample data computation for rendering of graph elements | |
| US8015056B1 (en) | Method for visual presentation of key performance indicators of a business utilizing a squarified tree map | |
| US10963144B2 (en) | Graphically organizing content in a user interface to a software application | |
| CN110807045A (en) | Data display method, device, equipment and computer readable storage medium | |
| Bao et al. | Visual framework for big data in d3. js | |
| CN111708814A (en) | Data statistical method, device, equipment and medium | |
| CN110728123B (en) | Report generation method, system and related equipment | |
| CN101877087A (en) | System and method for monitoring and surveying floating population based on space position | |
| CN112883042A (en) | Data updating and displaying method and device, electronic equipment and storage medium | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN112508671A (en) | Enterprise financial data processing method, system, device and medium | |
| CN110609989A (en) | Operation method for rapidly generating information form by adopting predefined layout component and application | |
| CN117035532A (en) | Electric power marketing management system and method based on marketing index multidimensional linkage analysis | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| CN112231386A (en) | Visual interaction method, system, equipment and storage medium for railway scientific research data | |
| CN111382977A (en) | Book purchasing method and device based on user borrowing behavior and storage medium | |
| CN115587098A (en) | Method and system for intelligently identifying chart data | |
| CN112699032B (en) | Method for realizing vddbench performance test result analysis based on Excel | |
| CN115409471A (en) | Automatic generation method and device for distribution network automation terminal machine account | |
| CN114238724A (en) | Data visualization method and device | |
| CN111783411A (en) | Report automatic generation system and method based on scheduling synchronization line loss | |
| Sheng et al. | Research and implementation of a personnel management system for private universities in China based on Java | |
| Durneková et al. | Information system for asset management in buildings |
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 |