CN-121982736-A - Intelligent identification and statistics method and system for electric bill

CN121982736ACN 121982736 ACN121982736 ACN 121982736ACN-121982736-A

Abstract

The application discloses an intelligent identification and statistics method and system for electric bills, wherein the method comprises the steps of responding to a data uploading instruction, displaying an electric bill uploading interface, importing an electric bill capable of crossing at most 12 months, responding to the intelligent identification instruction, conducting OCR (optical character recognition) on the electric bill to obtain an electric price type, further conducting feature extraction on the electric bill according to the electric price type to obtain electric bill data, responding to a data management instruction, displaying a data management interface, conducting summarization on the electric bill data to generate an electric bill list, wherein the electric bill list is used for checking or editing the electric bill data, responding to a statistics analysis instruction, displaying a statistics analysis interface, conducting statistics analysis on the electric bill list, and generating various types of visual charts. The method can realize one-key import, accurate identification, classified summarization and visual presentation, and export database files to reduce the manual operation cost and improve the data processing efficiency and accuracy, and can be widely applied to the technical field of data processing.

Inventors

HU JIAN
GUAN ZHENFENG
Xiao Fengxue
LV XINMIN

Assignees

广东艾博电力设计院(集团)有限公司

Dates

Publication Date: 20260505
Application Date: 20251225

Claims (10)

1. The intelligent identification and statistics method for the electric bill is characterized by comprising the following steps of: responding to the data uploading instruction, displaying an electric bill uploading interface, and importing an electric bill which can span at most 12 months of the year; responding to an intelligent recognition instruction, performing OCR (optical character recognition) on the electric bill to obtain an electric price type, and further performing feature extraction on the electric bill according to the electric price type to obtain electric bill data; Responding to a data management instruction, displaying a data management interface, summarizing the electric bill data, and generating an electric bill list, wherein the electric bill list is used for viewing or editing the electric bill data; and responding to the statistical analysis instruction, displaying a statistical analysis interface, and performing statistical analysis on the electric bill list to generate various types of visual charts.
2. The method according to claim 1, wherein the step of displaying an electric bill uploading interface in response to the data uploading instruction, and importing the electric bill capable of spanning at most 12 months of the year specifically comprises: Displaying a main interface; responding to a first data uploading instruction of a first component in the main interface, displaying the electric bill uploading interface, and importing the electric bill capable of spanning at most 12 months of the year through the electric bill uploading interface; And in response to a second data uploading instruction of the second component in the main interface, clearing the historical data, further displaying the electric bill uploading interface, and importing the electric bill capable of spanning at most 12 months of the year through the electric bill uploading interface.
3. The method according to claim 1, wherein the performing OCR recognition on the electricity bill in response to the intelligent recognition instruction to obtain an electricity price type specifically includes: responding to the intelligent identification instruction of the third component in the electric bill uploading interface, and identifying the metering point number, the year and month, the electricity utilization starting time, the electricity utilization ending time and the electricity price identification in the electric bill; And determining the electricity price type of the electricity bill according to the electricity price identifier, wherein the electricity price type comprises large industrial electricity and non-industrial electricity.
4. The method according to claim 1, wherein the electricity price type includes large industrial electricity and non-industrial electricity, and the feature extraction is performed on the electricity bill according to the electricity price type to obtain electricity bill data, specifically including: If the electricity price type of the electricity bill is the large industrial electricity, the peak electric energy electricity bill, the flat electric energy electricity bill, the electric quantity corresponding to the low-valley electric energy electricity bill, the electricity price and the amount of money in the electricity bill are extracted; If the electricity price type of the electricity bill is the non-industrial electricity, extracting the electric quantity, the electricity price and the amount corresponding to the total active electricity in the electricity bill; And carrying out data modification on the electric quantity, the electricity price and the amount of money to obtain the electricity bill data.
5. The method according to claim 1, wherein the electric bill data includes a metering point number and a year month, and the displaying a data management interface in response to the data management instruction gathers the electric bill data to generate an electric bill list specifically includes: Displaying a main interface; Responding to the data management instruction of a fourth component in the main interface, and displaying the data management interface; according to the metering point number and the year and month, carrying out data association on the electric bill data to generate a structured table; and determining a title bar of the structured table, and further filling the electric bill data of each month into the structured table according to the title bar to generate the electric bill list.
6. The method according to claim 1, wherein the displaying a statistical analysis interface in response to the statistical analysis instruction performs statistical analysis on the electric bill list to generate a plurality of types of visual charts, specifically includes: Displaying a main interface; Responding to the statistical analysis instruction of a fifth component in the main interface, and displaying the statistical analysis interface; Counting the total electric charge, the total electric quantity and the average electric charge of each item type under the same metering point number in the electric charge list to obtain a statistical result; Generating a monthly electricity charge trend histogram and a monthly electricity quantity trend graph according to the statistical result; The project types comprise peak electric energy charges, flat-section electric energy charges, off-peak electric energy charges and active total.
7. The method of claim 6, wherein the method further comprises: responding to a data export instruction of a sixth component in the data management interface, and exporting the electric bill list; and responding to a chart export instruction of a seventh component in the statistical analysis interface, and exporting the statistical result, the monthly electricity fee trend histogram or the monthly electricity quantity trend graph.
8. An intelligent identification and statistics system for electric bill is characterized by comprising: the data uploading module is used for responding to the data uploading instruction, displaying an electric bill uploading interface and importing an electric bill capable of spanning at most 12 months of the year; The data identification module is used for responding to the intelligent identification instruction, performing OCR (optical character recognition) on the electric bill to obtain an electric price type, and further performing feature extraction on the electric bill according to the electric price type to obtain electric bill data; the data management module is used for responding to the data management instruction, displaying a data management interface, summarizing the electric bill data, and generating an electric bill list, wherein the electric bill list is used for checking or editing the electric bill data; and the data statistics module is used for responding to the statistics analysis instruction, displaying a statistics analysis interface, carrying out statistics analysis on the electric bill list and generating various types of visual charts.
9. An electronic device comprising a memory, a processor, a program stored on the memory and executable on the processor, and a data bus for enabling a connected communication between the processor and the memory, the program when executed by the processor implementing the steps of the method according to any of claims 1 to 7.
10. A storage medium, which is a computer-readable storage medium, for computer-readable storage, characterized in that the storage medium stores one or more programs executable by one or more processors to implement the steps of the method of any one of claims 1 to 7.

