Peter Dalgaard wrote:
Uwe Ligges wrote:
Vincze Orsolya wrote:
There are three columns, I was just careless.
I succeed to merge the two tables. But:
1) in the first table there were rows, which were not present in the
second
table, these rows were deleted from the merged table too, but I need
them.
2) If i want to import from the second table just a certain column,
not all
that is missing from the first, how can i do that?
3) How can I save the generated table?
Sorry about the banal questions.... I'm beginner.
And thanks for the help...
Have a nice day
Homework? Then please ask you course material or teacher.
What makes you think that, Uwe? I don't see a teacher asking merge()
questions to a rank beginner (I wouldn't).
Peter,
at least I give them corresponding homeworks so that they learn about
it: at least merge(), subsetting and assignments are not beyond the
scope of a beginners course in Dortmund. I feel this is a typical 2nd or
3rd day R course homework for data manipulation.
Best,
Uwe
1) look at the documentation: all.x=TRUE
2) use the usual subsetting mechanisms to work with only the relevant
set of columns, e.g. merge(x, y[,c(1,2,6)], ....)
3) assign using z <- merge(x,y,....), then save() (or maybe write.table())
-pd
2009/2/15 Peter Dalgaard <p.dalga...@biostat.ku.dk>
Vincze Orsolya wrote:
Dear all,I had just started to learn R. So my question may sound a bit
stupid for you.
Is that possible to match and merge two tables in R? I mean I have two
tables, in the first I have two columns: RING NUMBER, WEIGHT and
CAPTURE
Err, ... for large values of "two"? Or is one of the three a rowname?
DATE, in the second RING NUMBER, SEX and CAPTURE DATE.
1) First I want to see, if to the ring numbers are the same, the
capture
dates are too?
2) And second if ring numbers are the same, to import the sex from the
second table in the first.
Is that possible?
Yes. It's a job for merge()
--
O__ ---- Peter Dalgaard Øster Farimagsgade 5, Entr.B
c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K
(*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalga...@biostat.ku.dk) FAX: (+45) 35327907
[[alternative HTML version deleted]]
------------------------------------------------------------------------
______________________________________________
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.
______________________________________________
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.
______________________________________________
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.
