CN112162953A - Current data processing method and device, current data processing equipment and storage medium - Google Patents
Current data processing method and device, current data processing equipment and storage medium Download PDFInfo
- Publication number
- CN112162953A CN112162953A CN202010673834.4A CN202010673834A CN112162953A CN 112162953 A CN112162953 A CN 112162953A CN 202010673834 A CN202010673834 A CN 202010673834A CN 112162953 A CN112162953 A CN 112162953A
- Authority
- CN
- China
- Prior art keywords
- current data
- test strip
- folder
- target
- writing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
Abstract
The application discloses a current data processing method, a device, equipment and a medium, wherein the method comprises the following steps: acquiring a folder to be processed containing original current data obtained by testing a test strip product; automatically creating a worksheet for storing target current data according to the test strip batches; automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and writing current data into a corresponding working table according to test strip batches; and according to the target current data in the working table, generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script so as to analyze the test strip performance. According to the method and the device, a new worksheet can be automatically created after the folder to be processed is obtained, the first data reading and writing script and the curve generating script are sequentially used for automatically extracting data and drawing in a gathering mode, manual copying, pasting and drawing are not needed, labor cost is saved, and the accuracy of data processing is improved while the working efficiency is improved.
Description
Technical Field
The present disclosure relates to the field of data automation processing technologies, and more particularly, to a current data processing method, a current data processing system, a current data processing device, and a computer-readable storage medium.
Background
In the pre-research stage of developing test strip products on an electrochemical platform, a chronoamperometry method of an electrochemical workstation is generally used for largely testing the change curve of an original current signal along with time, and then basic performance of the test strip products is evaluated through data collection and analysis. However, in the conventional technology, only after an experiment is finished, data required for pasting can be manually copied from a CSV file, and then drawing is manually performed, so that the operation is repeated and the steps are complicated, which results in a large workload, waste of certain manpower and time costs, and corresponding manual errors.
Therefore, how to solve the above problems is a great concern for those skilled in the art.
Disclosure of Invention
The application aims to provide a current data processing method and device, a current data processing device and a computer readable storage medium, so that the labor and time cost is saved, and the manual error is avoided.
In order to achieve the above object, the present application provides a current data processing method, including:
acquiring a folder to be processed containing original current data obtained by testing a test strip product;
automatically creating a corresponding worksheet for storing target current data according to the test strip batches to be tested;
automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and writing the current data in the file into the corresponding working table according to the test strip batch;
and generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves.
Optionally, the automatically reading the CSV format file in the folder to be processed by using the first data read-write script, and writing the current data in the file into the corresponding working table according to the test strip batch includes:
judging whether a target folder exists or not;
if the target folder exists, automatically creating a target subfolder with the same name in the target folder according to the subfolders in the folder to be processed;
automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and creating an xlsx format file with the same name as the CSV format file in the target subfolder;
importing the original current data read from the CSV format file into the corresponding xlsx format file for storage;
traversing and reading all the xlsx-format files by utilizing a second data reading-writing script, and writing current data in the xlsx-format files into the corresponding working table according to the test strip batches;
and if the target folder does not exist, entering the step of automatically creating the target subfolders with the same name in the target folder according to the subfolders in the folder to be processed after the target folder is newly created.
Optionally, the step of performing traversal reading on all the xlsx-format files by using a second data read-write script, and writing current data in the xlsx-format files into corresponding worksheets according to the test strip batches includes:
traversing and reading all the xlsx-format files by using a second data reading-writing script, and determining a sample zero point according to whether order change exists or not;
and extracting a preset amount of current data from each xlsx format file based on the sample zero point, and writing the current data into the corresponding working table.
Optionally, after writing the current data in the test strip batches into the corresponding working tables, the method further comprises:
and calculating the average value, the standard deviation and the variation coefficient for the normal temperature data and the aging data of each concentration of each test strip batch respectively by using a numerical calculation script according to the target current data, and storing the average value, the standard deviation and the variation coefficient into a preset cell of a corresponding working table.
Optionally, the method further includes:
receiving a selection instruction aiming at a target time point issued by a user;
and extracting target current data corresponding to the target time points from each working table according to the selection instruction so as to analyze the performance of the test strip according to the current data of the target time points.
Optionally, the generating a reaction curve corresponding to different sets of times and concentrations in each test strip batch by using the curve generation script includes:
based on preset visual elements, generating reaction curves corresponding to different display types for different groups and concentrations of each test strip batch through a curve generation script; the preset visual elements comprise line types and/or line colors;
and (4) leading the reaction curves of different groups and concentrations of each test strip batch into a working table for storing the reaction curves for summarizing.
To achieve the above object, the present application provides a current data processing apparatus including:
the file acquisition module is used for acquiring a folder to be processed containing original current data obtained by testing a test strip product;
the table creating module is used for automatically creating a corresponding working table for storing target current data according to the test strip batch to be tested;
the data writing module is used for automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script and writing the current data in the file into the corresponding working table according to the test strip batch;
and the curve generation module is used for generating reaction curves corresponding to different groups of times and concentrations of each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves.
Optionally, the method further includes:
the instruction receiving module is used for receiving a selection instruction which is issued by a user and aims at a target time point;
and the data extraction module is used for extracting target current data corresponding to the target time points from each worksheet according to the selection instruction so as to analyze the current data according to the current time points.
To achieve the above object, the present application provides a current data processing apparatus including:
a memory for storing a computer program;
a processor for implementing the steps of any of the aforementioned disclosed current data processing methods when executing the computer program.
To achieve the above object, the present application provides a computer-readable storage medium having a computer program stored thereon, which when executed by a processor, implements the steps of any one of the aforementioned disclosed current data processing methods.
According to the scheme, the current data processing method provided by the application comprises the following steps: acquiring a folder to be processed containing original current data obtained by testing a test strip product; automatically creating a corresponding worksheet for storing target current data according to the test strip batches to be tested; automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and writing the current data in the file into the corresponding working table according to the test strip batch; and generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves. According to the method and the device, a new worksheet can be automatically created after the to-be-processed folder containing original test current data is obtained, the first data read-write script and the curve generation script are sequentially utilized to automatically extract data and draw a summary drawing, manual copying, pasting and drawing are not needed, labor cost is saved, working time is remarkably shortened, manual errors are avoided, and the accuracy of data processing is improved while the working efficiency is improved.
The application also discloses a current data processing device, a current data processing device and a computer readable storage medium, which can also achieve the technical effects.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a current data processing method disclosed in an embodiment of the present application;
FIG. 2 is a flow chart of another current data processing method disclosed in the embodiments of the present application;
fig. 3 is a block diagram of a current data processing apparatus according to an embodiment of the present disclosure;
FIG. 4 is a block diagram of an electrical current data processing apparatus disclosed in an embodiment of the present application;
fig. 5 is a block diagram of another current data processing apparatus disclosed in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In the conventional technology, the required data can only be manually copied and pasted from the CSV file after the experiment is finished, and then the drawing is manually gathered, so that the operation is repeated and the steps are complicated, the workload is large, certain manpower and time cost are wasted, and corresponding manual errors can also exist.
Therefore, the embodiment of the application discloses a current data processing method, which saves labor and time cost and avoids manual errors.
Referring to fig. 1, a current data processing method disclosed in an embodiment of the present application includes:
s101: acquiring a folder to be processed containing original current data obtained by testing a test strip product;
in the embodiment of the application, a folder to be processed can be obtained, and the folder stores original current data obtained by testing test strip products. When the folder to be processed is obtained, the folder can be searched in the system specifically through a preset folder name or a preset file path.
It should be noted that, in the original folder to be processed, the original folder may be divided into corresponding subfolders according to the test concentration, each subfolder stores experimental test data of all sets of normal temperature test strips and aging test strips, and each experimental test data is stored by using two formats, namely CSV format and bin format. And respectively testing n normal-temperature test strips and n aging test strips in each group. In particular implementations, the number of test runs n per experiment is not fixed, thus requiring the user to enter the number of tests per group before data processing in order for the program to perform an automated data processing procedure based on that number. To avoid erroneous input, it can be determined whether the numerical value input by the user is a positive integer greater than zero.
S102: automatically creating a corresponding worksheet for storing target current data according to the test strip batches to be tested;
in this step, a corresponding worksheet for each lot for storing processed current data may be automatically created according to the test strip lot of the tested test strip product. Specifically, the worksheet may be a sheet of an Excel workbook window, and may be named according to test strip batches.
As a possible implementation, the format of the above worksheet may be specifically divided into three groups, i.e., small group, group and large group. The total amount of data in each group is the test count, and if the average value, the standard deviation and the coefficient of variation need to be calculated according to the test data, the amount of data in the group is the test count plus three. Since each small group of data has both working current and background current, the total amount of data in each group is the small group of data multiplied by two. Preferably, a column can be added to each group to distinguish it from other data. Since each strip was of both ambient and aged type, the total amount of data in each large group was the number of groups multiplied by two. In a specific working table, the working current of the batch at the first concentration of the normal temperature test strip, the background current of the batch at the first concentration of the normal temperature test strip, the working current of the batch at the first concentration of the aging test strip, and the background current of the batch at the first concentration of the aging test strip can be stored in sequence from left to right, and the second concentration, the third concentration, and the like can be stored in sequence in this way. In addition, the time corresponding to the booklet number data may be written in the first column of each sheet table.
S103: automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and writing the current data in the file into the corresponding working table according to the test strip batch;
in the embodiment of the application, the first data read-write script can be used for automatically reading the CSV format file in the folder to be processed. In a specific implementation, the bin format file in the folder to be processed may be deleted first, so as to facilitate reading of the CSV format file. The first data read-write script is specifically pre-written and can analyze the CSV format file to identify the original current data therein and import the original current data into the script corresponding to the worksheet. The test strip reading device can be used for reading normal-temperature test strip data and aging test strip data of different batches, groups and concentrations in a CSV format file, and writing current data into fixed positions in a working table of the corresponding test strip batch according to the batches, the groups, the concentrations and the test strip types.
In a preferred embodiment, after the current data is written into the corresponding working table, the average value, the standard deviation and the variation coefficient of the normal temperature data and the aging data of each concentration in each test strip batch are respectively calculated according to the target current data by using the numerical calculation script, and are stored into the preset cells of the corresponding working table. The numerical calculation script is written in advance and can calculate scripts corresponding to the average value, the standard deviation and the variation coefficient based on data to be processed.
S104: and generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves.
It is understood that the step can generate reaction curves corresponding to different groups and concentrations of each test strip batch by using the curve generation script according to the target current data extracted into the working table. The user can analyze the performance of the test strip product by the smoothness of the reaction curve, the presence of severe jitter, and the like.
It should be noted that, when reaction curves corresponding to different sets of times and concentrations of each test strip batch are generated, reaction curves corresponding to different display types can be generated for the test strip batches based on preset visual elements. The preset visual elements may include, but are not limited to, line types and/or line colors. The reaction curves of different batch groups and concentrations can be displayed by adopting solid lines, dotted lines and the like with different colors. And then can all lead into the worksheet that is used for depositing the reaction curve with the reaction curve of different ranks and concentration under each examination strip batch and gather, through different visual element, the user can be better carry out the contrast of examination strip test data.
As a preferred implementation manner, the embodiment of the present application may further receive a selection instruction for a target time point issued by a user. Specifically, the target time point may be a time point at which the data change selected by the user according to the smoothness of the response curve is relatively stable. After receiving the selection instruction, the target current data corresponding to the target time point can be additionally extracted from each worksheet according to the instruction, so that the test strip performance analysis can be performed according to the current data of the target time point.
In addition, the embodiment of the application can also summarize the reaction curves of the normal-temperature test strip and the aging test strip under the same batch group and concentration, and the aging degree of the aging test strip can be determined by comparing the difference between the reaction curves of the two types of test strips.
Specifically, the working table for storing the time point data and the working table for summarizing the current curve may be pre-established in the embodiment of the present application, and then the extracted current data of the target time point and the summarized reaction curve may be respectively stored in the corresponding working tables.
According to the scheme, the current data processing method provided by the application comprises the following steps: acquiring a folder to be processed containing original current data obtained by testing a test strip product; automatically creating a corresponding worksheet for storing target current data according to the test strip batches to be tested; automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and writing the current data in the file into the corresponding working table according to the test strip batch; and generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves. According to the method and the device, a new worksheet can be automatically created after the to-be-processed folder containing original test current data is obtained, the first data read-write script and the curve generation script are sequentially utilized to automatically extract data and draw a summary drawing, manual copying, pasting and drawing are not needed, labor cost is saved, working time is remarkably shortened, manual errors are avoided, and the accuracy of data processing is improved while the working efficiency is improved.
The embodiment of the application discloses another current data processing method, and compared with the previous embodiment, the embodiment further explains and optimizes the technical scheme. Referring to fig. 2, specifically:
s201: acquiring a folder to be processed containing original current data obtained by testing a test strip product;
s202: automatically creating a corresponding worksheet for storing target current data according to the test strip batches to be tested;
s203: judging whether a target folder exists or not; if yes, go to step S205; if not, go to step S204;
in the embodiment of the application, after the folder to be processed is obtained, whether a target folder for storing the processed current data exists in the system can be judged. Specifically, the search may be performed by searching for a file name.
S204: newly creating a target folder, and entering step S205 after the creation is completed;
it can be understood that, if it is determined that the target folder does not exist in the system, the target folder may be created, and a subsequent data processing process may be performed after the creation.
S205: automatically creating target subfolders with the same name in the target folder according to the subfolders in the folder to be processed;
s206: automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and creating an xlsx format file with the same name as the CSV format file in the target subfolder;
s207: importing the original current data read from the CSV format file into the corresponding xlsx format file for storage;
as a feasible implementation manner, the embodiment of the present application may create a corresponding target subfolder in the target folder according to the subfolder in the to-be-processed folder, and specifically may be the same as the file name of the subfolder in the to-be-processed folder. After the creation, the first data read-write script can be used for reading the CSV format file in the folder to be processed, creating an xlsx format file with the same name as the corresponding CSV format file in the target subfolder, and further importing the original current data read from the CSV format file into the corresponding xlsx format file.
S208: traversing and reading all the xlsx-format files by utilizing a second data reading-writing script, and writing current data in the xlsx-format files into the corresponding working table according to the test strip batches;
after the original current data is imported into the xlsx format file, the step can use the second data read-write script to traverse and read all the format files, and write the current data in the files into the corresponding worksheets according to the test strip batch.
By the method, the current data stored in the CSV format file in the folder to be processed can be extracted into the xlsx format file, and the preliminary arrangement of the data is realized. And then can directly go on traversing reading to the xlsx form file after putting up, can be more convenient data acquisition and summarize.
It should be noted that, since there is a discrepancy between the time point when the instrument is clicked and the actual time when the blood sample is taken, the time point when the blood sample is taken, i.e., the sample zero point, needs to be determined. Specifically, the sample zero point can be determined by whether order change exists or not when the second data read-write script is used for traversing and reading all format files. That is, the time point at which the first two data values increase in magnitude can be determined and determined as the sample zero point. And then extracting a preset amount of current data from each xlsx format file based on the sample zero point, and writing the current data into a corresponding working table. The preset number may be set according to actual conditions in a specific implementation, for example, may be set to 100, that is, the first 100 current data from the sample zero point in each xlsx format file may be extracted into the corresponding working table.
S209: and generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves.
In the following, a current data processing apparatus provided by an embodiment of the present application is described, and a current data processing apparatus described below and a current data processing method described above may be referred to each other.
Referring to fig. 3, an electric current data processing apparatus provided in an embodiment of the present application includes:
the file acquisition module 301 is configured to acquire a folder to be processed containing original current data obtained by testing a test strip product;
a table creating module 302, configured to automatically create a corresponding worksheet for storing target current data according to the test strip batch to be tested;
a data writing module 303, configured to automatically read the CSV format file in the folder to be processed by using a first data reading and writing script, and write the current data in the file into the corresponding working table according to the test strip batch;
and a curve generating module 304, configured to generate, according to the target current data in the worksheet, a reaction curve corresponding to different sets of times and concentrations in each test strip batch through a curve generating script, so as to perform test strip performance analysis according to the reaction curve.
For the specific implementation process of the modules 301 to 304, reference may be made to the corresponding content disclosed in the foregoing embodiments, and details are not repeated here.
On the basis of the foregoing embodiment, as a preferred implementation, the current data processing apparatus provided in the embodiment of the present application may further include:
the instruction receiving module is used for receiving a selection instruction which is issued by a user and aims at a target time point;
and the data extraction module is used for extracting target current data corresponding to the target time points from each worksheet according to the selection instruction so as to analyze the current data according to the current time points.
The present application further provides a current data processing device, and as shown in fig. 4, an embodiment of the present application provides a current data processing device including:
a memory 100 for storing a computer program;
the processor 200, when executing the computer program, may implement the steps provided by the above embodiments.
Specifically, the memory 100 includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer-readable instructions, and the internal memory provides an environment for the operating system and the computer-readable instructions in the non-volatile storage medium to run. The processor 200 may be a Central Processing Unit (CPU), a controller, a microcontroller, a microprocessor or other data Processing chip in some embodiments, and provides a computing and controlling capability for the current data Processing apparatus, and when executing the computer program stored in the memory 100, the steps of the current data Processing method disclosed in any of the foregoing embodiments may be implemented.
On the basis of the above-described embodiment, as a preferred implementation, referring to fig. 5, the current data processing apparatus further includes:
and an input interface 300 connected to the processor 200, for acquiring computer programs, parameters and instructions imported from the outside, and storing the computer programs, parameters and instructions into the memory 100 under the control of the processor 200. The input interface 300 may be connected to an input device for receiving parameters or instructions manually input by a user. The input device may be a touch layer covered on a display screen, or a button, a track ball or a touch pad arranged on a terminal shell, or a keyboard, a touch pad or a mouse, etc.
And a display unit 400 connected to the processor 200 for displaying data processed by the processor 200 and for displaying a visualized user interface. The display unit 400 may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch panel, or the like.
And a network port 500 connected to the processor 200 for performing communication connection with each external terminal device. The communication technology adopted by the communication connection can be a wired communication technology or a wireless communication technology, such as a mobile high definition link (MHL) technology, a Universal Serial Bus (USB), a High Definition Multimedia Interface (HDMI), a wireless fidelity (WiFi), a bluetooth communication technology, a low power consumption bluetooth communication technology, an ieee802.11 s-based communication technology, and the like.
Fig. 5 shows only the current data processing apparatus with the assembly 100 and 500, and it will be understood by those skilled in the art that the structure shown in fig. 5 does not constitute a limitation of the current data processing apparatus, and may include fewer or more components than those shown, or some components in combination, or a different arrangement of components.
The present application also provides a computer-readable storage medium, which may include: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk. The storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of the current data processing method disclosed in any of the foregoing embodiments.
The method and the device can automatically create a new worksheet after the to-be-processed folder containing original test current data is obtained, and automatically extract and collect the data by utilizing the first data read-write script and the curve generation script in sequence, do not need manual copying, pasting and drawing, save labor cost, remarkably shorten working time, avoid manual errors, and improve the accuracy of data processing while improving working efficiency.
The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. For the system disclosed by the embodiment, the description is relatively simple because the system corresponds to the method disclosed by the embodiment, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, it is possible to make several improvements and modifications to the present application without departing from the principle of the present application, and such improvements and modifications also fall within the scope of the claims of the present application.
It is further noted that, in the present specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Claims (10)
1. A current data processing method, comprising:
acquiring a folder to be processed containing original current data obtained by testing a test strip product;
automatically creating a corresponding worksheet for storing target current data according to the test strip batches to be tested;
automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and writing the current data in the file into the corresponding working table according to the test strip batch;
and generating reaction curves corresponding to different groups of times and concentrations in each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves.
2. The current data processing method according to claim 1, wherein the automatically reading the CSV format file in the folder to be processed by using the first data read-write script and writing the current data in the file into the corresponding worksheet according to the test strip batch comprises:
judging whether a target folder exists or not;
if the target folder exists, automatically creating a target subfolder with the same name in the target folder according to the subfolders in the folder to be processed;
automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script, and creating an xlsx format file with the same name as the CSV format file in the target subfolder;
importing the original current data read from the CSV format file into the corresponding xlsx format file for storage;
traversing and reading all the xlsx-format files by utilizing a second data reading-writing script, and writing current data in the xlsx-format files into the corresponding working table according to the test strip batches;
and if the target folder does not exist, entering the step of automatically creating the target subfolders with the same name in the target folder according to the subfolders in the folder to be processed after the target folder is newly created.
3. The current data processing method according to claim 1, wherein the step of performing traversal reading on all the xlsx-format files by using a second data read-write script and writing the current data in the xlsx-format files into the corresponding worksheets according to the test strip batches comprises:
traversing and reading all the xlsx-format files by using a second data reading-writing script, and determining a sample zero point according to whether order change exists or not;
and extracting a preset amount of current data from each xlsx format file based on the sample zero point, and writing the current data into the corresponding working table.
4. The current data processing method according to claim 1, further comprising, after writing the current data therein into the corresponding working table according to the test strip lot:
and calculating the average value, the standard deviation and the variation coefficient for the normal temperature data and the aging data of each concentration of each test strip batch respectively by using a numerical calculation script according to the target current data, and storing the average value, the standard deviation and the variation coefficient into a preset cell of a corresponding working table.
5. The current data processing method according to any one of claims 1 to 4, further comprising:
receiving a selection instruction aiming at a target time point issued by a user;
and extracting target current data corresponding to the target time points from each working table according to the selection instruction so as to analyze the performance of the test strip according to the current data of the target time points.
6. The method for processing current data according to claim 5, wherein the generating reaction curves corresponding to different sets of times and concentrations for each test strip batch by the curve generation script comprises:
based on preset visual elements, generating reaction curves corresponding to different display types for different groups and concentrations of each test strip batch through a curve generation script; the preset visual elements comprise line types and/or line colors;
and (4) leading the reaction curves of different groups and concentrations of each test strip batch into a working table for storing the reaction curves for summarizing.
7. An electric current data processing apparatus, characterized by comprising:
the file acquisition module is used for acquiring a folder to be processed containing original current data obtained by testing a test strip product;
the table creating module is used for automatically creating a corresponding working table for storing target current data according to the test strip batch to be tested;
the data writing module is used for automatically reading the CSV format file in the folder to be processed by utilizing a first data reading and writing script and writing the current data in the file into the corresponding working table according to the test strip batch;
and the curve generation module is used for generating reaction curves corresponding to different groups of times and concentrations of each test strip batch through a curve generation script according to the target current data in the working table so as to analyze the test strip performance according to the reaction curves.
8. The current data processing device of claim 7, further comprising:
the instruction receiving module is used for receiving a selection instruction which is issued by a user and aims at a target time point;
and the data extraction module is used for extracting target current data corresponding to the target time points from each worksheet according to the selection instruction so as to analyze the current data according to the current time points.
9. An electric current data processing apparatus, characterized by comprising:
a memory for storing a computer program;
a processor for implementing the steps of the current data processing method according to any one of claims 1 to 6 when executing the computer program.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the current data processing method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010673834.4A CN112162953B (en) | 2020-07-14 | 2020-07-14 | Current data processing method and device, current data processing equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010673834.4A CN112162953B (en) | 2020-07-14 | 2020-07-14 | Current data processing method and device, current data processing equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112162953A true CN112162953A (en) | 2021-01-01 |
| CN112162953B CN112162953B (en) | 2022-10-21 |
Family
ID=73859498
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010673834.4A Active CN112162953B (en) | 2020-07-14 | 2020-07-14 | Current data processing method and device, current data processing equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112162953B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113553299A (en) * | 2021-07-27 | 2021-10-26 | 浙江爱旭太阳能科技有限公司 | Processing method and processing system for welding tension data of solar cell |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130217589A1 (en) * | 2012-02-22 | 2013-08-22 | Jun Xu | Methods for identifying agents with desired biological activity |
| CN105354179A (en) * | 2015-11-02 | 2016-02-24 | 武汉钢铁(集团)公司 | Coke dry quenching report generation method |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN108363678A (en) * | 2017-12-28 | 2018-08-03 | 上海神力科技有限公司 | One kind being used for the fast automatic processing system of fuel cell pile test data |
| CN109189610A (en) * | 2018-08-16 | 2019-01-11 | 郑州云海信息技术有限公司 | The processing method of monitoring server data under a kind of linux |
| CN109669865A (en) * | 2018-12-10 | 2019-04-23 | 万兴科技股份有限公司 | Performance test methods, device, electronic equipment and readable storage medium storing program for executing |
| CN110377566A (en) * | 2019-06-29 | 2019-10-25 | 苏州浪潮智能科技有限公司 | Arrange the method and system of the S parameter test file of PCB |
-
2020
- 2020-07-14 CN CN202010673834.4A patent/CN112162953B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130217589A1 (en) * | 2012-02-22 | 2013-08-22 | Jun Xu | Methods for identifying agents with desired biological activity |
| CN105354179A (en) * | 2015-11-02 | 2016-02-24 | 武汉钢铁(集团)公司 | Coke dry quenching report generation method |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN108363678A (en) * | 2017-12-28 | 2018-08-03 | 上海神力科技有限公司 | One kind being used for the fast automatic processing system of fuel cell pile test data |
| CN109189610A (en) * | 2018-08-16 | 2019-01-11 | 郑州云海信息技术有限公司 | The processing method of monitoring server data under a kind of linux |
| CN109669865A (en) * | 2018-12-10 | 2019-04-23 | 万兴科技股份有限公司 | Performance test methods, device, electronic equipment and readable storage medium storing program for executing |
| CN110377566A (en) * | 2019-06-29 | 2019-10-25 | 苏州浪潮智能科技有限公司 | Arrange the method and system of the S parameter test file of PCB |
Non-Patent Citations (2)
| Title |
|---|
| 张行之: ""Python之xlsx文件与csv文件相互转换", 《HTTPS://BLOG.CSDN.NET/QQ_33689414/ARTICLE/DETAILS/78307031》, 21 October 2017 (2017-10-21), pages 1 - 3 * |
| 落叶居士-家意: "python读取excel画折线图_Python读取Excel表格，并同时画折线图和柱状图", 《HTTPS://BLOG.CSDN.NET/ZJY18886018024/ARTICLE/DETAILS/80621918》, 8 June 2018 (2018-06-08), pages 1 - 2 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113553299A (en) * | 2021-07-27 | 2021-10-26 | 浙江爱旭太阳能科技有限公司 | Processing method and processing system for welding tension data of solar cell |
| CN113553299B (en) * | 2021-07-27 | 2024-03-29 | 浙江爱旭太阳能科技有限公司 | Processing method and processing system for solar cell welding tension data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112162953B (en) | 2022-10-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107506300B (en) | User interface testing method, device, server and storage medium | |
| CN107239392B (en) | Test method, test device, test terminal and storage medium | |
| CN102289407B (en) | Method for automatically testing document format conversion | |
| CN106909372B (en) | Method and system for calculating purchase path of mobile terminal user | |
| CN105183592B (en) | Method and apparatus for supporting performance evaluation | |
| CN109885819B (en) | Data table dynamic adjustment method, system, device and storage medium | |
| CN108388515A (en) | Test data generating method, device, equipment and computer readable storage medium | |
| CN110718264A (en) | Method and device for testing information of solid state disk, computer equipment and storage medium | |
| CN102637168A (en) | Method for realizing automatic language translation in graphical user interface | |
| CN110555073A (en) | data processing method and device, electronic equipment and storage medium | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN110727603A (en) | Improved method for automatically testing positioning elements based on UI (user interface) | |
| CN111143556A (en) | Software function point automatic counting method, device, medium and electronic equipment | |
| CN112162953B (en) | Current data processing method and device, current data processing equipment and storage medium | |
| CN113076358A (en) | Report generation method, device, equipment and storage medium | |
| CN108153635B (en) | System memory edge testing method, system device and computer readable storage medium | |
| CN110674196B (en) | GRAPES (generalized Grace temporal evolution) area set forecast inspection display system and display method | |
| CN114333995A (en) | Method and device for displaying gene fusion locus | |
| CN103678107A (en) | Data processing method and system | |
| CN114356218A (en) | Data error correction method, device and medium for Flash memory | |
| CN109493918B (en) | Biological data management and phylogenetic analysis process method | |
| CN113792138A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN111125590B (en) | Method and device for drawing thermodynamic diagram | |
| CN111626024A (en) | Method and system for batch processing of SWCC model parameter data based on RETC software | |
| CN107025268A (en) | Introduction method, import system and the importing equipment of battery parameter |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |