CN111127247A

CN111127247A - Electric quantity data acquisition method and device, computer equipment and storage medium

Info

Publication number: CN111127247A
Application number: CN201911149726.0A
Authority: CN
Inventors: 梁洪浩; 曹小洪; 王波; 伍少成; 陈晓伟; 刘涛; 马越; 孙文龙; 李思鉴; 姜和芳
Original assignee: Shenzhen Power Supply Bureau Co Ltd
Current assignee: Shenzhen Power Supply Bureau Co Ltd
Priority date: 2019-11-21
Filing date: 2019-11-21
Publication date: 2020-05-08
Anticipated expiration: 2039-11-21
Also published as: CN111127247B

Abstract

The application relates to an electric quantity data acquisition method, an electric quantity data acquisition device, computer equipment and a storage medium. The method comprises the following steps: acquiring a corresponding table code data group of a plurality of measuring points corresponding to a target measuring point; selecting a base table code data group with the highest priority from the table code data groups; determining a first default time point corresponding to a data group of the basic table according to the data acquisition density; according to the priority of the table code data group meeting the data replacement condition, data replacement is carried out on the missing point data corresponding to the first missing time point in the basic table code data group to obtain a replaced table code data group; determining a second default time point corresponding to the data group of the replacement table according to the data acquisition density; and according to the priority of the table code data group which does not meet the data replacement condition, performing data fitting on the missing point data corresponding to the second missing point time point in the replaced table code data group to obtain a target table code data group. By adopting the method, the reliability and the integrity of the acquired electric quantity data can be improved.

Description

Electric quantity data acquisition method and device, computer equipment and storage medium

Technical Field

The present application relates to the field of power metering technologies, and in particular, to a method and an apparatus for acquiring power data, a computer device, and a storage medium.

Background

With the reform of the national power system, the electric power spot market mainly develops day-ahead, day-in, actual electric quantity transaction and auxiliary service transaction such as reserve, frequency modulation and the like. The transaction settlement foundation of the electric power spot market is the accurate clearing of electric quantity, so how to collect electric quantity data with high integrity and high reliability is a concern.

At present, the integrity and reliability of the electricity quantity data are generally improved by increasing the collection frequency of the electricity quantity data. However, in this collection method, there may be missed collection or abnormal collection of electricity quantity meter code data, and there still exists a problem that the integrity and reliability of the collected electricity quantity data are low.

Disclosure of Invention

In view of the above, it is necessary to provide a power data collection method, a device, a computer device and a storage medium, which can improve the reliability and integrity of collected power data.

A method of electricity data collection, the method comprising:

acquiring a corresponding table code data group of a plurality of measuring points corresponding to a target measuring point;

selecting a base table code data group with the highest priority from the table code data groups;

determining a first default time point corresponding to the basic table code data group according to the data acquisition density;

according to the priority of the table code data group meeting the data replacement condition, performing data replacement on the missing point data corresponding to the first missing time point in the basic table code data group to obtain a replaced table code data group;

determining a second default time point corresponding to the data group of the replacement table according to the data acquisition density;

and according to the priority of the table code data group which does not meet the data replacement condition, performing data fitting on the missing point data corresponding to the second missing point time point in the replaced table code data group to obtain a target table code data group.

An electrical quantity data collection device, the device comprising:

the acquisition module is used for acquiring a corresponding table code data group of a plurality of measurement points corresponding to the target measurement point;

the selecting module is used for selecting a basic table code data group with the highest priority from the table code data groups;

the determining module is used for determining a first default time point corresponding to the basic table code data group according to the data acquisition density;

the replacing module is used for carrying out data replacement on the missing data corresponding to the first missing time point in the basic table code data group according to the priority of the table code data group meeting the data replacement condition to obtain a replaced table code data group;

the determining module is further configured to determine a second default time point corresponding to the replacement table code data set according to the data acquisition density;

and the fitting module is used for performing data fitting on the missing point data corresponding to the second missing point time point in the replaced table code data group according to the priority of the table code data group which does not meet the data replacement condition to obtain a target table code data group.

A computer device includes a memory and a processor, where the memory stores a computer program, and the processor implements the steps of the electricity data collection method in the above embodiments when executing the computer program.

A computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the steps of the electricity quantity data collection method described in the above embodiments.

According to the electric quantity data acquisition method, the electric quantity data acquisition device, the computer equipment and the storage medium, the plurality of meter code data groups are obtained by simultaneously acquiring the meter code data corresponding to the target metering point through the plurality of measuring points, so that the replacement and fitting of the defect data are conveniently carried out based on the plurality of meter code data groups, the fault-tolerant effect of the data is achieved, and the integrity and the reliability of the acquired electric quantity data can be improved. The meter code data group with the highest priority in the meter code data groups is determined as a basic meter code data group, and data replacement is carried out on the missing data determined based on the data acquisition density in the basic meter code data group according to the priority of the meter code data group meeting the data replacement condition, so that the integrity and the reliability of the electricity meter code data can be improved. Furthermore, according to the priority of the meter code data group which does not meet the data replacement condition, data fitting is carried out on the missing point data in the replaced meter code data group, the integrity and the reliability of the electricity meter code data can be further improved, and the template meter code data group obtained through fitting is determined to be the collected electricity quantity data, so that the integrity and the reliability of the collected electricity quantity data can be improved.

Drawings

Fig. 1 is an application scenario diagram of an electric quantity data acquisition method in an embodiment;

FIG. 2 is a schematic flow chart of a method for collecting electrical quantity data according to an embodiment;

fig. 3 is a block diagram of an embodiment of an electricity data collection device;

FIG. 4 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application 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 present application and are not intended to limit the present application.

The electric quantity data acquisition method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 110 communicates with the server 120 through a network. The server 120 acquires, from the terminal 110, a plurality of surface data groups corresponding to respective measurement points corresponding to the target measurement point, and performs the electricity amount data collection method based on the plurality of surface data groups acquired. As shown in fig. 1, the terminal 110 includes at least a first terminal 112 and a second terminal 114, each of which corresponds to at least one measurement point, and the measurement points corresponding to different terminals are different from each other. The terminal 110 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 120 may be implemented by an independent server or a server cluster formed by a plurality of servers.

