I have a text file of data as below and doing a ggplot line plot of all the ids
as separate mini line plots which works with the following code.
Problem how do I order the dates for each id plot on the x axis so that the
dates are going from oldest to most recent????
Thanks in advance
Dave
CODE:
a<-read.table("DATA",header=TRUE);
b<-a[order(as.Date(a$date, format="%m/%d/%Y")),]
ggplot(data=b) + geom_line(aes(x=date, y=value, group=id, colour= factor(id)))
+ facet_wrap(~id, scales = "free")
DATA:
id date value
001 8/16/10 <0.16
001 10/25/10 <0.16
001 11/8/10 0.42
001 11/22/10 0.81
001 12/6/10 <0.16
002 8/18/10 2.93
002 10/25/10 2.4
002 11/8/10 1.36
002 11/22/10 1.22
004 8/20/10 0.77
004 10/25/10 0.85
004 11/8/10 1.22
004 11/22/10 0.21
004 12/6/10 1.81
004 10/26/11 0.54
005 6/4/09 1.33
005 6/18/10 1.32
005 8/25/10 2.5
005 9/15/10 1.3
005 10/25/10 1.1
005 11/8/10 0.66
005 11/22/10 0.84
005 12/6/10 7.42
005 11/4/11 1.21
006 9/23/10 0.97
006 10/25/10 2.25
006 11/8/10 0.51
006 11/22/10 0.53
006 12/6/10 0.41
008 8/25/10 3.14
008 10/25/10 3.58
008 11/8/10 2.41
008 12/6/10 2.08
008 6/11/12 3.2
009 10/6/10 0.24
009 11/22/10 0.34
009 2/2/11 0.58
009 2/16/11 0.54
009 3/2/11 0.25
009 3/16/11 0.39
010 9/14/10 0.28
010 2/2/11 0.19
010 2/16/11 0.42
010 3/2/11 0.39
010 3/16/11 0.26
011 8/20/10 <0.16
011 2/2/11 <0.16
011 2/16/11 <0.16
011 3/2/11 <0.16
011 3/16/11 1.76
011 10/26/11 <0.16
012 12/14/10 0.48
012 2/2/11 1.2
012 2/16/11 0.44
012 3/2/11 0.32
012 3/16/11 0.34
013 11/13/09 0.73
013 8/19/10 3.32
013 2/2/11 13.7
014 2/6/13 1.35
014 4/24/13 0.85
014 8/18/10 0.66
014 10/5/10 0.68
014 10/27/10 0.53
014 2/2/11 0.54
014 2/16/11 0.49
014 3/2/11 0.31
014 3/16/11 0.4
014 6/29/11 0.53
014 8/15/11 0.55
014 8/15/12 0.94
014 10/31/12 0.74
015 12/10/10 0.4
015 2/2/11 0.44
015 3/2/11 0.38
015 3/16/11 0.43
016 12/17/10 0.18
016 1/25/11 <0.16
016 2/2/11 0.53
016 2/2/11 0.54
016 2/16/11 0.46
016 3/2/11 0.29
016 3/16/11 0.2
016 3/20/12 0.18
016 3/26/12 0.23
016 3/30/12 0.52
016 4/2/12 0.33
016 4/23/12 0.3
017 11/17/11 3.35
017 12/9/11 2.56
018 2/25/13 18.1
018 3/11/13 14.9
018 3/25/13 11.1
018 4/10/13 8.47
018 4/22/13 15.9
______________________________________________
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.
