Re: [R] Time series plot
Here's an example illustrating a way to get a second y axis that has
a different range:
x <- 1:10
y1 <- 2*x
y2 <- 100-3*x+rnorm(10)
par(mar=c(5.1,4.1,4.1,4.1))
plot(x,y1)
par(new=TRUE)
plot(x,y2,xaxt='n',yaxt='n',xlab='',ylab='',pch=3)
axis(4)
mtext('y2',side=4,line=2.5)
-Don
At 2:18 PM +0530 1/4/07, Arun Kumar Saha wrote:
>Dear Gabor,
>
>Thank you very much for your letter. Actually I got partial solution from
>your suggestion. Still I am fighting with defining a secondary axis. More
>pecisely, suppose I have following two dataset:
>
>x = c(1:10)
>y = x*10
>
>To plot x I can simply write plot(x, type='l'), here the"y-axis" takes value
>from 1:10. Now I want to plot y on a Secondary "Y-axis" on same graphics
>window. Secondary y-axis will take value from 1:100 and plot y accordingly,
>just like Microsoft Excel. Is there any solution?
>
>Thanks and regards,
>
>
>
>
>
>On 1/4/07, Gabor Grothendieck <[EMAIL PROTECTED]> wrote:
>>
>> You can use read.zoo in the zoo package to read in the data
>> and then see:
>>
>> https://www.stat.math.ethz.ch/pipermail/r-help/2006-December/122742.html
>>
>> See ?axis for creating additional axes with classic graphics and
>>
>> library(lattice)
>> ?panel.axis
>>
>> in lattice graphics. Search the archives for examples.
>>
>> On 1/4/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote:
>> > Dear all R users,
>> >
>> > Suppose I have a data set like this:
>> >
>> > date price
>> >
>> > 1-Jan-02 4.8803747
>> > 2-Jan-02 4.8798430
>> > 3-Jan-02 4.8840133
>> > 4-Jan-02 4.8803747
>> > 5-Jan-02 4.8749683
>> > 6-Jan-02 4.8754263
>> > 7-Jan-02 4.8746628
>> > 8-Jan-02 4.8753500
>> > 9-Jan-02 4.8882416
>> > 10-Jan-02 4.8895217
>> > 11-Jan-02 4.8871108
>> >
>> > I want to get a time series plot of that dataset. But in x-axis I want
>> to
>> > see the first day, and last day, and other day in between them i.e.
>> > 1-Jan-02, 6-Jan-02, and 11-Jan-02 only. Can anyone tell me how to do
>> that?
>> >
>> > My second question is that is there any way to define a secondary axis
>> like
>> > Microsoft Excel in the same plot window?
>> >
>> > Thanks and regards,
>> > Arun
>> >
>> >[[alternative HTML version deleted]]
>> >
>> > __
>> > R-help@stat.math.ethz.ch 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.
>> >
>>
>
> [[alternative HTML version deleted]]
>
>__
>R-help@stat.math.ethz.ch 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.
--
--
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA
__
R-help@stat.math.ethz.ch 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.
Re: [R] Time series plot
Hi
On 4 Jan 2007 at 14:18, Arun Kumar Saha wrote:
Date sent: Thu, 4 Jan 2007 14:18:11 +0530
From: "Arun Kumar Saha" <[EMAIL PROTECTED]>
To: "Gabor Grothendieck" <[EMAIL PROTECTED]>
Copies to: "r-help@stat.math.ethz.ch"
Subject:Re: [R] Time series plot
> Dear Gabor,
>
> Thank you very much for your letter. Actually I got partial solution
> from your suggestion. Still I am fighting with defining a secondary
> axis. More pecisely, suppose I have following two dataset:
>
> x = c(1:10)
> y = x*10
>
> To plot x I can simply write plot(x, type='l'), here the"y-axis" takes
> value from 1:10. Now I want to plot y on a Secondary "Y-axis" on same
I think you are lost a bit in plotting
let's
x be
x<-rnorm(10)
and
y<-x*10
then
gives you x values on y axis and x axis is 1:10. You can put another
values y on the same plot but only if you give them space before
plot(x, type="l", ylim=range(y))
points(y)
but it is probably not what you want.
If you want to plot time series to get time labels on x axis then
Gabor's solution would be perfectly valid.
Or you can convert your date (which is probably factor) to real time.
> tab=read.table("clipboard", header=T)
> tab
dateprice
1 1-Jan-02 4.880375
2 2-Jan-02 4.879843
3 3-Jan-02 4.884013
4 4-Jan-02 4.880375
5 5-Jan-02 4.874968
6 6-Jan-02 4.875426
7 7-Jan-02 4.874663
8 8-Jan-02 4.875350
9 9-Jan-02 4.888242
10 10-Jan-02 4.889522
11 11-Jan-02 4.887111
tab$newdate <- as.POSIXct(strptime(tab$date, format="%d-%b-%y"))
> str(tab)
'data.frame': 11 obs. of 3 variables:
$ date : Factor w/ 11 levels "1-Jan-02","10-Jan-02",..: 1 4 5 6 7
8 9 10 11 2 ...
$ price : num 4.88 4.88 4.88 4.88 4.87 ...
$ newdate:'POSIXct', format: chr "2002-01-01" "2002-01-02" "2002-01-
03" "2002-01-04" .
plot(tab$newdate, tab$price)
what is what you may want without explicit need for secondary y axis.
HTH
Petr
> graphics window. Secondary y-axis will take value from 1:100 and plot
> y accordingly, just like Microsoft Excel. Is there any solution?
>
> Thanks and regards,
>
>
>
>
>
> On 1/4/07, Gabor Grothendieck <[EMAIL PROTECTED]> wrote:
> >
> > You can use read.zoo in the zoo package to read in the data
> > and then see:
> >
> > https://www.stat.math.ethz.ch/pipermail/r-help/2006-December/122742.
> > html
> >
> > See ?axis for creating additional axes with classic graphics and
> >
> > library(lattice)
> > ?panel.axis
> >
> > in lattice graphics. Search the archives for examples.
> >
> > On 1/4/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote:
> > > Dear all R users,
> > >
> > > Suppose I have a data set like this:
> > >
> > > date price
> > >
> > > 1-Jan-02 4.8803747
> > > 2-Jan-02 4.8798430
> > > 3-Jan-02 4.8840133
> > > 4-Jan-02 4.8803747
> > > 5-Jan-02 4.8749683
> > > 6-Jan-02 4.8754263
> > > 7-Jan-02 4.8746628
> > > 8-Jan-02 4.8753500
> > > 9-Jan-02 4.8882416
> > > 10-Jan-02 4.8895217
> > > 11-Jan-02 4.8871108
> > >
> > > I want to get a time series plot of that dataset. But in x-axis I
> > > want
> > to
> > > see the first day, and last day, and other day in between them
> > > i.e. 1-Jan-02, 6-Jan-02, and 11-Jan-02 only. Can anyone tell me
> > > how to do
> > that?
> > >
> > > My second question is that is there any way to define a secondary
> > > axis
> > like
> > > Microsoft Excel in the same plot window?
> > >
> > > Thanks and regards,
> > > Arun
> > >
> > >[[alternative HTML version deleted]]
> > >
> > > __
> > > R-help@stat.math.ethz.ch 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.
> > >
> >
>
> [[alternative HTML version deleted]]
>
> __
> R-help@stat.math.ethz.ch 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.
Petr Pikal
[EMAIL PROTECTED]
__
R-help@stat.math.ethz.ch 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.
Re: [R] Time series plot
Check out #2 in:
http://finzi.psych.upenn.edu/R/Rhelp02a/archive/85801.html
and RSiteSearch("axis(4") to find additional examples.
On 1/4/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote:
> Dear Gabor,
>
> Thank you very much for your letter. Actually I got partial solution from
> your suggestion. Still I am fighting with defining a secondary axis. More
> pecisely, suppose I have following two dataset:
>
> x = c(1:10)
> y = x*10
>
> To plot x I can simply write plot(x, type='l'), here the"y-axis" takes value
> from 1:10. Now I want to plot y on a Secondary "Y-axis" on same graphics
> window. Secondary y-axis will take value from 1:100 and plot y accordingly,
> just like Microsoft Excel. Is there any solution?
>
> Thanks and regards,
>
>
>
>
>
> On 1/4/07, Gabor Grothendieck <[EMAIL PROTECTED]> wrote:
> > You can use read.zoo in the zoo package to read in the data
> > and then see:
> >
> >
> https://www.stat.math.ethz.ch/pipermail/r-help/2006-December/122742.html
> >
> > See ?axis for creating additional axes with classic graphics and
> >
> > library(lattice)
> > ?panel.axis
> >
> > in lattice graphics. Search the archives for examples.
> >
> > On 1/4/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote:
> > > Dear all R users,
> > >
> > > Suppose I have a data set like this:
> > >
> > > date price
> > >
> > > 1-Jan-02 4.8803747
> > > 2-Jan-02 4.8798430
> > > 3-Jan-02 4.8840133
> > > 4-Jan-02 4.8803747
> > > 5-Jan-02 4.8749683
> > > 6-Jan-02 4.8754263
> > > 7-Jan-02 4.8746628
> > > 8-Jan-02 4.8753500
> > > 9-Jan-02 4.8882416
> > > 10-Jan-02 4.8895217
> > > 11-Jan-02 4.8871108
> > >
> > > I want to get a time series plot of that dataset. But in x-axis I want
> to
> > > see the first day, and last day, and other day in between them i.e.
> > > 1-Jan-02, 6-Jan-02, and 11-Jan-02 only. Can anyone tell me how to do
> that?
> > >
> > > My second question is that is there any way to define a secondary axis
> like
> > > Microsoft Excel in the same plot window?
> > >
> > > Thanks and regards,
> > > Arun
> > >
> > >[[alternative HTML version deleted]]
> > >
> > > __
> > > R-help@stat.math.ethz.ch 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.
> > >
> >
>
>
__
R-help@stat.math.ethz.ch 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.
Re: [R] Time series plot
Dear Gabor, Thank you very much for your letter. Actually I got partial solution from your suggestion. Still I am fighting with defining a secondary axis. More pecisely, suppose I have following two dataset: x = c(1:10) y = x*10 To plot x I can simply write plot(x, type='l'), here the"y-axis" takes value from 1:10. Now I want to plot y on a Secondary "Y-axis" on same graphics window. Secondary y-axis will take value from 1:100 and plot y accordingly, just like Microsoft Excel. Is there any solution? Thanks and regards, On 1/4/07, Gabor Grothendieck <[EMAIL PROTECTED]> wrote: > > You can use read.zoo in the zoo package to read in the data > and then see: > > https://www.stat.math.ethz.ch/pipermail/r-help/2006-December/122742.html > > See ?axis for creating additional axes with classic graphics and > > library(lattice) > ?panel.axis > > in lattice graphics. Search the archives for examples. > > On 1/4/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote: > > Dear all R users, > > > > Suppose I have a data set like this: > > > > date price > > > > 1-Jan-02 4.8803747 > > 2-Jan-02 4.8798430 > > 3-Jan-02 4.8840133 > > 4-Jan-02 4.8803747 > > 5-Jan-02 4.8749683 > > 6-Jan-02 4.8754263 > > 7-Jan-02 4.8746628 > > 8-Jan-02 4.8753500 > > 9-Jan-02 4.8882416 > > 10-Jan-02 4.8895217 > > 11-Jan-02 4.8871108 > > > > I want to get a time series plot of that dataset. But in x-axis I want > to > > see the first day, and last day, and other day in between them i.e. > > 1-Jan-02, 6-Jan-02, and 11-Jan-02 only. Can anyone tell me how to do > that? > > > > My second question is that is there any way to define a secondary axis > like > > Microsoft Excel in the same plot window? > > > > Thanks and regards, > > Arun > > > >[[alternative HTML version deleted]] > > > > __ > > R-help@stat.math.ethz.ch 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. > > > [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch 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.
Re: [R] Time series plot
You can use read.zoo in the zoo package to read in the data and then see: https://www.stat.math.ethz.ch/pipermail/r-help/2006-December/122742.html See ?axis for creating additional axes with classic graphics and library(lattice) ?panel.axis in lattice graphics. Search the archives for examples. On 1/4/07, Arun Kumar Saha <[EMAIL PROTECTED]> wrote: > Dear all R users, > > Suppose I have a data set like this: > > date price > > 1-Jan-02 4.8803747 > 2-Jan-02 4.8798430 > 3-Jan-02 4.8840133 > 4-Jan-02 4.8803747 > 5-Jan-02 4.8749683 > 6-Jan-02 4.8754263 > 7-Jan-02 4.8746628 > 8-Jan-02 4.8753500 > 9-Jan-02 4.8882416 > 10-Jan-02 4.8895217 > 11-Jan-02 4.8871108 > > I want to get a time series plot of that dataset. But in x-axis I want to > see the first day, and last day, and other day in between them i.e. > 1-Jan-02, 6-Jan-02, and 11-Jan-02 only. Can anyone tell me how to do that? > > My second question is that is there any way to define a secondary axis like > Microsoft Excel in the same plot window? > > Thanks and regards, > Arun > >[[alternative HTML version deleted]] > > __ > R-help@stat.math.ethz.ch 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. > __ R-help@stat.math.ethz.ch 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.
[R] Time series plot
Dear all R users, Suppose I have a data set like this: date price 1-Jan-02 4.8803747 2-Jan-02 4.8798430 3-Jan-02 4.8840133 4-Jan-02 4.8803747 5-Jan-02 4.8749683 6-Jan-02 4.8754263 7-Jan-02 4.8746628 8-Jan-02 4.8753500 9-Jan-02 4.8882416 10-Jan-02 4.8895217 11-Jan-02 4.8871108 I want to get a time series plot of that dataset. But in x-axis I want to see the first day, and last day, and other day in between them i.e. 1-Jan-02, 6-Jan-02, and 11-Jan-02 only. Can anyone tell me how to do that? My second question is that is there any way to define a secondary axis like Microsoft Excel in the same plot window? Thanks and regards, Arun [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch 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.
[R] Time series plot
Dear Jiang,
We do a lot of plots of that sort. At first I read the time values with
as.Date(timevariable, format = "%d/%m/%Y"). Then You can plot along like
Plot(as.Date-variable, "your target variable", type = "l")
If You set axes = F than you can customize the xAxis with axis(1, ...)
The AT and LABELS options in axis I fill with something like:
at.x <- seq(as.Date("2006-01-01"), as.Date("2006-05-30"), "month")
lab.x <- paste(format(at.x, "%b"), c(rep("'06", 5)))
So only the month will appear as labels and tickmarks...
HTH
Dubravko
YOU WROTE:
[R] Time series plot
Jiang, Jincai \(Institutional Securities Management\)
Tue, 02 May 2006 15:28:13 -0700
I have some time series data like
01/02/1990 0.531 0.479
01/03/1990 0.510 0.522
01/06/1990 0.602 0.604
there is no weekends and holidays.
how do I graph them in a single plot that the x-axis is the dates and
the y-axis is the time series?
Thank you
Regards,
Dubravko Dolic
Head of eConsulting
Tel:
+49 (0)89-55 27 44 - 4630
Fax:
+49 (0)89-55 27 44 - 2463
Email:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
--
Komdat GmbH
Nymphenburger Straße 86
80636 München
www.komdat.com <http://www.komdat.com/>
--
ONLINE MARKETING THAT WORKS
--
This electronic message contains information from Komdat Gmb...{{dropped}}
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] Time series plot
Try this (where you can replace textConnection(L) with name
of file containing data):
L <- "01/02/1990 0.531 0.479
01/03/1990 0.510 0.522
01/06/1990 0.602 0.604"
library(zoo)
z <- read.zoo(textConnection(L), format = "%m/%d/%Y")
plot(z, plot.type = "single")
This will give more info on zoo:
library(zoo)
vignette("zoo")
library(help = zoo)
On 5/2/06, Jiang, Jincai (Institutional Securities Management)
<[EMAIL PROTECTED]> wrote:
> I have some time series data like
>
> 01/02/1990 0.531 0.479
> 01/03/1990 0.510 0.522
> 01/06/1990 0.602 0.604
>
> there is no weekends and holidays.
> how do I graph them in a single plot that the x-axis is the dates and
> the y-axis is the time series?
> Thank you
>
> Regards,
>
> Jincai Jiang
> (Office) 212-761-3984
>
>
> This is not an offer (or solicitation of an offer) to buy/sell the
> securities/instruments mentioned. Morgan Stanley may deal as principal in or
> own or act as market maker for securities/instruments mentioned or may advise
> the issuers. Any ModelWare, research or other information referenced herein
> is subject to the ClientLink and ModelWare terms of use including all
> applicable disclosures and disclaimers. The information provided speaks only
> as of its date. We have not undertaken, and will not undertake, any duty to
> update the information or otherwise advise you of changes in our opinion or
> in the research or information. Continued access to the research and other
> information is provided for your convenience only, and is not a republication
> or reconfirmation of the opinions or information contained therein. For
> additional information and important disclosures, contact me or see the
> ModelWare website. Past performance is not indicative of future returns. This
> communication i!
s !
> solely for the addressee(s) and may contain confidential information. We do
> not waive confidentiality by mistransmission. Contact me if you do not wish
> to receive these communications. In the UK, this communication is directed in
> the UK to those persons who are market counterparties or intermediate
> customers (as defined in the UK Financial Services Authority's rules).
>
>[[alternative HTML version deleted]]
>
> __
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Time series plot
I have some time series data like 01/02/1990 0.531 0.479 01/03/1990 0.510 0.522 01/06/1990 0.602 0.604 there is no weekends and holidays. how do I graph them in a single plot that the x-axis is the dates and the y-axis is the time series? Thank you Regards, Jincai Jiang (Office) 212-761-3984 This is not an offer (or solicitation of an offer) to buy/sell the securities/instruments mentioned. Morgan Stanley may deal as principal in or own or act as market maker for securities/instruments mentioned or may advise the issuers. Any ModelWare, research or other information referenced herein is subject to the ClientLink and ModelWare terms of use including all applicable disclosures and disclaimers. The information provided speaks only as of its date. We have not undertaken, and will not undertake, any duty to update the information or otherwise advise you of changes in our opinion or in the research or information. Continued access to the research and other information is provided for your convenience only, and is not a republication or reconfirmation of the opinions or information contained therein. For additional information and important disclosures, contact me or see the ModelWare website. Past performance is not indicative of future returns. This communication is ! solely for the addressee(s) and may contain confidential information. We do not waive confidentiality by mistransmission. Contact me if you do not wish to receive these communications. In the UK, this communication is directed in the UK to those persons who are market counterparties or intermediate customers (as defined in the UK Financial Services Authority's rules). [[alternative HTML version deleted]] __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Re: [R] Time series plot orientation
Costas Vorlow wrote: Hello, I am trying to rotate by 90 degrees a time series plot. So I need the time axis to be the vertical one. Is there an easy way? No, you have to do it manually, AFAIK. Uwe Ligges I couldn't guess anything from the help pages. Apologies for a silly question. Regards, Costas __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
[R] Time series plot orientation
Hello, I am trying to rotate by 90 degrees a time series plot. So I need the time axis to be the vertical one. Is there an easy way? I couldn't guess anything from the help pages. Apologies for a silly question. Regards, Costas -- = This e-mail contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional Privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the addressee is strictly prohibited. - Dr. Costas Vorlow | Tel: +44 (0)191 33 45727 Durham Business School | Fax: +44 (0)191 33 45201 Room(324), University of Durham | email: K.E.Vorloou(at)durham.ac.uk Mill Hill Lane, | or : costas(at)vorlow.org Durham DH1 3LB, UK. | http://www.vorlow.org - Fingerprint: B010 577A 9EC3 9185 08AE 8F22 1A48 B4E7 9FA6 C31A __ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
