R读写外部文件

目录

• read.table()方法
• read.csv()方法
• readxl包

---

内容

read.table()方法

bank1 <- read.table('user_info.txt', header = F,
                                     sep = ',',
                                     na.strings = 'null',
                                     encoding = 'utf8')

选项：header，标题头；sep，分隔符；na.strings，指定字符串为NA；encoding，编码方式。

---

read.csv()方法：

bank2 <- read.csv('SegData.csv', header = F,
                                 sep = ',',
                                 na.strings = 'null',
                                 encoding = 'utf8')

选项：介绍同上。

---

readxl包

library(readxl)
excel_sheets('ng.3097-S2.xlsx')
#[1] "Sheet1"
f <- read_excel('ng.3097-S2.xlsx', sheet = "Sheet1", col_names = T,range = 'A2:G50')

---