Here are two solutions. The first uses the R merge command
and the second uses the R sqldf package. See ?merge
and http://sqldf.googlecode.com
Note that alter is an sql keyword so I have changed it
to alt for the second example:
> merge(iso, rawdata)[c("alt", "sex", "country")]
alter sex country
1 NA M Andorra
2 39 F Namibia
> library(sqldf)
> sqldf("select alt, sex, country from iso join rawdata using(country)")
alt sex country
1 NA M Andorra
2 39 F Namibia
On Fri, Oct 24, 2008 at 11:01 AM, Dr Eberhard W Lisse <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two tables:
>
>
>> iso
> continent code code3 codenum country
> 1 EU AD AND 20 Andorra, Principality of
> 2 AS AE ARE 784 United Arab Emirates
> 3 AS AF AFG 4 Afghanistan, Islamic Republic of
> 4 NA AG ATG 28 Antigua and Barbuda
> 5 NA AI AIA 660 Anguilla
> 159 AF NA NAM 516 Namibia, Republic of
> ...
> 246 AF ZW ZWE 716 Zimbabwe, Republic of
>
>
>
> and
>
>> rawdata
> idno alter sex cctld capacity topics content speakers
> 1 1 NA M AD A 2 1 2
> 2 2 52 M <NA> A 3 2 2
> 3 3 39 F NA T 2 2 2
> ...
>
> How do I make it print out something like
>
> alter sex country
> 1 NA M Andorra, Principality of
> 2 39 F Namibia, Republic of
> ...
>
> in other words do something like the following SQL:
>
> SELECT r.alter, r.sex, i.country
> FROM iso i, rawdata r
> WHERE i.code = r.cctld
>
> or even better:
>
> alter sex country
> 1 NA M Andorra, Principality of
> 2 52 M <NA>
> 3 39 F Namibia
> ...
>
> And idea (where I can read up on this)?
>
>
> el
> --
> Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist (Saar)
> [EMAIL PROTECTED] el108-ARIN / * | Telephone: +264 81 124 6733 (cell)
> PO Box 8421 \ / Please send DNS/NA-NiC related e-mail
> Bachbrecht, Namibia ;____/ to [EMAIL PROTECTED]
>
> ______________________________________________
> 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.
