Data processing and calculation integration method for transformer on-load tap-changer test

Abstract

The invention discloses a data processing and calculation integration method for a transformer on-load tap-changer test. The data processing and calculation integration method for the transformer on-load tap-changer test comprises the following steps: obtaining test data measured by a test end in the on-load tap-changer test; executing data preprocessing operation on the test data; calculating according to equipment voltage data in the preprocessed test data and a balance current value obtained at the last time in the experiment to obtain a resistance value data set; and determining at least two target peak points of the waveform to be drawn based on the resistance value data set by adopting a preset intelligent visualization algorithm, and drawing a visual on-load oscillogram according to the at least two target peak points. The technical problems of low efficiency, poor real-time performance and poor data accuracy caused by manual on-load tap-changer data processing are solved.

Description

Technical Field

[0001] The present application relates to the field of electrical data processing, and in particular to a method for integrating data processing and calculation for a transformer on-load tap changer test. Background Art

[0002] As an important electrical equipment in the power system, the operating status of the power transformer is directly related to the safe and stable operation of the power grid.

[0003] Electrical high-voltage test is an important means of transformer maintenance. Through electrical high-voltage test and according to the completed test results, it is determined whether the power transformer is stable and qualified, so as to avoid failure problems of the power transformer after it is put into power grid construction. On-load tap changer test is one of the routine items of high-voltage test. A large amount of switch operation data is generated in the on-load tap changer test. Therefore, data processing and calculation methods become the key links in the on-load tap changer test process.

[0004] In the prior art, the on-load tap changer data preprocessing and calculation method is mainly that the test personnel perform the on-load tap changer data test through the one-key maintenance operation of the smart tablet, query all the on-load tap changer data, select and filter the on-load tap changer data according to the needs, filter out the valid on-load tap changer data, and calculate the transition resistance value according to the filtered valid data. The calculation process of the transition resistance value includes the following steps: first, the test personnel determine the calculation point of the contact resistance, then the test personnel measure the contact resistance of each calculation point, and finally calculate the transition resistance. According to the measured current and voltage, the transition resistance is calculated using Ohm's law, and the transition resistance value is entered into the database. The test personnel selects on the on-load tap changer data visualization page according to the needs, and the inspection system returns the query results and realizes the visualization of the on-load tap changer data, completes the on-load tap changer test, and returns all the data in the on-load tap changer test.

[0005] As can be seen from the above, in the process of visualizing the on-load tap changer data, the test personnel are required to perform a large amount of manual data screening and calculation on the on-load tap changer data. The manual data screening and calculation process often wastes a lot of time and manpower, resulting in extremely low efficiency and poor real-time performance. In addition, the manual data screening and calculation process is also accompanied by factors such as reading errors, calculation errors or lack of standardized processes, resulting in poor data accuracy.

[0006] Currently, no effective solution has been proposed for the problems of low efficiency, poor real-time performance, and poor data accuracy caused by manual on-load tap changer data processing in related technologies. Summary of the invention

[0007] The main purpose of the present application is to provide an integrated method for data processing and calculation of a transformer on-load tap changer test, so as to solve the problems of low efficiency, poor real-time performance and poor data accuracy caused by manual data processing.

[0008] In order to achieve the above-mentioned objective, according to one aspect of the present application, a method for integrated data processing and calculation for a transformer on-load tap changer test is provided.

[0009] The integrated data processing and calculation method for the transformer on-load tap changer test according to the present application includes: obtaining test data measured at the test end in the on-load tap changer experiment; performing data preprocessing operations on the test data; calculating according to the equipment voltage data in the preprocessed test data and the balancing current value obtained last time in the experiment to obtain a resistance value data group; using a preset intelligent visualization algorithm, determining at least two target peak points of the waveform to be drawn based on the resistance value data group, and drawing a visualized on-load waveform diagram according to the at least two target peak points.

[0010] Furthermore, performing data preprocessing operations on the test data includes: filtering out a data group with a type label of on-load tap changer from the test data according to a preset grouping rule; using a data cleaning script pre-written in the Pandas library in Python to remove duplicate, invalid and erroneous data from the filtered on-load tap changer data, and obtaining device voltage data and the last balancing current value obtained in the experiment; and unifying the format of the eliminated data according to a standardized format.

