[R] Multiple line Graphs

TwistedSkies david.vicary at talbotuw.com
Fri Mar 30 11:16:13 CEST 2012


Hi Guys,

I am trying to create 20 indivudual line graphs that will be updated on a
weekly bases. I have managed to read in my data from SQL and defined my
loop. I am having difficulty in plotting the data and I think it may have
something to do with the way my data has been read in and maybe I need to
change it in a dataframe?!

Easch graph will be based on PolyNam, so this is defined in the loop, then
the date will be X - Axis and the Total the Y-Axis.

I have tried to upload the data as a .csv but it has been blocked so below
is some sample data, if you would like me to e-mail it over to you then just
let me know! Many Thanks for your help in advance 



                  PolyNam                                              Date         
Total
1      Australia_North_East_250km               2012-03-09    707304183
2      Australia_North_East_250km               2012-03-16    364042592
3      Australia_North_East_250km               2012-03-23    353652092
4      Australia_North_West_250km              2012-03-09    1332721712
5      Australia_North_West_250km              2012-03-16    1039809829
6      Australia_North_West_250km              2012-03-23    1039809829
7      Chile_North_250km                              2012-03-09   
141406503
8      Chile_North_250km                              2012-03-16   
101125272
9      Chile_North_250km                              2012-03-23    79043252
10    Dominican_Republic_Puerto_Rico       2012-03-09    321944081
11    Dominican_Republic_Puerto_Rico       2012-03-16    197842161
12    Dominican_Republic_Puerto_Rico       2012-03-23    184308866
13    FL_CBX_250km                                      2012-03-09   
108743687
14    FL_CBX_250km                                      2012-03-16   
54371843
15    FL_CBX_250km                                      2012-03-23   
62259843
16    Greece_Athens_250km                        2012-03-09    81823979
17    Greece_Athens_250km                        2012-03-16    42513139
18    Greece_Athens_250km                        2012-03-23    42513139
19    Hong_Kong_250km                               2012-03-09    31929125
20    Hong_Kong_250km                               2012-03-16    222436862
21    Hong_Kong_250km                               2012-03-23    222436862
22    Lebanon_Jerusalem_250km                2012-03-09    229025783
23    Lebanon_Jerusalem_250km                2012-03-16    137147675
24    Lebanon_Jerusalem_250km                2012-03-23    113036204
25    Mexico_Mexico_City_250km                2012-03-09    217923016
26    Mexico_Mexico_City_250km                2012-03-16    108961508
27    Mexico_Mexico_City_250km                2012-03-23    108961508
28    New_Zealand_Christchurch_250km   2012-03-09    135376966
29    New_Zealand_Christchurch_250km   2012-03-16    68064202
30    New_Zealand_Christchurch_250km   2012-03-23    68064202
31    New_Zealand_Wellington_250km      2012-03-09    16157602
32    New_Zealand_Wellington_250km      2012-03-16    7972088
33    New_Zealand_Wellington_250km      2012-03-23    7972088
34    Panama_Panama_City_250kms          2012-03-09    277630042
35    Panama_Panama_City_250kms          2012-03-16    260942688
36    Panama_Panama_City_250kms          2012-03-23    249112188
37    Peru_Lima_250km                               2012-03-09    342099837
38    Peru_Lima_250km                               2012-03-16    252701245
39    Peru_Lima_250km                               2012-03-23    257780890
40    Peru_South_East_250km                     2012-03-09    217545181
41    Peru_South_East_250km                     2012-03-16    118772591
42    Peru_South_East_250km                     2012-03-23    108772591
43    Philippines_Manilla_250km                2012-03-09    71038944
44    Philippines_Manilla_250km                2012-03-16    35519472
45    Philippines_Manilla_250km                2012-03-23    35519472
46    Santiago_250km                                  2012-03-09    37031152
47    Santiago_250km                                  2012-03-16    18515576
48    Santiago_250km                                  2012-03-23    18515576
49    Taiwan_250km                                    2012-03-09    
501738165
50    Taiwan_250km                                    2012-03-16    
250295303
51    Taiwan_250km                                    2012-03-23    
277197503
52    Turkey_Istanbul_250km                     2012-03-09     127543804
53    Turkey_Istanbul_250km                     2012-03-16     81947417
54    Turkey_Istanbul_250km                     2012-03-23     81947417
55    US_Los_Angeles_250km                     2012-03-09     743519687
56    US_Los_Angeles_250km                     2012-03-16     387822959
57    US_Los_Angeles_250km                     2012-03-23     371759844
58    US_San_Francisco_250km                  2012-03-09    595288671


--
View this message in context: http://r.789695.n4.nabble.com/Multiple-line-Graphs-tp4518505p4518505.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list