In one embodiment, as shown in fig. 2, a method for collecting power data is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:

s202, acquiring a table code data group corresponding to each of a plurality of measuring points corresponding to the target metering point.

The target metering point is a metering point of the electric quantity data to be collected, and specifically may be a customer metering point on a customer side or a station metering point measured by a station. A metering point is understood to be an electrical connection point in physical terms. One measuring point can be used for measuring a group of electric energy meter data of the target measuring point, one measuring point is composed of an electric energy meter and a terminal, and a plurality of electric energy meters and terminals can be combined to form a plurality of measuring points. For example, in the case of 2 terminals and 2 electric energy meters, the 2 electric energy meters are simultaneously used for acquiring the electric energy meter code data of the target metering point, and each terminal of the 2 terminals simultaneously acquires the electric energy meter code data acquired by the 2 electric energy meters, so that the 2 terminals and the 2 electric energy meters can be combined to form 4 measuring points.

And parallelly collecting the electricity meter code data of the target metering point at each time point of data to be collected according to the preset data collection density at each measuring point to obtain a group of electricity meter code data. The set of electricity meter data forms a meter data set. In this way, a plurality of table data groups corresponding to the target measurement point can be obtained by the plurality of measurement points. The data acquisition density may specifically refer to the number of electricity meter code data to be acquired per unit time of each measurement point, such as 1, or refer to a time interval between two adjacent electricity meter code data acquisitions of each measurement point, such as 1 hour. The unit time is, for example, 1 hour. The time point when the data should be collected can be determined according to the data collection density, for example, if the data collection density is 1 hour, the electricity meter data is collected at each integral point of each measurement point.

Specifically, the server acquires a plurality of table code data groups corresponding to the target metering point, and the plurality of table code data groups are respectively collected and stored by a plurality of measuring points corresponding to the target metering point. And when the electric quantity data acquisition condition is met, the server actively acquires the data group of the table collected by each measuring point corresponding to the target measuring point from the terminal corresponding to the measuring point. The electric quantity data acquisition condition is, for example, detection of an electric quantity data acquisition instruction, or detection of that the current time is consistent with a preset electric quantity data acquisition time. The server can also receive the table code data group actively pushed or reported by the terminal corresponding to each measuring point corresponding to the target measuring point.

In one embodiment, each measurement point collects electricity meter data through a plurality of data freezing modes. Each data freezing mode can be understood as a mode of recording electricity meter data. One measuring point collects electricity meter data according to a plurality of data freezing modes, and a meter data group under each data freezing mode can be obtained. Therefore, one measuring point is provided with a plurality of meter data groups, the number of the meter data groups corresponding to the target measuring point can be further increased, and the fault tolerance of the collected electric quantity data can be improved. Each data freezing mode corresponds to a corresponding data acquisition density, and the data acquisition densities corresponding to different data freezing modes can be the same or different. It can be understood that when the data acquisition densities of the different data freezing modes are different, the data acquisition density of the data freezing mode with the highest priority is the highest.

For example, the target metering point corresponds to 4 measuring points, each measuring point records electricity meter data through 3 data freezing modes, and the target metering point corresponds to 12 meter data groups. The electric meter data recorded by the 3 data freezing modes can be recorded by electric meter load, a terminal freezing window and electric meter integral point freezing respectively. Thus, each measuring point records the electricity meter data of the target measuring point by 3 copies through the 3-data freezing manner.

In one embodiment, the server obtains the corresponding table data group for each measurement point through one or more channels. When the corresponding surface code data group of each measuring point is obtained through a plurality of channels, the problem of failure in electric quantity data acquisition caused by abnormity of a single channel can be avoided, and the reliability of electric quantity data acquisition can be improved. The channel includes, but is not limited to, a wireless channel, which may be a channel based on a GPRS (General packet radio service) network, and a wired channel, which may be a channel based on an optical fiber.

In one embodiment, each channel is connected to a terminal corresponding to each measurement point. The wired channel accesses a separate front-end processor through the wired network, the separate front-end processor being a terminal access server dedicated to the limited network. The wireless network is accessed to the original front-end processor through the GPRS network, and the original front-end processor is a front-end server accessed by the GPRS network. The front-end processor is a server executing the electric quantity data acquisition method provided by the application, and acquires a bridge of the data group of the meter from a terminal corresponding to the measuring point. The front-end processor collects the data group of the meter data from the terminal and transmits the data group to a server for executing the electric quantity data collection method provided by the application, and the front-end processor and the server belong to a metering automation system. It can be understood that the front-end processor and the server for executing the electric quantity data acquisition method provided by the present application may be specifically the same server. Thus, the server collects the data group of the table directly from the terminal through the channel and performs corresponding processing.

In one embodiment, for each metering point, a double-table, double-terminal and double-channel acquisition mode is adopted to acquire a plurality of corresponding table data groups. For example, for a customer metering point, an acquisition mode that two terminals, two electric energy meters and one wired channel and one wireless channel are used together is adopted. Each channel is connected with two terminals respectively. The method comprises the following steps that one terminal collects electricity meter code data of one electric energy meter, or each terminal collects electricity meter code data of two electric energy meters. And corresponding to the station metering point, adopting an acquisition mode of two wired channels, two terminals and two electric energy meters. Each wired channel is independently connected with one terminal, or each wired channel is connected with two terminals, and each terminal acquires electricity meter code data of two electric energy meters.

In one embodiment, the server acquires a plurality of table code data groups corresponding to the target metering point within a preset time period. The server acquires a plurality of electric quantity meter data collected by each measuring point corresponding to the target measuring point within a preset time period to obtain a meter data group corresponding to each measuring point within the preset time period.

S204, selecting the basic table code data group with the highest priority from the table code data groups.

Specifically, after acquiring a plurality of table code data groups corresponding to the target metering point, the server determines the priority of each table code data group, selects a table code data group with the highest priority from the plurality of table code data groups according to the priority of each table code data group, and determines the selected table code data group as a basic table code data group corresponding to the target metering point.

