CN113126981A - Excel-based medical data processing method and device - Google Patents
Excel-based medical data processing method and device Download PDFInfo
- Publication number
- CN113126981A CN113126981A CN201911406159.2A CN201911406159A CN113126981A CN 113126981 A CN113126981 A CN 113126981A CN 201911406159 A CN201911406159 A CN 201911406159A CN 113126981 A CN113126981 A CN 113126981A
- Authority
- CN
- China
- Prior art keywords
- key
- data
- value pair
- processed
- cell
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/35—Creation or generation of source code model driven
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H70/00—ICT specially adapted for the handling or processing of medical references
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Medical Informatics (AREA)
- Health & Medical Sciences (AREA)
- Epidemiology (AREA)
- Data Mining & Analysis (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses a medical data processing method based on Excel, which can determine each key value pair data in a medical data table to be processed according to layout meta information corresponding to the medical data table to be processed, thereby realizing import or export of the medical data table to be processed by using each key value pair data. Therefore, when the Excel file is imported or exported, the import or export of various Excel templates can be realized by determining the key value pair data in the medical data table to be processed aiming at various Excel templates without depending on the fixed template of the Excel, and the decoupling between the Excel template and the code program of the Excel file import or export database is realized. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates frequently by manpower, and can avoid errors caused by modifying the code program manually, thereby improving the efficiency of importing or exporting the Excel file.
Description
Technical Field
The invention relates to the field of medical data processing, in particular to a method and a device for processing medical data based on Excel.
Background
Excel can conveniently produce various spreadsheets, and can perform complex operation on data by using formulas and functions. When managing a medical system, the medical system generates a large amount of medical data; in order to conveniently browse or use the medical data, an Excel file import or export function is provided in the medical system, so that a large amount of medical data can be imported into the database or exported and used from the database.
In the prior art, a method for importing or exporting an Excel file into or from a database is mainly implemented by using a specific Excel template and an import or export code program for the specific Excel template. However, the existing method for importing or exporting the Excel file into or from the database causes the tight coupling between the Excel template and the code program for importing or exporting the Excel file into or from the database; therefore, when the Excel template is changed, the code program of the Excel file import or export database needs to be modified manually. Because the process of manually modifying the code program is repeated and tedious and is easy to make mistakes, the existing method for importing or exporting the Excel file into or from the database causes low efficiency of importing or exporting the Excel file. Therefore, a method for improving the efficiency of importing or exporting an Excel file is needed.
Disclosure of Invention
The invention provides a method and a device for processing medical data based on Excel, which are used for realizing the purposes that a code program does not need to be frequently modified manually according to different Excel templates, and errors caused by manually modifying the code program can be avoided, so that the efficiency of importing or exporting Excel files is improved.
In a first aspect, the present invention provides a method for Excel-based medical data processing, the method comprising:
acquiring a processing instruction and a to-be-processed medical data table, wherein the processing instruction comprises a table import instruction or a table export instruction;
determining layout meta information corresponding to the medical data table to be processed, wherein the layout meta information comprises position information corresponding to each key value pair data in the medical data table to be processed;
and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
In a second aspect, the present invention provides an Excel-based medical data processing apparatus, the apparatus comprising:
the medical data processing device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a processing instruction and a medical data table to be processed, and the processing instruction comprises a table import instruction or a table export instruction;
the determining unit is used for determining layout meta-information corresponding to the medical data table to be processed, wherein the layout meta-information comprises position information corresponding to each key value pair data in the medical data table to be processed;
and the processing unit is used for processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
In a third aspect, the invention provides a readable medium comprising executable instructions, which when executed by a processor of an electronic device, perform the method according to any of the first aspect.
In a fourth aspect, the present invention provides an electronic device, comprising a processor and a memory storing execution instructions, wherein when the processor executes the execution instructions stored in the memory, the processor performs the method according to any one of the first aspect.
According to the technical scheme, the processing instruction and the medical data table to be processed can be obtained, the layout meta-information corresponding to the medical data table to be processed is determined, and then the data can be processed according to the processing instruction and the layout meta-information, so that the processed medical data can be obtained. Therefore, the method and the device can determine the key value pair data in the medical data table to be processed according to the layout meta information corresponding to the medical data table to be processed, so that the medical data table to be processed can be imported or exported by using the key value pair data. Therefore, when the Excel file is imported or exported, the import or export of various Excel templates can be realized by determining the key value pair data in the medical data table to be processed aiming at various Excel templates without depending on the fixed template of the Excel, and the decoupling between the Excel template and the code program of the Excel file import or export database is realized. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates frequently by manpower, and can avoid errors caused by modifying the code program manually, thereby improving the efficiency of importing or exporting the Excel file.
Further effects of the above-mentioned unconventional preferred modes will be described below in conjunction with specific embodiments.
Drawings
In order to more clearly illustrate the embodiments or the prior art solutions of the present invention, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments described in the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive labor.
FIG. 1A is a schematic flow chart of a method for Excel-based medical data processing according to the present invention;
FIG. 1B is a schematic flow chart of a method for Excel-based medical data processing according to the present invention;
FIG. 1C is a schematic flow chart of a method for Excel-based medical data processing according to the present invention;
FIG. 2 is a diagram illustrating a pending medical data form according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an Excel-based medical data processing apparatus according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be described in detail and completely with reference to the following embodiments and accompanying drawings. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. 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 invention.
The method aims to solve the problems that in the prior art, the process of manually modifying a code program is repeated and tedious, and errors are easy to occur, so that the existing method for importing or exporting the Excel file into or from the database causes low efficiency of importing or exporting the Excel file.
The invention provides a Excel-based medical data processing method, which can determine layout meta-information corresponding to a medical data form to be processed, and determine each key value pair data in the medical data form to be processed according to the layout meta-information corresponding to the medical data form to be processed, thereby realizing importing or exporting of the medical data form to be processed by using each key value pair data. Therefore, when the Excel file is imported or exported, the import or export of various Excel templates can be realized by determining the key value pair data in the medical data table to be processed aiming at various Excel templates without depending on the fixed template of the Excel, and the decoupling between the Excel template and the code program of the Excel file import or export database is realized. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates frequently by manpower, and can avoid errors caused by modifying the code program manually, thereby improving the efficiency of importing or exporting the Excel file.
Various non-limiting embodiments of the present invention are described in detail below with reference to the accompanying drawings.
Referring to fig. 1A, an Excel-based medical data processing method in an embodiment of the present invention is shown. In this embodiment, the method may include, for example, the steps of:
s101: and acquiring a processing instruction and a medical data table to be processed.
A processing instruction may be understood as an instruction that requires processing of a table, where the processing instruction may reflect the manner in which the processing of the table is required. In one implementation, the processing instruction may include a table import instruction or a table export instruction, where the table import instruction may be understood as an instruction that needs to import content data in a table into a database, that is, to reflect import processing that needs to be performed on the table, and the table export instruction may be understood as an instruction that needs to import content data in the database into the table, that is, to reflect export processing that needs to be performed on the table.
The medical data table to be processed can be understood as a medical data table that needs to be processed. For example, the pending medical data table may be an Excel table of a hospital drug usage catalog drug summary analysis.
It should be noted that, in one implementation, the to-be-processed medical data table may be a table that needs to be processed and includes to-be-processed medical information, for example, when the processing instruction is a table import instruction, the to-be-processed medical data table may be an Excel table that includes to-be-processed hospital medicine usage data.
In another implementation, the to-be-processed medical data table may be a template table that needs to be processed and does not include the to-be-processed medical information, for example, when the processing instruction is a table export instruction, the to-be-processed medical data table may be an Excel template table that does not include any to-be-processed hospital drug usage data. It should be noted that the template form can be understood as a form in which the content format is fixed and standardized according to a preset rule, and the template form represents the standardization of the structural form; it is understood that the template table includes the keys in the key value pairs but does not include the values in the key value pairs, while the pending medical data table that needs to be processed and includes the medical information to be processed includes the keys and the values in the key value pairs. Wherein a key-value pair is a container that associates a key (key object) and a value (i.e., value object), i.e., the key and the value are associated to form a key-value pair, such that a value corresponding to the key can be obtained by using the key, for example, the key in the medical data table to be processed can be "label basic drug" and the value corresponding to the key can be "neomycin fluocinolone acetonide cream".
In this embodiment, the processing instruction and the to-be-processed medical data form may be obtained in various manners, for example, the processing instruction and the to-be-processed medical data form may be input by a user through an input device (such as a keyboard and a microphone), for example, the processing instruction and the to-be-processed medical data form may be stored in a specified path by the user in advance, for example, the processing instruction may be input by the user through the input device, and the to-be-processed medical data is obtained from another terminal or a server.
S102: and determining layout meta-information corresponding to the medical data table to be processed.
Although the format layout of different tables is different for different formats of the to-be-processed medical data tables, the data content in the to-be-processed medical data tables of different formats is composed of key-value pair data. Therefore, the import and export processing of the medical data table to be processed can be realized by determining each key value pair data in the medical data table to be processed and utilizing each key value pair data in the medical data table to be processed; therefore, decoupling between the Excel template and the code program of the Excel file import or export database is realized, namely for the medical data tables to be processed with different formats, the import and export can be realized by adopting a mode of data according to each key value in the medical data tables to be processed, and therefore, after the format of the medical data tables to be processed is changed, the code program does not need to be modified manually.
Specifically, after the medical data table to be processed is acquired, the layout meta information of the medical data table to be processed may be determined first. In one implementation, the layout meta information of the medical data table to be processed may include position information corresponding to each key value pair data in the medical data table to be processed, for example, the number of rows and columns of the key values in the key value pair in the table, and the number of rows and columns of the key values in the key value pair in the table.
That is, in this embodiment, after the medical data table to be processed is acquired, each key-value pair data in the medical data table to be processed may be determined first. Then, the position information of the key and the position information of the value in each key-value pair data are determined, that is, the position information of each key-value pair data is obtained. Thus, the layout meta information of the medical data table to be processed can be obtained.
S103: and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
After determining the layout meta information of the medical data table to be processed, the layout meta information of the medical data table to be processed may include position information corresponding to each key value pair data; therefore, the data can be processed corresponding to the processing instruction according to the processing instruction and the layout meta-information, so as to obtain the processed medical data.
For example, in one implementation, when the processing instruction is a table import instruction, the data of each key value in the medical data table to be processed may be imported according to the table import instruction and the layout meta information, so as to extract the medical information corresponding to each key value in the medical data table to be processed, that is, in this case, the processed medical data is the medical information corresponding to each key value in the medical data table to be processed. For example, the medical information corresponding to the key-value pair data is the corresponding relation between the 'labeled basic drug' and the 'neomycin fluocinolone acetonide cream' can be extracted.
For another example, in another implementation manner, when the processing instruction is a table export instruction, export processing may be performed on each key value pair data in the medical data table to be processed according to the table export instruction and the layout meta information, that is, medical information corresponding to each key value pair data is filled into the medical data table to be processed, so as to obtain a medical data table to be processed in which medical information is filled, that is, the processed medical data is the medical data table to be processed in which medical information is filled; for example, the medical information corresponding to the key-value pair data may be: the key marks the corresponding relation between the basic medicine and the value neomycin fluocinolone acetonide cream, and is filled into the cell corresponding to the key value pair data in the medical data table to be processed, namely the cell corresponding to the key marks the basic medicine is in the same column and the cell in the next row is filled with the neomycin fluocinolone cream.
Therefore, in the method, the layout meta information corresponding to the medical data table to be processed can be determined, and the key value pair data in the medical data table to be processed can be determined according to the layout meta information corresponding to the medical data table to be processed, so that the data can be imported or exported to the medical data table to be processed by using the key value pairs. Therefore, when the Excel file is imported or exported, the import or export of various Excel templates can be realized by determining the key value pair data in the medical data table to be processed aiming at various Excel templates without depending on the fixed template of the Excel, and the decoupling between the Excel template and the code program of the Excel file import or export database is realized. Therefore, compared with the prior art, the method and the device do not need to modify the code program according to different Excel templates frequently by manpower, and can avoid errors caused by modifying the code program manually, thereby improving the efficiency of importing or exporting the Excel file.
Fig. 1A is only a basic embodiment of the method of the present invention, and based on this, certain optimization and expansion can be performed, and other alternative embodiments of the method can also be obtained.
Next, another embodiment of the Excel-based medical data processing method according to the present invention will be described. In this embodiment, S102 is further described on the basis of the embodiment corresponding to fig. 1A (S102 includes S202-S204). As shown in fig. 1B, in this embodiment, the method specifically includes the following steps:
s201: and acquiring a processing instruction and a medical data table to be processed.
S201 in the present embodiment is the same as S101 in the corresponding embodiment of fig. 1A. Therefore, in this embodiment, S201 is not described again, and reference may be specifically made to the description of S101.
S202: and determining a template form corresponding to the medical data form to be processed.
Since the template table includes the keys in the key value pair but does not include the values in the key value pair, and the keys in the key value pair are usually fields set in advance, the position information of the keys in the key value pair is determined first, then the corresponding values are determined according to the keys, and the layout meta information is more easily obtained by determining the position information corresponding to the values. Therefore, after the to-be-processed medical data form is obtained, the template form corresponding to the to-be-processed medical data form can be determined. In one implementation, if the acquired medical data table to be processed is a template table, the template table corresponding to the medical data table to be processed can be directly obtained. In another implementation manner, if the acquired to-be-processed medical data table is not the template table, the template table corresponding to the to-be-processed medical data table may be acquired according to the to-be-processed medical data table, for example, the template table corresponding to the to-be-processed medical data table may be acquired from a server, a cloud server, or a local server according to the to-be-processed medical data table.
S203: and determining the type of each key value pair data in the template table according to the template table.
It should be noted that the type of the key-value pair data in the template table is used to reflect the positional relationship between the key and the value in the key-value pair data, that is, the type of the key-value pair data may reflect the relationship between the positional information of the key and the positional information of the value. In one implementation, the types of key-value pair data may include: data fill, placeholder, header, and marker types; wherein, the data filling type can reflect that the key in the key value pair data is in the same row with the value, but the value is positioned in the back column of the key; the placeholder type may reflect that keys and values in the key-value pair data are in the same row and column; the header type may reflect that the key in the key-value pair data is in the same column as the value, but the value is in the next row of the key; the token type may reflect that a key in the key-value pair data is in the same row as the value but the value is in the next column of keys, or that a key in the key-value pair data is in the same column as the value but the value is in the next row of keys.
As an example, the cells corresponding to the first row and the first column in the template table may be scanned line by line, and according to a situation of a character string included in a cell, a situation of a character string included in a cell adjacent to the cell, and a situation of a character string included in each cell in the row of the cell, whether the cell is a key in the key-value pair data is determined, and if yes, a type of the key-value pair data corresponding to each key is further determined. If it is detected that the cell and the adjacent other cells are merged cells, the character string included in any one of the merged cells may be used as the character string included in each of the merged cells. For example, as shown in fig. 2, row 3 to row 5 of column a are a merged cell, and the character strings included in the merged cell are "serial numbers", it can be considered that the character strings included in the cell corresponding to row 3 of column a, the cell corresponding to row 4 of column a, and the cell corresponding to row 5 of column a are all "serial numbers".
Next, how to determine the type of each key-value pair data in the template table will be described with the type of the key-value pair data as a data fill type, a placeholder type, a header type, and a mark type, respectively.
First, how to determine key-value pair data of a type of data fill type in template table data will be described.
Specifically, in this embodiment, it is necessary to scan the cells in the template table one by one, and determine the type of each cell, and for convenience of description, the currently determined cell may be referred to as a first cell in this embodiment. Assuming that any cell in the template table is a first cell, if the first cell includes a preset character string and no character string exists in a second cell which is in the same row as, adjacent to and behind the first cell, the character string in the first cell is used as a key and the character string in the second cell is used as a value, so that the type of key-value pair data formed by the values respectively included in the first cell and the second cell can be determined as a data filling type. It should be noted that the preset character string may be a preset specific character string, for example, the preset character string may be a medical term and/or a common table term, for example, the preset character string may be a medical term such as a drug YPID number and a dosage form, or a common table term such as a serial number and a date.
Continuing with the example of FIG. 2, the description is given. Assuming that the first cell is the cell of the A column and the 2 nd row; since the first cell includes a preset character string "fill-in unit (unit common chapter)", and a second cell which is in the same row as, adjacent to, and behind the first cell has no character string, the character string "fill-in unit (unit common chapter)" in the first cell can be used as a key, and the character string in the second cell can be used as a value, so that the character string "fill-in unit (unit common chapter)" in the first cell and the character string in the second cell can form a key-value pair data, and the type of the key-value pair data is a data fill-in type.
Next, how to determine key-value pair data of the type placeholder in the template table data will be described.
Specifically, in this method, the cells in the template table need to be scanned one by one, and the type of each cell needs to be determined. Assuming that any cell in the template table is a first cell, if the first cell includes a placeholder, taking the placeholder in the first cell as a key, taking a character string corresponding to the placeholder as a value, and setting the type of key-value pair data as a placeholder type. It should be noted that a placeholder is understood as a symbol in a cell for holding a fixed position and to which content can be added, for example, the title of a template: xxxx province (district, city) selects a summary analysis table of medical health institution drug usage catalog — 2019, and xxxx can be replaced by a placeholder $ { providencName } or $ { metalEntity.
Continuing with the example of FIG. 2, the description is given. Assuming that the first cell is a cell in column a and row 1, the first cell includes a preset character string "$ { providencName } province (district, city) selected medical and health institution drug usage catalog drug summary analysis table — 2019"; because the placeholder of $ { providencaname } can be obtained by removing the "province/city/selected medical and health institution drug usage catalog drug summary analysis table _ 2019" in the first cell, the placeholder in the first cell can be used as a key, the character string corresponding to the placeholder is used as a value, the key and the value form key-value pair data, and the type of the key-value pair data is a placeholder type.
Next, how to determine key-value pair data whose type is a header type in the template table data will be described.
Specifically, in this method, the cells in the template table need to be scanned one by one, and the type of each cell needs to be determined. Assuming that any cell in the template table is a first cell, if each cell in a row where the first cell is located includes a preset character and each cell in a next row of the first cell does not include a character string, that is, assuming that a row number corresponding to the first cell is an nth row, each cell in an N +1 th row does not include a character string; the character string in the first cell is taken as a key, the character string in a third cell which is in the same column with the first cell but is positioned at the next row of the first cell is taken as a value, and the type of the key-value pair data is of a header type.
Continuing with the example of FIG. 2, the description is given. The first unit cell is assumed to be the unit cell of the A column and the 5 th row; each cell in the row where the first cell is located includes a preset character, and each cell in the next row of the first cell (i.e., each cell in the 6 th row) includes no character string; therefore, the character string "serial number" in the first cell may be used as a key, and the character string in the third cell (i.e., the cell in the a-th column or the cell in the 6 th row) that is in the same column as the first cell but is positioned in the lower row of the first cell may be used as a value, so that the character string "serial number" in the first cell and the character string in the third cell may form key-value pair data, and the type of the key-value pair data is a table header type.
Finally, how to determine the key-value pair data whose type is the mark type in the template table data will be described.
Specifically, in this method, the cells in the template table need to be scanned one by one, and the type of each cell needs to be determined. Assuming that any cell in the template table is a first cell, if the first cell includes a preset character string, and a fourth cell adjacent to the first cell includes a mark character string corresponding to the preset character string. It should be noted that the fourth cell may be a cell that is in the same row as the first cell and is located in a column below the first cell, or may be a cell that is in the same row as the first cell and is located in a row below the first cell; the marker string corresponding to the preset string may be understood as at least one fixed string preset and corresponding to the preset string, for example, the preset string is "unit", and the marker string corresponding to the preset string may include "hai lake hospital", "yang facing hospital", and the like. In this way, the character string in the first cell can be used as a key, the character string in the fourth cell can be used as a value, and the type of key-value pair data formed by the character string in the first cell and the character string in the fourth cell is a mark type.
S204: and determining the position information of the value in the key-value pair data according to the position information and the type of the key-value pair data aiming at each key-value pair data in the template table, and taking the position information of the key and the position information of the value as the position information corresponding to the key-value pair data.
It should be noted that, since the type of the key-value pair data in the template table may represent the relationship between the position information of the key and the position information of the value, after determining the position information of the key in the key-value pair data and the type of the key-value pair data, the position information of the value in the key-value pair data may be determined. Therefore, in this embodiment, after determining the type of each key-value pair data in the template table, for each key-value pair data in the template table, the position information of the value in the key-value pair data (i.e., the number of rows and columns of the value) may be determined according to the position information and the type of the key-value pair data, and the position information of the key and the position information of the value may be used as the position information corresponding to the key-value pair data.
For example, if the position information of the key-value pair data is nth row and mth column, and the type of the key-value pair data is data fill type, the position information of the value in the key-value pair data may be determined to be nth row and mth +1 column.
For another example, if the position information of the key-value pair data is nth row and mth column, and the type of the key-value pair data is placeholder type, it may be determined that the position information of the value in the key-value pair data is nth row and mth column.
For another example, if the position information of the key-value pair data is the nth row and the mth column, and the type of the key-value pair data is the header type, it may be determined that the position information of the value in the key-value pair data is the N +1 th row and the mth column.
For example, if the position information of the key-value pair data is N-th row and M-th column, and the type of the key-value pair data is a mark type, it may be determined that the position information of the value in the key-value pair data is N + 1-th row, M-th column, or N-th row and M + 1-th column. Note that N, M are positive integers.
S205: and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
S205 in the present embodiment is the same as S103 in the corresponding embodiment of fig. 1A. Therefore, in this embodiment, S205 is not described again, and reference may be specifically made to the description of S103.
So far, the embodiment realizes a process of Excel-based medical data processing by combining with a specific application scenario. Of course, the above scenario is only an exemplary scenario and is not intended to limit the method provided by the present invention. The method provided by the invention can be applied to the processing process of other Excel-based medical data processing methods with the same principle in an extensive way.
Fig. 1A is only a basic embodiment of the method of the present invention, and based on this, certain optimization and expansion can be performed, and other alternative embodiments of the method can also be obtained.
Next, another embodiment of the Excel-based medical data processing method according to the present invention will be described. In the present embodiment, on the basis of the embodiment corresponding to fig. 1A, in the case where the processing instruction is a table import instruction, S103 is further described (S103 includes S303). As shown in fig. 1C, in this embodiment, the method specifically includes the following steps:
s301: and acquiring a processing instruction and a medical data table to be processed.
In this embodiment, the processing instruction is a table import instruction, and accordingly, the to-be-processed medical data table is a template table including medical information.
It should be noted that S301 in the present embodiment is similar to S101 in the corresponding embodiment of fig. 1A. Therefore, in this embodiment, S301 is not described again, and reference may be specifically made to the description of S101.
S302: determining layout meta information corresponding to the medical data table to be processed, wherein the layout meta information comprises position information corresponding to each key value pair data in the medical data table to be processed;
s302 in this embodiment is the same as S102 in the corresponding embodiment of fig. 1A. Therefore, in this embodiment, S302 is not described again, and reference may be specifically made to the description of S102.
S303: and according to the layout meta information, performing data extraction on the medical data table to be processed to obtain medical information corresponding to each key value pair data.
Since the layout meta information of the to-be-processed medical data table may include the position information corresponding to each key value pair data in the to-be-processed medical data table, the cell corresponding to the key and the cell corresponding to the key in each key value pair data in the to-be-processed medical data table may be determined according to the layout meta information. Then, the character strings included in the cells corresponding to the keys in each key-value pair data and the character strings included in the cells corresponding to the values are extracted, so that the character strings included in the cells corresponding to the keys and the character strings included in the cells corresponding to the values can be used as the medical information corresponding to the key-value pair data.
For example, it is assumed that, according to the layout meta information, it can be determined that the cell a corresponding to the key in the key-value pair data is located in the a-th column and the third row, and the cell a includes a character string of "unit"; the cell B corresponding to the key in the key-value pair data is located in column B and the third row, and the character string included in the cell B is "hai lake hospital". In this way, by extracting the character strings in the cell a and the cell B, it is possible to determine that the medical data corresponding to the key-value pair data is the correspondence between the "unit" and the "hai lake hospital".
S304: and storing the medical information corresponding to each key value pair data to a preset database.
After determining the medical information corresponding to each key value pair data in the medical data table to be processed, the medical information corresponding to each key value pair data may be stored in a preset database for subsequent export and processing. It should be noted that, when the medical data table to be processed is obtained, an obtaining source may be determined, and the obtaining source, for example, a user name corresponding to the terminal, may be used as the user identifier; and the medical information corresponding to the user identification and each key value pair data can be stored in a preset database as a corresponding relation. For example, if the to-be-processed medical data table is uploaded by a hail hospital, the medical information corresponding to each key value pair data in the to-be-processed table and the corresponding relationship of the user identifier "hail hospital" may be stored in the preset database, so that the medical data corresponding to the user identifier may be extracted from the preset database according to the user identifier for processing.
So far, the embodiment realizes a process of Excel-based medical data processing by combining with a specific application scenario. Of course, the above scenario is only an exemplary scenario and is not intended to limit the method provided by the present invention. The method provided by the invention can be applied to the processing process of other Excel-based medical data processing methods with the same principle in an extensive way.
Fig. 1A is only a basic embodiment of the method of the present invention, and based on this, certain optimization and expansion can be performed, and other alternative embodiments of the method can also be obtained.
Next, another embodiment of the Excel-based medical data processing method according to the present invention will be described. In this embodiment, on the basis of the embodiment corresponding to fig. 1A, in the case that the processing instruction is a table derivation instruction, S103 is further described (S103 includes S403). In this embodiment, the method specifically includes the following steps:
s401: acquiring the form export instruction and the to-be-processed medical data form, and determining to-be-exported medical information according to the form export instruction;
in this embodiment, the processing instruction is a table derivation instruction, and the to-be-processed medical data table is a template table. For example, in one implementation, the table export instruction may include a user identifier corresponding to the medical information to be exported, so that the medical information corresponding to the user identifier may be obtained from a preset database according to the user identifier, and the medical information is used as the medical information to be exported.
It should be noted that S401 in this embodiment is similar to S101 in the corresponding embodiment of fig. 1A. Therefore, in this embodiment, S401 will not be described, and reference may be made to the description of S101.
S402: and determining layout meta-information corresponding to the medical data table to be processed.
S402 in the present embodiment is the same as S102 in the corresponding embodiment of fig. 1A. Therefore, in this embodiment, S402 will not be described, and reference may be made to the description of S102.
S403: and filling the medical information to be exported into the medical data table to be processed according to the key value pair data corresponding to the medical data to be exported and the layout meta information.
Since the layout meta information of the to-be-processed medical data table may include the position information corresponding to each key value pair data in the to-be-processed medical data table, the cell corresponding to the key and the cell corresponding to the key in each key value pair data in the to-be-processed medical data table may be determined according to the layout meta information. Then, key-value pair data corresponding to each piece of medical information in the medical information to be derived can be determined. Then, the key-value pair data corresponding to the medical data may be matched with each key-value pair data in the medical data table to be processed, and if the key-value pair data corresponding to one medical data is matched with one key-value pair data in the medical data table to be processed, for example, the keys in the key-value pair data are the same, for example, the key in the key-value pair data corresponding to one medical data is "unit" and the key in the key-value pair data in the medical data table to be processed is also "unit", it may be considered that the key-value pair data corresponding to the medical data is matched with the key-value pair data in the medical data table to be processed; the key-value pair data corresponding to the medical information may be filled into the to-be-processed medical data table, and the position corresponding to the key-value pair data matched with the key-value pair data corresponding to the medical information may be filled, so that the export of the to-be-processed medical data table filled with the medical information may be completed.
So far, the embodiment realizes a process of Excel-based medical data processing by combining with a specific application scenario. Of course, the above scenario is only an exemplary scenario and is not intended to limit the method provided by the present invention. The method provided by the invention can be applied to the processing process of other Excel-based medical data processing methods with the same principle in an extensive way.
Fig. 3 shows an embodiment of an Excel-based medical data processing apparatus according to the present invention. The apparatus of this embodiment is a physical apparatus for executing the method of the above embodiment. The technical solution is essentially the same as that in the above embodiment, and the corresponding description in the above embodiment is also applicable to this embodiment. The device in this embodiment includes:
an obtaining unit 301, configured to obtain a processing instruction and a to-be-processed medical data table, where the processing instruction includes a table import instruction or a table export instruction;
a determining unit 302, configured to determine layout meta information corresponding to the to-be-processed medical data table, where the layout meta information includes position information corresponding to each key value pair data in the to-be-processed medical data table;
and the processing unit 303 is configured to process data of each key value in the to-be-processed medical data table according to the processing instruction and the layout meta information, so as to obtain processed medical data.
Optionally, the determining unit 302 is specifically configured to:
determining a template form corresponding to the medical data form to be processed;
determining the type of each key value pair data in the template table according to the template table;
and determining the position information of the value in the key-value pair data according to the position information and the type of the key-value pair data aiming at each key-value pair data in the template table, and taking the position information of the key and the position information of the value as the position information corresponding to the key-value pair data.
Optionally, the types of the key-value pair data include: data fill, placeholder, header, and marker types;
the determining unit 302 is further specifically configured to:
if a first cell comprises a preset character string and no character string exists in a second cell which is in the same row with the first cell, is adjacent to the first cell and is positioned behind the first cell, the character string in the first cell is used as a key, the character string in the second cell is used as a value, and the type of key value to data is a data filling type;
if the first cell comprises a placeholder, taking the placeholder in the first cell as a key, taking a character string corresponding to the placeholder as a value, and taking the type of key-value pair data as a placeholder type;
if each cell in the row of the first cell comprises a preset character and each cell in the next row of the first cell does not comprise a character string, taking the character string in the first cell as a key, taking the character string in a third cell which is in the same column with the first cell but is positioned in the next row of the first cell as a value, and taking the type of key value pair data as a header type;
if the first cell comprises a preset character string, and a fourth cell adjacent to the first cell comprises a mark character string corresponding to the preset character string, taking the character string in the first cell as a key, taking the character string in the fourth cell as a value, and setting the type of key value pair data as a mark type.
Optionally, the determining unit 302 is further specifically configured to:
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is a data filling type, determining the position information of the value in the key-value pair data is the Nth row and the Mth +1 th column;
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is a placeholder type, determining that the position information of the value in the key-value pair data is the Nth row and the Mth column;
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is the header type, determining that the position information of the value in the key-value pair data is the (N + 1) th row and the Mth column;
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is a mark type, determining that the position information of the value in the key-value pair data is the (N + 1) th row, the Mth column or the Nth row and the (M + 1) th column; wherein N, M are all positive integers.
Optionally, the processing instruction is a table import instruction; accordingly, the processing unit 303 is configured to:
and according to the layout meta information, performing data extraction on the medical data table to be processed to obtain medical information corresponding to each key value pair data.
Optionally, the apparatus further includes a storage unit, configured to:
and storing the medical data corresponding to each key value pair data into a preset database.
Optionally, the processing instruction is a table derivation instruction; the obtaining unit 301 is specifically configured to:
acquiring the form export instruction and the to-be-processed medical data form, and determining to-be-exported medical information according to the form export instruction;
accordingly, the processing unit 303 is specifically configured to:
and filling the medical information to be exported into the medical data table to be processed according to the key value pair data corresponding to the medical data to be exported and the layout meta information.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention. On the hardware level, the electronic device comprises a processor and optionally an internal bus, a network interface and a memory. The Memory may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory, such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.
The processor, the network interface, and the memory may be connected to each other via an internal bus, which may be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one double-headed arrow is shown in FIG. 4, but that does not indicate only one bus or one type of bus.
And the memory is used for storing the execution instruction. In particular, a computer program that can be executed by executing instructions. The memory may include both memory and non-volatile storage and provides execution instructions and data to the processor.
In a possible implementation manner, the processor reads the corresponding execution instructions from the nonvolatile memory into the memory and then runs the corresponding execution instructions, and the corresponding execution instructions can also be obtained from other equipment, so that the Excel-based medical data processing device is formed on a logic level. The processor executes the execution instructions stored in the memory, so that the Excel-based medical data processing method provided by any embodiment of the invention is realized through the executed execution instructions.
The method performed by the Excel-based medical data processing apparatus according to the embodiment of the present invention shown in fig. 1A can be applied to or implemented by a processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or instructions in the form of software. The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components. The various methods, steps and logic blocks disclosed in the embodiments of the present invention may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The steps of the method disclosed in connection with the embodiments of the present invention may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The storage medium is located in a memory, and a processor reads information in the memory and completes the steps of the method in combination with hardware of the processor.
The embodiment of the present invention further provides a readable storage medium, where the readable storage medium stores an execution instruction, and when the stored execution instruction is executed by a processor of an electronic device, the electronic device can execute the Excel-based medical data processing method provided in any embodiment of the present invention, and is specifically configured to execute the method described in the Excel-based medical data processing.
The electronic device described in the foregoing embodiments may be a computer.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects.
The embodiments of the present invention are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, as for the apparatus embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
It should also be noted that 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 like elements in a process, method, article, or apparatus that comprises the element.
The above description is only an example of the present invention, and is not intended to limit the present invention. Various modifications and alterations to this invention will become apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the scope of the claims of the present invention.
Claims (10)
1. A method for Excel-based medical data processing, the method comprising:
acquiring a processing instruction and a to-be-processed medical data table, wherein the processing instruction comprises a table import instruction or a table export instruction;
determining layout meta information corresponding to the medical data table to be processed, wherein the layout meta information comprises position information corresponding to each key value pair data in the medical data table to be processed;
and processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
2. The method of claim 1, wherein the determining layout meta information corresponding to the medical data table to be processed comprises:
determining a template form corresponding to the medical data form to be processed;
determining the type of each key value pair data in the template table according to the template table;
and determining the position information of the value in the key-value pair data according to the position information and the type of the key-value pair data aiming at each key-value pair data in the template table, and taking the position information of the key and the position information of the value as the position information corresponding to the key-value pair data.
3. The method of claim 2, wherein the type of key-value pair data comprises: data fill, placeholder, header, and marker types;
determining the type of each key-value pair data in the template table according to the template table, including:
if a first cell comprises a preset character string and no character string exists in a second cell which is in the same row with the first cell, is adjacent to the first cell and is positioned behind the first cell, the character string in the first cell is used as a key, the character string in the second cell is used as a value, and the type of key value to data is a data filling type;
if the first cell comprises a placeholder, taking the placeholder in the first cell as a key, taking a character string corresponding to the placeholder as a value, and taking the type of key-value pair data as a placeholder type;
if each cell in the row of the first cell comprises a preset character and each cell in the next row of the first cell does not comprise a character string, taking the character string in the first cell as a key, taking the character string in a third cell which is in the same column with the first cell but is positioned in the next row of the first cell as a value, and taking the type of key value pair data as a header type;
if the first cell comprises a preset character string, and a fourth cell adjacent to the first cell comprises a mark character string corresponding to the preset character string, taking the character string in the first cell as a key, taking the character string in the fourth cell as a value, and setting the type of key value pair data as a mark type.
4. The method of claim 3, wherein determining location information for values in the key-value pair data according to the location information and type of the key-value pair data comprises:
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is a data filling type, determining the position information of the value in the key-value pair data is the Nth row and the Mth +1 th column;
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is a placeholder type, determining that the position information of the value in the key-value pair data is the Nth row and the Mth column;
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is the header type, determining that the position information of the value in the key-value pair data is the (N + 1) th row and the Mth column;
if the position information of the key-value pair data is the Nth row and the Mth column and the type of the key-value pair data is a mark type, determining that the position information of the value in the key-value pair data is the (N + 1) th row, the Mth column or the Nth row and the (M + 1) th column; wherein N, M are all positive integers.
5. The method of any of claims 1-4, wherein the processing instruction is a table import instruction; correspondingly, the medical data table to be processed is a template table comprising medical information; the processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain processed medical data comprises:
and according to the layout meta information, performing data extraction on the medical data table to be processed to obtain medical information corresponding to each key value pair data.
6. The method according to claim 5, wherein after the data extraction is performed on the medical data table to be processed according to the layout meta information to obtain the medical information corresponding to each key value pair data, the method further comprises:
and storing the medical information corresponding to each key value pair data to a preset database.
7. The method of any of claims 1-4, wherein the processing instruction is a table export instruction; the medical data table to be processed is a template table; the acquiring processing instruction and the to-be-processed medical data table comprise:
acquiring the form export instruction and the to-be-processed medical data form, and determining to-be-exported medical information according to the form export instruction;
correspondingly, the processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain processed medical data includes:
and filling the medical information to be exported into the medical data table to be processed according to the key value pair data corresponding to the medical data to be exported and the layout meta information.
8. An Excel-based medical data processing apparatus, characterized in that the apparatus comprises:
the medical data processing device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring a processing instruction and a medical data table to be processed, and the processing instruction comprises a table import instruction or a table export instruction;
the determining unit is used for determining layout meta-information corresponding to the medical data table to be processed, wherein the layout meta-information comprises position information corresponding to each key value pair data in the medical data table to be processed;
and the processing unit is used for processing the data of each key value in the medical data table to be processed according to the processing instruction and the layout meta information to obtain the processed medical data.
9. A readable medium comprising executable instructions which, when executed by a processor of an electronic device, cause the electronic device to perform the method of any of claims 1 to 7.
10. An electronic device comprising a processor and a memory storing execution instructions, the processor performing the method of any one of claims 1-7 when the processor executes the execution instructions stored by the memory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911406159.2A CN113126981B (en) | 2019-12-31 | 2019-12-31 | Medical data processing method and device based on Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911406159.2A CN113126981B (en) | 2019-12-31 | 2019-12-31 | Medical data processing method and device based on Excel |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113126981A true CN113126981A (en) | 2021-07-16 |
| CN113126981B CN113126981B (en) | 2023-10-03 |
Family
ID=76768706
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911406159.2A Active CN113126981B (en) | 2019-12-31 | 2019-12-31 | Medical data processing method and device based on Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113126981B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114866531A (en) * | 2022-04-02 | 2022-08-05 | 山东体育学院 | Cross-network data transmission method and system |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
| US20100005115A1 (en) * | 2008-07-03 | 2010-01-07 | Sap Ag | Method and system for generating documents usable by a plurality of differing computer applications |
| US20120060216A1 (en) * | 2010-09-01 | 2012-03-08 | Apixio, Inc. | Medical information navigation engine (mine) system |
| CN107608669A (en) * | 2017-08-15 | 2018-01-19 | 山西云度知识产权服务有限公司 | A kind of method based on database table structure automatic generation function and the page |
| CN107887009A (en) * | 2017-11-20 | 2018-04-06 | 浪潮金融信息技术有限公司 | Processing method and processing device, computer-readable storage medium and the terminal of information for hospital data |
| US20180157468A1 (en) * | 2016-12-03 | 2018-06-07 | Thomas STACHURA | Spreadsheet-Based Software Application Development |
| CN108322492A (en) * | 2017-01-16 | 2018-07-24 | 医渡云（北京）技术有限公司 | Medical data synchronous method and device |
| CN109582286A (en) * | 2018-07-04 | 2019-04-05 | 福州震旦计算机技术有限公司 | Data standard method of calibration and its device based on Freemarker technology |
| CN109933752A (en) * | 2017-12-15 | 2019-06-25 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus exporting electronic document |
-
2019
- 2019-12-31 CN CN201911406159.2A patent/CN113126981B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
| US20100005115A1 (en) * | 2008-07-03 | 2010-01-07 | Sap Ag | Method and system for generating documents usable by a plurality of differing computer applications |
| US20120060216A1 (en) * | 2010-09-01 | 2012-03-08 | Apixio, Inc. | Medical information navigation engine (mine) system |
| US20180157468A1 (en) * | 2016-12-03 | 2018-06-07 | Thomas STACHURA | Spreadsheet-Based Software Application Development |
| CN108322492A (en) * | 2017-01-16 | 2018-07-24 | 医渡云（北京）技术有限公司 | Medical data synchronous method and device |
| CN107608669A (en) * | 2017-08-15 | 2018-01-19 | 山西云度知识产权服务有限公司 | A kind of method based on database table structure automatic generation function and the page |
| CN107887009A (en) * | 2017-11-20 | 2018-04-06 | 浪潮金融信息技术有限公司 | Processing method and processing device, computer-readable storage medium and the terminal of information for hospital data |
| CN109933752A (en) * | 2017-12-15 | 2019-06-25 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus exporting electronic document |
| CN109582286A (en) * | 2018-07-04 | 2019-04-05 | 福州震旦计算机技术有限公司 | Data standard method of calibration and its device based on Freemarker technology |
Non-Patent Citations (1)
| Title |
|---|
| 杜德洁 等: "医疗质控数据统计中EXCEL软件实用技巧", 《医学研究生学报》, vol. 25, no. 3, pages 298 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114866531A (en) * | 2022-04-02 | 2022-08-05 | 山东体育学院 | Cross-network data transmission method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113126981B (en) | 2023-10-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111290956B (en) | Brain graph-based test method and device, electronic equipment and storage medium | |
| CN109635300B (en) | Data verification method and device | |
| CN110647562B (en) | Data query method and device, electronic equipment and storage medium | |
| CN109271315B (en) | Script code detection method, script code detection device, computer equipment and storage medium | |
| CN110737689B (en) | Data standard compliance detection method, device, system and storage medium | |
| CN113407536B (en) | Method, device, terminal equipment and medium for associating table data | |
| CN113963770A (en) | Report file generation method and device, computer equipment and storage medium thereof | |
| WO2019042349A1 (en) | Translation method, mobile terminal and storage device of operating system framework | |
| CN114090671A (en) | Data import method and device, electronic equipment and storage medium | |
| CN110688315A (en) | Interface code detection report generation method, electronic device, and storage medium | |
| CN112948418A (en) | Dynamic query method, device, equipment and storage medium | |
| CN113126981A (en) | Excel-based medical data processing method and device | |
| CN109102845B (en) | Medical document auditing method, device, computer equipment and storage medium | |
| CN111222324A (en) | Time identification method and device, computer readable storage medium and electronic equipment | |
| CN112487122B (en) | Address normalization processing method and device | |
| CN111984674A (en) | Method and system for generating structured query language | |
| CN108427664B (en) | Document analysis method and device | |
| CN107132993B (en) | Method and device for writing data into memory | |
| CN111199805B (en) | Type hierarchy extraction method and device based on medical data | |
| CN113033177A (en) | Method and device for analyzing electronic medical record data | |
| CN107704484B (en) | Webpage error information processing method and device, computer equipment and storage medium | |
| CN112685253A (en) | Front-end error log collection method, device, equipment and storage medium | |
| CN111913993B (en) | Table data generation method, apparatus, electronic device and computer readable storage medium | |
| CN113360505B (en) | Time sequence data-based data processing method and device, electronic equipment and readable storage medium | |
| CN112445888A (en) | Information extraction method and related equipment |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230217 Address after: Room 304, Unit 1, Floor 4, Building 9, West District, No. 9 Courtyard, Linglong Road, Haidian District, Beijing, 100089 Applicant after: BEIJING YIYIYUN TECHNOLOGY Co.,Ltd. Address before: Floor 4, 5, 6 and 7, building E7, Zhihui Yunjin incubation base of Guizhou great health pharmaceutical industry, Wudang District, Guiyang City, Guizhou Province Applicant before: GUIZHOU YIDU CLOUD TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |