摘要
文章运用SQL技术对体检数据进行清洗、统计及汇总。先建立清洗规则,通过PL/SQL软件对体检数据去除脏数据,再确定统计规则,产生大量统计汇总结果,通过Excel透视表转换为易读的数据报表。使用SQL高效清洗数据,尤其是SQL组成的存储过程可以快速得出大量统计值,在数据统计、汇总时非常便捷。即便在数据统计汇总规则变化时,SQL也能灵活应对快速产生统计汇总结果,在工作和科研中具有很好的应用价值。
Use SQL technology to clean and summarize physical examination data.First establish cleaning rules,and remove the dirty data of physical examination data through PL/SQL software.Determine the statistical rules,generate a large number of statistical summary results,and convert them into readable data reports through Excel pivot table.Then using SQL can clean data efficiently,especially the stored procedure composed of SQL can quickly get a large number of statistical values,which is very convenient in data statistics and summary.Even when the rules of data statistical summary change,SQL can flexibly respond to the rapid production of statistical summary results,which has a good value in work and scientific research.
作者
王路露
Wang Lulu(Jiangsu Provincial Center for Disease Control and Prevention,Nanjing 210000,China)
出处
《无线互联科技》
2020年第17期46-48,共3页
Wireless Internet Technology