[0011] Furthermore, the use of a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group includes: judging whether the resistance value in the resistance value data group is valid; if valid, dividing the resistance value data group into at least two groups according to a preset grouping rule, and inputting the groups into a first calculation model for calculation to obtain at least two average peak points; and using the average peak point as the target peak point.

[0012] Furthermore, the use of a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group includes: judging whether the resistance value in the resistance value data group is valid; if valid, dividing the resistance value data group into at least two groups according to a preset grouping rule, and inputting the groups into a first calculation model for calculation to obtain at least two average peak points; inputting the at least two average peak points into a second calculation model for calculation to obtain a standard average peak range; judging whether the at least two average peak points are within the standard average peak range; if so, taking the average peak point as the target peak point; if not, cyclically executing the process of re-dividing the resistance value data group into at least two groups according to the preset grouping rule, and inputting the groups into the first calculation model for recalculation, and then judging whether it is within the calculated standard average peak range, until it is judged to be within the calculated standard average peak range.

[0013] Furthermore, after determining whether the resistance value in the resistance value data group is valid, the method further includes: if invalid, looping and recalculating according to the device voltage data in the preprocessed test data and the last obtained balance current value in the experiment, and then determining whether the calculated resistance in the resistance value data group is valid, until it is determined to be valid.

[0014] Furthermore, a preset intelligent visualization algorithm is used to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and after drawing a visualized carrier waveform according to the at least two target peak points, it also includes: storing the preprocessed test data and the visualized carrier waveform diagram in a corresponding test data table in a database.

[0015] Furthermore, after storing the preprocessed test data and the visualized carrier waveform in the corresponding test data table in the database, it also includes: receiving a data query request issued by a user at a terminal; and calling the corresponding preprocessed test data and / or the visualized carrier waveform in the test data table according to the data query request.

[0016] In order to achieve the above-mentioned purpose, according to another aspect of the present application, a data processing and calculation integrated device for transformer on-load tap changer test is provided.

[0017] The data processing device for the on-load tap changer experiment according to the present application includes: an acquisition module, used to acquire the test data measured by the test end in the on-load tap changer experiment; a preprocessing module, used to perform data preprocessing operations on the test data; a calculation module, used to calculate according to the equipment voltage data in the preprocessed test data and the balancing current value obtained last time in the experiment to obtain a resistance value data group; a visualization module, used to use a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and draw a visualized on-load waveform diagram according to the at least two target peak points.

[0018] In order to achieve the above objective, according to another aspect of the present application, a computer-readable storage medium is provided.

[0019] According to the computer-readable storage medium of the present application, a computer program is stored in the computer-readable storage medium, wherein the computer program is configured to execute the integrated method for data processing and calculation of the transformer on-load tap changer test when running.

[0020] In order to achieve the above objective, according to another aspect of the present application, an electronic device is provided.

[0021] The electronic device according to the present application includes: a memory and a processor, wherein the memory stores a computer program, wherein the processor is configured to run the computer program to execute the integrated data processing and calculation method for the transformer on-load tap changer test.

[0022] In the embodiment of the present application, a data processing method of an on-load tap changer experiment is adopted, by performing a data preprocessing operation on the acquired test data; a resistance value data group is obtained by calculating according to the equipment voltage data in the preprocessed test data and the balancing current value obtained for the last time in the experiment; a preset intelligent visualization algorithm is adopted, at least two target peak points of the waveform to be drawn are determined based on the resistance value data group, and a visualized on-load waveform diagram is drawn according to the at least two target peak points; the purpose of intelligent data screening and calculation for visualization is achieved, thereby achieving the technical effect of high efficiency, good real-time performance, and high data accuracy, thereby solving the technical problems of low efficiency, poor real-time performance, and poor data accuracy caused by manual on-load tap changer data processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] The drawings constituting a part of this application are used to provide a further understanding of this application, so that other features, purposes and advantages of this application become more obvious. The schematic embodiment drawings and their descriptions of this application are used to explain this application and do not constitute an improper limitation on this application. In the drawings:

[0024] Figure 1 is a flow chart of a data processing and calculation integration method for a transformer on-load tap changer test according to an embodiment of the present application;

[0025] Figure 2 is a flowchart of data preprocessing operations according to a preferred embodiment of the present application;

[0026] Figure 3 It is a system block diagram of a data processing and calculation integrated method for transformer on-load tap changer test according to a preferred embodiment of the present application;

