Rè¯è¨Excelæ件
Microsoft Excelæ¯ä½¿ç¨æ广æ³ççµåè¡¨æ ¼ç¨åºï¼å®æ¯ä»¥.xlsæ.xlsxæ ¼å¼åå¨æ°æ®ã Rå¯ä»¥ä½¿ç¨æäºexcelç¹å®çå
ç´æ¥è¯»åè¿äºæ件çå
容ãä¸äºå¸¸ç¨ç软件å
æ - XLConnectï¼xlsxï¼gdataçãå¨è¿ä¸ªç¯æç« ä¸ï¼æ们å°ä½¿ç¨xlsx软件å
ã Rä¹å¯ä»¥ä½¿ç¨è¿ä¸ªå
åå
¥excelæ件ã
å®è£
xlsx软件å
å¯ä»¥å¨Ræ§å¶å°ä¸ä½¿ç¨ä»¥ä¸å½ä»¤æ¥å®è£
xlsx软件å
ãå®å¯è½ä¼è¦æ±å®è£
ä¸äºè¿ä¸ªå
æä¾èµçéå å
ãæç
§ç¸åçå½ä»¤ä¸æéçå
åæ¥å®è£
éå çå
ã
install.packages("xlsx")
R
éªè¯å¹¶å è½½âxlsxâ软件å
使ç¨ä»¥ä¸å½ä»¤æ¥éªè¯åå è½½xlsxå
ãåè以ä¸ä»£ç -
# Verify the package is installed.
any(grepl("xlsx",installed.packages()))
# Load the library into R workspace.
library("xlsx")
R
å½èæ¬è¿è¡æ¶ï¼å¾å°ä»¥ä¸è¾åº -
[1] TRUE
Loading required package: rJava
Loading required package: methods
Loading required package: xlsxjars
Shell
æ³¨ï¼ å¦æ第ä¸ä¸ªè¾åºç»æ为ï¼FALSEï¼è¯· install.packages("xlsx") è¯å¥éæ°å è½½å®è£
ã
åå¤xlsxæ件ç¨ä½ä¸ºè¾å
¥
æå¼Microsoft excelãå°ä»¥ä¸æ°æ®å¤å¶å¹¶ç²è´´å°å为sheet1çå·¥ä½è¡¨ä¸ã
id name salary start_date dept
1 Rick 623.3 1/1/2012 IT
2 Dan 515.2 9/23/2013 Operations
3 Michelle 611 11/15/2014 IT
4 Ryan 729 5/11/2014 HR
5 Gary 843.25 3/27/2015 Finance
6 Nina 578 5/21/2013 IT
7 Simon 632.8 7/30/2013 Operations
8 Guru 722.5 6/17/2014 Finance
Txt
å¦ä¸æ示 -
å¦ä¸æ示 -
è¿å°ä»¥ä¸æ°æ®å¤å¶å¹¶ç²è´´å°å¦ä¸ä¸ªå·¥ä½è¡¨ï¼å¹¶å°æ¤å·¥ä½è¡¨éå½å为cityã
name city
Rick Seattle
Dan Tampa
Michelle Chicago
Ryan Seattle
Gary Houston
Nina Boston
Simon Mumbai
Guru Dallas
å¦ä¸æ示 -
å°Excelæ件å¦å为âinput.xlsxâï¼åºè¯¥å°æ¤æ件ä¿åå¨Rå·¥ä½åºçå½åå·¥ä½ç®å½ä¸ã
读åExcelæ件
使ç¨read.xlsx()å½æ°è¯»åinput.xlsxï¼å¦ä¸æ示ï¼ç»æä½ä¸ºæ°æ®å¸§åå¨å¨Rç¯å¢ä¸ã
# Read the first worksheet in the file input.xlsx.
data <- read.xlsx("input.xlsx", sheetIndex = 1)
print(data)
R
å½æ们æ§è¡ä¸è¿°ä»£ç æ¶ï¼ä¼äº§ç以ä¸ç»æ -
id name salary start_date dept
1 1 Rick 623.30 2012-01-01 IT
2 2 Dan 515.20 2013-09-23 Operations
3 3 Michelle 611.00 2014-11-15 IT
4 4 Ryan 729.00 2014-05-11 HR
5 NA Gary 843.25 2015-03-27 Finance
6 6 Nina 578.00 2013-05-21 IT
7 7 Simon 632.80 2013-07-30 Operations
8 8 Guru 722.50 2014-06-17 Finance
温馨提示:答案为网友推荐,仅供参考