Advertisement
celestialgod

read_xls_utf8

Jul 3rd, 2015
340
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
R 0.83 KB | None | 0 0
  1. library(rJava)
  2. library(xlsx)
  3. library(data.table)
  4. library(magrittr)
  5.  
  6. fileName = "birdnames.xls"
  7. original_data = read.xlsx2(fileName, 1,
  8.   header=TRUE, encoding = "UTF-8", as.data.frame=FALSE) %>%
  9.   do.call(cbind, .) %>% data.table()
  10.   # data.table在這裡是非必要,為了後面的setnames而用的
  11. data_names = read.xlsx2(fileName, 1,
  12.   header=FALSE, startRow=1, endRow=1, encoding = "UTF-8",
  13.   as.data.frame=FALSE) %>% unlist() # 這行是因為header通常讀不進去要手動
  14. original_data %<>% setnames(data_names)
  15.   # setnames是data.table的function,提供不複製直接重新命名data.table的方法
  16.   # 如果前面不用data.table,這裡可以改成用magrittr的set_names*[m
  17.   # 或是直接用names() <-
  18. original_data$c_name
  19.  
  20.  
  21. library(readxl)
  22. fileName = "birdnames.xls"
  23. dat = read_excel(fileName)
  24. dat$c_name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement