Thank to Ulrik for the hint.
However, I don't comprehend the function until now:
For example I made up an array "input":
input
kop
[1,] "w;d;e;f"
[2,] "w;d;e;f"
[3,] "w;d;e;f"
[4,] "w;d;e;f"
[5,] "w;d;e;f"
and tried to break it into four cols with commmand:
output<-separate(into,kop,into=c("a","b","c","d"),sep=";")
R returned:
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!
Yours, Ferri
Gesendet: Dienstag, 22. November 2016 um 14:57 Uhr
Von: "Ulrik Stervbo" <[email protected]>
An: "Ferri Leberl" <[email protected]>, "r-helpr-project.org"
<[email protected]>
Betreff: Re: [R] Breaking down a list into a table
Hi Ferri,
It sounds like the function 'separate' from the tidyr package is what you look
for,
HTH
Ulrik
On Tue, 22 Nov 2016 at 14:49 Ferri Leberl
<[email protected][mailto:[email protected]]> wrote:
Dear All,
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.
Yours, Ferri
______________________________________________
[email protected][mailto:[email protected]] mailing list -- To
UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help[https://stat.ethz.ch/mailman/listinfo/r-help]
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.
______________________________________________
[email protected] mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.