[0027] Figure 4 is a flow chart of an intelligent visualization algorithm according to a preferred embodiment of the present application;

[0028] Figure 5 It is a visualized carrier wave graph according to a preferred embodiment of the present application;

[0029] Figure 6 It is a structural diagram of a data processing and calculation integrated device for transformer on-load tap changer test according to an embodiment of the present application. DETAILED DESCRIPTION

[0030] In order to enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of this application.

[0031] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present application described here. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0032] In the present application, the terms "upper", "lower", "left", "right", "front", "back", "top", "bottom", "inner", "outer", "middle", "vertical", "horizontal", "lateral", "longitudinal" and the like indicate positions or positional relationships based on the positions or positional relationships shown in the drawings. These terms are mainly used to better describe the present invention and its embodiments, and are not used to limit the indicated devices, elements or components to have a specific orientation, or to be constructed and operated in a specific orientation.

[0033] In addition, some of the above terms may be used to express other meanings in addition to indicating orientation or positional relationship. For example, the term "on" may also be used to express a certain dependency or connection relationship in some cases. For those skilled in the art, the specific meanings of these terms in the present invention can be understood according to specific circumstances.

[0034] In addition, the terms "installed", "set", "provided with", "connected", "connected", and "socketed" should be understood in a broad sense. For example, it can be a fixed connection, a detachable connection, or an integral structure; it can be a mechanical connection or an electrical connection; it can be a direct connection, or an indirect connection through an intermediate medium, or it can be an internal connection between two devices, elements, or components. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0035] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0036] According to an embodiment of the present invention, a method for integrated data processing and calculation for a transformer on-load tap changer test is provided. Figure 1 As shown, the method includes the following steps S100 to S400:

[0037] Step S100, obtaining test data measured by a test end in an on-load tap changer test;

[0038] The test end is an on-site experimental instrument, which is wirelessly connected to the smart tablet, so that the corresponding application processing software can be installed on the smart tablet to control the on-site experimental instrument. In this embodiment, personnel use the one-key maintenance operation in the application processing software to control the corresponding experimental instrument to perform on-load tap changer data testing. After the experiment is completed, all on-load tap changer data (i.e., test data) can be queried.

[0039] Step S200, performing data preprocessing operations on the test data;

[0040] After the test data is obtained, the test data contains data that is irrelevant to the on-load tap changer, repeated, invalid, and erroneous. Therefore, the test data needs to be cleaned to filter out the on-load tap changer data and remove the repeated, invalid, and erroneous data.

[0041] Reference Figure 2 In step 200, performing data preprocessing operations on the test data includes:

[0042] Filtering out a data group with a type label of on-load tap changer from the test data according to a preset grouping rule;

[0043] Use the data cleaning script pre-written in the Pandas library in Python to remove duplicate, invalid, and erroneous data from the filtered on-load tap changer data, and obtain the device voltage data and the last balanced current value obtained in the experiment;

[0044] Unify the format of the eliminated data according to the standardized format;

[0045] Specifically, according to a specified grouping rule, which is grouping according to data type, a data group whose data type is on-load tap changer data is screened out, and a grouping object of the on-load tap changer data is obtained.

[0046] Use the Pandas library in Python, the drop_duplicates() method to remove duplicate values, and use dropna() to delete rows or columns with missing values, clean the carrier wave data, and unify the data format. df is a DataFrame containing on-load tap changer data, df = df.drop_duplicates(subset = ['equipment ID', 'voltage data', 'timestamp']) to remove duplicate values, select and delete records with missing values, df = df.dropna(subset = ['voltage data']), fill missing values ​​with the median, df['voltage data'].fillna(df['voltage data'].median(), inplace = True), check and convert data types to ensure that the data type matches the query requirements, ensure that the timestamp is of datetime type, df['timestamp'] = pd.to_datetime(df['timestamp']), ensure that the voltage data is of numeric type df['voltage data'] = pd.to_numeric(df['voltage data'], errors = 'coerce').

[0047] The data returned is device voltage data, but the units of the voltage data are inconsistent. The units are mV and V. Unit conversion calculation is performed, and the float type voltage data is multiplied by 100 to convert it into integer data. The on-load tap changer data unit is unified into mV data, and the returned on-load tap changer data is unified into integer type. The on-load tap changer data is stored in an array.

