It would make helping you easier if you presented your data
in a format that others could copy and paste into R. E.g.,
z <- list(data.frame(favoriteValue=c(23527,21837),
Classification=c("xxxx","xyxy")),
data.frame(favoriteValue=c(25427,21237,21997),
Classification=c("xxxx","xyxy","xyxy")),
data.frame(favoriteValue=c(99427), Classification=c("xxxx")))
You asked from something that "looks like" comma-separated strings of
numerals.
> zAll <- do.call(rbind, z)
> zAll$ID <- rep(seq_along(z), vapply(z, nrow, 0)) # which data.frame each
row came from
> zAll
favoriteValue Classification ID
1 23527 xxxx 1
2 21837 xyxy 1
3 25427 xxxx 2
4 21237 xyxy 2
5 21997 xyxy 2
6 99427 xxxx 3
> library(dplyr)
> zAll %>% group_by(ID) %>% summarize(favoriteValue = paste(favoriteValue,
collapse=","))
# A tibble: 3 x 2
ID favoriteValue
<int> <chr>
1 1 23527,21837
2 2 25427,21237,21997
3 3 99427
It is usually better say how you intend the use the result of your data
manipulation, rather that how it looks when printed. The comma-separated
strings are not handy for answering questions like "what are the most
common favoriteValues?" or "who has the most favoriteValues?" - the format
used in zAll is better for that.
Bill Dunlap
TIBCO Software
wdunlap tibco.com
On Tue, Nov 6, 2018 at 11:06 AM, JEFFERY REICHMAN <reichm...@sbcglobal.net>
wrote:
> r-help Forum
>
> With a bit of r-help yesterday I was able to structure a JSON file such
> that I can read it within the R environment and export what I need except
> for one list object.
>
> So when I run ....
>
> location <- json.raw[["favorites"]]
> thead(location)
>
> # R returns something like ...
>
> [[1]]
> favoriteValue favoriteType Classification
> 1 23527 https:// ..... xxxx
> 2 21837 https:// ..... xyxy
>
> [[2]]
> favoriteValue favoriteType Classification
> 1 25427 https:// ..... xxxx
> 2 21237 https:// ..... xyxy
> 3 21997 https:// ..... xyxy
>
> [[3]]
> favoriteValue favoriteType Classification
> 1 99427 https:// ..... xxxx
>
>
> What I want (need) is a data frame that looks like
>
> favoriteValue
> 1 23527, 21837
> 2 25427, 21237, 21997
> 3 99427
>
> Jeff Reichman
>
> ______________________________________________
> R-help@r-project.org 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.
>
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org 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.