In one embodiment, each measurement point corresponding to the target metering point is preconfigured with a priority, and each data freezing mode is also preconfigured with a priority. And the server determines the priority of the data group according to the priority of the measuring point corresponding to the data group and the priority of the data freezing mode. It is understood that the priority of the data group is determined mainly by the priority of the measuring point and secondarily by the priority of the data freezing mode. In this way, the priority of the data group collected by the measurement point with high priority through various data freezing methods is higher than that of the data group collected by the measurement point with low priority through various data freezing methods. And the measuring point respectively collects the table code data groups through a plurality of data freezing modes, and the priorities of the table code data groups are determined according to the priorities of the data freezing modes.

In one embodiment, each measurement point consists of a terminal and an electric energy meter. And the priorities of the plurality of measuring points corresponding to the target measuring point are determined by the priorities of the terminals forming the measuring points and the priorities of the electric energy meters. When the priority of the measuring point is determined, the priority of the electric energy meter is used as the main priority, and the priority of the terminal is used as the auxiliary priority. For example, the target metering point corresponds to two electric energy meters, namely a main meter and an auxiliary meter, and two terminals, namely a main terminal and a standby terminal, and the 2 terminals and the 2 electric energy meters are combined to form 4 measuring points corresponding to the target metering point. The 4 measurement points are respectively as follows according to the priority sequence from high to low: the system comprises a main terminal main meter measuring point, a standby terminal main meter measuring point, a main terminal auxiliary meter measuring point and a standby terminal auxiliary meter measuring point.

Further, if each measuring point collects electricity meter data in a 3-data freezing mode, 12 meter data groups corresponding to the target measuring point are obtained. The 12 table code data groups are respectively as follows according to the priority sequence from high to low: the method comprises the steps of main terminal main meter ammeter load recording, a main terminal main meter terminal freezing window, main terminal main meter ammeter integral point freezing, standby terminal main meter ammeter load recording, standby terminal main meter terminal freezing window, standby terminal main meter ammeter integral point freezing, main terminal auxiliary meter ammeter load recording, main terminal auxiliary meter terminal freezing window, main terminal auxiliary meter ammeter integral point freezing, standby terminal auxiliary meter ammeter load recording, standby terminal auxiliary meter terminal freezing window and standby terminal auxiliary meter integral point freezing.

S206, determining a first default time point corresponding to the data group of the basic table according to the data acquisition density.

The missing time point refers to a time point when data is required to be collected according to the data collection density but the electricity meter code data is not collected, or refers to a time point when data is required to be collected according to the data collection density and a data collection record is generated but all data items in the electricity meter code data are not collected successfully. The electricity meter data corresponding to the defect time point in the table data set may be understood as defect data.

Specifically, the server obtains a pre-configured data acquisition density, and determines each time point at which data should be acquired according to the data acquisition density. And the server traverses the basic table code data group according to the determined time point of the data to be collected so as to determine whether the basic table code data group comprises the electricity meter code data corresponding to each time point. And when the time point at which the data are to be collected is judged to have no corresponding electricity meter data in the basic meter data group, the server determines the time point as a first default time point corresponding to the basic meter data group. When the time point when the data are required to be collected is judged to have corresponding electricity meter code data in the basic meter code data group, the server further judges whether each data item in the electricity meter code data exists and whether each data item corresponds to the data. When the electricity meter code data corresponding to the time point of the data to be collected is judged to have the missing item or the data corresponding to the missing data item, the server determines the time point as a first missing time point corresponding to the basic meter code data group.

In one embodiment, each electricity meter code data in the meter code data group comprises the acquisition time of the electricity meter code data, a plurality of data items which are pre-configured and data corresponding to each data item. And the server respectively matches each time point of data to be acquired, which is determined according to the data acquisition density, with each electricity meter data in the basic meter data group so as to determine a first missing time point according to a matching result.

In one embodiment, the server determines electricity meter data corresponding to the first deficiency time point in the base meter data group as deficiency data.

In one embodiment, if it is determined that the base table data group has the first missing time point, it indicates that the electricity meter data which fails to be collected or has the data items which are not completely collected exist in the base table data group, that is, the missing data exists. The server judges the integrity of the basic table code data group according to the data acquisition density, determines the time point when the electricity meter code data acquisition fails or the data items are not completely acquired in the basic table code data group, and determines the time point as a first default time point.

And S208, carrying out data replacement on the missing point data corresponding to the first missing point time point in the basic table code data group according to the priority of the table code data group meeting the data replacement condition to obtain a replaced table code data group.

The data replacement condition is a basis or condition for screening the table code data group which can be used for performing data replacement on the deficiency data in the basic table code data, and specifically may be a table code data group corresponding to the electric energy meter with the highest screening priority. The data replacement condition is, for example, to filter the table data group corresponding to the main table.

Specifically, the server screens the table code data groups meeting the data replacement condition from the acquired table code data groups, performs data replacement on the deficiency data corresponding to the first deficiency time point in the basic table code data group according to the priority of the screened table code data groups and the electricity meter code data corresponding to the first deficiency time point in the screened table code data groups in sequence, and stops the replacement operation when the electricity meter code data corresponding to the first deficiency time point in the basic table code data group is obtained by replacement or the screened table code data groups are traversed, so as to obtain the replacement table code data group corresponding to the basic table code data group.

In one embodiment, for each first deficiency time point, the server performs data replacement on deficiency data corresponding to the first deficiency time point in the basic table code data group according to the electricity meter data corresponding to the first deficiency time point in the table code data groups meeting the data replacement condition in the order from high to low in the priority of the table code data groups. And when the data of the corresponding defect point in the basic table code data is successfully replaced according to the electricity meter code data in the table code data group with the current priority, the data of the defect point is not required to be continuously replaced according to the electricity meter code data with the next priority. It can be understood that if the electricity meter data corresponding to the first shortage time point exists in the meter data group of the current priority, the data replacement of the shortage data corresponding to the first shortage time point can be successfully performed based on the meter data group of the current priority.

