[R] Breaking down a list into a table
ferri.leberl at gmx.at
Wed Nov 30 16:18:19 CET 2016
Thank to Ulrik for the hint.
However, I don't comprehend the function until now:
For example I made up an array "input":
and tried to break it into four cols with commmand:
Fehler in UseMethod("separate_") :
nicht anwendbare Methode für 'separate_' auf Objekt der Klasse "c('matrix', 'character')" angewendet
Could you please explain me my mistake?
Thank you in advance!
Gesendet: Dienstag, 22. November 2016 um 14:57 Uhr
Von: "Ulrik Stervbo" <ulrik.stervbo at gmail.com>
An: "Ferri Leberl" <ferri.leberl at gmx.at>, "r-helpr-project.org" <r-help at r-project.org>
Betreff: Re: [R] Breaking down a list into a table
It sounds like the function 'separate' from the tidyr package is what you look for,
On Tue, 22 Nov 2016 at 14:49 Ferri Leberl <ferri.leberl at gmx.at[mailto:ferri.leberl at gmx.at]> wrote:
I asked for support to deal with a hirarchy within a character separated list.
I solved the problem crudely but effectively by
- Choosing for a TSV as input, where in columns that may contain several (or as well no) items the items are separated via semicolon
- adding semicolons to the first row to grant that the first row has the maximum number of semicolons of this column
- grasping the column(x<-myarray[,y], where y is some integer value) and saving it as a TSV (with only one column)
- importing it again, defining it semicolumn-separated, with fill option
To all those who feel pain reading this: Is there a shortcut?
Thank you in advance.
R-help at r-project.org[mailto:R-help at r-project.org] mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html[http://www.R-project.org/posting-guide.html]
and provide commented, minimal, self-contained, reproducible code.
More information about the R-help