Function

コメント・参照等

FUN = f_read_demographics.r
function (download_folder, sheet = 2) 
{
    lapply(c("XLConnect", "Nippon"), require, character.only = T)
    path_to_folder <- paste0("C:/Users/", Sys.info()["user"], download_folder)
    setwd(path_to_folder)
    xls_files <- dir()
    sheet_name0 <- XLConnect::getSheets(XLConnect::loadWorkbook(xls_files))
    buf0 <- readWorksheetFromFile(xls_files, sheet = sheet, check.names = F, header = F)
    if (sheet == 2) {
        unittxt <- zen2han(buf0[2, 13])
        datapart0 <- as.numeric(buf0[, 1]) %>% is.na %>% `!` %>% which %>% buf0[., ]
        datapart0[, 1] <- seq(from = as.Date(paste0(datapart0[1, 1], "-1-1")), by = "+1 year", length.out = nrow(datapart0))
        patterntxt <- "△"
        datapart0[, -1] <- apply(datapart0[, -1], 2, function(x) (as.numeric(gsub("\\s|[0-9]+\\)|\\*", "", gsub(patterntxt, "-", x)))))
        namepart0 <- as.numeric(buf0[, 1]) %>% is.na %>% `!` %>% which %>% head(1) %>% seq(from = 1, to = .) %>% buf0[., ] %>% head(., -1)
        colnametxt <- gsub("\\s|NA|[0-9]\\)|\\(再.*掲\\)", "", sapply(paste0(namepart0[3, ], namepart0[4, ], namepart0[5, ], namepart0[6, ]), zen2han))
        colnames(datapart0) <- colnametxt
        datadf <- datapart0[, colnames(datapart0) != ""]
        datadf <- datadf[, -tail(grep("年次", colnames(datadf)), 1)]
        rownames(datadf) <- NULL
    }
    return(list(datadf = datadf, unittxt = unittxt))
}