In one embodiment, after determining a plurality of first missing time points corresponding to the base table data group according to the data acquisition density, the server obtains a first missing time point list according to the plurality of first missing time points. And the server takes the corresponding table code data groups of the main terminal main table measuring point and the standby terminal main table measuring point as replacement data sources according to the data replacement conditions. And the server reads the electricity meter data corresponding to each first deficiency time point in the next-priority meter code data group from the replacement data source according to the first deficiency time point list and the sequence of the meter code data group priorities from high to low, and determines the read electricity meter data as the replacement data of the corresponding deficiency data until each first deficiency time point in the first deficiency time point list finds the replacement data or each meter code data group in the replacement data source is read. And the server merges the determined replacement data aiming at the missing data with the existing electricity meter data in the basic meter data group to obtain a replacement meter data group.

S210, determining a second default time point corresponding to the data group of the replacement table according to the data acquisition density.

Specifically, the server determines time points of data to be collected according to the data collection density, and traverses the replacement table code data group according to the determined time points of the data to be collected to determine whether the replacement table code data group includes electricity meter code data corresponding to each time point, so that the integrity of the replacement table code data group is determined. When the time point when the data needs to be collected is judged not to have corresponding electricity meter code data in the replacement table code data group, or when the time point is judged to have corresponding electricity meter code data in the replacement table code data group but has the data item missing or the data item missing, the server determines the time point as a second missing time point corresponding to the replacement table code data group.

In one embodiment, the server determines each time point when data should be acquired according to the data acquisition density, and respectively matches the electricity meter data in the replacement meter data group to determine the second lack time point. It can be understood that if it is determined that the replacement table code data group should have the second missing time point, it indicates that, after the data replacement is performed on the missing data in the basic table code data group according to the table code data group meeting the data replacement condition, the missing data still exists in the obtained replacement table code data, that is, it indicates that no electricity meter code data capable of successfully replacing the missing data exists in each table code data group meeting the data replacement condition. And the server further performs data fitting on the missing point data according to the data group of the meter data which does not meet the data replacement condition so as to obtain corresponding electricity meter data through fitting.

S212, according to the priority of the table code data group which does not meet the data replacement condition, data fitting is carried out on the missing point data corresponding to the second missing point time point in the replaced table code data group, and the target table code data group is obtained.

Specifically, when it is determined that the replacement table code data group corresponds to the second default time point, the server screens the table code data groups which do not meet the data replacement condition from the acquired plurality of table code data groups, performs data fitting on the electricity meter code data corresponding to the second default time point in the replacement table code data group according to the priority of the screened table code data groups and the electricity meter code data corresponding to the second default time point in sequence according to the electricity meter code data corresponding to the second default time point in the screened table code data groups, and stops the fitting operation when the electricity meter code data corresponding to the second default time point in the replacement table code data group is obtained by fitting or the screened table code data groups are traversed, so as to obtain the target table code data group corresponding to the basic table code data group.

In an embodiment, the server performs an iterative process of data replacement on the missing point data corresponding to the first missing time point according to the table code data group meeting the data replacement condition, and similarly performs an iterative process of data fitting on the missing point data corresponding to the second missing time point according to the table code data group not meeting the data replacement condition, which is not described herein again.

According to the electric quantity data acquisition method, the meter code data corresponding to the target metering point are acquired through the plurality of measuring points simultaneously to obtain the plurality of meter code data groups, so that missing data can be replaced and fitted based on the plurality of meter code data groups, the data fault tolerance effect is achieved, and the integrity and the reliability of the acquired electric quantity data can be improved. The meter code data group with the highest priority in the meter code data groups is determined as a basic meter code data group, and data replacement is carried out on the missing data determined based on the data acquisition density in the basic meter code data group according to the priority of the meter code data group meeting the data replacement condition, so that the integrity and the reliability of the electricity meter code data can be improved. Furthermore, according to the priority of the meter code data group which does not meet the data replacement condition, data fitting is carried out on the missing point data in the replaced meter code data group, the integrity and the reliability of the electricity meter code data can be further improved, and the template meter code data group obtained through fitting is determined to be the collected electricity quantity data, so that the integrity and the reliability of the collected electricity quantity data can be improved.

In one embodiment, step S208 includes: screening a first table code data group which meets the data replacement condition in the table code data groups; selecting a first table code data group with highest priority from first table code data groups which are not used for data replacement currently; and performing data replacement on the missing point data corresponding to the first missing time point in the basic table code data group according to the electricity meter code data corresponding to the first missing time point in the selected first table code data group, and returning to the step of selecting the first table code data group with the highest priority from the first table code data groups which are not used for data replacement at present to continue to be executed until the electricity meter code data corresponding to the first missing time point is obtained by replacement, or when the first table code data group is traversed, obtaining the replaced table code data group.

Specifically, the server screens a first table data group meeting the data replacement condition from the acquired plurality of table data groups. The server selects a first table code data group with the highest priority from first table code data groups which are not used for data replacement at present, and performs data replacement on the deficiency data corresponding to the first deficiency time point in the basic table code data group according to the electricity meter code data corresponding to the first deficiency time point in the selected first table code data group. If the electricity meter code data corresponding to the first deficiency time point can be obtained by replacing according to the currently selected first meter code data group, the server stops the data replacement operation of the deficiency data corresponding to the first deficiency time point, and continues to perform data replacement on the deficiency data which is not subjected to data replacement until the electricity meter code data corresponding to each first deficiency time point is obtained by replacement, or the replacement meter code data group is obtained by traversing the screened first meter code data group at each first deficiency time point.

In one embodiment, the first default time point is multiple. And after the server selects the first table code data group with the highest priority from the first table code data groups which are not used for data replacement at present, respectively performing data replacement on the defect data corresponding to the corresponding first defect time points according to the electricity meter code data corresponding to each first defect time point in the selected first table code data group. After data replacement is carried out based on the currently selected first table code data group, if a first shortage time point of the electricity meter code data obtained through replacement does not exist, the server continuously selects the first table code data group with the highest priority from the first table code data groups which are not used for data replacement, and carries out data replacement on the shortage data corresponding to the first shortage time point of the electricity meter code data obtained through replacement on the basis of the first table code data group selected next time until the electricity meter code data corresponding to each first shortage time point is obtained through replacement, or the replacement table code data group is obtained by aiming at all the first table code data groups until the electricity meter code data corresponding to each first shortage time point is obtained through replacement.