[0048] Step S300, calculating according to the device voltage data in the preprocessed test data and the last obtained balance current value in the experiment to obtain a resistance value data group;

[0049] According to Ohm's law: Formula 1: Divide all the returned voltage data U by the last balanced current value I obtained in the test to obtain a resistance value data array The resistance value data group R is returned.

[0050] It realizes intelligent screening of on-load tap-changer data, effectively reducing time and manpower, thereby improving efficiency and real-time performance.

[0051] Step S400: using a preset intelligent visualization algorithm, determining at least two target peak points of the waveform to be drawn based on the resistance value data group, and drawing a visualized waveform diagram with carrier wave according to the at least two target peak points.

[0052] The processor is pre-set with an intelligent visualization algorithm. When the corresponding resistance value data set is calculated, the processor will call the intelligent visualization algorithm and execute the algorithm based on the resistance value data set. It is mainly divided into two steps. First, determine at least two target peak points required for drawing the waveform. Then, based on at least two target peak points, call the drawing software to draw a visualized waveform with carrier wave (refer to Figure 5 ). It realizes intelligent calculation to achieve visualization, high efficiency, good real-time performance, and high data accuracy.

[0053] In a preferred embodiment, in step S400, using a preset intelligent visualization algorithm, determining at least two target peak points of the waveform to be drawn based on the resistance value data set includes:

[0054] Determining whether the resistance value in the resistance value data group is valid;

[0055] If valid, the resistance value data set is divided into at least two groups according to a preset grouping rule, and the groups are input into a first calculation model for calculation to obtain at least two average peak points;

[0056] The average peak point is taken as the target peak point.

[0057] Preferably, four groups of P data are taken successively from the array R, and the average values ​​of the P data are calculated to obtain four data T1, T2, T3, and T4. The values ​​of the first group of P data are [R[1], R[2], ..., R[P]], the values ​​of the second group of P data are [R[2], R[3], ..., R[P+1]], the values ​​of the third group of P data are [R[3], R[4], ..., R[P+2]], and the values ​​of the fourth group of P data are [R[4], R[5], ..., R[P+3]]. The calculation formula is as follows, where P must satisfy P≥50:

[0058] The calculation formula is the average value of each group

[0059] According to the formula, four target peak points with average values ​​of T1, T2, T3, and T4 are calculated and directly used to draw the visual load waveform diagram. According to the data processing results returned by the load test, the load waveform can be quickly drawn without recalculation, and the request can be completed quickly.

[0060] Refer to Figure 4 In another preferred embodiment, in step S400, the using of a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data set includes:

[0061] Determining whether the resistance value in the resistance value data group is valid;

[0062] If valid, the resistance value data set is divided into at least two groups according to a preset grouping rule, and the groups are input into a first calculation model for calculation to obtain at least two average peak points;

[0063] Inputting at least two average peak points into a second calculation model for calculation to obtain a standard average peak range;

[0064] Determining whether the at least two average peak points are within a standard average peak range;

[0065] If yes, then the average peak point is taken as the target peak point;

[0066] If not, the resistance value data group will be re-divided into at least two groups according to the preset grouping rules in a loop, and the data will be input into the first calculation model for recalculation according to the groups, and then it will be determined whether it is within the calculated standard average peak range, until it is determined to be within the calculated standard average peak range.

[0067] Preferably, four groups of P data are taken successively from the array R, and the average values ​​of the P data are calculated to obtain four data T1, T2, T3, and T4. The values ​​of the first group of P data are [R[1], R[2], ..., R[P]], the values ​​of the second group of P data are [R[2], R[3], ..., R[P+1]], the values ​​of the third group of P data are [R[3], R[4], ..., R[P+2]], and the values ​​of the fourth group of P data are [R[4], R[5], ..., R[P+3]]. The calculation formula is as follows, where P must satisfy P≥50:

[0068] The calculation formula is: the average value of each group

[0069] The average values ​​calculated according to the formula are T1, T2, T3, and T4 respectively.

[0070] Take 50 groups of P points (P satisfies P≥50) in the R array continuously, calculate the average value of the 50 groups, and take values ​​similar to those in step a to obtain the standard average value range [m,n]. Compare the results T1, T2, T3, and T4 calculated by formula 2 respectively. If they are not in the average value range [m,n], discard the value of T this time, that is, burr removal is achieved, and re-calculate the value of T in step a until the calculated results are all within the standard average value range. In this case, the value of T is available.

