Hi Jim, I tried it and it while it does make the diagram look more like what I want, there are a few categories still out of order. Thank you for your help!
-Angela -------------------------------------------- On Thu, 7/23/15, Jim Lemon <drjimle...@gmail.com> wrote: Subject: Re: [R] Ordering in Sankey diagram using R and googleVis Cc: "r-help mailing list" <r-help@r-project.org> Date: Thursday, July 23, 2015, 6:43 AM Hi Angela, Assuming that your reformatted data is named "data", have you tried: data[order(data$count,data$before,decreasing=TRUE),] Jim On Thu, Jul 23, 2015 at 3:15 AM, Angela via R-help <r-help@r-project.org> wrote: > Hello, > > I am trying to figure out if there is a way to order the left side of a Sankey diagram from most frequent to least frequent. I am using R version 3.2.1 and using googleVis version 0.5.9 for the Sankey. I've tried sorting, but that does not work. Is there anyway to force it to arrange the left ("before") side in decreasing frequency? Something I am missing? Does not have to be using [[elided Yahoo spam]] > > -Angela > > Example of the data I have, in a csv file: > > before after > A B > A B > A B > A C > A A > A A > A B > D E > F B > F B > F F > G H > G A > > I reformat the data in R so it looks like this: > > before after count > A B 4 > A C 1 > A A 2 > D E 1 > F B 2 > F F 1 > G H 1 > G A 1 > > Then plot using this: > plot( gvisSankey (data, from="before", to="after", weight="freq", options=list(width=600, height=800, > sankey="{iterations: 2}"))) > > ______________________________________________ > 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. ______________________________________________ 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.