Medical bill medicine unit correction method and system
By adding manual verification links to the drug unit marking and building a drug unit correction mapping table, the accuracy problem in drug unit marking is solved, and the rapid and accurate correction of drug units and accurate statistics of drug sales data are achieved.
Patent Information
- Application Number
- CN202411423617.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-12
- Publication Date
- 2025-02-11
AI Technical Summary
The prior art has accuracy problems in drug unit marking, especially for special drugs or emerging drug forms, it is difficult to accurately judge unit size, and there is a lack of manual intervention mechanism, which leads to errors in drug unit data and obstacles to calculating drug sales data.
A method for correcting medical bills for drug units is proposed, including collecting and filling medical bills for detailed data, correcting drug unit prices, constructing a drug unit correction mapping table, and correcting drug units based on the mapping table, which is ultimately used to calculate drug sales. This method adds a manual verification process to ensure the accuracy of corrections.
This method can quickly correct the drug unit, determine the conversion ratio, count the number of drugs, and provide accurate corrections when drug data is reused, improving the accuracy and efficiency of drug unit correction.
Smart Images
Figure CN119417542A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of ticket data processing, and more specifically, to a method and system for correcting drug units on medical invoices. Background Art
[0002] The detailed data of medical bills will ensure the correctness of the drug quantity and amount displayed on the bills. Since the drug unit is not displayed on the invoice, there is no strict constraint on its correctness, which leads to the common situation of drug unit errors in the background data. In addition, different doctors in different hospitals have different habits, and the drug unit data is even more uneven, which has a great obstacle to the calculation of drug sales data. Therefore, it is necessary to correct the drug unit, that is, to correct it according to the smallest granularity unit of each drug.
[0003] Prior art, such as the Chinese patent with patent number "CN111477294A", discloses a method for processing drug unit switching in an intelligent clinic system. The method comprises the following steps: Step 1, extracting units of different forms of drugs; Step 2: marking drug units according to drug unit size information; Step 3: storing drug information by combining the tag value with the corresponding drug unit relationship and conversion ratios at all levels; Step 4: when using a drug unit for the first time, only the tag information of the unit is recorded, without recording the specific value of the unit; Step 5: when using or reusing again, the corresponding drug unit information can be accurately obtained through the stored tag value.
[0004] The problem with the above-mentioned prior art is that the drug unit marking depends on the drug unit size information, but for some special drugs or newly emerging drug forms, it may be difficult to accurately judge the unit size, which in turn affects the accuracy of the marking. In addition, the method lacks a mechanism for manual intervention. In practical applications, some special situations may require manual judgment and adjustment, but the method does not provide a corresponding way. For example, for some unclear drug unit markings, manual confirmation and correction may be required. Summary of the invention
[0005] In order to solve the above technical problems, the present invention proposes a method and system for correcting drug units in medical bills.
[0006] The technical solution of the present invention is as follows:
[0007] The present invention provides a method for correcting drug units in medical bills, comprising the following steps:
[0008] Step S1, collecting detailed data of medical bills, including: hospital name, drug name, drug manufacturer, drug unit, drug unit price, drug quantity and drug amount; filling or cleaning the missing values of the three fields of drug amount, drug quantity and drug unit price in the detailed data of medical bills;
[0009] Step S2, processing the filled drug unit price which is a negative number, or only one of the drug amount and drug quantity is negative data, to ensure that the drug unit price is positive, and the drug amount and drug quantity are both positive and negative; correcting the mismatch between the drug unit price and the quotient of the drug amount and drug quantity, to obtain a corrected drug unit price;
[0010] Step S3, constructing a drug unit correction mapping table, including drug name, drug manufacturer, drug correction unit price, drug unit, minimum particle size unit and magnification factor;
[0011] Step S4, modifying the drug unit in the detailed data of the medical bill according to the drug unit modification mapping table to obtain a modified drug unit;
[0012] Step S5, using the detailed data of the revised medical bills as the data basis for calculating the sales volume of the medicines.
[0013] As a preferred implementation, the missing values of the three fields of drug amount, drug quantity, and drug unit price in the detailed data of the medical bill are filled or cleaned, including the following steps:
[0014] Fill in data based on the relationship of drug unit price = drug amount / drug quantity;
[0015] For data that cannot be filled in using the relationship of drug unit price = drug amount / drug quantity, the information of similar drugs is retrieved from the detailed data of medical bills using the four dimensions of hospital name, drug name, drug manufacturer, and drug unit to fill in the missing values, and the remaining missing values are calculated based on the relationship between drug amount, drug quantity, and drug unit price.
[0016] If any two of the three are missing and it is impossible to find filling data from other data, the data will be cleaned and deleted.
[0017] As a preferred implementation, the mismatch between the drug unit price and the quotient of the drug amount and the drug quantity is corrected to obtain a corrected drug unit price; the price is calculated by the following formula:
[0018]
[0019] As a preferred implementation, the magnification factor in the drug unit correction mapping table is calculated by the following formula:
[0020]
[0021] As a preferred embodiment, the minimum granularity unit in the drug unit correction mapping table is filled with the following method:
[0022] Count and count the drug name, drug manufacturer, revised drug price, and drug unit, and use the drug unit with the highest count as the revised drug unit;
[0023] The K nearest neighbor voting method is used to confirm the minimum particle size unit and the magnification factor;
[0024] Calculate the minimum particle size number based on the magnification factor.
[0025] As a preferred implementation, the K nearest neighbor voting method is used to confirm the minimum granularity unit and the magnification factor, and the specific process is as follows:
[0026] Assume that the unit price of the smallest granularity unit of the unknown drug is P, and the unit prices of the smallest granularity units of the known drugs are P1, P2, ..., P i , calculate the distance between Pi and P respectively:
[0027] d(P i ,P)=|P i -P|;
[0028] The calculated distances are sorted from small to large, and the smallest granularity units with the highest corresponding frequency of the K nearest unit prices are selected as the smallest granularity units, and the magnification factor with the highest corresponding frequency is selected as the magnification factor.
[0029] On the other hand, the present invention also provides a medical bill drug unit correction system, characterized by comprising:
[0030] The data preprocessing module is used to collect detailed data of medical bills, including: hospital name, drug name, drug manufacturer, drug unit, drug unit price, drug quantity and drug amount; fill or clean the missing values of the three fields of drug amount, drug quantity and drug unit price in the detailed data of medical bills;
[0031] The unit price correction module processes the data where the filled drug unit price is negative, or only one of the drug amount and drug quantity is negative, to ensure that the drug unit price is positive, and the drug amount and drug quantity are both positive and negative; the unit price of the drug is corrected if it does not match the quotient of the drug amount and drug quantity, and the corrected drug unit price is obtained;
[0032] A mapping table construction module is used to construct a drug unit correction mapping table, including drug name, drug manufacturer, drug correction unit price, drug unit, minimum granularity unit and magnification factor;
[0033] The unit correction module corrects the drug unit in the detailed data of the medical bill according to the drug unit correction mapping table to obtain the corrected drug unit;
[0034] The sales statistics module uses the detailed data of the revised medical bills as the data basis for calculating drug sales.
[0035] As a preferred implementation, the data preprocessing module fills or cleans the missing values of the three fields of drug amount, drug quantity, and drug unit price in the detailed data of the medical bill, including the following steps:
[0036] Fill in data based on the relationship of drug unit price = drug amount / drug quantity;
[0037] For data that cannot be filled in using the relationship of drug unit price = drug amount / drug quantity, the information of similar drugs is retrieved from the detailed data of medical bills using the four dimensions of hospital name, drug name, drug manufacturer, and drug unit to fill in the missing values, and the remaining missing values are calculated based on the relationship between drug amount, drug quantity, and drug unit price.
[0038] If any two of the three are missing and it is impossible to find filling data from other data, the data will be cleaned and deleted.
[0039] On the other hand, the present invention further provides an electronic device having a computer program stored thereon, wherein when the computer program is executed by a processor, a method for correcting drug units on a medical invoice as described in any embodiment of the present invention is implemented.
[0040] On the other hand, the present invention also provides a computer-readable medium for storing one or more programs, which, when executed by the one or more processors, enables the one or more processors to implement a method for correcting drug units in medical invoices as described in any embodiment of the present invention.
[0041] The present invention has the following beneficial effects: 1. The present invention does not require any prior information for the correction of drug units, and is suitable for scenarios where drug units need to be quickly corrected. 2. The conversion ratio can be quickly determined after the drug units are corrected. 3. The number of drugs can be counted using the corrected drug units. 4. The present invention constructs a drug unit correction mapping table, which is suitable for scenarios where drug data needs to be used again after use. 5. The addition of a manual verification link can promptly handle some difficult problems and ensure the accuracy and efficiency of drug unit correction. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.
[0043] Figure 1 The figure is a schematic diagram of the method flow of embodiment 1. DETAILED DESCRIPTION
[0044] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0045] It should be understood that the step numbers used in this document are only for convenience of description and are not intended to limit the order in which the steps are executed.
[0046] It should be understood that the terms used in the present specification are only for the purpose of describing specific embodiments and are not intended to limit the present invention. As used in the present specification and the appended claims, unless the context clearly indicates otherwise, the singular forms "a", "an" and "the" are intended to include plural forms.
[0047] The terms “include” and “comprising” indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or combinations thereof.
[0048] The term "and / or" means and includes any and all possible combinations of one or more of the associated listed items.
[0049] Embodiment 1:
[0050] In order to make the purpose, technical solutions and advantages of the present invention more clear, the following will be combined with the specific embodiments of the present application and refer to the attached Figure 1 , clearly and completely describe the technical solution of the present invention.
[0051] In order to solve the problems in the prior art, the present invention provides a method for correcting drug units in medical bills, comprising the following steps:
[0052] Step S1, collecting detailed data of medical bills, including: hospital name, drug name, drug manufacturer, drug unit, drug unit price, drug quantity and drug amount; filling or cleaning the missing values of the three fields of drug amount, drug quantity and drug unit price in the detailed data of medical bills;
[0053] Fill the missing values of the drug amount, drug quantity, and drug unit price fields. If any two of the three are missing, and if no data that can be replaced in parallel can be found from other data, delete the data. The example is as follows:
[0054] Ticket ID Hospital Name Drug Name Pharmaceutical manufacturers Pharmaceutical Unit Drug price Quantity of medicines Drug amount 1 H1 M1 C1 piece # / A # / A 118.5 2 H2 M2 C2 bottle # / A 5 200 3 H2 M3 C3 box 3 # / A 180 4 H3 M4 C4 piece 6 30.5 # / A
[0055] For the data with bill ID = 1, first search for the same data as bill 1 from the five dimensions of hospital name, drug name, drug manufacturer, drug unit, and drug amount. Use the mode of drug unit prices in the same data to fill in the missing drug unit price data. At the same time, use the drug quantity corresponding to the mode to fill in the missing drug quantity. The calculation formula is as follows:
[0056] Drug unit price =
[0057] MaxFrequency(hospital name, drug name, drug manufacturer, drug unit, drug amount, drug unit price);
[0058] Among them, the hospital name, drug name, drug manufacturer, drug unit, and drug amount are the same as those in Note 1. If the same data is not found in the data, the data is directly deleted because it is impossible to infer the drug unit price and quantity only from the drug amount.
[0059] For the data with bill ID 2, the missing value of drug unit price can be filled according to the following formula:
[0060]
[0061] For the data with bill ID 3, the missing value of drug quantity can be filled according to the following formula:
[0062]
[0063] For the data with bill ID 4, the missing value of drug amount can be filled according to the following formula:
[0064] Drug amount = drug unit price × drug quantity;
[0065] Step S2, processing the filled drug unit price which is a negative number, or only one of the drug amount and drug quantity is negative data, to ensure that the drug unit price is positive, and the drug amount and drug quantity are both positive and negative; correcting the mismatch between the drug unit price and the quotient of the drug amount and drug quantity, to obtain a corrected drug unit price;
[0066] Step S201 processes the data with a negative drug price or one of the drug amount and drug quantity being negative, to ensure that the drug price is positive and the drug amount and drug quantity are both positive and negative. An example is as follows:
[0067] Ticket ID Hospital Name Drug Name Pharmaceutical manufacturers Pharmaceutical Unit Drug price Quantity of medicines Drug amount 5 H5 M5 C5 piece 586.31 56 -32833.36 6 H6 M6 C6 box -25.56 12 306.72
[0068] For the data with bill ID 5, the drug quantity can be corrected according to the following formula:
[0069]
[0070] For the data with bill ID 6, the drug unit price needs to be corrected to positive, and the drug quantity and drug amount need to be adjusted to negative, that is:
[0071] Ticket ID Hospital Name Drug Name Pharmaceutical manufacturers Pharmaceutical Unit Drug price Quantity of medicines Drug amount 6 H6 M6 C6 box 25.56 -12 -306.72
[0072] Step S202 corrects the mismatch between the drug unit price and the quotient of the drug amount and the drug quantity to obtain a corrected drug unit price, as shown in the following example:
[0073] Ticket ID Hospital Name Drug Name Pharmaceutical manufacturers Pharmaceutical Unit Drug price Quantity of medicines Drug amount 8 H8 M8 C8 grain 2592 24 2592
[0074] Because there are no strict constraints on drug unit prices, it is common to see mismatches between drug unit prices and drug units in medical bills. For example, in the data with bill ID 8, the drug quantity is calculated by pills, but the drug unit price is calculated by box. This causes the following formula to be invalid:
[0075] Drug amount = drug unit price × drug quantity;
[0076] In order to ensure the rationality of the subsequent calculation of drug units, the drug unit price needs to be corrected to obtain the corrected drug unit price. The calculation formula is as follows:
[0077]
[0078] Step S3, constructing a drug unit correction mapping table, including drug name, drug manufacturer, drug correction unit price, drug unit, minimum particle size unit and magnification factor;
[0079] Construct a mapping table of drug name, drug manufacturer, revised drug unit price, drug unit, minimum granularity unit, and magnification factor from drug unit to minimum granularity unit (hereinafter referred to as magnification factor). The table structure is as follows:
[0080] Drug Name Pharmaceutical manufacturers Drug price Pharmaceutical Unit Minimum granularity unit Amplification factor M0 C0 960 box piece 24 M0 C0 240 plate piece 6 M1 C1 200 box branch 5 …… …… …… …… ……
[0081] Step S301, where the amplification coefficient is calculated by the coarse-grained unit drug price and the minimum-grained drug price corresponding to the same "drug name, drug manufacturer, drug amount, and drug quantity". The specific formula is as follows:
[0082]
[0083] Calculate the minimum granularity of the drug according to the magnification factor, and add the drug name, drug unit price, drug manufacturer, drug unit, minimum granularity unit, and magnification factor to the constructed drug unit correction mapping table;
[0084] Step S302, if the minimum granularity unit cannot be obtained through the above method, then count and statistics are performed according to the drug name, drug manufacturer, revised drug unit price, and drug unit to obtain frequency data. If the drug unit with the highest count can be used as the minimum granularity unit, as shown in the following table, the minimum granularity unit of the drug name M0 and unit price 40 is "tablet", and the result is appended to the constructed drug unit correction mapping table.
[0085] Drug Name Pharmaceutical manufacturers Correction of drug unit price Pharmaceutical Unit count M0 C0 40 piece 109 M0 C0 40 box 1 …… …… …… …… ……
[0086] Step S303, if the minimum granularity unit and the magnification factor cannot be calculated by counting statistics, the nearest K modified drug unit prices whose distance to the drug unit price is less than the predetermined threshold can be calculated, and the minimum granularity unit and the magnification factor corresponding to the largest number of drug units of the K modified drug unit prices are used as the minimum granularity unit and the magnification factor, and the calculation results are appended to the constructed drug unit correction mapping table. The specific calculation process is as follows:
[0087] Assume that the unit price of the smallest granularity unit of an unknown drug is P, and for the unit prices of the smallest granularity units of known drugs, P1, P2, ..., P i , calculate the distance between Pi and P respectively:
[0088] d(P i ,P)=|P i -P|;
[0089] The calculated distances are sorted from small to large, and the smallest granularity units with the highest corresponding frequency of the K nearest unit prices are selected as the smallest granularity units, and the magnification factor with the highest corresponding frequency is selected as the magnification factor.
[0090] Step S304: If the above methods still cannot handle the problem, the data needs to be output and corrected through manual experience. At the same time, the calculation results of the algorithm also need to be checked by rules and manually verified. The rule verification mainly checks the rules for data with large differences in quantity and amount, or performs preliminary verification through publicly available data that can be collected. Finally, further proofreading is performed by experienced technicians to ensure the correctness of the results.
[0091] Step S4, modifying the drug unit in the detailed data of the medical bill according to the drug unit modification mapping table to obtain a modified drug unit;
[0092] Step S5, using the detailed data of the revised medical bills as the data basis for calculating the sales volume of the medicines.
[0093] Embodiment 2:
[0094] This embodiment provides a medical bill drug unit correction system, including:
[0095] The data preprocessing module is used to collect detailed data of medical bills, including: hospital name, drug name, drug manufacturer, drug unit, drug unit price, drug quantity and drug amount; fill or clean the missing values of the three fields of drug amount, drug quantity and drug unit price in the detailed data of medical bills;
[0096] The unit price correction module processes the data where the filled drug unit price is negative, or only one of the drug amount and drug quantity is negative, to ensure that the drug unit price is positive, and the drug amount and drug quantity are both positive and negative; the unit price of the drug is corrected if it does not match the quotient of the drug amount and drug quantity, and the corrected drug unit price is obtained;
[0097] A mapping table construction module is used to construct a drug unit correction mapping table, including drug name, drug manufacturer, drug correction unit price, drug unit, minimum granularity unit and magnification factor;
[0098] The unit correction module corrects the drug unit in the detailed data of the medical bill according to the drug unit correction mapping table to obtain the corrected drug unit;
[0099] The sales statistics module uses the detailed data of the revised medical bills as the data basis for calculating drug sales.
[0100] Embodiment three:
[0101] This embodiment provides an electronic device having a computer program stored thereon, wherein when the computer program is executed by a processor, a method for correcting drug units on a medical invoice as described in any embodiment of the present invention is implemented.
[0102] Embodiment 4:
[0103] This embodiment provides a computer-readable medium for storing one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors implement a method for correcting drug units in medical bills as described in any embodiment of the present invention.
[0104] In the embodiments of the present application, "at least one" refers to one or more, and "more than one" refers to two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can represent the existence of A alone, the existence of A and B at the same time, and the existence of B alone. Among them, A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following" and similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one of a, b and c can be represented by: a, b, c, a and b, a and c, b and c, or a and b and c, where a, b, c can be single or multiple.
[0105] Those of ordinary skill in the art will appreciate that the various units and algorithm steps described in the embodiments disclosed herein can be implemented in a combination of electronic hardware, computer software, and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.
[0106] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0107] In several embodiments provided in the present application, if any function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory; hereinafter referred to as: ROM), random access memory (Random Access Memory; hereinafter referred to as: RAM), disk or optical disk, and other media that can store program codes.
[0108] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.
Claims
1. A method for correcting drug units in medical bills, characterized in that: The following steps are involved: Step S1, collecting detailed data of medical bills, including: hospital name, drug name, drug manufacturer, drug unit, drug unit price, drug quantity and drug amount; filling or cleaning the missing values of the three fields of drug amount, drug quantity and drug unit price in the detailed data of medical bills; Step S2, processing the filled drug unit price which is a negative number, or only one of the drug amount and drug quantity is negative data, to ensure that the drug unit price is positive, and the drug amount and drug quantity are both positive and negative; correcting the mismatch between the drug unit price and the quotient of the drug amount and drug quantity, to obtain a corrected drug unit price; Step S3, constructing a drug unit correction mapping table, including drug name, drug manufacturer, drug correction unit price, drug unit, minimum particle size unit and magnification factor; Step S4, modifying the drug unit in the detailed data of the medical bill according to the drug unit modification mapping table to obtain a modified drug unit; Step S5, using the detailed data of the revised medical bills as the data basis for calculating the sales volume of the medicines.
2. A method for correcting drug units in medical bills according to claim 1, characterized in that: The method of filling or cleaning the missing values of the three fields of drug amount, drug quantity, and drug unit price in the detailed data of the medical bill includes the following steps: Fill in data based on the relationship of drug unit price = drug amount / drug quantity; For data that cannot be filled in using the relationship of drug unit price = drug amount / drug quantity, the information of similar drugs is retrieved from the detailed data of medical bills using the four dimensions of hospital name, drug name, drug manufacturer, and drug unit to fill in the missing values, and the remaining missing values are calculated based on the relationship between drug amount, drug quantity, and drug unit price. If any two of the three are missing and it is impossible to find filling data from other data, the data will be cleaned and deleted.
3. A method for correcting drug units in medical bills according to claim 1, characterized in that: The mismatch between the drug unit price and the quotient of the drug amount and the drug quantity is corrected to obtain a corrected drug unit price; the corrected drug unit price is calculated using the following formula:
4. A method for correcting drug units in medical bills according to claim 1, characterized in that: The magnification factor in the drug unit correction mapping table is calculated by the following formula:
5. A method for correcting drug units in medical bills according to claim 1, characterized in that: The minimum granularity unit in the drug unit correction mapping table is filled in the following way: Count and count the drug name, drug manufacturer, revised drug price, and drug unit, and use the drug unit with the highest count as the revised drug unit; The K nearest neighbor voting method is used to confirm the minimum particle size unit and the magnification factor; Calculate the minimum particle size number based on the magnification factor.
6. A method for correcting drug units in medical bills according to claim 5, characterized in that: The K nearest neighbor voting method is used to confirm the minimum granularity unit and the magnification factor. The specific process is as follows: Assume that the unit price of the smallest granularity unit of the unknown drug is P, and the unit prices of the smallest granularity units of the known drugs are P1, P2, ..., P i , calculate the distance between Pi and P respectively: d(P i ,P)=|P i -P|; The calculated distances are sorted from small to large, and the smallest granularity units with the highest corresponding frequency of the K nearest unit prices are selected as the smallest granularity units, and the magnification factor with the highest corresponding frequency is selected as the magnification factor.
7. A medical bill drug unit correction system, characterized in that: include: The data preprocessing module is used to collect detailed data of medical bills, including: hospital name, drug name, drug manufacturer, drug unit, drug unit price, drug quantity and drug amount; fill or clean the missing values of the three fields of drug amount, drug quantity and drug unit price in the detailed data of medical bills; The unit price correction module processes the data where the filled drug unit price is negative, or only one of the drug amount and drug quantity is negative, to ensure that the drug unit price is positive, and the drug amount and drug quantity are both positive and negative; the unit price of the drug is corrected if it does not match the quotient of the drug amount and drug quantity, and the corrected drug unit price is obtained; A mapping table construction module is used to construct a drug unit correction mapping table, including drug name, drug manufacturer, drug correction unit price, drug unit, minimum granularity unit and magnification factor; The unit correction module corrects the drug unit in the detailed data of the medical bill according to the drug unit correction mapping table to obtain the corrected drug unit; The sales statistics module uses the detailed data of the revised medical bills as the data basis for calculating drug sales.
8. A medical bill drug unit correction system according to claim 7, characterized in that: The data preprocessing module fills or cleans the missing values of the three fields of drug amount, drug quantity, and drug unit price in the detailed data of the medical bill, including the following steps: Fill in data based on the relationship of drug unit price = drug amount / drug quantity; For data that cannot be filled in using the relationship of drug unit price = drug amount / drug quantity, the information of similar drugs is retrieved from the detailed data of medical bills using the four dimensions of hospital name, drug name, drug manufacturer, and drug unit to fill in the missing values, and the remaining missing values are calculated based on the relationship between drug amount, drug quantity, and drug unit price. If any two of the three are missing and it is impossible to find filling data from other data, the data will be cleaned and deleted.
9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, a method for correcting drug units in medical bills as described in any one of claims 1 to 6 is implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, a method for correcting drug units in medical bills as described in any one of claims 1 to 6 is implemented.
Citation Information
Patent Citations
Processing method for drug unit switching of intelligent clinic system
CN111477294A