I have two data frames like so> qpisoiso requests 1 A1 20 2 A2 199 3 AD 5 4 AE 176 ... 189 ZW 82> qplegitiso requests 1 A2 36 2 AE 4 3 AM 2 4 AO 1 ... 100 ZW 3 I want to create another dataframe qpspam which contains all pairs from pqiso with the values for requests of qplegit being subtracted from those which exist in qpiso, ie iso requests 1 A1 20 2 A2 163 3 AD 5 4 AE 172 ... 189 ZW 79 but don't know how to do this, and google isn't too helpful. As usual, a solution is preferred, but a pointer to where I can read this up is equally appreciated :-)-O el
If you really prefer solution code, then provide reproducible example code as
the footer requests.
Use ?merge with the all.x=TRUE parameter, and then perform your calculations on
the resulting combined data frame, using ?ifelse and ?is.na as needed.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
On June 29, 2014 9:24:39 AM PDT, Dr Eberhard Lisse <nospam at lisse.NA>
wrote:>I have two data frames like so
>
>> qpiso
> iso requests
>1 A1 20
>2 A2 199
>3 AD 5
>4 AE 176
>...
>189 ZW 82
>
>> qplegit
> iso requests
>1 A2 36
>2 AE 4
>3 AM 2
>4 AO 1
>...
>100 ZW 3
>
>
>I want to create another dataframe qpspam which contains all pairs
>from pqiso with the values for requests of qplegit being subtracted
>from those which exist in qpiso,
>
>ie
> iso requests
>1 A1 20
>2 A2 163
>3 AD 5
>4 AE 172
>...
>189 ZW 79
>
>but don't know how to do this, and google isn't too helpful.
>
>As usual, a solution is preferred, but a pointer to where I can
>read this up is equally appreciated :-)-O
>
>el
>
>______________________________________________
>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.
you can get a new data frame by merge(qpiso, qplegit, all.x = TRUE, all.y = TRUE, by = "iso" ) Take the subtraction on the new data frame. 2014-06-29 11:24 GMT-05:00 Dr Eberhard Lisse <nospam@lisse.na>:> I have two data frames like so > > > qpiso > iso requests > 1 A1 20 > 2 A2 199 > 3 AD 5 > 4 AE 176 > ... > 189 ZW 82 > > > qplegit > iso requests > 1 A2 36 > 2 AE 4 > 3 AM 2 > 4 AO 1 > ... > 100 ZW 3 > > > I want to create another dataframe qpspam which contains all pairs > from pqiso with the values for requests of qplegit being subtracted > from those which exist in qpiso, > > ie > iso requests > 1 A1 20 > 2 A2 163 > 3 AD 5 > 4 AE 172 > ... > 189 ZW 79 > > but don't know how to do this, and google isn't too helpful. > > As usual, a solution is preferred, but a pointer to where I can > read this up is equally appreciated :-)-O > > el > > ______________________________________________ > 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. >[[alternative HTML version deleted]]