1ã导å
¥ CSVæ件
1ï¼ä½¿ç¨ read.csvå½æ°å¯¼å
¥CSVæ件
2ï¼read.csvå½æ°è¯æ³ï¼ read.csv (file)
3ï¼æ¡ä¾ï¼ data1 <- read.csv ("D:/data/datatable.csv") --
ç»å¯¹è·¯å¾2ã导å
¥ææ¬æ件
1ï¼ä½¿ç¨ read.tableå½æ°å¯¼å
¥CSVæ件
2ï¼read.tableå½æ°è¯æ³ï¼ read.table (file, header = FALSE, sep="", â¦)
fileï¼æ件路å¾
headerï¼æ件æ é¢è¡ï¼æ件头ï¼ï¼é»è®¤ä¸º FALSEï¼è¡¨ç¤ºæ²¡ææ é¢è¡
sepï¼
åé符ï¼é»è®¤ä¸ºç©ºï¼è¡¨ç¤ºé»è®¤ææ°æ®å¯¼å
¥æä¸å
3ï¼æ¡ä¾
data2 <- read.table ("D:/data/datatable.csv", header = TRUE, sep ="," )
data3 <- read.csv ("D:/data/datatable.csv", header = TRUE, sep ="," )
3ã导å
¥ Excelæ件
1ï¼ Excelæ件导å
¥æ¥éª¤ï¼x86æä½ç³»ç»ï¼
å¼å
¥ RODBCå
install.packages ("RODBC")
library (RODBC)
注ï¼å®è£
å
æ¶ï¼å
åéè¦å å¼å·ï¼èå¼å
¥å
æ¶ä¸å å¼å·ï¼
ä½¿ç¨ odbcConnectExcelå½æ°æ¥è¿æ¥ Excel 2003ï¼
åç¼å为 .xlsï¼
odbcConnectExcelå½æ°è¯æ³ï¼ odbcConnectExcel (file)
æ¡ä¾ï¼ connect1 <- odbcConnectExcel ("D:/data/datatable.xls")
ä½¿ç¨ odbcConnectExcel2007å½æ°æ¥è¿æ¥ Excel 2007ï¼åç¼å为 .xlsxï¼
odbcConnectExcelå½æ°è¯æ³ï¼ odbcConnectExcel2007 (fil