[0071] The calculation formula is: the average value of 50 groups

[0072] According to the calculation, the maximum value of the 50 sets of data is n, the minimum value is m, and the standard average value range is [m, n]. Compare the data T1, T2, T3, and T4 in step a with the standard average value, and the value that satisfies m≤T≤n is taken as the target peak point. Finally, a visual carrier wave graph is drawn through the drawing software according to the target peak point.

[0073] According to the data processing results returned by the load test, the load waveform can be quickly drawn without recalculation, and the request can be completed quickly. The peak judgment and loop program are set to effectively remove burrs, making the final T1, T2, T3, T4 seat target peak points more accurate.

[0074] From the above description, it can be seen that the present invention achieves the following technical effects:

[0075] In the embodiment of the present application, a data processing method of an on-load tap changer experiment is adopted, by performing a data preprocessing operation on the acquired test data; a resistance value data group is obtained by calculating according to the equipment voltage data in the preprocessed test data and the balancing current value obtained for the last time in the experiment; a preset intelligent visualization algorithm is adopted, at least two target peak points of the waveform to be drawn are determined based on the resistance value data group, and a visualized on-load waveform diagram is drawn according to the at least two target peak points; the purpose of intelligent data screening and calculation for visualization is achieved, thereby achieving the technical effect of high efficiency, good real-time performance, and high data accuracy, thereby solving the technical problems of low efficiency, poor real-time performance, and poor data accuracy caused by manual on-load tap changer data processing.

[0076] According to an embodiment of the present invention, preferably, after determining whether the resistance value in the resistance value data group is valid, the method further includes:

[0077] If invalid, the loop is executed to recalculate based on the device voltage data in the preprocessed test data and the last balanced current value obtained in the experiment, and then determine whether the resistance in the calculated resistance value data group is valid, until it is determined to be valid.

[0078] The resistance value judgment and loop program are set up to effectively improve the accuracy of each resistor in the resistance value group finally obtained.

[0079] Reference Figure 3 According to an embodiment of the present invention, preferably, a preset intelligent visualization algorithm is used to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and after drawing the visualized carrier waveform according to the at least two target peak points, it also includes: storing the preprocessed test data and the visualized carrier waveform diagram in the corresponding test data table in the database.

[0080] The drawn visualization carrier wave diagram is stored in the corresponding test data table in the database to provide guarantee for subsequent calls.

[0081] Reference Figure 3 According to an embodiment of the present invention, preferably, after storing the preprocessed test data and the visualized carrier waveform in a corresponding test data table in a database, the method further includes:

[0082] Receiving data query requests sent by users at the terminal;

[0083] According to the data query request, the corresponding pre-processed test data and / or the visualized carrier wave graph are called in the test data table.

[0084] The user inputs the corresponding information on the mobile phone, computer and other terminals to issue a data query request, and then the corresponding pre-processed test data and / or the visualized carrier wave graph can be called from the test data table, which is convenient for subsequent query.

[0085] It should be noted that the steps shown in the flowcharts of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and that, although a logical order is shown in the flowcharts, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0086] According to an embodiment of the present invention, there is also provided a device for implementing the above-mentioned integrated data processing and calculation method for transformer on-load tap changer test, such as Figure 6 As shown, the device comprises:

[0087] An acquisition module 10 is used to acquire test data measured by a test end in an on-load tap changer experiment;

[0088] The test end is an on-site experimental instrument, which is wirelessly connected to the smart tablet, so that the corresponding application processing software can be installed on the smart tablet to control the on-site experimental instrument. In this embodiment, personnel use the one-key maintenance operation in the application processing software to control the corresponding experimental instrument to perform on-load tap changer data testing. After the experiment is completed, all on-load tap changer data (i.e., test data) can be queried.

[0089] A preprocessing module 20, used to perform data preprocessing operations on the test data;

[0090] After the test data is obtained, the test data contains data that is irrelevant to the on-load tap changer, repeated, invalid, and erroneous. Therefore, the test data needs to be cleaned to filter out the on-load tap changer data and remove the repeated, invalid, and erroneous data.

[0091] Reference Figure 2 In step 200, performing data preprocessing operations on the test data includes:

[0092] Filtering out a data group with a type label of on-load tap changer from the test data according to a preset grouping rule;

[0093] Use the data cleaning script pre-written in the Pandas library in Python to remove duplicate, invalid, and erroneous data from the filtered on-load tap changer data, and obtain the device voltage data and the last balanced current value obtained in the experiment;

[0094] Unify the format of the eliminated data according to the standardized format;

[0095] Specifically, according to a specified grouping rule, which is grouping according to data type, a data group whose data type is on-load tap changer data is screened out, and a grouping object of the on-load tap changer data is obtained.

[0096] Use the Pandas library in Python, the drop_duplicates() method to remove duplicate values, and use dropna() to delete rows or columns with missing values, clean the carrier wave data, and unify the data format. df is a DataFrame containing on-load tap changer data, df = df.drop_duplicates(subset = ['equipment ID', 'voltage data', 'timestamp']) to remove duplicate values, select and delete records with missing values, df = df.dropna(subset = ['voltage data']), fill missing values ​​with the median, df['voltage data'].fillna(df['voltage data'].median(), inplace = True), check and convert data types to ensure that the data type matches the query requirements, ensure that the timestamp is of datetime type, df['timestamp'] = pd.to_datetime(df['timestamp']), ensure that the voltage data is of numeric type df['voltage data'] = pd.to_numeric(df['voltage data'], errors = 'coerce').

[0097] The data returned is device voltage data, but the units of the voltage data are inconsistent. The units are mV and V. Unit conversion calculation is performed, and the float type voltage data is multiplied by 100 to convert it into integer data. The on-load tap changer data unit is unified into mV data, and the returned on-load tap changer data is unified into integer type. The on-load tap changer data is stored in an array.

[0098] A calculation module 30, used to calculate according to the device voltage data in the preprocessed test data and the last obtained balance current value in the experiment to obtain a resistance value data set;

[0099] According to Ohm's law: Formula 1: Divide all the returned voltage data U by the last balanced current value I obtained in the test to obtain a resistance value data array The resistance value data group R is returned.

[0100] It realizes intelligent screening of on-load tap-changer data, effectively reducing time and manpower, thereby improving efficiency and real-time performance.

[0101] The visualization module 40 is used to use a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and draw a visualized carrier waveform according to the at least two target peak points.

[0102] The processor is pre-set with an intelligent visualization algorithm. When the corresponding resistance value data set is calculated, the processor will call the intelligent visualization algorithm and execute the algorithm based on the resistance value data set. It is mainly divided into two steps. First, determine at least two target peak points required for drawing the waveform. Then, based on at least two target peak points, call the drawing software to draw a visualized waveform with carrier wave (refer to Figure 5 ). It realizes intelligent calculation to achieve visualization, high efficiency, good real-time performance, and high data accuracy.

[0103] In a preferred embodiment, in step S400, using a preset intelligent visualization algorithm, determining at least two target peak points of the waveform to be drawn based on the resistance value data set includes:

[0104] Determining whether the resistance value in the resistance value data group is valid;

[0105] If valid, the resistance value data set is divided into at least two groups according to a preset grouping rule, and the groups are input into a first calculation model for calculation to obtain at least two average peak points;

[0106] The average peak point is taken as the target peak point.

[0107] Preferably, four groups of P data are taken successively from the array R, and the average values ​​of the P data are calculated to obtain four data T1, T2, T3, and T4. The values ​​of the first group of P data are [R[1], R[2], ..., R[P]], the values ​​of the second group of P data are [R[2], R[3], ..., R[P+1]], the values ​​of the third group of P data are [R[3], R[4], ..., R[P+2]], and the values ​​of the fourth group of P data are [R[4], R[5], ..., R[P+3]]. The calculation formula is as follows, where P must satisfy P≥50:

[0108] The calculation formula is the average value of each group

[0109] According to the formula, four target peak points with average values ​​of T1, T2, T3, and T4 are calculated and directly used to draw the visual load waveform diagram. According to the data processing results returned by the load test, the load waveform can be quickly drawn without recalculation, and the request can be completed quickly.

[0110] Refer to Figure 4In another preferred embodiment, in step S400, the using of a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data set includes:

[0111] Determining whether the resistance value in the resistance value data group is valid;

[0112] If valid, the resistance value data set is divided into at least two groups according to a preset grouping rule, and the groups are input into a first calculation model for calculation to obtain at least two average peak points;