In the above embodiment, according to the priority of the table code data group meeting the data replacement condition, data replacement is performed on the missing data in the basic table code data group in an iterative manner to obtain a replaced table code data group with higher integrity and reliability, so that the integrity and reliability of the collected electric quantity data can be improved.

In one embodiment, step S212 includes: screening a second table code data group which does not meet the data replacement condition in the table code data groups; selecting a second table data group with the highest priority from second table data groups which are not used for data fitting currently; and performing data fitting on the missing point data corresponding to the second missing time point in the replacement table code data group according to the electricity meter code data corresponding to the second missing time point in the selected second table code data group, and returning to the step of selecting the second table code data group with the highest priority from the second table code data groups which are not used for data fitting at present to continue to be executed until the electricity meter code data corresponding to the second missing time point is obtained by fitting, or when the second table code data group is traversed, obtaining the target table code data group.

Specifically, the server removes a first table code data group meeting the data replacement condition from the acquired plurality of table code data groups so as to screen out a second table code data group not meeting the data replacement condition. And the server selects a second table code data group with the highest priority from the second table code data groups which are not used for data fitting currently, and performs data fitting on the deficiency data corresponding to the second table code data group in the replacement table code data group according to the electricity meter data corresponding to the second deficiency time point in the selected second table code data group. If the electricity meter data corresponding to the second deficiency time point can be obtained through fitting according to the currently selected second meter data group, the server stops the data fitting operation on the deficiency data corresponding to the second deficiency time point, continues to perform data fitting on the deficiency data which is not subjected to data fitting until the electricity meter data corresponding to each second deficiency time point is obtained through fitting, or the target meter data group is obtained through traversing the screened second meter data groups for each second deficiency time point.

In one embodiment, the server may perform data fitting on the missing point data corresponding to each second missing time point at which the electricity meter data is not obtained through fitting by using the currently selected second meter data group. The server also can sequentially traverse the second table code data groups according to the sequence of the priorities from high to low aiming at each second deficiency time point, and perform data fitting according to deficiency data corresponding to the second deficiency time point in the traversed second table code data groups until the electricity meter code data corresponding to the second deficiency time point is obtained through fitting, or continue to perform the data fitting operation aiming at the next second deficiency time point until each second table code data group is traversed.

In the above embodiment, according to the priority of the table code data group that does not meet the data replacement condition, data fitting is iteratively performed on the missing data in the replacement table code data group to obtain a target table code data group with higher integrity and reliability. Therefore, when the collected electric quantity data is determined according to the target table code data group, the integrity and the reliability of the collected electric quantity data can be improved.

In one embodiment, the data fitting of the deficiency data corresponding to the second deficiency time point in the replacement table code data set according to the electricity meter data corresponding to the second deficiency time point in the selected second table code data set includes: acquiring electricity meter code data corresponding to a second default time point and electricity meter code data corresponding to a time point before the second default time point from the selected second electricity meter code data group; calculating the fitting electric quantity corresponding to the second default time point according to the acquired electric quantity meter data; and fitting the electricity meter code data corresponding to the second missing time point according to the electricity meter code data corresponding to the fitting electricity quantity and the previous time point in the replacement meter code data group.

In one embodiment, the server subtracts the electricity meter code data corresponding to the second shortage time point from the electricity meter code data corresponding to the previous time point of the second shortage time point to obtain the fitting electric quantity corresponding to the second shortage time point. Further, the server adds the electricity meter data corresponding to the time point before the second default time point in the replacement meter data group to the fitting electricity quantity corresponding to the second default time point to obtain the corresponding fitting electricity quantity.

In one embodiment, after determining a plurality of second absence time points corresponding to the replacement table code data set, the server obtains a second absence time point list according to the plurality of second absence time points. And the server takes the corresponding table data groups of the primary terminal secondary table measuring points and the secondary terminal secondary table measuring points as fitting data sources according to the data replacement conditions. And the server reads electricity meter code data corresponding to the second deficiency time point in the meter code data group with the next priority and electricity meter code data corresponding to the previous time point of the second deficiency time point from the fitting data source according to the second deficiency time point list and the sequence of the meter code data group priorities from high to low, and performs electricity quantity fitting on the second deficiency time point according to the read electricity meter code data to obtain fitting electricity quantity. And the server calculates the fitting data corresponding to the second missing time point according to the electricity meter code data corresponding to the replacing meter code data group at the previous time point of the second missing time point and the fitting electric quantity obtained by fitting, and uses the fitting data as the electricity meter code data corresponding to the second missing time point. And the server merges the electricity meter code data obtained by fitting with the electricity meter code data existing in the replacement meter code data to obtain a target meter code data group.

In one embodiment, the server may collect the electricity meter code data corresponding to the target metering point at the same time point because the primary table and the secondary table may be different from each other due to the initial meter code data when the primary table and the secondary table are used for collecting the electricity meter code data of the target metering point, but the electricity meter code data corresponding to the target metering point may be collected in parallel by the primary table and the secondary table, so that the electricity quantity increment or the electricity quantity change amount collected at the same time point is the same at the corresponding measuring point of the primary table and the secondary table. In this way, based on the table data group corresponding to the sub table, missing data in the table data group corresponding to the main table can be obtained by fitting.

In the above embodiment, the electric quantity increment corresponding to the second default time point in the second meter code data group is determined as the fitting electric quantity corresponding to the second default time point in the replacement meter code data group, and the corresponding meter code data is obtained based on the fitting electric quantity fitting, so that the integrity and reliability of the meter code data can be improved.

In one embodiment, the electric quantity data acquisition method further includes: determining a third default time point corresponding to the target table code data group according to the data acquisition density; when the third default time point meets the in-group fitting condition, fitting the electricity meter code data corresponding to the third default time point according to the electricity meter code data corresponding to the time point adjacent to the third default time point in the target meter code data group; when the third missing time point does not meet the in-group fitting condition, fitting the electricity meter code data corresponding to the third missing time point according to the historical electricity meter code data corresponding to the time point which is in the same ratio with the third missing time point and has the same date attribute; and according to the electricity meter code data corresponding to the third default time point, obtaining a final target meter code data group with the existing electricity meter code data in the target meter code data group.