Description

Intelligent identification and statistics method and system for electric bill Technical Field The application relates to the technical field of data processing, in particular to an intelligent identification and statistics method and system for an electric bill. Background In the current electric charge management scene, the data processing of the electric charge bill mainly depends on manual input or traditional simple tools, and has the problems of low efficiency, poor precision, weak summarizing capability, visual deletion, easily confused data, incapability of analyzing summarized data and the like. Disclosure of Invention In order to solve the technical problems, the application aims to provide the intelligent identification and statistics method and the intelligent identification and statistics system for the electric bill, which can reduce the manual operation cost and improve the data processing efficiency and accuracy. In order to achieve the above purpose, an aspect of the embodiments of the present application provides an intelligent identification and statistics method for an electric bill, including the following steps: responding to the data uploading instruction, displaying an electric bill uploading interface, and importing an electric bill which can span at most 12 months of the year; responding to an intelligent recognition instruction, performing OCR (optical character recognition) on the electric bill to obtain an electric price type, and further performing feature extraction on the electric bill according to the electric price type to obtain electric bill data; Responding to a data management instruction, displaying a data management interface, summarizing the electric bill data, and generating an electric bill list, wherein the electric bill list is used for viewing or editing the electric bill data; and responding to the statistical analysis instruction, displaying a statistical analysis interface, and performing statistical analysis on the electric bill list to generate various types of visual charts. In some embodiments, the responding to the data uploading instruction displays an electric bill uploading interface, and imports an electric bill of at most 12 months across the year, specifically including: Displaying a main interface; responding to a first data uploading instruction of a first component in the main interface, displaying the electric bill uploading interface, and importing the electric bill capable of spanning at most 12 months of the year through the electric bill uploading interface; And in response to a second data uploading instruction of the second component in the main interface, clearing the historical data, further displaying the electric bill uploading interface, and importing the electric bill capable of spanning at most 12 months of the year through the electric bill uploading interface. In some embodiments, the responding to the intelligent recognition instruction carries out OCR recognition on the electric bill to obtain an electric price type, which specifically includes: responding to the intelligent identification instruction of the third component in the electric bill uploading interface, and identifying the metering point number, the year and month, the electricity utilization starting time, the electricity utilization ending time and the electricity price identification in the electric bill; And determining the electricity price type of the electricity bill according to the electricity price identifier, wherein the electricity price type comprises large industrial electricity and non-industrial electricity. In some embodiments, the electricity price type includes large industrial electricity and non-industrial electricity, and the feature extraction is performed on the electricity bill according to the electricity price type to obtain electricity bill data, which specifically includes: If the electricity price type of the electricity bill is the large industrial electricity, the peak electric energy electricity bill, the flat electric energy electricity bill, the electric quantity corresponding to the low-valley electric energy electricity bill, the electricity price and the amount of money in the electricity bill are extracted; If the electricity price type of the electricity bill is the non-industrial electricity, extracting the electric quantity, the electricity price and the amount corresponding to the total active electricity in the electricity bill; And carrying out data modification on the electric quantity, the electricity price and the amount of money to obtain the electricity bill data. In some embodiments, the electric bill data includes a metering point number and a year month, and the responding to the data management instruction displays a data management interface, gathers the electric bill data, and generates an electric bill list, which specifically includes: Displaying a main interface; Responding to the data management instruction