[R] Conversion to xlsx file

Hi, all I would like to convert xls files to xlsx files with R commands in R console instead of saving xls files as xlsx files after opening xls files. Please show me how. Thanks. Wonjae -- View this message in context: http://r.789695.n4.nabble.com/Conversion-to-xlsx-file-tp3487118p3487118.h

[R] How to call data elements

Hi, I have a stupid and simple question. Please forgive me. In an example below, please tell me how to call "1947" in mydata. Thank you in advance. Wonjae > mydata [[1]] [1] "1947""83" "234.289" "235.6" "159" "107.608" "1947" [8] "60.323" > mydata[[1],1] error:unex

[R] as.Date function error

Hi, I have some problems with as.Date function. After I applied as.Date for my data, "2010" changed to "2020" as below Where am I wrong? Thanks Wonjae > x=c("11/16/2010","11/17/2010","11/18/2010","11/19/2010") > x=as.Date(x,"%m/%d/%y") > x [1] "2020-11-16" "2020-11-17" "2020-11-18" "2020-11-19"

[R] as.Date error

Thank you for replying the as.Date error question. I have one more question as below. I used cbind command, and data x changed, 2010-11-16 to 14929, 2010-11-17 to 14930. What happened to them? What should I do to see -mm-dd format data? > x=c("11/16/2010","11/17/2010","11/18/2010","11/19/201

[R] How to convert 3-digits hours

Hi, all Here is what I tried to do. > strptime('20110101 0900',"%Y%m%d %H%M") [1] "2011-01-01 09:00:00" > strptime('20110101 900',"%Y%m%d %H%M") [1] NA If I have a 3-digit hour like '900', please show me how to convert it to 09:00:00. Thank you in advance. Wonjae -- View this message in co