[0113] Inputting at least two average peak points into a second calculation model for calculation to obtain a standard average peak range;

[0114] Determining whether the at least two average peak points are within a standard average peak range;

[0115] If yes, then the average peak point is taken as the target peak point;

[0116] If not, the resistance value data group will be re-divided into at least two groups according to the preset grouping rules in a loop, and the data will be input into the first calculation model for recalculation according to the groups, and then it will be determined whether it is within the calculated standard average peak range, until it is determined to be within the calculated standard average peak range.

[0117] Preferably, four groups of P data are taken successively from the array R, and the average values ​​of the P data are calculated to obtain four data T1, T2, T3, and T4. The values ​​of the first group of P data are [R[1], R[2], ..., R[P]], the values ​​of the second group of P data are [R[2], R[3], ..., R[P+1]], the values ​​of the third group of P data are [R[3], R[4], ..., R[P+2]], and the values ​​of the fourth group of P data are [R[4], R[5], ..., R[P+3]]. The calculation formula is as follows, where P must satisfy P≥50:

[0118] The calculation formula is: the average value of each group

[0119] The average values ​​calculated according to the formula are T1, T2, T3, and T4 respectively.

[0120] Take 50 groups of P points (P satisfies P≥50) in the R array continuously, calculate the average value of the 50 groups, and take values ​​similar to those in step a to obtain the standard average value range [m,n]. Compare the results T1, T2, T3, and T4 calculated by formula 2 respectively. If they are not in the average value range [m,n], discard the value of T this time, that is, burr removal is achieved, and re-calculate the value of T in step a until the calculated results are all within the standard average value range. In this case, the value of T is available.

[0121] The calculation formula is: the average value of 50 groups

[0122] According to the calculation, the maximum value of the 50 sets of data is n, the minimum value is m, and the standard average value range is [m, n]. Compare the data T1, T2, T3, and T4 in step a with the standard average value, and the value that satisfies m≤T≤n is taken as the target peak point. Finally, a visual carrier wave graph is drawn through the drawing software according to the target peak point.

[0123] According to the data processing results returned by the load test, the load waveform can be quickly drawn without recalculation, and the request can be completed quickly. The peak judgment and loop program are set to effectively remove burrs, making the final T1, T2, T3, T4 seat target peak points more accurate.

[0124] From the above description, it can be seen that the present invention achieves the following technical effects:

[0125] In the embodiment of the present application, a data processing method of an on-load tap changer experiment is adopted, by performing a data preprocessing operation on the acquired test data; a resistance value data group is obtained by calculating according to the equipment voltage data in the preprocessed test data and the balancing current value obtained for the last time in the experiment; a preset intelligent visualization algorithm is adopted, at least two target peak points of the waveform to be drawn are determined based on the resistance value data group, and a visualized on-load waveform diagram is drawn according to the at least two target peak points; the purpose of intelligent data screening and calculation for visualization is achieved, thereby achieving the technical effect of high efficiency, good real-time performance, and high data accuracy, thereby solving the technical problems of low efficiency, poor real-time performance, and poor data accuracy caused by manual on-load tap changer data processing.

[0126] According to an embodiment of the present invention, preferably, after determining whether the resistance value in the resistance value data group is valid, the method further includes:

[0127] If invalid, the loop is executed to recalculate based on the device voltage data in the preprocessed test data and the last balanced current value obtained in the experiment, and then determine whether the resistance in the calculated resistance value data group is valid, until it is determined to be valid.

[0128] The resistance value judgment and loop program are set up to effectively improve the accuracy of each resistor in the resistance value group finally obtained.

[0129] Reference Figure 3According to an embodiment of the present invention, preferably, a preset intelligent visualization algorithm is used to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and after drawing the visualized carrier waveform according to the at least two target peak points, it also includes: storing the preprocessed test data and the visualized carrier waveform diagram in the corresponding test data table in the database.

[0130] The drawn visualization waveform diagram is stored in the corresponding test data table in the database to provide guarantee for subsequent calls.

[0131] Reference Figure 3 According to an embodiment of the present invention, preferably, after storing the preprocessed test data and the visualized carrier waveform in a corresponding test data table in a database, the method further includes:

[0132] Receiving data query requests sent by users at the terminal;

[0133] According to the data query request, the corresponding pre-processed test data and / or the visualized carrier wave graph are called in the test data table.

