Convert (csv) string object to data frame

Question

My character object looks like this:

"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"

I want to convert it to data frame with every \n a new row should be created.

Can someone please help me in this?

Aramis7d · Accepted Answer · 2017-04-26 10:54:09Z

10

try :

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)

which gives:

   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

answered Apr 26, 2017 at 10:54

Aramis7d

2,49620 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aramis7d Over a year ago

@Sonal glad to know. you may check here

Adamm · Accepted Answer · 2017-04-26 10:45:41Z

-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)

answered Apr 26, 2017 at 10:45

Adamm

2,30425 silver badges35 bronze badges

Collectives™ on Stack Overflow

Convert (csv) string object to data frame

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related