Hi All,
Is there an easy way to reduce a data.frame to 1 'id' per row while keeping
information from the other rows of that same variable, if applicable? e.g.:
# data
multi[1:15,]
id r n wi wi.tau z k alliance a.rater eml
treatment outcome o.rater german
1 100 0.2800000 44 41 21.72514 0.2876821 210 <NA> <NA> <NA>
<NA> <NA> Client <NA>
2 100 0.2800000 44 41 21.80953 0.2876821 182 <NA> <NA> Early
<NA> <NA> <NA> <NA>
3 100 0.2800000 44 41 22.36641 0.2876821 206 <NA> Client <NA>
<NA> <NA> <NA> <NA>
4 100 0.2800000 44 41 23.59224 0.2876821 188 <NA> <NA> <NA>
<NA> <NA> <NA> Other
5 100 0.2800000 44 41 23.83157 0.2876821 147 WAI <NA> <NA>
<NA> <NA> <NA> <NA>
6 101 0.0000000 37 34 19.65678 0.0000000 182 <NA> <NA> Early
<NA> <NA> <NA> <NA>
7 101 0.5423790 37 34 17.65078 0.6075200 98 <NA> <NA> <NA>
Psychodymic <NA> <NA> <NA>
8 101 0.5423790 37 34 19.58820 0.6075200 210 <NA> <NA> <NA>
<NA> <NA> Observer <NA>
9 101 0.5423790 37 34 21.09334 0.6075200 188 <NA> <NA> <NA>
<NA> <NA> <NA> Other
10 101 0.9075737 37 34 19.65678 1.5135878 182 <NA> <NA> Late
<NA> <NA> <NA> <NA>
11 103a 0.4950000 18 15 10.36364 0.5426615 90 <NA> <NA> <NA>
<NA> SCL <NA> <NA>
12 103a 0.6171548 18 15 11.32425 0.7203964 210 <NA> <NA> <NA>
<NA> <NA> Observer <NA>
13 103a 0.6171548 18 15 11.34714 0.7203964 182 <NA> <NA> Early
<NA> <NA> <NA> <NA>
14 103a 0.6171548 18 15 11.49606 0.7203964 206 <NA> Client <NA>
<NA> <NA> <NA> <NA>
15 103a 0.6171548 18 15 11.81150 0.7203964 188 <NA> <NA> <NA>
<NA> <NA> <NA> Other
# with the goal of having a reduced df (1 id per row) like this:
id r n wi wi.tau z k alliance a.rater eml
treatment outcome o.rater german
1 100 0.2800000 44 41 21.72514 0.2876821 210 wai client early
<NA> <NA> Client other
101 etc...
Ideally, I would like to reduce by id and r, if the values are the same and
keep any discrepant values as a separate row (if possible), e.g.:
6 101 0.0000000 37 34 19.65678 0.0000000 182 <NA> <NA> Early
<NA> <NA> <NA> <NA>
7 101 0.5423790 37 34 17.65078 0.6075200 98 <NA> <NA> Late
Psychodymic <NA> Observer Other
I appreciate any assistance,
AC
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
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.
