Your posting arrives as plain text so it is impossible to see what you had
highlighed in red. Also it is very difficult to see what is in that data.frame.
Could you either reduce the data.frame to make minimal, self-contained,
reproducible code. A good approach might be to use dput to create a handy form
of the data.frame that a reader can easily use. See ?dput
--- On Fri, 7/31/09, Meenu Sahi <meenusahi at gmail.com> wrote:
> From: Meenu Sahi <meenusahi at gmail.com>
> Subject: [R] Fill dataframe from a table according to a criteria
> To: "R" <r-help at r-project.org>
> Received: Friday, July 31, 2009, 12:13 PM
> Deare R users
>
> I am new to R.
> What I want to do is explained below;-
> I have table called States.Prob which is given below
> ? ? ? ? ? ? ?
> ???Prob of States
> Changes? State1? State2 State3 State4
> A? ? ? ? ?
> ???Pa1? ? ? Pa2?
> ???Pa3? ???Pa4
> B? ? ? ? ?
> ???Pb1? ? ? Pb2?
> ???Pb3? ???Pb4
> C? ? ? ? ?
> ???Pc1? ? ? Pc2?
> ???Pc3? ???Pc4
> D? ? ? ? ?
> ???Pd1? ? ? Pd2?
> ???Pd3? ???Pd4
>
> and I have a dataframe called mydata which is given below
> where I want to
> fill in the last four columns of probabilities taken from
> States.Prob
> according to the change and state in mydata4:-
> PxMid EU0006MIndex.x DMSW1Curncy.x DMSW2Curncy.x
> DMSW3Curncy.x
> 1 01/01/2003? ? ? ? 2.80113?
> ? ? ? 2.7070? ? ? ?
> 2.8920? ? ? ? 3.1720
> 2 01/01/2007? ? ? ? 3.85350?
> ? ? ? 4.0760? ? ? ?
> 4.1250? ? ? ? 4.1230
> 3 01/02/2002? ? ? ? 3.41563?
> ? ? ? 3.6385? ? ? ?
> 4.0810? ? ? ? 4.3587
> 4 01/02/2006? ? ? ? 2.70000?
> ? ? ? 2.9545? ? ? ?
> 3.1672? ? ? ? 3.2792
> 5 01/05/2002? ? ? ? 3.49863?
> ? ? ? 3.7940? ? ? ?
> 4.2300? ? ? ? 4.4920
> 6 01/05/2006? ? ? ? 3.03588?
> ? ? ? 3.3254? ? ? ?
> 3.5950? ? ? ? 3.7380
> ? DMSW4Curncy.x DMSW5Curncy.x DMSW6Curncy.x
> DMSW7Curncy.x DMSW8Curncy.x
> 1? ? ? ? 3.4360? ? ?
> ? 3.6640? ? ? ? 3.8640? ?
> ? ? 4.0360? ? ? ? 4.1790
> 2? ? ? ? 4.1230? ? ?
> ? 4.1250? ? ? ? 4.1350? ?
> ? ? 4.1460? ? ? ? 4.1620
> 3? ? ? ? 4.5487? ? ?
> ? 4.6988? ? ? ? 4.8313? ?
> ? ? 4.9338? ? ? ? 5.0138
> 4? ? ? ? 3.3627? ? ?
> ? 3.4342? ? ? ? 3.4899? ?
> ? ? 3.5437? ? ? ? 3.5941
> 5? ? ? ? 4.7650? ? ?
> ? 4.8675? ? ? ? 5.0550? ?
> ? ? 5.1600? ? ? ? 5.2400
> 6? ? ? ? 3.8290? ? ?
> ? 3.9050? ? ? ? 3.9690? ?
> ? ? 4.0240? ? ? ? 4.0750
> Change? State? PState1? PState2?
> PState3? PState4
> 1 B? ? ???State1? Pb1
> 2 A? ? ???State4? ?
> ? ? ? ? ? ? ? ?
> ? ? ? ? ? ? ? ?
> ? ? ???Pa4
> 3 B? ? ???State2? ?
> ? ? ? ? ? ? Pb2
> 4 C? ? ???State3? ?
> ? ? ? ? ? ? ? ?
> ? ? ? ???Pc3
> 5 D? ? ???State1? Pd1
> 6 A? ? ???State3? ?
> ? ? ? ? ? ? ? ?
> ? ? ? ???Pa3
>
> What I want to do is highlighted in Red.
> How can I do this easily?
>
> Many thanks for your time.
>
> kind regards
> Meenu
>
> ??? [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>
__________________________________________________________________
Looking for the perfect gift? Give the gift of Flickr!