[Development of a method for cleaning outpatient data rapidly and generating statistical reports automatically to the analysis of time series on the air pollution and disease].
Wei sheng yan jiu = Journal of hygiene research(2016)
Abstract
OBJECTIVE:To develop a method for cleaning the outpatient data rapidly and generating the statistical reports automatically.
METHODS:Formulating the cleaning rules according to the data characters, writing programs to clean the individual cases and generate the statistical reports using the SQL language.
RESULTS:It could clean the different individual cases rapidly, calculate the daily outpatient visits and generate the statistical reports automatically with high accuracy.
CONCLUSION:The method can apply to the data processing of the hospital cases, first aid cases, cause-of-death data and health records. It not only can process large amounts of data flexibly, conveniently and quickly, but also has great practical value. So it is the necessary way to the health risk assessment of air pollution.
MoreTranslated text
Key words
SQL,analysis of time series,classification of disease,data cleaning,statistical report
AI Read Science
Must-Reading Tree
Example
![](https://originalfileserver.aminer.cn/sys/aminer/pubs/mrt_preview.jpeg)
Generate MRT to find the research sequence of this paper
Chat Paper
Summary is being generated by the instructions you defined