The intra-group fitting condition refers to a judgment basis or condition for obtaining electricity meter code data corresponding to missing data in the meter code data group by fitting according to existing electricity meter code data in the meter code data group to be fitted, and specifically may be that the number of the continuous missing data in the meter code data group to be fitted is less than or equal to a preset threshold, for example, 1 or 2. The adjacent time points include a front adjacent time point and a rear adjacent time point. The peer may specifically refer to the current previous year, the previous month of the current month, the previous week of the current week, the previous one or more statutory vacations of the current statutory vacation, or the like. Date attributes such as workday, double holidays, legal holidays, etc., which include both small and long holidays (e.g., New year, Wuyi and Qingming, etc.) and large and long holidays (e.g., spring festival and national day).

Specifically, after the server carries out data replacement and data fitting on the basic table code data group to obtain a target table code data group, the integrity of the target table code data group is judged according to the data acquisition density, and a corresponding third default time point is determined when the target table code data group is judged to be incomplete. The server compares the determined third default time point with a preset fit-in-group condition. When the third default time point meets the intra-group fitting condition, the server acquires electricity meter code data corresponding to a front adjacent time point and a rear adjacent time point of the third default time point from the target meter code data group, averages the acquired electricity meter code data, and determines the calculated average value as the electricity meter code data obtained by fitting the third default time point. The averaging may be an arithmetic average or a weighted average.

Further, when the third default time point does not meet the intra-group fitting condition, the server acquires the measurement points corresponding to the basic meter data group, acquires the historical electricity meter data at the time point which is in the same ratio with the third default time point and has the same date attribute, and fits the acquired historical electricity meter data to obtain the electricity meter data corresponding to the third default time point. And after the electricity meter code data corresponding to each third default time point is obtained through fitting, the server obtains a final target meter code data group according to the electricity meter code data corresponding to each third default time point and the existing electricity meter code data in the target meter code data group.

In one embodiment, when the target meter code data group has two consecutive third deficiency time points, the server acquires electricity meter code data corresponding to a previous adjacent time point of the previous third deficiency time point and an electricity meter code data group corresponding to a next adjacent time point of the next third deficiency time point from the target meter code data group, and determines an average value of the acquired electricity meter code data as the electricity meter code data corresponding to the two third deficiency time points. It is to be understood that the front-adjacent time point and the rear-adjacent time point may be a plurality of adjacent time points that are closest in time.

In one embodiment, when the third missing time point does not meet the intra-group fitting condition, the server averages historical electricity meter code data corresponding to a plurality of time points which are in the same ratio with the third missing time point and have the same date attribute, and determines the calculated average value as the electricity meter code data corresponding to the third missing time point.

For example, when the primary table fails to collect data with missing points and the secondary table successfully collects data with electric meter data, the data with missing points of the primary table is approximately fitted through the data with electric meter data collected by the secondary table. And when the primary table and the secondary table fail to acquire both the defective data and the continuous defective data are less than or equal to 2, fitting the defective data according to the electric quantity meter data acquired by the primary table at the time points before and after the defective time point interval. When the double-table acquisition fails and both the missing data exist and the quantity of the continuously read missing data is more than 2, fitting the missing data according to the historical electricity meter data acquired by the main table in the time point interval with the same-ratio same-date attribute as the missing time point interval in the following fitting mode.

If the missing time point interval is in the working day, fitting according to the mean value of the electricity meter data in the same time point interval in each working day of the previous month; for example, if there is a missing data at 1:00-2:00 on 22 days (tuesday) in 5 months, fitting is performed with the average of the electricity meter data at 1:00-2:00 in each working day in 4 months. If the missing time point interval is in the double holidays, fitting according to the average value of the electricity meter data in the same time point interval of each double holiday in the previous month; for example, if there is a missing data in the range of 2:00-3:00 in 6/9 (saturday) in 2018, fitting is performed by using the average value of the electricity meter code data in the range of 2:00-3:00 in each saturday and in the range of 2:00-3:00 in 5/5 in 2018.

If the lack time point interval is in a legal holiday, fitting according to the electricity meter code data of the latest holiday interval of the same type, wherein the lack data of the small and long holidays are fitted by referring to the average value of the electricity meter code data of the latest three legal holidays, the lack data of the large and long holidays are fitted by taking the average value of the electricity meter code data of the same holiday in the last year, and if no historical analog data exists, fitting is carried out by referring to the average value of the electricity meter code data of the last legal holiday; such as: if the data in the defect exists in 2:00-3:00 of 2 days of national day (national celebration) in 10 months in 2018, fitting the data by using the mean value of the data in the electricity meter data in 2:00-3:00 of 7 days of national celebration in 10 months in 2017; such as: and if the data in the year 2018, 6, 17 (at noon) and 2:00-3:00 have the defect, fitting the mean value of the electric meter data in the year 2018, namely New year's day, Qingming day and Wuyi holiday of 2:00-3: 00.

If the lacking time point interval spans the time period of working day/double-holiday and legal holiday, the lacking time point interval is divided according to the working day/double-holiday and the legal holiday, and then fitting is carried out according to the data fitting mode of the working day/double-holiday and the legal holiday. If typhoon, user stop and the like can not know whether the actual site of the user is normal power utilization in time, fitting is carried out on working days, double holidays and holidays as usual according to the above rules.

In the above embodiment, when there are a plurality of third default time points, the default data corresponding to the corresponding third default time points are respectively fitted according to the intra-group fitting conditions, so that the integrity of the target table code data group is improved, and the reliability of the target table code data group is ensured.

In one embodiment, step S202 includes: acquiring initial table data groups corresponding to a plurality of measuring points corresponding to a target measuring point; determining an initial missing time point corresponding to an initial table code data group; and performing data complementary collection on the missing point data at the initial missing point in the complementary collection period to obtain a surface data group.

The complementary acquisition period is a preset time interval or time length capable of performing data complementary acquisition on the deficiency data, for example, within 3 days, that is, a time interval in which the current time is the end time and the time length is 3 days.

