Clean SISMA .csv exports

clean_sisma_csv() A helper function that cleans .csv pivot tables exported from SISMA clean_sisma_csv has been superseded in favor of clean_sisma_df

Usage

clean_sisma_csv(file)

Arguments

file

Path to a .csv file exported from SISMA that contains data element variables running wide and period and organizational units running long

Value

clean_sisma_csv() returns an object with 7 columns (period, snu, psnu, sitename, sisma_uid, indicator, value). Unnecessary columns from the input file are removed and a period column coded from the input variable periodcode is created. All numeric data element columns that represent indicator or data element values are pivoted long

Examples

 if (FALSE) { # \dontrun{
 df <- clean_sisma_csv()} # }