R Scripts for daily, monthly and quarterly data cleaning
-
ACR-reconciliation.R: R script that takes ACR data and cross checks against our internal database to import missing records
-
Append.R: R script that appends two csv files through the gtools package's smartbind function.
-
Reporting.R: R script that cleans and merges data from many files for grant reporting
-
excelDatesFunction.R: If the variable is a factor, converts excel dates in the format Jan 01, 1990 to 1990-01-01
-
chart_of_accounts.R: Script that cleans the Chart of Accounts document for format to upload into TrackVia
-
phone.R: Script that matches Verizon and ShoreTel phone data with patients
-
compare_hie.R: Compares the patient lists in the Unified Report and individual ACO practice patient lists