我的角色对象看起来像这样:
"ID,MONTH_ID,FLAG\n70,201001,1\n71,201001,1\n94,201001,1\n95,201001,1\n102,201001,
1\n110,201001,1\n124,201001,1"
我希望将它转换为数据框,每个\n
都应该创建一个新行。
有人能帮我实现吗?
x <- "ID,MONTH_ID,FLAG\n70,201001,1\n71,201001,1\n94,201001,1\n95,201001,1\n102,201001,1\n110,201001,1\n124,201001,1"
df <- read.table(text = x, sep =",", header = TRUE, stringsAsFactors = FALSE)
这将会给出:
ID MONTH_ID FLAG
1 70 201001 1
2 71 201001 1
3 94 201001 1
4 95 201001 1
5 102 201001 1
6 110 201001 1
7 124 201001 1
x <- "ID,MONTH_ID,FLAG\n70,201001,1\n71,201001,1\n94,201001,1\n95,201001,1\n102,201001,1\n110,201001,1\n124,201001,1"
l <- strsplit(x, "\n")
df <- as.data.frame(l)