Re: st: RE: complicated scatterplot with connected points

[Antoine Terracol <terracol@univ-paris1.fr>]

Gisella,

is this what you are looking for?

clear
input str10 id_city        x1   y1   x2    y2    x3   y3  str10 city1 
 str10   city2    str10   city3
"Portland"    34   64   23    78    54   67   "Portland1"  "Portland2" 
"Portland3"
"Chicago"     53   72   33    52    91   77   "Chicago1"   "Chicago2" 
"Chicago3"
"Boston"      50   70   30    50    90   70   "Boston1"   "Boston2" 
"Boston3"
end

reshape long x y city, i(id_city) j(period)

sort id_city period

twoway (connected y x if id_city=="Portland", mlabel(city)) ///
(connected y x if id_city=="Chicago", mlabel(city)) ///
(connected y x if id_city=="Boston", mlabel(city))

Antoine

On 05/12/2010 15:54, Gisella Young wrote:
> Dear Nick (and others),
>
> Thank you for the hint but unfortunately I have not been able to see how this solves the problem. Reshaping the data as you suggest is not a problem, but I still can't see how to connect the scatterplot points with lines in the specific way needed. Perhaps you (or someone else) could give a further clue, or elaborate some of the other various approaches that you mention exist?
>
> Thanks for the help.
>
> regards,
> Gisella
>
>
> --- On Fri, 12/3/10, Nick Cox<n.j.cox@durham.ac.uk>  wrote:
>
> > From: Nick Cox<n.j.cox@durham.ac.uk>
> > Subject: st: RE: complicated scatterplot with connected points
> > To: "'statalist@hsphsun2.harvard.edu'"<statalist@hsphsun2.harvard.edu>
> > Date: Friday, December 3, 2010, 5:44 PM
> > There are various approaches to this.
> > One is to restructure your data so that the graphics command
> > becomes easier.
> >
> > preserve
> > reshape long x y, i(city)
> >
> > Spelling is Stata.
> >
> > Nick
> > n.j.cox@durham.ac.uk
> >
> >
> > Gisella Young
> >
> > I want to draw a slightly complex scatterplot in STATA and
> > have not been able to find a way how. For each city I have 3
> > points (each with a x- and y-coordinate) for 3 different
> > years. I can use the -twoway- graphics command to do three
> > overlaid scatterplots so that each city has 3 points, one
> > for each year. The tricky part: to CONNECT (with a line) the
> > three points for each city, so as to trace its path over
> > time.
> >
> > The command I am using at the moment, for the basic
> > scatterplot without connecting lines, is:
> >   twoway (scatter x y1, sort mlabel(city1)) (scatter x2 y2,
> > sort mlabel(city2)) (scatter x3 y3, sort mlabel(city3))
> >
> >
> > My data has the following structure:
> >
> > city
> > x1   y1   x2
> > y2
> > x3   y3   city1
> >    city2      city3
> >
> > Portland
> > 34   64   23
> > 78
> > 54   67   Portland1
> > Portland2  Portland3
> > Chicago
> >     53   72   33
> >    52
> > 91   77   Chicago1   Chicago2   Chicago3
> > Boston      etc
> >
> >
> > I would greatly appreciate any suggestions. Thank you!
> >
> >
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/help.cgi?search
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
>
>
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/