Splitting Data Frame into Two Based on Source Array

Dear all,

Suppose I have this data frame:
data_main
V1  V2
foo    13.1
bar   12.0
qux   10.4
cho  20.33
pox   8.21

And I want to split the data into two parts
first part are the one contain in the source array:
src
[1] "bar" "pox"

and the other one the complement.

In the end we hope to get this two dataframes:
data_child1
V1 V2
bar   13.1
pox   8.21

and
data_child2_complement
foo 13.1
qux 10.4
cho 20.33

Is there a compact way to do it in R?

- Gundala Viswanath
Jakarta - Indonesia
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20080908/4dc08df0/attachment.pl>
Try this which gives a list of two data frames:

split(data_main, data_main$V1 %in% c("foo", "bar"))
Dear all,

Suppose I have this data frame:

data_main
  V1  V2
foo    13.1
bar   12.0
qux   10.4
cho  20.33
pox   8.21

And I want to split the data into two parts
first part are the one contain in the source array:

src
[1] "bar" "pox"

and the other one the complement.

In the end we hope to get this two dataframes:

data_child1
    V1 V2
bar   13.1
pox   8.21

and

data_child2_complement
foo 13.1
qux 10.4
cho 20.33

Is there a compact way to do it in R?

- Gundala Viswanath
Jakarta - Indonesia

______________________________________________
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.

data_main[ match(src,data_main$V1), ]

and the compliment of src (call it srcc)

data_main[ match(srcc,data_main$V1), ]

...this only works so long as there is only one occurrance of each item in
V1 in V1.

--Adam

Dear all,

Suppose I have this data frame:

data_main
  V1  V2
foo    13.1
bar   12.0
qux   10.4
cho  20.33
pox   8.21

And I want to split the data into two parts
first part are the one contain in the source array:

src
[1] "bar" "pox"

and the other one the complement.

In the end we hope to get this two dataframes:

data_child1
    V1 V2
bar   13.1
pox   8.21

and

data_child2_complement
foo 13.1
qux 10.4
cho 20.33

Is there a compact way to do it in R?

- Gundala Viswanath
Jakarta - Indonesia

______________________________________________
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.