Specifically, the server acquires one or more measuring points corresponding to the terminal from the terminal, corresponding to the initial table data group collected by the target metering point. And when the data complementary collection triggering condition is met, the server determines the initial missing time points corresponding to the corresponding initial table code data groups and the missing data corresponding to each initial missing time point according to the data collection density. When the initial meter code data group corresponds to the initial default time point, the server acquires the electricity meter code data corresponding to the initial default time point again from the terminal corresponding to the initial meter code data group according to the initial default time point, and replaces the corresponding default data with the electricity meter code data so as to realize data replenishment of the default data. By supplementing data of the missing data to each initial table code data group, the server can obtain a plurality of table code data groups corresponding to the target metering point.

The data complementary acquisition triggering condition is, for example, that the current time is detected to be consistent with the preset data complementary acquisition triggering time. After the server acquires the initial table data group, for the missing data of the initial missing time point in the make-up period, the server may periodically trigger the data make-up operation, for example, trigger the data make-up operation every 1 hour.

In one embodiment, when it is determined that there is missing data in the initial table data group, the server may acquire the initial table data group again from the corresponding terminal to achieve data complementary collection.

In one embodiment, the server performs data complementary collection according to the priority of the initial table code data group, and when the initial table code data group with a high priority is successfully collected, a missing record cannot be generated for the initial table code data group with a low priority and missing data, and data complementary collection cannot be performed for the missing data with the low priority. When the initial table code data group with high priority has the initial shortage time point, data complementary collection is carried out on the shortage data corresponding to the initial shortage time point in the initial table code data group with low priority.

In the above embodiment, by performing data complementary collection on the missing point data in the initial meter code data group, the integrity and reliability of the electric quantity meter code data in the obtained meter code data group can be improved, so that the integrity and reliability of the electric quantity data can be improved when the electric quantity data is collected based on the meter code data group. And only carry out data additional collection in the additional collection cycle to avoid carrying out unnecessary data additional collection to the deficiency data that surpasses the time efficiency, can reduce unnecessary data interaction, thereby can reduce data processing complexity.

In one embodiment, the electric quantity data acquisition method further includes: calculating the segmented electric quantity corresponding to the target metering point according to the target table data group; judging the abnormity of the segmented electric quantity; and when the abnormal subsection electric quantity is judged, repairing the abnormal subsection electric quantity.

In one embodiment, after the server obtains the target meter data group corresponding to the target meter point through data replacement and data fitting, the server calculates a plurality of segmented electric quantities corresponding to the target meter point according to the electric quantity meter data in the target meter data group. The server can calculate to obtain a plurality of corresponding segmented electric quantities according to any two adjacent electric quantity meter data in the target meter data group. The server can also calculate to obtain the segmented electric quantity corresponding to each time point according to a preset time point list and the electric quantity meter code data corresponding to each time point in the target meter code data in the time point list.

In one embodiment, after obtaining the plurality of segment electric quantities corresponding to the target metering point, the server determines whether a negative segment electric quantity exists in the plurality of segment electric quantities, and/or determines whether a sudden increase condition exists in a next segment electric quantity in time sequence compared with a previous segment electric quantity, so as to realize the abnormal determination of the segment electric quantity. And when the negative subsection electric quantity exists and/or the sudden increase subsection electric quantity exists, judging that the subsection electric quantity is abnormal.

In one embodiment, the server can automatically repair the abnormal sectional power quantity based on a plurality of table code data groups acquired currently for a target metering point and/or one or more historical table code data groups acquired for the target metering point. The server can also trigger alarm information based on the abnormal subsection electric quantity and push the alarm information to the terminal so as to be convenient for manually repairing the abnormal subsection electric quantity based on the pushed alarm information. The repair of the abnormal segment power amount is not particularly limited herein.

In the embodiment, after the target surface code data with higher integrity and reliability is obtained through data replacement and data fitting, the segmented electric quantity corresponding to the target metering point is determined based on the target surface code data, the anomaly analysis is performed based on the segmented electric quantity, the anomaly restoration is performed based on the anomaly analysis result, and the reliability and the integrity of the collected electric quantity data can be further improved.

It should be understood that, although the steps in the flowchart of fig. 2 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in fig. 2 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.

In one embodiment, as shown in fig. 3, there is provided a power data collection device 300, including: an obtaining module 302, a selecting module 304, a determining module 306, a replacing module 308, and a fitting module 310, wherein:

an obtaining module 302, configured to obtain a data group corresponding to each of a plurality of measurement points corresponding to a target measurement point;

a selecting module 304, configured to select a basic table code data group with a highest priority from the table code data groups;

the determining module 306 is configured to determine a first default time point corresponding to the basic table data set according to the data acquisition density;

the replacing module 308 is configured to perform data replacement on the missing data corresponding to the first missing time point in the basic table code data set according to the priority of the table code data set meeting the data replacement condition, so as to obtain a replaced table code data set;

the determining module 306 is further configured to determine a second default time point corresponding to the replacement table data set according to the data acquisition density;

and the fitting module 310 is configured to perform data fitting on the missing point data corresponding to the second missing point time point in the replaced table code data group according to the priority of the table code data group that does not meet the data replacement condition, so as to obtain a target table code data group.

In one embodiment, the replacing module 308 is further configured to filter a first table data group of the table data groups that meets the data replacing condition; selecting a first table code data group with highest priority from first table code data groups which are not used for data replacement currently; and performing data replacement on the missing point data corresponding to the first missing time point in the basic table code data group according to the electricity meter code data corresponding to the first missing time point in the selected first table code data group, and returning to the step of selecting the first table code data group with the highest priority from the first table code data groups which are not used for data replacement at present to continue to be executed until the electricity meter code data corresponding to the first missing time point is obtained by replacement, or when the first table code data group is traversed, obtaining the replaced table code data group.

In one embodiment, the fitting module 310 is further configured to filter a second table data group of the table data groups that does not meet the data replacement condition; selecting a second table data group with the highest priority from second table data groups which are not used for data fitting currently; and performing data fitting on the missing point data corresponding to the second missing time point in the replacement table code data group according to the electricity meter code data corresponding to the second missing time point in the selected second table code data group, and returning to the step of selecting the second table code data group with the highest priority from the second table code data groups which are not used for data fitting at present to continue to be executed until the electricity meter code data corresponding to the second missing time point is obtained by fitting, or when the second table code data group is traversed, obtaining the target table code data group.

