I am trying to read data separated with :: (two colons) in R. When I use sep = "::"
with read.table function, I get an error message, "sep value must be one byte." I am wondering if I can read this data in R. I did not have any problem with reading this data in Python.
For now, I use sep=":"
and then get NA's in columns that were the other ":". So I delete columns of NA's. Is there a way to read data directly by specifying sep = "::" in R?
Let's say we have:
A::B::C
23::34::56
12::56::87
90::43::74
in a txt file. Then we can do:
lines <- readLines("doublesep.txt")
> lines
[1] "A::B::C" "23::34::56" "12::56::87" "90::43::74"
lines <- gsub("::", ",", lines)
> lines
[1] "A,B,C" "23,34,56" "12,56,87" "90,43,74"
Now, you can either write to a file or convert to a data.frame
object:
> read.table(text=lines, sep=",", header=T)
A B C
1 23 34 56
2 12 56 87
3 90 43 74
> writeLines(lines, "doubletosingle.csv")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With