关键词: 骨折, 药膏, 用药规律, 数据挖掘, R 软件

Abstract: Objective To analyze the prescription and medicine information of Chinese Medical Formulas for the external treatment of fracture based on R software，and to analyze the prescription and medicine pattern of the external treatment of fracture by Chinese medicine cream. Methods The prescription information of ointment for external treatment of bone fracture was extracted from Chinese Medical Formulas，Excel software was used to enter the information of the ointment to establish a ″database of Chinese Medical Formulas for external treatment of bone fracture by ointment″，and R software was used to analyze the frequency，correlation，association rule，and cluster analyses of the ointment prescriptions.Results A total of 103 ointment prescriptions with 246 Chinese herbs were included，and the cumulative frequency of use was 931. Among them，there were 23 Chinese herbs with a usage frequency ≥ 10 times，with a cumulative usage frequency of 388 times（41. 68%）. The top 5 herbal medicines were Ruxiang（Olibanum），Moyao（Myrrha），Danggui（Angelicae Sinensis Radix），Rougui（Cinnamomi Cortex），and Baizhi（Angelicae Dahuricae Radix）in order. The efficacy of herbal medicines was mainly classified as activating blood circulation and resolving blood stasis，clearing heat，and tonifying deficiency；the medicinal properties were mainly warm；the taste was mainly pungent and bitter；and the meridians were mainly liver，spleen，heart，and kidney. The top 5 herbal combinations with higher correlation coefficients were mostly blood activators and heat-clearing drugs. The top 3 selected added media were wine，ginger juice and vinegar in order. 16 core herbal combinations were obtained by association rule analysis，and 4 herbal clustering combinations were obtained by systematic clustering analysis.Conclusion The core herbal formulas for external treatment of fracture with Ruxiang（Olibanum），Moyao（Myrrha），Danggui（Angelicae Sinensis Radix）， and Tubiechong（Eupolyphaga）are based on the principles of reducing swelling and pain， activating blood stasis，and tonifying the kidney to strengthen the tendons and bones. The dosing rules derived from data mining technology have certain reference values for the clinical use of external treatment of fractures with creams. They can also provide a reference for new drug development.

Key words: fracture, ointment, medication pattern, data mining, R software