data_clean: Basic cleaning of data
In lhmet/rinmetxls: Read Meteorological Data From Excel Files Distribuited By INMET

Description Usage Arguments Details Value See Also Examples

Clean variable names and parse date

1	data_clean(data.xls)

data.xls

data frame output from xls_read

This function parse dates, nomalize 'variable names' appending the hour after each one. Date column is added in last column. Files were processed in Excel and SO Windows. There is a note about the origin in dates from Windows Excel. Date given as number of days since 1900-01-01, e.g. as.Date(32768, origin = "1900-01-01") is a date in 1989. Excel is said to use 1900-01-01 as day 1 (Windows default) but this is complicated by Excel incorrectly treating 1900 as a leap year. We use as origin '1899-12-30' to correctly parse dates. Please see http://support.microsoft.com/kb/214330 for details.

data frame with the same values as the input data, but colnames are normalized and dates are parsed. All variables are character vectors.

Other data processing: data_tidy, varnames_recode

## Not run: 
if(interactive()){
xfiles_l <- list.files("vignettes/dvd_xls_files", recursive = TRUE, full.names = TRUE)
xls_file <- xfiles_l[1]
raw_data <- xls_read(xls_file)
clean_data <- data_clean(raw_data)
str(clean_data)
 }

## End(Not run)