Test data processing system
Through the automated processing and format conversion of the test data processing system, the problem of manual analysis and format conversion in the prior art is solved, and efficient and accurate processing of electrical performance parameters and report generation is achieved.
Patent Information
- Application Number
- CN202411986782.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-31
- Publication Date
- 2025-04-29
AI Technical Summary
When the prior art deals with the calculation of electrical performance parameters of different national standards, it requires manual analysis, calculation and comparison, which leads to time consumption and is prone to misjudgment. The file formats and data formats of the power analyzers of different brands of records are different, and the format conversion is required manually, which increases the workload.
Provided is a test data processing system, including an interaction module, a communication module, a storage module, a format conversion module and a data processing module. The system can establish a communication connection with the target power analyzer, obtain electrical performance parameter files, and convert the files into a unified format through the format conversion module. The data processing module generates test reports based on specified standards and data processing methods.
Through automated processing and format conversion, manual intervention is reduced, testing efficiency and accuracy are improved, and misjudgment caused by manual errors is avoided.
Smart Images
Figure CN119903300A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of circuit testing, and in particular to a test data processing system. Background Art
[0002] Power analyzers are increasingly used in testing electric vehicles, rail transit, photovoltaic wind power, motors and other fields. They can accurately measure electrical performance parameters such as voltage, current, power, harmonics, DC components and efficiency in circuits in real time.
[0003] For different national standards, the calculation methods of harmonic current, harmonic voltage, DC component, efficiency and other parameters may be slightly different, requiring manual analysis, calculation and value extraction of a large amount of data, and comparison and judgment with different standard requirements. In addition, different brands of power analyzers have different file formats and data formats for saving records, and manual data format conversion is required, which will consume a lot of time of testers and may also introduce misjudgment caused by human errors. Summary of the invention
[0004] The embodiment of the present application provides a test data processing system that can improve test efficiency and test accuracy.
[0005] In a first aspect, an embodiment of the present application provides a test data processing system, the test data processing system comprising an interaction module, a communication module, a storage module, a format conversion module and a data processing module;
[0006] The interactive module is used to provide an interactive interface for the user to select the brand of the target power analyzer, the path of the specified folder, the specified standard assessment value and the specified data processing method based on the interactive interface;
[0007] The communication module is used to establish a communication connection with the target power analyzer and obtain an initial electrical performance parameter file from the target power analyzer, wherein the initial electrical performance parameter file contains electrical performance parameters obtained when the target power analyzer measures the target circuit;
[0008] The storage module is used to store the acquired initial electrical performance parameter file in a designated folder;
[0009] The format conversion module is used to convert the initial electrical performance parameter file in the designated folder into a target electrical performance parameter file in a target format;
[0010] The data processing module is used to generate a test report of the target circuit according to the electrical performance parameters in the target electrical performance parameter file, the specified standard assessment value and the specified data processing method.
[0011] In some embodiments, the target electrical performance parameter file includes electrical performance parameters of multiple different test items, the specified data processing method includes test data processing methods corresponding to multiple specified test items among the multiple different test items, the test data processing method includes a maximum value calculation processing method, an average value calculation processing method, a minimum value calculation processing method or a root mean square calculation processing method, and the specified standard assessment value includes the standard assessment value corresponding to each of the specified test items.
[0012] In some embodiments, the data processing module includes a data reading unit, a calculation unit, a comparison unit, and a report generation unit;
[0013] The data reading unit is used to read the effective electrical performance parameters corresponding to each of the designated test items from the target electrical performance parameter file according to the effective data starting keyword corresponding to the target power analyzer;
[0014] The calculation unit is used to determine the actual test value corresponding to each of the designated test items according to the corresponding test data processing method and the corresponding effective electrical performance parameter;
[0015] The comparison unit is used to compare the corresponding actual test value with the corresponding standard assessment value to obtain the comparison results corresponding to each of the designated test items;
[0016] The report generating unit is used to write each of the actual test values and each of the comparison results into a test report template to obtain the test report.
[0017] In some embodiments, the communication module establishes a communication connection with the target power analyzer via a network cable or a USB.
[0018] In some embodiments, the test data processing system further includes a batch processing module.
[0019] In some embodiments, the test data processing system further includes an analyzer setup module;
[0020] The analyzer setting module is used to set the current working parameters of the target power analyzer, and the current working parameters include file name, file path, recording duration and sampling interval.
[0021] In some embodiments, the test data processing system further includes a deletion module;
[0022] The deleting module is used to delete the initial electrical performance parameter file after the format conversion module converts the initial electrical performance parameter file into the target electrical performance parameter file.
[0023] In some embodiments, the test data processing system further includes an analyzer data storage module;
[0024] The analyzer data storage module is used to store data of power analyzers of different brands;
[0025] Among them, power analyzers of different brands correspond to different valid data starting keywords.
[0026] In some embodiments, the test data processing system further includes a data processing mode storage module;
[0027] The data processing mode storage module is used to store at least one test data processing mode corresponding to each test item in a plurality of test items.
[0028] In some embodiments, the test data processing system further includes a standard assessment value storage module;
[0029] The standard assessment value storage module is used to store standard assessment values under multiple different test standards.
[0030] The embodiment of the present application provides a test data processing system. The test data processing system includes an interactive module, a communication module, a storage module, a format conversion module and a data processing module; the interactive module is used to provide an interactive interface for the user to select the brand of the target power analyzer, the path of the specified folder, the specified standard assessment value and the specified data processing method based on the interactive interface; the communication module is used to establish a communication connection with the target power analyzer and obtain an initial electrical performance parameter file from the target power analyzer, wherein the initial electrical performance parameter file contains the electrical performance parameters obtained when the target power analyzer measures the target circuit; the storage module is used to store the obtained initial electrical performance parameter file in a specified folder; the format conversion module is used to convert the initial electrical performance parameter file in the specified folder into a target electrical performance parameter file in a target format; the data processing module is used to generate a test report of the target circuit according to the electrical performance parameters in the target electrical performance parameter file, the specified standard assessment value and the specified data processing method. The embodiment of the present application can convert files of different formats into files of target format through a format conversion module without manual format conversion, and can automatically generate a test report of the target circuit through a data processing module without manual data analysis and calculation. It can be seen that the test data processing system provided by the present application can improve test efficiency and test accuracy. BRIEF DESCRIPTION OF THE DRAWINGS
[0031] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.
[0032] Figure 1 A schematic diagram of an application scenario of a test data processing system provided in an embodiment of the present application;
[0033] Figure 2 A schematic diagram of the structure of a test data processing system provided in an embodiment of the present application;
[0034] Figure 3 A structural diagram of a data processing module provided in an embodiment of the present application;
[0035] Figure 4 Another structural schematic diagram of the test data processing system provided in an embodiment of the present application. DETAILED DESCRIPTION
[0036] In order to make the technical problems, technical solutions and beneficial effects to be solved by the present application clearer and more understandable, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0037] See also Figure 1 , Figure 1 A schematic diagram of an application scenario of the test data processing system provided in the present application, wherein the test data processing system is connected to a target power analyzer to issue commands to the target power analyzer to set current operating parameters of the target power analyzer, wherein the current operating parameters include file name, file path, recording duration, and sampling interval, wherein the test data processing system can specifically issue commands to the target power analyzer through a network protocol (transmission Control Protocol / Internet Protocol, TCP / IP) communication method.
[0038] Among them, the target power analyzer is the power analyzer currently connected to the test data processing system. The test data processing system provided by this application can analyze and calculate the electrical performance parameters collected by power analyzers of multiple different brands.
[0039] See also Figure 2 , Figure 2A structural diagram of a test data processing system provided in an embodiment of the present application, wherein the test data processing system includes an interaction module 10, a communication module 20, a storage module 30, a format conversion module 40 and a data processing module 50;
[0040] The interactive module 10 is used to provide an interactive interface for the user to select the brand of the target power analyzer, the path of the specified folder, the specified standard assessment value and the specified data processing method based on the interactive interface;
[0041] The communication module 20 is used to establish a communication connection with a target power analyzer and obtain an initial electrical performance parameter file from the target power analyzer, wherein the initial electrical performance parameter file contains electrical performance parameters obtained when the target power analyzer measures the target circuit;
[0042] The storage module 30 is used to store the acquired initial electrical performance parameter file in a designated folder;
[0043] The format conversion module 40 is used to convert the initial electrical performance parameter file in the specified folder into a target electrical performance parameter file in a target format; wherein the target format may be a CSV format, and the format of the initial electrical performance parameter file may be a CSV format, a TDM format or a PAD format. In this embodiment, only the initial electrical performance parameter file in a non-CSV format needs to be format converted, which facilitates subsequent unified analysis and avoids the problem of inconsistent data formats saved by power analyzers of different brands.
[0044] The data processing module 50 is used to generate a test report of the target circuit according to the electrical performance parameters in the target electrical performance parameter file, the specified standard assessment value and the specified data processing method.
[0045] Among them, the target electrical performance parameter file contains electrical performance parameters of multiple different test items, the specified data processing method includes test data processing methods corresponding to multiple specified test items in the multiple different test items, the test data processing method includes a maximum value calculation processing method, an average value calculation processing method, a minimum value calculation processing method or a root mean square calculation processing method, and the specified standard assessment value includes the standard assessment value corresponding to each of the specified test items.
[0046] Multiple different test items include voltage, current, power, harmonics, DC component and efficiency.
[0047] Specifically, the electrical performance parameters obtained from the target power analyzer include electrical performance parameters of multiple different test items, the designated test item is the test item specified by the current user to be analyzed, and the designated data processing mode is the data processing mode set by the user for different designated test items, including the maximum value, average value, minimum value or root mean square value of the test item. For example, the designated data processing mode set for designated test item 1 is to calculate the maximum value of the test item, and the designated data processing mode set for designated test item 2 is to calculate the average value of the test item. After the calculation, the number of decimal points is fixed after the n-digit point to prevent the data from being too long.
[0048] For further information, see Figure 3 The data processing module 50 provided in this embodiment includes a data reading unit 51, a calculation unit 52, a comparison unit 53 and a report generation unit 54, wherein:
[0049] The data reading unit 51 is used to read the effective electrical performance parameters corresponding to each of the designated test items from the target electrical performance parameter file according to the effective data starting keyword corresponding to the target power analyzer;
[0050] The data reading unit 51 can be implemented using the pandas module of python.
[0051] The calculation unit 52 is used to determine the actual test value corresponding to each of the designated test items according to the corresponding test data processing method and the corresponding effective electrical performance parameter;
[0052] The calculation unit 52 may be implemented by using the numpy module, math module and round module of Python.
[0053] The comparison unit 53 is used to compare the corresponding actual test value with the corresponding standard assessment value to obtain the comparison results corresponding to each of the designated test items;
[0054] Specifically, if there are multiple designated test items, for each designated test item, after obtaining the actual test value of the designated test item through the calculation unit 52, the actual test value is compared with the designated standard assessment value. If the actual test value is within the designated standard assessment value, the test conclusion is that the test passed, otherwise the test failed.
[0055] The report generating unit 54 is used to write each of the actual test values and each of the comparison results into a test report template to obtain the test report.
[0056] Among them, the report generation unit 54 can be implemented using Python's DataFrame module, and the corresponding test values, assessment values, test conclusions and other data can be automatically written into the test report according to different specified test items. The test report storage path can be consistent with the data file or specified by the user.
[0057] Furthermore, the communication module 20 establishes a communication connection with the target power analyzer via a network cable or a USB.
[0058] See also Figure 4 Furthermore, the test data processing system also includes a batch processing module 60, through which the batch processing module 60 can synchronously process the electrical performance parameters of the target circuit under multiple different test powers to improve data analysis efficiency.
[0059] The test data processing system further includes a deletion module 70;
[0060] The deleting module 70 is used to delete the initial electrical performance parameter file after the format conversion module 40 converts the initial electrical performance parameter file into the target electrical performance parameter file to save storage space.
[0061] The test data processing system also includes an analyzer data storage module 80;
[0062] The analyzer data storage module 80 is used to store data of power analyzers of different brands; the interactive interface in the interactive module 10 can display data of power analyzers of different brands, so that the user can select the brand of the target power analyzer through the displayed data of the multiple power analyzers;
[0063] Among them, power analyzers of different brands correspond to different valid data starting keywords.
[0064] The test data processing system further includes a data processing mode storage module 90;
[0065] The data processing method storage module 90 is used to store at least one test data processing method corresponding to each test item in multiple test items. The interactive interface in the interactive module 10 can display the multiple test data processing methods stored in the data processing method storage module 90, so that the user can set a specified data processing method for different specified test items through the displayed multiple test data processing methods.
[0066] Among them, the first few lines of data saved by the power analyzer are generally recorded instrument settings and other setting data, not actual test data, but the recorded content is fixed. Therefore, when reading the data file, the data reading unit 51 first searches for the valid data starting keyword corresponding to the target power analyzer brand from the analyzer data storage module 80, and then reads the valid electrical performance parameters from the target electrical performance parameter file according to the corresponding valid data starting keyword. Specifically, all data in the file are searched, and the number of rows where the data successfully matches the valid data starting keyword is the number of rows of the starting row of the valid electrical performance parameters.
[0067] The target electrical performance parameter file includes setting data and effective electrical performance parameters. All effective electrical performance parameters form a large dictionary, in which the header is each key of the dictionary (type of test item), and the corresponding key value is the effective electrical performance parameter.
[0068] The test data processing system further includes a standard assessment value storage module 100;
[0069] The standard assessment value storage module 100 is used to store standard assessment values under multiple different test standards.
[0070] The standard assessment value storage module 100 stores standard assessment values under various different test standards, and can also continuously add or adjust test standards according to user needs. The test standards include "NB / T32004-2018", "GB / T 34120-2023", "INMETRO ORDINANCE 140_2022" and "EN 50549-10-2022" and other test standards.
[0071] Through the standard assessment value storage module 100, according to the user's selection, the interactive interface in the interactive module 10 can display multiple test standards stored in the standard assessment value storage module 100, so that the user can specify the corresponding test standards for each designated test item through the displayed multiple test standards, and the standard assessment value associated with the corresponding designated test item under the test standard is the designated standard assessment value corresponding to the designated test item. For example, the designated standard assessment value set for the designated test item of the DC component is the designated standard assessment value under the test standard NB / T32004-2018, wherein the standard assessment value may include a standard assessment range, such as not more than 0.5%In.
[0072] Furthermore, the test data processing system also includes a running log display module, which can be implemented using the logger module of Python and is used to print the current running log to facilitate error location and processing.
[0073] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present application, and these modifications or replacements should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.
Claims
1. A test data processing system, characterized in that: The test data processing system includes an interaction module, a communication module, a storage module, a format conversion module and a data processing module; The interactive module is used to provide an interactive interface for the user to select the brand of the target power analyzer, the path of the specified folder, the specified standard assessment value and the specified data processing method based on the interactive interface; The communication module is used to establish a communication connection with the target power analyzer and obtain an initial electrical performance parameter file from the target power analyzer, wherein the initial electrical performance parameter file contains electrical performance parameters obtained when the target power analyzer measures the target circuit; The storage module is used to store the acquired initial electrical performance parameter file in the designated folder; The format conversion module is used to convert the initial electrical performance parameter file in the designated folder into a target electrical performance parameter file in a target format; The data processing module is used to generate a test report of the target circuit according to the electrical performance parameters in the target electrical performance parameter file, the specified standard assessment value and the specified data processing method.
2. The test data processing system according to claim 1, characterized in that: The target electrical performance parameter file includes electrical performance parameters of multiple different test items, the specified data processing method includes test data processing methods corresponding to multiple specified test items among the multiple different test items, the test data processing method includes a maximum value calculation processing method, an average value calculation processing method, a minimum value calculation processing method or a root mean square calculation processing method, and the specified standard assessment value includes the standard assessment value corresponding to each of the specified test items.
3. The test data processing system according to claim 2, characterized in that: The data processing module includes a data reading unit, a calculation unit, a comparison unit and a report generation unit; The data reading unit is used to read the effective electrical performance parameters corresponding to each of the designated test items from the target electrical performance parameter file according to the effective data starting keyword corresponding to the target power analyzer; The calculation unit is used to determine the actual test value corresponding to each of the designated test items according to the corresponding test data processing method and the corresponding effective electrical performance parameter; The comparison unit is used to compare the corresponding actual test value with the corresponding standard assessment value to obtain the comparison results corresponding to each of the designated test items; The report generating unit is used to write each of the actual test values and each of the comparison results into a test report template to obtain the test report.
4. The test data processing system according to claim 1, characterized in that: The communication module establishes a communication connection with the target power analyzer via a network cable or a USB.
5. The test data processing system according to claim 1, characterized in that: The test data processing system also includes a batch processing module.
6. The test data processing system according to claim 1, characterized in that: The test data processing system also includes an analyzer setting module; The analyzer setting module is used to set the current working parameters of the target power analyzer, and the current working parameters include file name, file path, recording duration and sampling interval.
7. The test data processing system according to claim 1, characterized in that: The test data processing system also includes a deletion module; The deleting module is used to delete the initial electrical performance parameter file after the format conversion module converts the initial electrical performance parameter file into the target electrical performance parameter file.
8. The test data processing system according to claim 1, characterized in that: The test data processing system also includes an analyzer data storage module; The analyzer data storage module is used to store data of power analyzers of different brands; Among them, power analyzers of different brands correspond to different valid data starting keywords.
9. The test data processing system according to claim 1, characterized in that: The test data processing system also includes a data processing mode storage module; The data processing mode storage module is used to store at least one test data processing mode corresponding to each test item in a plurality of test items.
10. The test data processing system according to claim 1, characterized in that: The test data processing system also includes a standard assessment value storage module; The standard assessment value storage module is used to store standard assessment values under multiple different test standards.