CN112800036A - Report analysis chart automatic generation and display method and system - Google Patents
Report analysis chart automatic generation and display method and system Download PDFInfo
- Publication number
- CN112800036A CN112800036A CN202011611581.4A CN202011611581A CN112800036A CN 112800036 A CN112800036 A CN 112800036A CN 202011611581 A CN202011611581 A CN 202011611581A CN 112800036 A CN112800036 A CN 112800036A
- Authority
- CN
- China
- Prior art keywords
- data
- displaying
- cleaned
- core
- steps
- 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
- 238000004458 analytical method Methods 0.000 title claims abstract description 40
- 238000000034 method Methods 0.000 title claims abstract description 31
- 230000002159 abnormal effect Effects 0.000 claims abstract description 30
- 238000004140 cleaning Methods 0.000 claims abstract description 18
- 230000005856 abnormality Effects 0.000 claims abstract description 12
- 208000025174 PANDAS Diseases 0.000 claims description 17
- 208000021155 Paediatric autoimmune neuropsychiatric disorders associated with streptococcal infection Diseases 0.000 claims description 17
- 240000004718 Panda Species 0.000 claims description 17
- 235000016496 Panda oleosa Nutrition 0.000 claims description 17
- 238000007637 random forest analysis Methods 0.000 claims description 10
- 238000004422 calculation algorithm Methods 0.000 claims description 9
- 238000003066 decision tree Methods 0.000 claims description 8
- 238000007405 data analysis Methods 0.000 claims description 4
- 238000013075 data extraction Methods 0.000 claims description 4
- 230000035772 mutation Effects 0.000 claims description 3
- 238000012549 training Methods 0.000 claims description 3
- 238000013079 data visualisation Methods 0.000 abstract description 4
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000007500 overflow downdraw method Methods 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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
- 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/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/24—Classification techniques
- G06F18/243—Classification techniques relating to the number of classes
- G06F18/24323—Tree-organised classifiers
-
- 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0635—Risk analysis of enterprise or organisation activities
Abstract
The embodiment of the invention provides a method for automatically generating and displaying a report analysis chart, which comprises the following steps: the method comprises the following steps: extracting data from a database; step two: cleaning the extracted data; step three: when the cleaned data is abnormal data, providing a wind control warning, and displaying the reason of the abnormality to a user; step four: when the cleaned data is normal data, acquiring junk data and core data through data characteristic identification; step five: the embodiment of the invention realizes data visualization, automatically analyzes the data and provides wind control and warning prompts for abnormal data.
Description
Technical Field
The invention relates to the technical field of big data, in particular to a method and a system for automatically generating and displaying a report analysis chart.
Background
The existing data visualization platform is only used for data display and does not have the effect of data analysis, so that the utilization rate of database resources is low, and meanwhile, business personnel cannot judge the value of data.
Summary of the invention
In order to overcome the defects of the prior art, the invention provides an automatic generation and display method of a report analysis chart, which is used for solving the problems that the prior art cannot automatically analyze data and cannot provide wind control and warning prompts for abnormal data.
The technical scheme adopted by the invention for solving the technical problems is as follows: the method for automatically generating and displaying the report analysis chart is characterized by comprising the following steps of:
the method comprises the following steps: extracting data from a database;
step two: cleaning the extracted data;
step three: when the cleaned data is abnormal data, providing a wind control warning, and displaying the reason of the abnormality to a user;
step four: when the cleaned data is normal data, acquiring junk data and core data through data characteristic identification;
step five: analyzing the core data and displaying the analysis result.
Specifically, the step of extracting data from the database comprises:
and extracting data from the function read _ SQL connection database packaged by the pandas library through an SQL statement.
Specifically, the step of extracting data from the function read _ SQL connection database encapsulated by the pandas library through the SQL statement comprises the following steps:
the extracted data is selected from the function read _ SQL join database encapsulated by the pandas library in Python by SQL statements.
Specifically, the step of cleaning the extracted data includes:
and cleaning data extracted from the function read _ sql link database packaged by the pandas library.
Specifically, the data extracted from the function read _ sql link database encapsulated in the pandas library is cleaned, and the steps include:
sorting and combining the data of multiple dimensions;
and removing the junk information and optimizing and arranging the core information.
Specifically, when the data after being cleaned is abnormal data, a wind control warning is provided, and the reason for the abnormality is displayed to a user, the steps include:
the data after being cleaned has fields which do not appear in history, fields without data and fields without data;
and distinguishing abnormal degrees by self-defining abnormal indexes, identifying mutation data, providing wind control warning, and displaying abnormal reasons to a user.
Specifically, when the cleaned data is normal data, the garbage data and the core data are obtained through data feature identification, and the steps include:
when the cleaned data is normal data, generating a random forest by using a decision tree algorithm to obtain the importance level of each field of the data;
and removing the junk data with lower grade, and reserving the core data.
Specifically, the core data is analyzed, and the steps include:
expanding the field with higher grade in a single dimension;
and feeding back the key interval trend of the data change to the user, and prompting the importance degree of the key interval trend of the data change.
Specifically, the core data is analyzed and the analysis result is displayed, and the steps include:
comparing the existing data with historical data, analyzing the difference of each dimension to obtain the trend of data evolution, and feeding back the trend to a user;
or
Identifying the field group with higher relevance by identifying the key data, and feeding back the field group to the user;
or
Inputting all key fields of historical data into a decision tree algorithm to generate a random forest, and training the random forest into a prediction model;
and predicting the current data by using the prediction model, and displaying the prediction result and the probability.
Specifically, the method is characterized by analyzing core data and displaying an analysis result, and the method comprises the following steps:
a statistical chart is drawn and displayed by utilizing matplotlib in python, and the displaying mode comprises a bar chart, a broken line chart, a pie chart and a combination chart.
An automatic generation and display system for report analysis chart comprises the following steps:
a data extraction unit for extracting data from a database;
the data cleaning unit is used for cleaning the extracted data;
the first data judgment unit is used for providing a wind control warning when the cleaned data is abnormal data and displaying the reason of the abnormality to a user;
the second data judgment unit is used for obtaining the junk data and the core data through data characteristic identification when the cleaned data are normal data;
and the data analysis display unit is used for analyzing the core data and displaying the analysis result.
The invention has the beneficial effects that: the method comprises the following steps: extracting data from a database; step two: cleaning the extracted data; step three: when the cleaned data is abnormal data, providing a wind control warning, and displaying the reason of the abnormality to a user; step four: when the cleaned data is normal data, acquiring junk data and core data through data characteristic identification; step five: the core data are analyzed, and the analysis result is displayed, so that data visualization is realized, automatic analysis is performed on the data, and wind control and warning prompts are provided for abnormal data.
Drawings
FIG. 1 is a flow chart of a method for automatically generating and displaying a report analysis chart.
FIG. 2 is a functional block diagram of an automatic report analysis chart generation and display system.
FIG. 3 is another flow chart of a method for automatically generating and displaying report analysis chart.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The following detailed description of specific implementations of the present invention is provided in conjunction with specific embodiments:
the first embodiment is as follows:
fig. 1 shows an implementation flow of a report analysis chart automatic generation and display method provided in an embodiment of the present invention, and for convenience of description, only the relevant parts related to the embodiment of the present invention are shown, which are detailed as follows:
in step S101, data is extracted from a database;
specifically, the step of extracting data from the database comprises:
and extracting data from the function read _ SQL connection database packaged by the pandas library through an SQL statement.
Specifically, the step of extracting data from the function read _ SQL connection database encapsulated by the pandas library through the SQL statement comprises the following steps:
the extracted data is selected from the function read _ SQL join database encapsulated by the pandas library in Python by SQL statements.
In step S102, the extracted data is cleaned;
specifically, the step of cleaning the extracted data includes:
and cleaning data extracted from the function read _ sql link database packaged by the pandas library.
Specifically, the data extracted from the function read _ sql link database encapsulated in the pandas library is cleaned, and the steps include:
sorting and combining the data of multiple dimensions;
and removing the junk information and optimizing and arranging the core information.
In step S103, when the data after being cleaned is abnormal data, providing a wind control warning, and displaying the reason of the abnormality to the user;
specifically, when the data after being cleaned is abnormal data, a wind control warning is provided, and the reason for the abnormality is displayed to a user, the steps include:
the data after being cleaned has fields which do not appear in history, fields without data and fields without data;
and distinguishing abnormal degrees by self-defining abnormal indexes, identifying mutation data, providing wind control warning, and displaying abnormal reasons to a user.
In step S104, when the cleaned data is normal data, the garbage data and the core data are obtained through data feature identification;
specifically, when the cleaned data is normal data, the garbage data and the core data are obtained through data feature identification, and the steps include:
when the cleaned data is normal data, generating a random forest by using a decision tree algorithm to obtain the importance level of each field of the data;
and removing the junk data with lower grade, and reserving the core data.
Specifically, the core data is analyzed, and the steps include:
expanding the field with higher grade in a single dimension;
and feeding back the key interval trend of the data change to the user, and prompting the importance degree of the key interval trend of the data change.
In step S105, the core data is analyzed and the analysis result is presented.
Specifically, the core data is analyzed and the analysis result is displayed, and the steps include:
comparing the existing data with historical data, analyzing the difference of each dimension to obtain the trend of data evolution, and feeding back the trend to a user;
or
Identifying the field group with higher relevance by identifying the key data, and feeding back the field group to the user;
or
Inputting all key fields of historical data into a decision tree algorithm to generate a random forest, and training the random forest into a prediction model;
and predicting the current data by using the prediction model, and displaying the prediction result and the probability.
Specifically, the core data is analyzed and the analysis result is displayed, and the steps include:
a statistical chart is drawn and displayed by utilizing matplotlib in python, and the displaying mode comprises a bar chart, a broken line chart, a pie chart and a combination chart.
It will be understood by those skilled in the art that all or part of the steps in the method for implementing the above embodiments may be implemented by relevant hardware instructed by a program, and the program may be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disk, optical disk, etc.
Example two:
fig. 2 shows a structure of an automatic report analysis chart generation and display system according to a second embodiment of the present invention, and for convenience of description, only the parts related to the second embodiment of the present invention are shown, which are detailed as follows:
a data extraction unit 201 for extracting data from a database;
a data cleaning unit 202 for cleaning the extracted data;
the first data judgment unit 203 is used for providing a wind control warning when the cleaned data is abnormal data and displaying the reason of the abnormality to a user;
a second data judgment unit 204, configured to obtain garbage data and core data through data feature identification when the cleaned data is normal data;
and the data analysis and presentation unit 205 is used for analyzing the core data and presenting the analysis result.
In the embodiment of the invention, the method comprises the following steps: extracting data from a database; step two: cleaning the extracted data; step three: when the cleaned data is abnormal data, providing a wind control warning, and displaying the reason of the abnormality to a user; step four: when the cleaned data is normal data, acquiring junk data and core data through data characteristic identification; step five: the core data are analyzed, and the analysis result is displayed, so that data visualization is realized, automatic analysis is performed on the data, and wind control and warning prompts are provided for abnormal data. The detailed implementation of each unit can refer to the description of the first embodiment, and is not repeated herein.
Example three:
fig. 3 is another schematic flow chart of a report analysis chart automatic generation and display method provided by the third embodiment of the present invention, and for convenience of description, only the parts related to the third embodiment of the present invention are shown, where the method includes:
the detailed implementation mode is as follows:
data extraction: the database is connected by the encapsulated function read _ SQL of the pandas library in python, and then the data to be extracted is selected in SQL statements, so that the data will be in Dataframe type format for the following operations.
Data cleaning: and sorting and combining the data of multiple dimensions, removing junk information, and optimally arranging core information. The sorting method is to extract effective fields through historical data and user settings, and then use merge function in the pandas library to splice data.
Abnormal data: the fields which do not appear in history, the fields which do not have data or the fields which lack data are defined as abnormal data, abnormal degrees are distinguished by setting abnormal indexes in a self-defined mode, meanwhile, historical data are compared, the data which are mutated are identified, wind control warning is provided, and the reason of the abnormal is displayed for a user.
Data feature identification: and generating a random forest by using a decision tree algorithm, wherein the algorithm can score each field, and the field with high score is a key field, so that the important grade of each field of the data can be obtained, the junk data with lower grade is removed, and the data with higher grade, namely the core data, is reserved.
Analyzing core data: after the data are subjected to feature recognition, the field with higher grade is subjected to single-dimension expansion, the change trend of the key interval of data change is fed back to a user, and the importance degree of the data is prompted.
Comparing historical data: and comparing the existing data with the historical data, and analyzing the difference of each dimension to obtain the trend of data evolution.
And (3) key data identification: and (3) fusing the characteristics by permutation and combination, wherein the fusion method is to separately input the fields of the combination into a decision tree model to obtain the probability distribution of the combination and the prediction result, and if the relevance is high, the relevance between the fields of the combination is high. Therefore, the relevance among all dimensions is obtained, the field group identifications with higher relevance are screened out and then fed back to the user.
And (3) displaying an analysis result: and drawing a statistical chart by utilizing matplotlib in python and displaying the statistical chart in a manner of bar chart, broken line chart, pie chart and combination chart, explaining each displayed picture, wherein the explained content comprises the importance level of each field and other fields with higher relevance to the field.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the embodiments described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation.
Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention. The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (11)
1. A report analysis chart automatic generation and display method is characterized by comprising the following steps:
the method comprises the following steps: extracting data from a database;
step two: cleaning the extracted data;
step three: when the cleaned data is abnormal data, providing a wind control warning, and displaying the reason of the abnormality to a user;
step four: when the cleaned data is normal data, acquiring junk data and core data through data characteristic identification;
step five: analyzing the core data and displaying the analysis result.
2. The method for automatically generating and displaying the report analysis chart according to claim 1, wherein the step of extracting data from the database comprises the following steps:
and extracting data from the function read _ SQL connection database packaged by the pandas library through an SQL statement.
3. The method for automatically generating and displaying report analysis graph according to claim 2, wherein the step of extracting data from the function read _ SQL link database encapsulated in the pandas library through SQL statements comprises the steps of:
the extracted data is selected from the function read _ SQL join database encapsulated by the pandas library in Python by SQL statements.
4. The method for automatically generating and displaying the report analysis chart according to claim 3, wherein the extracted data is cleaned, and the steps comprise:
and cleaning data extracted from the function read _ sql link database packaged by the pandas library.
5. The method as claimed in claim 4, wherein the step of cleaning the data extracted from the function read _ sql link database encapsulated in the pandas library comprises the steps of:
sorting and combining the data of multiple dimensions;
and removing the junk information and optimizing and arranging the core information.
6. The method for automatically generating and displaying the report analysis chart according to claim 5, wherein when the cleaned data is abnormal data, a wind control warning is provided, and the reason of the abnormality is displayed to a user, and the method comprises the following steps:
the data after being cleaned has fields which do not appear in history, fields without data and fields without data;
and distinguishing abnormal degrees by self-defining abnormal indexes, identifying mutation data, providing wind control warning, and displaying abnormal reasons to a user.
7. The method for automatically generating and displaying the report analysis chart according to claim 6, wherein when the cleaned data is normal data, the garbage data and the core data are obtained through data characteristic identification, and the steps comprise:
when the cleaned data is normal data, generating a random forest by using a decision tree algorithm to obtain the importance level of each field of the data;
and removing the junk data with lower grade, and reserving the core data.
8. The method for automatically generating and displaying the report analysis chart according to claim 7, wherein core data are analyzed, and the steps comprise:
expanding the field with higher grade in a single dimension;
and feeding back the key interval trend of the data change to the user, and prompting the importance degree of the key interval trend of the data change.
9. The method for automatically generating and displaying the report analysis chart according to claim 8, wherein core data are analyzed and an analysis result is displayed, and the steps comprise:
comparing the existing data with historical data, analyzing the difference of each dimension to obtain the trend of data evolution, and feeding back the trend to a user;
or
Identifying the field group with higher relevance by identifying the key data, and feeding back the field group to the user; or
Inputting all key fields of historical data into a decision tree algorithm to generate a random forest, and training the random forest into a prediction model;
and predicting the current data by using the prediction model, and displaying the prediction result and the probability.
10. The method for automatically generating and displaying the report analysis chart according to claim 9, wherein core data are analyzed and an analysis result is displayed, and the steps comprise:
a statistical chart is drawn and displayed by utilizing matplotlib in python, and the displaying mode comprises a bar chart, a broken line chart, a pie chart and a combination chart.
11. An automatic generation and display system for report analysis chart comprises the following steps:
a data extraction unit for extracting data from a database;
the data cleaning unit is used for cleaning the extracted data;
the first data judgment unit is used for providing a wind control warning when the cleaned data is abnormal data and displaying the reason of the abnormality to a user;
the second data judgment unit is used for obtaining the junk data and the core data through data characteristic identification when the cleaned data are normal data;
and the data analysis display unit is used for analyzing the core data and displaying the analysis result.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011611581.4A CN112800036A (en) | 2020-12-30 | 2020-12-30 | Report analysis chart automatic generation and display method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011611581.4A CN112800036A (en) | 2020-12-30 | 2020-12-30 | Report analysis chart automatic generation and display method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN112800036A true CN112800036A (en) | 2021-05-14 |
Family
ID=75804548
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011611581.4A Pending CN112800036A (en) | 2020-12-30 | 2020-12-30 | Report analysis chart automatic generation and display method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112800036A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113283222A (en) * | 2021-06-11 | 2021-08-20 | 平安科技(深圳)有限公司 | Automatic report generation method and device, computer equipment and storage medium |
CN113836132A (en) * | 2021-11-29 | 2021-12-24 | 中航金网(北京)电子商务有限公司 | Method and device for checking multi-end report forms |
Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030149604A1 (en) * | 2002-01-25 | 2003-08-07 | Fabio Casati | Exception analysis, prediction, and prevention method and system |
CN102915376A (en) * | 2012-11-13 | 2013-02-06 | 北京神州绿盟信息安全科技股份有限公司 | Method and equipment for detecting deviant behavior of database |
CN108492134A (en) * | 2018-03-07 | 2018-09-04 | 国网四川省电力公司 | The big data user power utilization behavior analysis system integrated based on multicycle regression tree |
CN109063178A (en) * | 2018-08-22 | 2018-12-21 | 四川新网银行股份有限公司 | A kind of method and device of the self-service analytical statement extended automatically |
CN109766334A (en) * | 2019-01-07 | 2019-05-17 | 国网湖南省电力有限公司 | Processing method and system for electrical equipment online supervision abnormal data |
CN110533108A (en) * | 2019-09-02 | 2019-12-03 | 四川长虹电器股份有限公司 | A kind of sales volume rejecting outliers method based on isolated forest algorithm |
CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
CN111061704A (en) * | 2019-11-01 | 2020-04-24 | 东方微银科技(北京)有限公司 | Financial analysis report generation method and equipment |
CN111177220A (en) * | 2019-12-26 | 2020-05-19 | 中国平安财产保险股份有限公司 | Data analysis method, device and equipment based on big data and readable storage medium |
CN111738462A (en) * | 2020-06-08 | 2020-10-02 | 国网江苏省电力有限公司常州供电分公司 | Fault first-aid repair active service early warning method for electric power metering device |
CN111914013A (en) * | 2020-08-13 | 2020-11-10 | 傲普(上海)新能源有限公司 | Data management method, system, terminal and medium based on pandas database and InfluxDB database |
CN112015724A (en) * | 2019-09-25 | 2020-12-01 | 国网湖北省电力有限公司黄石供电公司 | Method for analyzing metering abnormality of electric power operation data |
-
2020
- 2020-12-30 CN CN202011611581.4A patent/CN112800036A/en active Pending
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030149604A1 (en) * | 2002-01-25 | 2003-08-07 | Fabio Casati | Exception analysis, prediction, and prevention method and system |
CN102915376A (en) * | 2012-11-13 | 2013-02-06 | 北京神州绿盟信息安全科技股份有限公司 | Method and equipment for detecting deviant behavior of database |
CN108492134A (en) * | 2018-03-07 | 2018-09-04 | 国网四川省电力公司 | The big data user power utilization behavior analysis system integrated based on multicycle regression tree |
CN109063178A (en) * | 2018-08-22 | 2018-12-21 | 四川新网银行股份有限公司 | A kind of method and device of the self-service analytical statement extended automatically |
CN109766334A (en) * | 2019-01-07 | 2019-05-17 | 国网湖南省电力有限公司 | Processing method and system for electrical equipment online supervision abnormal data |
CN110618983A (en) * | 2019-08-15 | 2019-12-27 | 复旦大学 | JSON document structure-based industrial big data multidimensional analysis and visualization method |
CN110533108A (en) * | 2019-09-02 | 2019-12-03 | 四川长虹电器股份有限公司 | A kind of sales volume rejecting outliers method based on isolated forest algorithm |
CN112015724A (en) * | 2019-09-25 | 2020-12-01 | 国网湖北省电力有限公司黄石供电公司 | Method for analyzing metering abnormality of electric power operation data |
CN111061704A (en) * | 2019-11-01 | 2020-04-24 | 东方微银科技(北京)有限公司 | Financial analysis report generation method and equipment |
CN111177220A (en) * | 2019-12-26 | 2020-05-19 | 中国平安财产保险股份有限公司 | Data analysis method, device and equipment based on big data and readable storage medium |
CN111738462A (en) * | 2020-06-08 | 2020-10-02 | 国网江苏省电力有限公司常州供电分公司 | Fault first-aid repair active service early warning method for electric power metering device |
CN111914013A (en) * | 2020-08-13 | 2020-11-10 | 傲普(上海)新能源有限公司 | Data management method, system, terminal and medium based on pandas database and InfluxDB database |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113283222A (en) * | 2021-06-11 | 2021-08-20 | 平安科技(深圳)有限公司 | Automatic report generation method and device, computer equipment and storage medium |
CN113283222B (en) * | 2021-06-11 | 2021-10-08 | 平安科技(深圳)有限公司 | Automatic report generation method and device, computer equipment and storage medium |
CN113836132A (en) * | 2021-11-29 | 2021-12-24 | 中航金网(北京)电子商务有限公司 | Method and device for checking multi-end report forms |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN112800036A (en) | Report analysis chart automatic generation and display method and system | |
CN111352971A (en) | Bank system monitoring data anomaly detection method and system | |
US20130282578A1 (en) | Computer-based collective intelligence recommendations for transaction review | |
CN111738462B (en) | Fault first-aid repair active service early warning method for electric power metering device | |
CN111988176A (en) | Fault positioning system visualization method based on simulation topological structure | |
CN115981984A (en) | Equipment fault detection method, device, equipment and storage medium | |
CN107748782A (en) | Query statement processing method and processing device | |
CN112579789A (en) | Equipment fault diagnosis method and device and equipment | |
CN110348683A (en) | The main genetic analysis method, apparatus equipment of electrical energy power quality disturbance event and storage medium | |
CN115358155A (en) | Power big data abnormity early warning method, device, equipment and readable storage medium | |
CN115277113A (en) | Power grid network intrusion event detection and identification method based on ensemble learning | |
CN110413901A (en) | A kind of assessing credit risks method based on social network analysis | |
CN107025293A (en) | A kind of second power equipment defective data method for digging and system | |
CN115329092A (en) | Knowledge graph generation method, system and medium for threat analysis of power monitoring system | |
CN115828243A (en) | Static code flow analysis method based on scanning scheme | |
CN114626433A (en) | Fault prediction and classification method, device and system for intelligent electric energy meter | |
CN115330262A (en) | Smart city public management method, system and storage medium | |
CN114781328A (en) | Method for visually arranging business process based on plaintext file | |
CN113076355A (en) | Method for sensing data security flow situation | |
CN112966897A (en) | Multi-dimensional data analysis method based on maintenance platform | |
CN113297289A (en) | Method and device for extracting business data from database and electronic equipment | |
CN115375059A (en) | Power grid risk operation and maintenance automatic early warning method and system | |
CN112667617A (en) | Visual data cleaning system and method based on natural language | |
KR20150142459A (en) | Automated system and method of instrument index | |
CN111680572A (en) | Power grid operation scene dynamic judgment method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210514 |
|
RJ01 | Rejection of invention patent application after publication |