[0134] The user inputs the corresponding information on the mobile phone, computer and other terminals to issue a data query request, and then the corresponding pre-processed test data and / or the visualized carrier wave graph can be called from the test data table, which is convenient for subsequent query.

[0135] Obviously, those skilled in the art should understand that the above modules or steps of the present invention can be implemented by a general computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, and optionally, they can be implemented by a program code executable by a computing device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. Thus, the present invention is not limited to any specific combination of hardware and software.

[0136] The above description is only the preferred embodiment of the present application and is not intended to limit the present application. For those skilled in the art, the present application may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application.

Claims

1. A method for integrated data processing and calculation of transformer on-load tap changer test, characterized in that: include: Obtain the test data measured at the test end in the on-load tap changer experiment; Performing data preprocessing operations on the test data; Calculate according to the device voltage data in the pre-processed test data and the last obtained balance current value in the experiment to obtain a resistance value data group; A preset intelligent visualization algorithm is adopted to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and a visualized carrier waveform is drawn according to the at least two target peak points.

2. The method according to claim 1, characterized in that The performing of data preprocessing operation on the test data comprises: Filtering out a data group with a type label of on-load tap changer from the test data according to a preset grouping rule; Use the data cleaning script pre-written in the Pandas library in Python to remove duplicate, invalid, and erroneous data from the filtered on-load tap changer data, and obtain the device voltage data and the last balanced current value obtained in the experiment; The format of the eliminated data is unified according to the standardized format.

3. The method according to claim 1, characterized in that The method of using a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group includes: Determining whether the resistance value in the resistance value data group is valid; If valid, the resistance value data set is divided into at least two groups according to a preset grouping rule, and the groups are input into a first calculation model for calculation to obtain at least two average peak points; The average peak point is taken as the target peak point.

4. The method according to claim 3, characterized in that The method of using a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group includes: Determining whether the resistance value in the resistance value data group is valid; If valid, the resistance value data set is divided into at least two groups according to a preset grouping rule, and the groups are input into a first calculation model for calculation to obtain at least two average peak points; Inputting at least two average peak points into a second calculation model for calculation to obtain a standard average peak range; Determining whether the at least two average peak points are within a standard average peak range; If yes, then the average peak point is taken as the target peak point; If not, the resistance value data group will be re-divided into at least two groups according to the preset grouping rules in a loop, and the data will be input into the first calculation model for recalculation according to the groups, and then it will be determined whether it is within the calculated standard average peak range, until it is determined to be within the calculated standard average peak range.

5. The method according to claim 3 or 4, characterized in that: After determining whether the resistance value in the resistance value data group is valid, the method further includes: If invalid, the loop is executed to recalculate based on the device voltage data in the preprocessed test data and the last balanced current value obtained in the experiment, and then determine whether the resistance in the calculated resistance value data group is valid, until it is determined to be valid.

6. The method according to claim 1, characterized in that The method further comprises: using a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and drawing a visualized waveform according to the at least two target peak points. The preprocessed test data and the visualized carrier wave graph are stored in the corresponding test data table in the database.

7. The method according to claim 6, characterized in that After storing the preprocessed test data and the visualized carrier waveform in the corresponding test data table in the database, it also includes: Receiving data query requests sent by users at the terminal; According to the data query request, the corresponding pre-processed test data and / or the visualized carrier wave graph are called in the test data table.

8. A data processing and calculation integrated device for transformer on-load tap changer test, characterized in that: include: An acquisition module is used to acquire test data measured at the test end in the on-load tap changer experiment; A preprocessing module, used for performing data preprocessing operations on the test data; A calculation module, used to calculate according to the device voltage data in the preprocessed test data and the last obtained balance current value in the experiment to obtain a resistance value data group; The visualization module is used to use a preset intelligent visualization algorithm to determine at least two target peak points of the waveform to be drawn based on the resistance value data group, and draw a visualized carrier waveform according to the at least two target peak points.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, wherein the computer program is configured to execute the integrated method for data processing and calculation for the transformer on-load tap changer test according to any one of claims 1 to 4, 6, and 7 when running.

10. An electronic device comprising: A memory and a processor, characterized in that a computer program is stored in the memory, wherein the processor is configured to run the computer program to execute the integrated method for data processing and calculation of the transformer on-load tap changer test according to any one of claims 1 to 4, 6, and 7.

Images