In an embodiment, the fitting module 310 is further configured to obtain electricity meter code data corresponding to the second lack time point and electricity meter code data corresponding to a time point before the second lack time point from the selected second electricity meter code data group; calculating the fitting electric quantity corresponding to the second default time point according to the acquired electric quantity meter data; and fitting the electricity meter code data corresponding to the second missing time point according to the electricity meter code data corresponding to the fitting electricity quantity and the previous time point in the replacement meter code data group.

In one embodiment, the fitting module 310 is further configured to determine a third default time point corresponding to the target table data set according to the data acquisition density; when the third default time point meets the in-group fitting condition, fitting the electricity meter code data corresponding to the third default time point according to the electricity meter code data corresponding to the time point adjacent to the third default time point in the target meter code data group; when the third missing time point does not meet the in-group fitting condition, fitting the electricity meter code data corresponding to the third missing time point according to the historical electricity meter code data corresponding to the time point which is in the same ratio with the third missing time point and has the same date attribute; and according to the electricity meter code data corresponding to the third default time point, obtaining a final target meter code data group with the existing electricity meter code data in the target meter code data group.

In an embodiment, the obtaining module 302 is further configured to obtain an initial table data set corresponding to each of a plurality of measurement points corresponding to the target metering point; determining an initial missing time point corresponding to an initial table code data group; and performing data complementary collection on the missing point data at the initial missing point in the complementary collection period to obtain a surface data group.

In one embodiment, the fitting module 310 is further configured to calculate the segmented electric quantity corresponding to the target metering point according to the target table data set; judging the abnormity of the segmented electric quantity; and when the abnormal subsection electric quantity is judged, repairing the abnormal subsection electric quantity.

For specific limitations of the electric quantity data acquisition device, reference may be made to the above limitations of the electric quantity data acquisition method, and details are not repeated here. All or part of each module in the electric quantity data acquisition device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used for storing the table code data group corresponding to the target metering point and the target table code data group obtained by fitting. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of electricity data collection.

Those skilled in the art will appreciate that the architecture shown in fig. 4 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, which includes a memory and a processor, the memory stores a computer program, and the processor executes the computer program to implement the steps of the electricity data collection method in the above embodiments.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and the computer program, when executed by a processor, implements the steps of the electricity quantity data collection method in the above embodiments.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A method of electricity data collection, the method comprising:

2. The method of claim 1, wherein the data replacement of the missing point data corresponding to the first missing point time point in the base table code data group according to the priority of the table code data group meeting the data replacement condition to obtain a replacement table code data group comprises:

screening a first table code data group which meets the data replacement condition in the table code data groups;

selecting a first table code data group with highest priority from first table code data groups which are not used for data replacement currently;

according to the electricity meter data corresponding to the first default time point in the selected first meter code data group, carrying out data replacement on the default data corresponding to the first default time point in the basic meter code data group, and carrying out data replacement on the default data corresponding to the first default time point in the basic meter code data group

And returning to the step of selecting the first table code data group with the highest priority from the first table code data groups which are not used for data replacement at present, and continuing to execute the step until the electricity meter data corresponding to the first default time point is obtained through replacement, or obtaining the replaced table code data group when the first table code data group is traversed completely.

3. The method of claim 1, wherein the data fitting missing point data corresponding to the second missing point time point in the replacement table code data set according to the priority of the table code data set that does not meet the data replacement condition to obtain a target table code data set comprises:

screening a second table code data group which does not meet the data replacement condition in the table code data groups;

selecting a second table data group with the highest priority from second table data groups which are not used for data fitting currently;

according to the electricity meter data corresponding to the second default time point in the selected second meter code data group, performing data fitting on the default data corresponding to the second default time point in the replacement meter code data group, and performing data fitting on the default data corresponding to the second default time point in the replacement meter code data group

And returning to the step of selecting the second table code data group with the highest priority from the second table code data groups which are not used for data fitting at present, and continuing to execute the step until the electricity meter data corresponding to the second default time point is obtained through fitting, or when the second table code data group is traversed completely, obtaining the target table code data group.

4. The method of claim 3, wherein the data fitting of the deficiency data corresponding to the second deficiency time point in the replacement table code data set according to the electricity meter data corresponding to the second deficiency time point in the selected second table code data set comprises:

acquiring electricity meter code data corresponding to the second default time point and electricity meter code data corresponding to a time point before the second default time point from the selected second electricity meter code data group;

calculating the fitting electric quantity corresponding to the second default time point according to the acquired electric quantity meter data;

and fitting the electricity meter code data corresponding to the second default time point according to the electricity meter code data corresponding to the fitting electricity quantity and the previous time point in the replacement meter code data group.

5. The method of claim 3, further comprising:

determining a third default time point corresponding to the target table code data group according to the data acquisition density;

when the third default time point meets the in-group fitting condition, fitting the electricity meter code data corresponding to the third default time point according to the electricity meter code data corresponding to the time point adjacent to the third default time point in the target electricity meter code data group;

when the third missing time point does not meet the in-group fitting condition, fitting the electricity meter data corresponding to the third missing time point according to the historical electricity meter data corresponding to the time point which is in the same ratio with the third missing time point and has the same date attribute;

and according to the electricity meter code data corresponding to the third default time point, obtaining a final target meter code data group with the electricity meter code data existing in the target meter code data group.

6. The method as claimed in any one of claims 1 to 5, wherein the obtaining of the table data set corresponding to each of the plurality of measurement points corresponding to the target metrology point comprises:

acquiring initial table data groups corresponding to a plurality of measuring points corresponding to a target measuring point;

determining an initial missing time point corresponding to the initial table code data group;

and performing data complementary collection on the missing point data of the initial missing point time point in the complementary collection period to obtain a surface data group.

7. The method according to any one of claims 1 to 5, further comprising:

calculating the segmented electric quantity corresponding to the target metering point according to the target table code data group;

judging the abnormity of the segmented electric quantity;

and when the sectional electric quantity is judged to be abnormal, repairing the abnormal sectional electric quantity.

8. An electrical quantity data acquisition device, characterized in that the device comprises:

9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.