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.

Download full-text PDF

Source

Publication Analysis

Top Keywords

statistical reports
16
method cleaning
8
cleaning outpatient
8
outpatient data
8
data rapidly
8
rapidly generating
8
generating statistical
8
reports automatically
8
air pollution
8
clean individual
8

Similar Publications

Context: Point-of-care ultrasound (POCUS) has diverse applications across various clinical specialties, serving as an adjunct to clinical findings and as a tool for increasing the quality of patient care. Owing to its multifunctionality, a growing number of medical schools are increasingly incorporating POCUS training into their curriculum, some offering hands-on training during the first 2 years of didactics and others utilizing a longitudinal exposure model integrated into all 4 years of medical school education. Midwestern University Arizona College of Osteopathic Medicine (MWU-AZCOM) adopted a 4-year longitudinal approach to include POCUS education in 2017.

View Article and Find Full Text PDF

Large-scale gene-environment interaction (GxE) discovery efforts often involve analytical compromises for the sake of data harmonization and statistical power. Refinement of exposures, covariates, outcomes, and population subsets may be helpful to establish often-elusive replication and evaluate potential clinical utility. Here, we used additional datasets, an expanded set of statistical models, and interrogation of lipoprotein metabolism via nuclear magnetic resonance (NMR)-based lipoprotein subfractions to refine a previously discovered GxE modifying the relationship between physical activity (PA) and HDL-cholesterol (HDL-C).

View Article and Find Full Text PDF

Objective: The public health nutrition workforce is well-placed to contribute to bold climate action, however tertiary educators are seeking practical examples of how to adequately prepare our future workforce. This study examines the responses of university students engaged in a co-designed planetary health education workshop as part of their public health nutrition training.

Design: A mixed-methods approach was used to collect and interpret student responses to four interactive tasks facilitated during an in-person workshop.

View Article and Find Full Text PDF

Background: Addressing oculoplastic conditions in the preoperative period ensures both the safety and functional success of any ophthalmic procedure. Some oculoplastic conditions, like nasolacrimal duct obstruction, have been extensively studied, whereas others, like eyelid malposition and thyroid eye disease, have received minimal or no research.

Aim: To investigate the current practice patterns among ophthalmologists while treating concomitant oculoplastic conditions before any subspecialty ophthalmic intervention.

View Article and Find Full Text PDF

Historically, psychiatric diagnoses have been made based on patient's reported symptoms applying the criteria from diagnostic and statistical manual of mental disorders. The utilization of neuroimaging or biomarkers to make the diagnosis and manage psychiatric disorders remains a distant goal. There have been several studies that examine brain imaging in psychiatric disorders, but more work is needed to elucidate the complexities of the human brain.

View Article and Find Full Text PDF

Want AI Summaries of new PubMed Abstracts delivered to your In-box?

Enter search terms and have AI summaries delivered each week - change queries or unsubscribe any time!